Business Scenario
A leading provider of commercial services to the life science industry. The company offers a fully integrated platform of solutions to address pricing, access, reimbursement, adherence and product delivery challenges on behalf of pharmaceutical organizations. In 2019, the client acquired another firm to add Health Economics and Outcomes Research (HEOR) services to its platform.
Business Drivers
- 200+ ETL jobs in SSIS (70% full loads), 100% Long running Store procedures
- Multiple BI Technologies. No Self-service BI environment. No report rationalization
- Performance issues in data reporting
- No Data Warehouse / Data Lake. 80% business rules in Store procurements
- Severe Data Quality issues. No enterprise BI/DW architect
- No Process adherence/SLA for resolutions and ticket management
Solution Highlights
- End-End lineage for all data reporting objects. Created Data models/ER and data flow documents.
- Report rationalization. BI Technology rationalization. Create Self-Service BI platform for users to build reports independently
- Performance tuning of long-running queries and fixing
- Migrate BI data to DW/ Datamart
- Implement data standardization and Data quality solution
Business Outcomes
- Faster turn-around on tickets
- Minimized tickets by Self-Service BI Capabilities
- More time spent on Billable work (On-boarding and supporting enhancements)
- Improved confidence on data quality
- Improved report rendering time; improved performance