Back to Success Stories

Health Claims Data Warehouse

Office of Personnel Management (OPM)

The Office of Personnel Management (OPM) oversees the administration of benefits through the Federal Employee Health Benefits Program for approximately 8.2 million federal workers, retirees and their dependents.

The Health Claims Data Warehouse (HCDW) will provide OPM with detailed information on the cost and quality of health care services in different geographic regions, across health plans and specialty types, and for sub-populations.

DynaVet designed, developed and implemented Extract/Transformation/Load (ETL) and data warehouse applications and data quality solutions. DynaVet updated source to target mapping documents and data models, developed test solutions, and created documentation. DynaVet helped establish a system to receive encrypted data from FEHB plans, which enabled the initiation of the HCDW build. We also provided ongoing SME development and program management support.