A national healthcare client assists employers and health plans by providing managed care solutions for the most difficult, costly and debilitating medical conditions and diseases that increase health care costs. The client’s current data warehouse began with a small amount of data stored for limited reporting needs. Over time, additional data was added and like most first time warehousing efforts this growth was executed without a long-term design or strategy. Data became difficult to manage and no longer effectively supported the measurement of improvements in the health of members and health care costs savings. The client recognized the value that a well designed data warehouse and its reporting capabilities could bring to the business and requested a strategy to implement that capability.
Solution:
The client engaged CapTech to lead the re-architecture of the data warehouse. The project’s scope involved the development of an enterprise logical data model, and the architecture and design of an Operational Data Store (ODS), Data Warehouse, and reporting Data Marts. CapTech developed the full architecture and strategy including architectural principles, data flows, data quality strategy, and Extract Transform and Load (ETL) strategy for moving and staging data. The team then designed and implemented the operational data warehouse environment, which consists of a main repository surrounded by data marts that provide functional views of the data and reduce the reporting load on the main repository. CapTech also led the effort to set standards for Data Modeling, Data Naming and Data Quality within the enterprise to ensure the long term viability of the data warehouse strategy. The working system is able to accept millions of transactions on a daily basis and provide near real time reporting and analysis of the data with fast response and enterprise reach.
Tools:
Microsoft SQL Server® 2008
Microsoft Visio®
CA Erwin Data Modeler®
Results:
Supports forty million user requests per day routinely
Seamless integration of twenty five business data sources
Scalable support to billions of transactions per day
Data consistency across multiple enterprise systems
A sustainable strategy for corporate information management