Experience

NEL

• United Kingdom
• Hospitals and Health Care
• 200 - 300 Employee

• Senior Data Developer

  • Oct 2014 - Present

  * Database development and management (designing, implementation, performance turning and administration)* Database developing and maintaining data quality assurance.* Developing and supporting data provision, the Extraction, Transformation and Loading (ETL) of data within the Data Warehouse and the provision of Data Marts. Day to day maintenance of the local data flow service, inclusive of acute and non-acute contracted information requirement.* Building/developing SSIS solution (ETL) for Integration between 3rd party warehouse solution and various Patient Management Systems and modules.* Building/developing and maintaining of SQL solution to produce monthly local level data submission as per NHS England standard.* Managing short term projects supporting new business information delivery and reporting.* Managing data and systems to ensure compliance with NHS Data Standards and Information Governance principles* Providing data support for Business Analyst and Data Analyst, developing and maintaining of data quality dashboards to improve the quality of data submission.* Developing Power Pivot reports using Power Query and building dashboards using Power BI.* Developing Excel vba solution to support Ad-hoc requirements or data quality testing and assurance.* Documentation of data (data dictionary/relationships)* Preparing documentation and specifications.



Hybrid BI Solutions

• Data Support and Report Developer

  • May 2013 - Present

   Making report in Web Intelligent and modification of reports for BOBJ, using BEX and Universe Query Connections. Report Migration from R2 to R3.1 Data iteration in MS excel Using SQL Server Management Studio 2005, Jobs testing and creating test report. Creating Job Deployment documentation. Entering Data into Customized software for day to day activity. Entering data in to MS Excel and producing report using Pivot Table and fixed format. Importing data to MS Excel and producing report using Pivot Table and fixed format.  Spreadsheet Data Manipulating and generating reports for MIS.



Gazebo Fine Food Ltd

• Data Administrator

  • Oct 2009 - Apr 2013

   Maintaining MS Access database for customized software, tracing duplicate data and validating data to maintain database standards and keep all records up to date. Extracting data from MS Access and MS SQL database and generating reports for MIS Spreadsheet Data Manipulating and generating reports for MIS. Developing MS Access base application for Stock Controlling & Time Sheet Data, Which produces re-order level quantity and monthly balance of stocks and stocks valuation as well as time sheet utility gives idea of, how much labor company using and time of production. Application and database support to in-house users! Communicating to senior and colleagues and giving them their required reports from the system; Entering data in to Customized software and testing; Entering data in to MS Excel and producing report using Pivot Table and fixed format; Printing Standard format to different customer by using Mail Merge MS Word – MS Excel, MS Word – MS Access; One to one emailing to 100 and more client by using Mail merge MS Word – MS Excel – MS Outlook; Server Data back up; Taking care of all soft copies in all systems; Installing and updating application; System formatting and installing drivers; System maintenance like cleaning unnecessary files and folder and removing temp and unwanted files from the system and uninstalling unwanted software and system analyzing and defragmenting; Time to time antivirus scanning for the system and servers, ensuring Antivirus software is up to date. Checking day to day posts/couriers for operation department and filing appropriately; Scanning documents for records and laminating documents. Data Analysis• Production & Packing Time Sheet• Stock inflow and outflowProjects Time Sheet Mgmt. Goods In & OutPlatform/Software/Tools: MS Access Front and Data Entry & Reports, Back End DatabaseRole: Developer



DSFS Advisory Services Pvt. Ltd.

• Database Administrator

  • Apr 2003 - Aug 2009

   Fetching data by using simple queries from one table and by joining two table; Updating table by such a criteria (inner join) and updating(multi table update) one table by joining other table criteria(inner join) and updating tables by using outer join as well; By using queries Inserting data into table; Designing Database structure; Entering data in to Customized application daily transaction day today basis; Importing financial transaction in to customized software and mysql or ms access utilities and exporting different data to different format;  Processing data to generate different analysis and reports; Ensuring that the data remains consistent across the database; Provisioning for data security and recovery control; Establishing the needs of users and monitoring user access and security; Installing and testing new versions of the database management system (DBMS); Maintaining data standards, including adherence to the Data Protection Act; Developing, managing and testing backup and recovery plans; Ensuring that storage, archiving, backup and recovery procedures are functioning correctly; Working closely with IT project managers, database programmers and web developers; Communicating regularly with technical, applications and operational staff to ensure database integrity and security; As an Senior Data Administrator there was 5 members are working under me and we all are working in the team and achieved different projects; By using MS Excel VBA, developing calculators, Insurance Policy wise and Mutual Fund Scheme wise of Maturity Value and other different analysis.  Understanding the customer requirement and developing/implementing the application; Giving understanding to developer team; Client Software and Data Support, Solving Client query relating Software and database; Developing utility in the software as per client requirement; Keeping database structure and data up to date;