ERP Consolidation
and Enterprise
Data Platform
SUMMARY
A large US Healthcare company needed to integrate multiple platforms, acquired companies, and data to a consolidated environment for reporting and analysis in a multi-year effort to create a consolidated Pharmacy Benefits Management division.
Problem Statement
- Time to delivery, costs, and IT involvement around data projects needed to be controlled
- Need to consolidate data assets resulting from M&A growth across multiple revenue generating platforms
Exusia Solution
-
Designed and implemented an enterprise data platform leveraging ETL for consolidating, integrating and distributing all data across the firm
from a single integrated data repository - Provisioned to operational applications and client reporting
- GUI based framework allowing business analyst and operations to manage data onboarding, rules, and provisioning of data
Business Outcome
- Successful Acquisition of and ongoing merger with 3rd Largest PBM
- Reduced blended hourly rates for analysis, development and testing / support
- Reduced average project execution efforts to 3-5 months (from 9-12 months)
- Smaller average team size of 40-50% compared to other technologies
