This project is responsible for applying business logic to perform cleansing, standardizing and removing redundant data according to the client requirement. The transformed data is loaded into database and is used to generate valuable and intelligent reports. This process is done by using SSIS, SQL Server and Power BI, Spotfire. Duration: July 2018 till date Tools: SQL Server 2012/2017, Visual Studio 2015, ETL Tool – SSIS, Visualization Tools – SpotFire, Power BI Roles and Responsibilities: • Developed SSIS Packages for migration, data pull from multiple sources and complex transformation, cleaning and analyzing data and bulk data load. • Experience in performing profiling over data, data quality checks using Data Insight and Address cleansing transforms. • Primary role was to ensure the preparedness of data before go-live (Country / Company code wise) by running data governance checks as part of Full Dress Rehearsals. • Performed checks on production data and co-ordinate with respective teams to highlight the data anomalies • Worked on POCs for Postal code format checks, name standardization and phonetic checks. • Worked on end-to-end implementation of dashboards which includes analysis, design, development and presentation as per client requirements • Developed multiple SpotFire dashboards for deriving business insights and to provide predictive analytics capabilities • Developed multiple Power BI dashboards to create interactive visualizations for analysis of data from multiple sources to provide trends and predictive analysis. Provide story telling feature to understand data transformation over a period of time. • Involved in writing stored procedures triggers and views. • Worked on deployment of SSIS Packages to a third party scheduler – Control

PHM’s main goal is to gather, normalize and analyze clinical data across a patient’s many care settings that can reveal opportunities to improve patient’s health and provider’s financial outcomes. RCM unifies the business and clinical sides of healthcare by coupling administrative data, such as a patient's name, insurance provider and other personal information, with the treatment a patient receives and their healthcare data. The objective is to support data aggregation, data governance and data analytics along with providing reporting capabilities necessary for compliance and provider incentives.

An Internal project in development for provisioning, de-provisioning and maintaining identities and their entitlements across the systems. This HR system handles the life cycle of an employee from the date of on boarding to off boarding in an organization. This process involves three main modules like Provisioning, Secondary provisioning and De-provisioning. Duration: Nov 2015 to December 2016 Tools: SQL Server 2008R2, Visual Studio 2008, MSBI Tools (SSIS, SSRS). Roles and Responsibilities: • Involved in analysis, design, coding, and maintenance. • Developed SSIS ETL Packages, SSRS Reports. • Involved in Database Design of the Application and Writing Stored Procedures, Triggers, Views • Involved in Unit Testing and preparing Unit test cases.