Managing more than 62 billion claims records for CMS

The Centers for Medicare & Medicaid Services (CMS) Integrated Data Repository (IDR) is the largest government Teradata database in the world—a one petabyte Teradata system complemented by a 667 Terabyte Hadoop system serving approximately 2,500 users. Perspecta performs comprehensive data management support for the IDR, including extract–transform–load (ETL), data quality, data modeling, data query assistance support, and MicroStrategy Business Intelligence support and data validation activities.

Perspecta ensures that the data provided by the IDR—containing more than 62 billion records—are payment-grade to support electronic health record (EHR) incentive payments to Medicare providers. The IDR is the centerpiece of CMS’ Enterprise Data Warehouse strategy to meet the requirements of Medicare modernization initiatives, supporting the agency’s critical need to have an integrated data environment that contains Medicare and Medicaid claims as well as beneficiary, provider and health plan data. It is a critical source of Medicare-related information used by the CMS Center for Program Integrity (CPI), the CMS Medicare Shared Savings Program (MSSP) and a variety of other health care-related organizations.