Large State Health Plan
Project: Enterprise Data Warehouse Testing, ETL Testing
The Client provides health coverage to more than 2.7 million members. The Enterprise Analytic Environment (EAE) project was created to fulfill the Client’s need for timely access to accurate business information using a single, integrated data source (enterprise data warehouse) to support analytic reporting efforts, and to provide an enduring and flexible analytic environment that supports intuitive access to high quality, consistent data/information.
Data was migrated from the legacy systems and other sources into a data warehouse environment that could be used by the Client’s multiple business units. VIP was engaged to manage and conduct QA/QC work on various projects related to the Client’s enterprise data warehouse. We concluded that the overall testing approach should not only focus on data, but also be adapted to the Client’s analytics’ data warehouse context from a business perspective.
The test team adopted a ‘Top Down’ approach, which started with high-level comparison, and ended with an individual sample record check. In addition, we helped standardize the defect tracking process and made it part of the development life cycle by utilizing Rational Clear Quest. Our team also discovered and resolved many issues common to data warehouse projects in a timely fashion.
During this two-year engagement, our resources were able to achieve the project goals while improving the overall QA process. We implemented standards for usage of tools, creation of test strategies, test plans and detailed test cases. Our “Top Down” test methodology was so successful that it was adopted by the Client’s enterprise analytics environment department as its standard approach for future data warehouse and ETL testing. The Enterprise Analytics client leadership team recognized VIP for the quality results we achieved.