Home Site Map Contact Us
 
   
  Case Studies
   Testimonials
You are here Home > Success Stories » Case Studies

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
  Top
Content Management || BCBSMo Website or MyBluePlan (IBT) Maintenance || Medical Management || Standard Reporting Package (SRP) || Datawarehousing || Oracle Applications R11i Implementation || Customer Access Billing Specification || Customer Service Automation || MIS department Automation || Product Catalog
 
 
 
Copyright © 2011 Saahi Systems Ltd. All rights reserved.