Tools : Informatica Power Center, Teradata, UNIX Shell Scripting Team Size : 5 Duration : 3 years Description: The Loading the HEDIS measures which are crucial in determining the score of the Health plan as per the US government terms and conditions which give rating to Organization based on the Health plan Standards

Tools : Informatica Power Center, IBM DB2, UNIX Shell Scripting Team Size : 15 Duration : 1.3 Years Description: As part of this project, we processed the eligible/non-eligible members according to Affordable Care Act. In addition, the enhancements and maintenance of the comprehensive health care reform law enacted in March 2010.

Roles & Responsibilities: • Involved in all phases of SDLC from requirement gathering, design, development, testing and support for production environment. • Mentoring the team to make sure meeting the SLA as expected and monitoring the loads. • Guiding and motivating team when they stuck with requirement analysis or technical roadblocks. • Worked on Performance tuning to decrease the run time of process from 72 hours to 7 hours. • Involved in giving internal and external reviews to the client for developed projects.

Tools : Informatica Power Center, Oracle, UNIX Shell Scripting

Team Size : 3 Duration : 1 year Description: The requirement is to utilize Revinate data associated with all survey components and determine the quality score for all WHG properties. Franchisee operations team will utilize the score and take necessary actions to facilitate their business operations. Annual & Quarterly WynReview report generated in Salesforce for Service, Cleanliness and Condition Data feed from Revinate for WynReview manually extracted and loaded to Salesforce. Data feed from Revinate for OTA Guest Satisfaction Ratings extracted and loaded to Salesforce. Responsibilities: • Understanding the Customer Requirements and the Technical Specifications Documents. • Played role of ETL developer in developing mappings, unit testing and resolving the issues in QA testing phase. Also involved in Deployment process while moving components across environments, defect tracking and bug fixing. • Participated in preparing Unit test case documents, detailed design documents and mapping sheets.

Tools : Informatica Power Center, Teradata 15.1 Team Size : 6 Duration : 1.5 year Description: • Blue Cross Blue Shield Minnesota (BCBSMN) is a leading U.S. Healthcare company, dedicated to providing the best care and optimizing outcomes when care is sought. BCBSMN connects payers, providers and patients in the U.S. healthcare system. BCBSMN’s offerings integrate and automate key business and administrative functions of its payer and provider customers throughout the patient encounter. BCBSMN sells health insurance products for Individual, Small, large groups, Medicare and Medicaid market in the state of Minnesota. • There are 6 different domains in Health Care system namely Member, Claims (Medical & Pharmacy), Provider, Client and Benefit. I had worked for Member domain Roles and Responsibilities • Creation of Informatica mappings. 4 • Creation and scheduling of jobs. • Preparation of UTC documents and review checklists. Coordination of onsite calls. • Worked on tools like ClearCase and Build Forge for Code Migration. • To write SQL scripts for performing the business logics. • Preparation of High-level test scenarios and development of test cases. • Involved in Identification of Test Data using SQL. • Test Execution and Defect logging and tracking of defects till its closure.