The client is a leading health and life insurer and benefits administrator in the US. The customer had business information available across different legacy platforms due to the acquisition of various businesses. Hence reporting had to be carried out for each individual database separately and business decisions could not be taken effortlessly.
How we have helped our customer:
- We worked on designing, developing and testing ETL programs/jobs to extract data from four claims systems (CORE, NGS, eCAMS, and PowerSTEPP) into one Physical data warehouse.
- Performed data transformation to convert data into the EDM.
- Loaded data into the newly created Enterprise Data Model designed by IBM with standardized Data Model
