Chicago Medicaid MCO Case Study
HEDIS Analytics & State Quality Reporting
Client Profile
Cook County-based Medicaid Managed Care Organization serving vulnerable populations. Organization grew from ~45,000 to 90,000 members and 2,000 to 4,300 contracted providers during engagement period.
The Challenge
As a Medicaid MCO, the organization faced:
Multi-million dollar financial exposure tied to Illinois state quality performance withhold (up to 1.5% of capitation)
Fragmented data across member, provider, claims, and clinical systems
HEDIS audit and state reporting requirements with zero tolerance for error
Need to support utilization management, care management, and disease management program analytics
Pressure to demonstrate quality improvement in competitive Medicaid marketplace
Our Approach
Data Integration & Architecture:
Integrated member, provider, and claims data in SQL Server to create enterprise data backbone
Implemented quality controls and lineage documentation meeting audit standards
Built and maintained Access databases supporting departmental needs across organization
Developed data warehouse processes integrating multiple source systems into reporting repositories
HEDIS Production & Compliance:
Owned HEDIS production and audit compliance for 8+ measures tied to state quality withhold
Consistently met or exceeded annual HEDIS Audit data programming and integration requirements
Served as Project Manager for selection and implementation of NCQA-certified HEDIS software
Led RFP evaluation, vendor coordination, and annual reporting cycles
Analytics & Decision Support:
Produced audit-ready metrics and ad-hoc reports for internal leaders and external partners
Designed reports for UM/CM/DM programs used to determine staffing needs and program efficacy
Supported state contractual requirements including withhold dollar calculations tied to quality performance
Provided analytics supporting behavioral health initiatives and Performance Improvement Projects
Results
Quality Performance:
Exceeded 90th percentile for 7-day mental health hospitalization follow-up
12.6 percentage point improvement in 30-day mental health follow-up versus baseline
Contributed to Performance Improvement Projects achieving statistically significant gains on 6 of 13 measures
Exceeded Medicaid 50th percentile on comprehensive diabetes care nephropathy monitoring
Operational Impact:
Ensured zero HEDIS audit findings on data quality or completeness during tenure
Supported organization's eligibility for state quality withhold recovery and bonus payments
Enabled confident executive decision-making through audit-ready, traceable analytics
Business Impact
The data foundation and analytics capabilities directly supported the organization's financial performance by enabling quality withhold recovery and bonus payments, while positioning them for growth in a competitive Medicaid marketplace. Work ensured the organization could confidently report on care quality for 90,000 vulnerable members while meeting strict state regulatory and audit requirements.