Monarch Project: Geisinger Health Plan initially had the Amisys claims processing engine where all the Claims, Membership, Eligibility, Benefits, Capitation, Authorizations & Provider information was adjudicated, and this system was replaced by Facets claims processing tool/engine in 3 phases where the data was mapped to the ODS and later to the Data warehouse for ReportingAccumulators:Geisinger has association with various pharmacy benefit managers and sharing the member accumulations in a two-way manner Inbound and Out-bound was one of the major business decisions.B2B Outbound Extracts:Outbound extracts to various external and internal vendors in a standard B2B formatBroker Enrollment:Enrolling the broker HICN and MBI members in the gold screen and sending them out the latest status of the members to the concerned vendors in conjunction with CMS

Implementation of ETL processes for loading the Tufts data warehouse from 22 different sourcesystems including mainframe data in both VSAM and sequential files, Microsoft SQL Server,Oracle, flat-files, XML based data and unstructured data. This ETL consists of more than 300Informatica mappings and associated workflows.Implementation of Informatica Power exchange CDC registrations ,DataMaps ,Technical documentation and Training and implementation of the modules in Productionfor all enterprise projects across Tufts health plan.Implementation of Informatica IDQ Applications and implementation of themodules in Production for all enterprise projects across Tufts health plan.Informatica Power Center 9.6.1/9.5.1/9.1.0 (Power Center Designer, workflow manager,workflow monitor), Power Exchange 9.6(Express)/9.5.1/9.1, Informatica IDQ 9.6.1 ,Oracle11g/R2,SQL Server

Cigna provides health care and related benefits offered to individuals, and through employers, brokers and consultants .Cigna provides medical, dental, behavioral health, pharmacy and vision care benefits. The purpose of Enterprise Data Warehouse (EDW) is to integrate Membership, Eligibility, Client Database, Accounts, Banking, Billing, Chirps, Claims, Reimbursements and Finance systems into single analytical system which helps to save several millions for the organization and helps to improve membership, Patient care and Revenue. Data from EDW is effectively utilized for the report generation in downstream areas like Advice, Pricing, Finance, CCDR, CCDM, HCE and Compliance. Primary responsible for ETL work using Informatica Power center v8.6 and v9.0 for the loading of an oracle data warehouse, supporting the Information Management needs of the 4th largest health insurance company in the USA. Responsible for the implementation of Informatica Power exchange v9.0 tool for the enterprise in sourcing systems including mainframe data in both VSAM and sequential files, Microsoft SQL Server, Oracle & flat-files