A large pharmaceutical manufacturer with a portfolio spanning oncology, neurology, and cardiovascular disease aimed to expand its reporting & analytics capabilities within the Pricing and Contracting (PnC) function. Relying primarily on siloed operational reports from its revenue management application, the company recognized the need to move towards more strategic, forward-looking insights. Ahead of its transition to the cloud, the company engaged Marbls to conduct an assessment and develop a roadmap for a future-state reporting & analytics platform.
- The company was facing multiple challenges related to how PnC data is managed, processed and reported on:
- Limited tools / capabilities for business teams to perform advanced analytics and reporting cross-channel
- Lengthy and cumbersome Gross-To-Net reporting process, with potential for errors
- Manual work required to build cross-system, forward-looking reports, making analytics time-consuming and results inconsistent
- Lack of harmonized data models, common identifier and an integrated analytical infrastructure
- Challenges with data quality due to lack of a single source of truth and robust data management processes
- Marbls conducted a current-state assessment with business and technical recommendations including:
- Future-state reporting requirements aligned to strategic business goals
- A streamlined reporting process with reducing reliance on operational reports
- Expanded data use cases beyond operational reporting to include strategic functions such as Gross-to-Net (GTN), Pre/Post Deal Analysis, Forecasting/Modeling
- An architecture of a centralized data repository to house all integrated data, together with the middleware to support a robust ETL process
- An outline of a more efficient Master Data Management process combining use of MDM tools and manual stewardship
- A standardized reporting and visualization framework
- The recommendations and roadmap provided by Marbls helped the company to:
- Optimize some of the key business processes around PnC data management in particular supporting Gross-To-Net analytics
- Plan an integrated and scalable data and analytical architecture to support reporting needs e.g. combining Regulatory, Managed Care and Distribution channels
- Define a clear technology stack for middleware, data warehousing, and visualization tools
- Architect consistent data governance through formalized stewardship and identifier management
- Provide a foundational framework to support GTN analytics and upcoming digital capabilities
- Equip the leadership with a strategic roadmap for ongoing reporting transformation and innovation