• Understanding the Requirements, Building Data Model, ETL Development architecture and Preparing mapping documents to load data from different internal & external applications into AIR.

 • Defining frameworks for new AIR Databases, Data Quality (DQ), Creating functional data requirement (FDR) and Master Test Strategy

• Conducting workflow, process diagram and gap analysis to derive requirements for existing systems enhancements and developing code.
 • Developing ETL packages using SSIS packages to bring the data from different source systems into our new AIR databases

• Develop reports/dashboards on top of the AIR databases using SSRS to make the business people to understand the trending and analytics to make decisions based out of it.
• Working in all phases of the project right from Analysis, Design, Development, Testing, Release and Deployment to other Environments until Production all through Agile Model Execution
• Bug fix and enhancements in the existing ETL, Reports and Stored Procedures
• Conducting reviews for peer and self. Performing all sorts of Testing (Unit, Smoke, Integration, Regression & Retesting)

• Implemented the base ETL for the Data Warehousing Redesign of Fallon Community Health Plan. 
• Design & develop ETL packages to load Membership, Provider, Claims, Pharmaceutical data into the Enterprise Data Ware Facts and Dimensions using SSIS 2012 
• Requirement gathering from onshore, Design, Review, Development of SSIS Packages using complex tasks & components involved 
• Making the team to understand the design and responsible for development of SSIS packages 
• Designed & developed SQL objects such as Stored procedures, tables, views and functions according to the requirement 
• Converting the business to SQL Server which was already implemented in oracle as part of Optum Insight Track 
• Acting as point of contact for the EDW Redesign, Bangalore team. 
• Pushing ETL, DB objects to QA 
• Participating calls with onshore on the design discussion 
• Preparing technical documentation and release plan 
• Preparing Daily and weekly status report

• Gathering and analysis the Requirements from the business, Preparing ETL Development architecture and Preparing mapping documents to load data into the EDW
• Performing workflow, process diagram and gap analysis to derive requirements for existing systems enhancements and developing EDW code

• Providing data ware housing solutions to improve healthcare strategies and business especially in the clinical module
• Implemented SNP Dashboard – a Complete Product gives a clear picture about Special Needy Plan Members & their care
• Implemented Risk Members Dashboard – another Product which gives a Patient 360-degree Risk Cohorts – data driven from Claims, Pharmacy, Essette, EMR&JSA (Alignment Healthcare Specific Assessment)
• Other projects – Care Center Activities, Outreach Activities, HCC Rules Engine, Reports migration using Tabular Models, Power BI – Responsibilities start right from Requirements Gathering, Design, Development, Enhancements & Maintenance of the solutions provided
• Participating & Contributing in requirement gathering discussions with client, Closely working with business analyst on the requirements and with architect on data modelling and technical design of ETL and Reports
• Developing - ETL packages using SSIS 2014 to load the data from various sources to the EDW and then to ADS for analysis, Static and Dynamic Reports using SSRS 2014 and deploying them to Share Point, Database objects required for the packages and reports development
• Deploying DB Objects, SSIS Packages and SSRS Reports to the Pre-Prod environment and test the entire model with the real-time data before going live
• Performance tuning in SQL queries, Bug fix and enhancements in the ETL, Reports and Stored Procedures
• Coordinating with offshore teams and taking ownership of work delegated
• Analyzing the migration of existing ETL to cloud using Spark, Scala related technologies
• Agile Model Execution

• Complete Implementation of DB objects for the grand success Product of United Health Group “e-CAC” – which aims at developing a Computer Assisted Coding Solution that would integrate an existing NLP engine with an encoder and deliver the product through a SaaS model which is used to improve the revenue cycle management system of hospitals. 
• Design, Develop, maintain and update database objects/schema
• Creating reports using SSRS 2012 on top of the transactional DB to make the business to understand the performance of the revenue cycle management system which helps on decision making. 
• Creating stored procedures, Data validation and Migration scripts for the application 
• Developing Database objects for New Feature Implementation, Change Requests and addressing the DB related defects. 
• Design, Develop, maintain and update database objects/schema. 
• Performance tuning in SQL queries. Deploying the DB changes to the QA Environment • Monitoring the Nightly Jobs that are used to populate the Aggregation tables and fixing if there is a job failure 
• Coordinating with other teams (SaaS and UI) to address new Change Request and Defects 
• Developing packages using SSIS 2012 to load the data from various sources to the Data Warehouse – New Implementation. Bug fix and enhancements in the existing Reports and Stored Procedures 
• Peer & Self Reviews, Preparing Unit test cases and Executing the test cases 
• Executing the project in Scrum model

• Assisted the whole ETL implementation of The Outsource Group to load Centralized database which in turn be used by the business users for ADHOC reporting. 
• Develop, Enhance & Maintenance of the SSIS Packages 
• Scheduling and Monitoring SQL Nightly jobs to run SSIS Packages and fixing if there is a job failure 
• Writing simple stored procedures using T-SQL to meet the requirement 
• Code review, re-design/ re-engineer existing codes during development 
• Working in Onsite – Offshore Model 
• Used best practices and followed code/design guidelines as per the Client 
• Core details Report Testing - Developing Simple Reports using SSRS on need basis.