Relevance Lab has built the Clinical Supplies Demand and Supply Planning Analytics & Decision Support System for a global bio-pharmaceutical major. The system provides a single source of truth for the client's clinical trial programs by automating data collection from disparate systems. It has helped to optimize the productivity of the clinical supply strategy team by about 50%.
In the dynamic landscape of clinical research, efficiency and accuracy are paramount. To address the challenges of data management and reporting, our innovative solution has revolutionized the way planners prepare clinical study assessment reports. By harnessing cutting-edge technology, we've empowered planners and program managers to focus on their core tasks, enhancing productivity and strategic decision-making.
Friction Points
- Manual error-prone process for tracking and planning clinical trials resulting in high cycle time.
- Absence of a single dashboard providing the overview of clinical statistics studies across the organization.
- Data residing in different and disparate systems was making data reconciliation a difficult task.
Solutions
- Automating the extraction of structured and unstructured data from different sources (transaction systems, Excel sheets, Word documents, and PDFs) covering all compounds with details of demand and supply and all subject enrollments and statistics from investigation sites across the globe.
- Data was collected from five systems: Forecast, Demand, Orders, Enrollment, and Shipment systems and integrated seamlessly.
- Single consolidated truth of 40 compounds with 130 studies spread across 5 geographical regions in 60 countries.
- Relevant statistics provided for the collected data for all identified user groups.
- Creation of intuitive, interactive visualizations with drill-down capabilities supplemented by a powerful analytics layer.
- Personalization of visualization and analytics layer based on business roles.
Outcomes
- Planners can now prepare consolidated clinical study assessment reports with just one click.
- It optimized the productivity of the clinical supply strategy team (consisting of forecasting, planning, and program management teams) by about 50%.
- Planners and program managers can now focus on their core tasks without wasting time on data collection, preparation, and presentation.
- A single analytical dashboard view of the entire clinical supply chain is created covering all clinical studies, compounds, and sites with details of forecast of demand and supply for all material types.
- Personalized visualization layer with drill-down capabilities offers unprecedented visibility into the clinical trial programs, providing both broad overviews and deep dives.
- The system has also helped customers identify compounds that have high obsolescence.