Download PDF
Forecast Automation and Optimized R&D Pipeline
Technology Category
- Analytics & Modeling - Predictive Analytics
Applicable Industries
- Pharmaceuticals
Applicable Functions
- Product Research & Development
- Business Operation
Services
- Software Design & Engineering Services
- System Integration
The Challenge
The company wanted the ability to analyze a range of potential outcomes in two separate areas. Pharmaceutical R&D decision making is perhaps the most perplexing and high-stakes responsibility in the modern enterprise. The reasons are no secret: Drug developers make huge investments, some with 10-year development timelines, or more. They face extreme technical and regulatory uncertainty about these investments. Meanwhile, they must cross-manage a vast portfolio of potential products at varying stages of development. Drug development pipelines are massive risk portfolios dotted with a few hard-to-see, and harder-to-realize, opportunities for reward. This can frustrate even advanced portfolio management processes. It is impossible to know, for example, which projects will make it to market, fail to gain regulatory approval after years of investment, or never make it out of the discovery phase. Despite these unknowns, the pressure to replenish pipelines with high-potential future revenues is relentless. Facing these odds, one top-20 global drug developer approached Vanguard Software about the possibility of a system that could address this challenge. Along with many other attributes, the company wanted a system that could apply advanced modeling and simulation to complex drug-development data. The end goal was to better inform management decision making. At the time, the company was targeting several challenges. According to an Associate Portfolio Management Director with the company who spoke recently with Vanguard Software: “Our existing system was time-consuming. It was difficult to update and maintain the data, and it offered little flexibility as far as managing what-if scenarios. It was not able to provide some of the more advanced analysis that we wanted. We had to do that in Excel.”
About The Customer
A top-20 global drug developer needed a solution to address typical industry issues: large monetary investments, technical and regulatory uncertainty, and managing a portfolio of products at varying stages of development. The company is a major player in the pharmaceutical industry, dealing with the complexities of drug development which involves significant financial investments and long timelines, often spanning over a decade. They face the challenge of navigating through technical and regulatory uncertainties while managing a diverse portfolio of potential products at different stages of development. The company sought a more efficient and effective way to handle these challenges, aiming to optimize their R&D pipeline and improve decision-making processes. They approached Vanguard Software to explore the possibility of implementing a system that could provide advanced modeling and simulation capabilities to better inform their management decisions.
The Solution
The company wanted the ability to analyze a range of potential outcomes in two separate areas: line items on the Profit and Loss (P&L) statement and expected R&D spending, taking timeline uncertainty into account. They aimed to understand the probability of each possible outcome and model individual and aggregate outcomes under multiple scenarios, known as 'what-if' testing. They sought a full-scale Monte Carlo simulation for operational and strategic planning, a web-based environment, and the ability for potentially dozens of users to collaborate on the same data. The existing software system was inadequate, as were the spreadsheets they used for modeling and simulation. The company also wanted to optimize its selection and prioritization of R&D projects with less effort and more clarity. The highest value projects needed to move forward to maximize sustainable future revenue, while lower value projects needed to be identified and discarded to avoid draining resources. The result was project and portfolio forecasts that more accurately predicted the measure of uncertainty, providing more effective decision-making. Vanguard Software delivered a system that enabled the company’s R&D Portfolio Managers to test different courses of action, perform sensitivity analyses, and get an automated roll-up of projects into a multi-year, company-wide projection of future operational and financial performance.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Case Study: Pfizer
Pfizer’s high-performance computing software and systems for worldwide research and development support large-scale data analysis, research projects, clinical analytics, and modeling. Pfizer’s computing services are used across the spectrum of research and development efforts, from the deep biological understanding of disease to the design of safe, efficacious therapeutic agents.
Case Study
Fusion Middleware Integration on Cloud for Pharma Major
Customer wanted a real-time, seamless, cloud based integration between the existing on premise and cloud based application using SOA technology on Oracle Fusion Middleware Platform, a Contingent Worker Solution to collect, track, manage and report information for on-boarding, maintenance and off-boarding of contingent workers using a streamlined and Integrated business process, and streamlining of integration to the back-end systems and multiple SaaS applications.
Case Study
Process Control System Support
In many automated production facilities, changes are made to SIMATIC PCS 7 projects on a daily basis, with individual processes often optimised by multiple workers due to shift changes. Documentation is key here, as this keeps workers informed about why a change was made. Furthermore, SIMATIC PCS 7 installations are generally used in locations where documentation is required for audits and certification. The ability to track changes between two software projects is not only an invaluable aid during shift changes, but also when searching for errors or optimising a PCS 7 installation. Every change made to the system is labour-intensive and time-consuming. Moreover, there is also the risk that errors may occur. If a change is saved in the project, then the old version is lost unless a backup copy was created in advance. If no backup was created, it will no longer be possible to return to the previous state if and when programming errors occur. Each backup denotes a version used by the SIMATIC PCS 7 system to operate an installation. To correctly interpret a version, information is required on WHO changed WHAT, WHERE, WHEN and WHY: - Who created the version/who is responsible for the version? - Who released the version? - What was changed in the version i.e. in which block or module of the SIMATIC PCS 7 installation were the changes made? - When was the version created? Is this the latest version or is there a more recent version? - Why were the changes made to the version? If they are part of a regular maintenance cycle, then is the aim to fix an error or to improve production processes? - Is this particular version also the version currently being used in production? The fact that SIMATIC PCS 7 projects use extremely large quantities of data complicates the situation even further, and it can take a long time to load and save information as a result. Without a sustainable strategy for operating a SIMATIC PCS 7 installation, searching for the right software version can become extremely time-consuming and the installation may run inefficiently as a result.
Case Study
Drug Maker Takes the Right Prescription
China Pharm decided to build a cloud-based platform to support the requirements of IT planning for the next five to ten years which includes a dynamic and scalable mail resource pool platform. The platform needed to have the following functions: all nodes support redundancy, ensuring service continuity and good user experience, simple and easy-to-use user interfaces for end users and administrators and good compatibility and supports smooth capacity expansion.
Case Study
ELI LILLY ADOPTS MICROMEDIA’S ALERT NOTIFICATION SYSTEM
Pharmaceutical production is subject to a strict set of enforced rules that must be adhered to and compliance to these standards is critically necessary. Due to the efforts of WIN 911’s strategic partner Micromedia, Lilly was able to adopt an alarm notification infrastructure that integrated smoothly with their existing workflows and emergency hardware and protocols. These raw energy sources enable the industrial process to function: electricity, WIN-911 Software | 4020 South Industrial Drive, Suite 120 | Austin, TX 78744 USA industrial steam, iced water, air mixtures of varying quality. Refrigeration towers, boilers and wastewater are monitored by ALERT. Eli Lilly identified 15000 potential variables, but limitations compelled them to chisel the variable list down to 300. This allowed all major alarms to be covered including pressure, discharge, quantity of waste water discharged,temperature, carbon dioxide content, oxygen & sulphur content, and the water’s pH.
