Managed Markets Forecasting and Modeling Tool

A top-5 Pharma company came to Everest with a problem: they needed to know how a new tier status would impact their sales forecast. This customer was entering a period of heavy competition, generic entrants, and Managed Care contract negotiations, and they needed a quantitative, predictive model for account forecasting and scenario analysis.

It was a complicated business problem, but Everest had the answer. Our customized solution included three items: a custom data warehouse, a custom modeling application, and a web portal. The data warehouse allowed the customer to bring together syndicated account sales data, account affiliation data, and formulary data. Now that the data was in place, the customer was able to utilize the modeling application to generate “what-if” scenarios which allowed them to evaluate and forecast account volume using expected variables. On top of these solutions, we also provided a web portal for the customer’s master data management, cube and report viewing, as well as tracking forecasts over time.

We provided a complex solution, but the benefits to the customer were simple. Using the tools we created for them, the customer could now predict account volumes accurately in mere minutes when given input parameters. And market and account analysis which previously took months to perform could now be completed in hours, or even minutes; greatly reducing analytic expenses.

Not only did Everest’s solutions for the customer save them time, we also saved them money: $20 million to date.

Technologies used: SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Microsoft Excel, ASP.NET 4.0, AJAX, MDX, OLAP