Demand Forecasting Analytics Enabled Accurate, Data-Driven Forecasts

 

Established in 1997, the client is a world leader in developing and commercializing first-or-best-in-class therapies for rare genetic diseases. Headquartered in California, US, the client has operations spread across 20+ countries and has 2500+ employees worldwide.  

 

Background

The client leveraged Oracle E-Business Suite (EBS) as its Enterprise Resource Planning solution and implemented Demantra for demand management. However, it was facing challenges due to lack of insights into: 

  • Accuracy of predicting demand for its products
  • Inconsistencies in supply chain in terms of production of goods, their delivery and their inventory

 

DiLytics implemented a solution on Oracle Analytics that involved:

  • Loading planned data from Oracle Advanced Supply Chain Planning (ASCP) and actual manufacturing orders execution, and inventory data from EBS into Data Warehouse
  • Building metrics, KPIs, dimensions, and hierarchies on the operational data, planning data, inventory data, and manufacturing execution data in Oracle BI Server
  • Building reports, dashboards, conditional alerts, and guided navigations in Oracle BI Presentation Server

 

DiLytics performed the following activities as part of the engagement: 

  • Requirements review and analysis
  • Fit-Gap analysis
  • Design ETL, EDW, and Oracle Analytics
  • Build ETL, EDW, and Oracle Analytics
  • Conduct Conference Room Pilot
  • Perform System Testing
  • Execute UATDeploy and go-live

 

DiLytics solution provided reports and dashboards in the following areas: 

  • Forecast Accuracy
  • Forecast Changes
  • Shipment Forecast
  • Forecast Bias
  • Out-of-Trend Forecast
  • Consensus Forecast

 

Business Beneifts

  • Accurate, data-driven demand forecasts
  • Increased supply chain efficiency
  • Reduction in inventory holding costs

 

Technical Stack

  • Source Systems: Oracle ASCP, Oracle EBS, Oracle Demantra
  • Data Integration Tool: Informatica
  • Data Warehouse: Oracle Business Analytics Warehouse
  • Reporting Tool: Oracle Analytics

What Does the Client Say?

DiLytics team specializes in Business Intelligence, Analytics, Data Warehousing, and Data Integration implementation services. They have provided training and knowledge transfer to our IT Staff and Business Users on OBIEE and ETL. We are very pleased with the flexibility, professionalism, quality and timelines of DiLytics’s work. The DiLytics team is diligent, proactive, and very responsive to our requirements and inputs. The DiLytics team has communicated with all levels of staff at BioMarin, including our business leaders and senior management. – Associate Director (Finance Systems)  

DiLytics Delivers

View all Success Stories →

Manufacturing Analytics

DiLytics implemented a Manufacturing Analytics solution for a Biotechnology Company in a short period of 100 days.

Custom Data Warehouse

DiLytics implemented a custom data warehouse solution for a Leading Container Leasing Company in a short span of 150 days.

Center of Excellence

DiLytics established a Business Intelligence Center of Excellence to help a Video Game and Digital Entertainment Company maximize RoI.