An upcoming specialty pharmaceutical firm was looking to elevate its forecasting infrastructure for its pain management portfolio.
Viscadia designed and built a statistical trend-based forecast platform for predicting demand across different channels. While accounting for market, product or channel level event impacts. Furthermore, it granted the capability to download essential summaries and execute comprehensive calculations quickly.
Triangulated demand, ex-factory and distributor data to prepare inputs for trending. Automated data processing to build data pipeline and adjust for capture rates
Designed an integrated and robust statistical palette to generate baseline forecast as part of the inline model, embedding it within the primary framework
Built in modular fashion to visualize and draw comparison across different forecast versions. Adjunct waterfall views to assist in compartmentalizing the deviation
Implemented an end-to-end dynamic feature to map rebates data at payer level to contract type level by leveraging insurance program details
Devised user-friendly automation in the model to enhance model usability and accessibility while not compromising the transparency of the flow
Developed a comprehensive module to weigh in impact of key events for market, product and contracting events and assimilated it within the model