Client Introduction
Aetna is one of the largest managed health care companies in the United States, offering medical, pharmaceutical, dental, behavioural health, long-term care, and disability insurance plans. Its network encompasses more than 22 million medical members, 690,000+ primary care doctors and specialists, and 5,700+ hospitals. Since 2018, Aetna has operated as a subsidiary of CVS Health Corporation — which reported record annual revenue of $402.1 billion in 2025. Aetna serves an estimated 34 million people with information and resources to support informed health decisions.
Aetna’s Informatics Enterprise Data Warehouse is one of the largest healthcare data warehouses in the world, integrating data from virtually every Aetna transactional system — including enrolment, provider, products, claims, pharmacy, and financial systems — to support reporting, analytics, regulatory compliance, and downstream operational applications.
Programme Introduction
Programme: Aetna Informatics Enterprise Data Warehouse – Strategic Initiatives
Platform: Informatics Enterprise Data Warehouse (EDW)
Scope: Three concurrent strategic projects addressing ICD-10 compliance, CVS Caremark integration, and Narrow Networks analytics
This engagement comprised three concurrent strategic projects within Aetna’s Informatics EDW programme — each addressing a distinct regulatory, business transformation, or product strategy imperative. Together they reflect the complexity and strategic importance of Aetna’s data warehouse as the foundational platform for claims processing, financial reporting, regulatory compliance, and product delivery.
Three Strategic Projects
Project 1: ICD-10 Conversion (8212)
Mandated by CMS effective 1 October 2013, the ICD-10 transition expanded available diagnosis and procedure codes from ~17,000 to 155,000+. This project delivered EDW enhancements to receive, store, process, transmit, and report ICD-10 codes — with a critical dual processing capability supporting simultaneous ICD-9 and ICD-10 claim handling post the mandate date.
Key deliverables: EDW schema changes for the expanded ICD-10 code set · Dual ICD-9/ICD-10 pipeline architecture · Remediation of downstream applications and reporting systems · Multi-release phased delivery · CMS regulatory compliance.
Project 2: ACE Programme – CVS Caremark Integration (8270)
The ACE (Aetna Caremark Enterprise) Programme delivered the IT infrastructure for deep integration between Aetna and CVS Caremark, including a new Pharmacy Book of Record (RxBOR), real-time data exchange for eligibility, claims, and benefits, and downstream EDW and financial reporting feeds.
Key deliverables: EDW enhancements to receive pharmacy data feeds from the new model · RxBOR as authoritative pharmacy data source · Real-time eligibility, claim, and benefits integration · Downstream application access to combined Aetna and CVS Caremark partner data · Financial reporting continuity throughout conversion.
Project 3: BEN & Narrow Networks (8262)
Narrow and tiered network products — offering lower premiums in exchange for curated, quality-tiered provider access — affect enrolment, provider data, claims adjudication, benefits configuration, and financial reporting simultaneously. This project delivered multi-release EDW enhancements supporting Aetna’s preferred provider product strategy.
Key deliverables: EDW modelling of narrow and tiered network provider and product data · Changes across enrolment, provider, products, and claims domains · Downstream reporting reflecting network tier configurations · Analytics support for network performance and member uptake.
Technical Implementation
EDW Architecture Principles
- Multi-release phased delivery: Controlled, validated delivery of complex data warehouse changes without disrupting production
- Cross-domain data integration: Changes spanning claims, enrolment, provider, products, pharmacy, and finance — requiring careful coordination of data model changes and ETL updates
- Dual-mode compatibility: ICD-10 project required simultaneous ICD-9 and ICD-10 processing through schema and pipeline design preserving backwards compatibility
- Downstream system continuity: All projects prioritised continuity of downstream reporting and financial systems throughout periods of significant data architecture change
- Data governance and quality: Validation and quality controls ensuring newly integrated data met Aetna’s accuracy, completeness, and consistency standards
Business Impact
Regulatory compliance at scale — ICD-10 conversion delivered CMS regulatory compliance for one of the largest US health insurers, with dual ICD-9/ICD-10 processing throughout the transition period.
Strategic integration enablement — ACE Programme delivery created the data foundations for Aetna’s pharmacy integration with CVS Caremark — a critical enabler of the integrated CVS Health model serving ~34 million members today.
Product portfolio expansion — Narrow Networks delivery provided the data infrastructure for Aetna’s preferred provider strategy, enabling accurate representation of tiered and narrow network structures and supporting analytics for network performance and growth.
Enterprise data integrity — Rigorous data quality controls and phased delivery governance ensured the EDW remained the reliable foundation for financial reporting and regulatory submissions throughout complex business transformations.
Appendix: Glossary of Terms
ACE Programme: IT integration programme supporting the vendor model between Aetna and CVS Caremark, including pharmacy data integration and downstream EDW feeds.
CMS: The US federal agency responsible for Medicare, Medicaid, and healthcare coding standards including the ICD-10 mandate.
CVS Caremark: The pharmacy benefits management division of CVS Health managing prescription drug benefits for Aetna and other health plans.
Dual Processing: The capability to simultaneously receive, process, and report data under two different coding standards — ICD-9 and ICD-10 — within the same data warehouse infrastructure.
eDelivery: Electronic delivery of regulatory and account documents to clients who have opted for digital rather than physical mail.
Enterprise Data Warehouse (EDW): A centralised repository consolidating data from multiple transactional source systems across an organisation.
ICD-9 / ICD-10: International Classification of Diseases coding standards. ICD-10 replaced ICD-9 as the US healthcare standard from 1 October 2013, expanding from ~17,000 to 155,000+ codes.
Informatics: Aetna’s division responsible for the Enterprise Data Warehouse and BI platform managing data integration and distribution to downstream applications.
Narrow Networks: Health insurance plans restricting covered provider networks to a curated subset, offering lower premiums in exchange for reduced provider choice.
Pharmacy Book of Record (RxBOR): The authoritative system for recording and managing pharmacy claims, benefits, and eligibility data.
Tiered Networks: Health plan designs categorising in-network providers into tiers based on cost and quality, with different cost-sharing amounts per tier.
Downstream Applications: Systems and applications receiving and consuming data from the EDW, including financial reporting tools, regulatory submission systems, and analytical platforms.
Ready to Modernise Your Healthcare Data Platform?
Are you navigating a complex healthcare data transformation — a regulatory coding migration, a strategic payer or pharmacy integration, or a network strategy requiring enterprise data warehouse enhancements? Get in touch to explore how a structured, phased delivery approach can protect data continuity and drive measurable outcomes.
Pramod Siddabattuni - Product Consultant / Data Solutions Architect 