Modernization of Commercial Data Warehouse for US Pharmaceutical company
Overview.
A US-based pharmaceutical company implemented a SaaS-based Commercial Data Warehouse system and faced various challenges from a solution, partner, cost, and delivery perspective. Data Warehousing for commercial operations can be a challenge to manage; having the right partner is key. To assist, Coforge, with its deep Data & Analytics expertise, migrated the client off the SaaS platform to a new, modern platform, implemented a managed service model, and initiated introduction of features from the backlog requests.
The client was having numerous challenges with a SaaS-based Commercial Data Warehouse solution that was supporting all core Commercial Operations business processes. Challenges included:
Fully outsourced model with no ability to implement enhancements outside of SaaS vendor.
Long lead times and high costs for enhancements
Long lead times and high costs for enhancements
Limited architecture and data model that did not support all business use cases.
High number of defects with lack of transparency around root cause and resolution
Data integration issues with providing and consuming partners/applications
Slow response for information and service requests
Significant time/cost required for vendor management.
Lack of complete and proper documentation.
Solution
Quick migration to new Customer-owned, modern, high performance Coforge Data Warehouse platform.
Platform technology architecture (high-level):
Microsoft Azure Data Factory infrastructure
PySpark data pipelines
Snowflake database
Expanded, flexible data model.
Qlik for Reporting & Analytics
Migration to Coforge for managed services to provide full DevOps support.
Increased support coverage including onsite presence.
Implemented new base QC framework to address data integration/quality issues.
The Impact
Ensured high performing, modern Commercial Data Warehouse implementation.
Significantly reduced turnaround time and cost for enhancements
Reduced time for service requests and incidents resolution.
Enabled regular updates on service requests, incidents, enhancements to key stakeholders.
Increased communication and reduced issue resolution time.
