Datawarehousing
The customer
The nation's largest publicly traded health care companies serving the needs of 15.5 million medical members across California, Georgia, Missouri, Wisconsin and approximately 46 million specialty members nationwide. Its included in the S&P 500® Index.
| The challenge |
| A. |
Client wanted a central source of information of all the WellPoint networked companies to enable them quickly analyze facts and figures for discovering trends and patterns for suggesting new business opportunities. |
| B. |
Since data was sourced from various systems, there was major risk of data inconsistency and redundancy. |
| C. |
Client wanted a centralized system that would help them extensively in their business development. |
| D. |
Historical data structures were not totally complaint with the current ones. |
Client wanted a solution to provide
|
| .: |
Since data was sourced from various systems, there was major risk of data inconsistency and redundancy. |
| .: |
Indicate strengths and weaknesses / opportunities and threats in a competitive environment. |
| .: |
Inform management decision on pricing and competitive positioning. |
The Solution
SAAHI developed and deployed a centralized warehouse, by doing through analysis of the data and creating a Dimensional Model using ERWin. Extraction, Transformation and Loading of data from Persistent Data Storages (PDS) to Enterprise Data Warehouse (EDW) was accomplished using Informatica. EDW is a loaded database having forty-one months of historical data that will be one source for analysis across all subject areas within WellPoint. The data is gathered from legacy databases across all plans (based on releases) and checked to ensure consistency across all subject areas. This will now be the primary source for reporting and analytics for all data users at Client.
| Benefits |
| 1 |
Quick analysis of facts and figures. |
| 2 |
Quick time to the market. |
| 3 |
Significant cost benefits accrued through usage of onsite/offshore delivery model. |
| Technology Used |
| DBMS |
IMS DB |
| RDBMS |
Oracle 8.1.7, UDB DB2 |
| Platform |
SCO-UNIX, Linux Mandrake 8.1, Mainframe, Windows 2000 Professional |
| ETL |
SQL*PLUS / PL-SQL / SQL Loader, Informatica |
| Data Modeling Tool |
Erwin 4.1 |
| OLAP/Reporting Tool |
Cognos, SAS, Report Net |
|
