Material Requirement Planning Analytics Led to Improved Production Efficiency 

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 customer was facing a challenge with respect to determining which raw material needs replenishment and hence needs to be ordered, when to be ordered, in what quantity, and when the delivery of the order should be scheduled.

In addition, the customer also wanted information that would help it to identify what raw material items will create a production shortage, what raw material items in quarantine should be released and by when, and what raw material items should be called from the local warehouse in order to release it on time for the next production work order.

 

DiLytics’ Solution

DiLytics extended the current reporting solution in Oracle Analytics by:

  • Creating new tables and adding columns to existing tables in Enterprise Data Warehouse (EDW)
  • Developing ETL code using Informatica to extract data required for  MRP Analytics reporting from EBS into EDW staging tables
  • Developing ETL code using Informatica to load data required for  MRP Analytics reporting from the EDW staging tables into Facts and dimensions
  • Modeling the extended EDW tables in Oracle Analytics to create metrics and attributes

DiLytics implemented a solution on Oracle Analytics that involved:

  • Items with BOH Below Safety stock
  • Need by to Promise date PO
  • OTD to Promise date PO
  • Past Due PO Confirmation
  • Past Due PO
  • Past Due RM QA Release
  • Planned Orders Compression Lead Time
  • PO Lines created from MRP
  • PO Reschedule In-Out
  • Production Shortage Dashboard

Business Benefits

Key business benefits to the client included:

  • Improved inventory control via better scheduling and ordering for raw material items
  • Increased production efficiency

Technical Stack

Source Systems: Oracle EBS, Oracle ASCP 

Data Integration Tool: Informatica 

Data Warehouse: Oracle Business Analytics Warehouse 

Reporting Tool: Oracle Analytics 

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.

Enterprise Data Warehouse Implementation Enabled Better Business Performance

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.