Pack and Fill Planning Analytics Enabled Efficient Management of the Production Process

 

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 issues with respect to communicating important information to key internal stakeholders and CMOs (contract manufacturing organizations). The client felt a need for a solution that could provide a comprehensive record of the pack and fill planning to its key stakeholders. 

 

Solution

DiLytics provided the pack-and-fill analytics solution to the client on Oracle Analytics. The reporting solution provided the following information, item-wise: 

  • To the client’s internal staff:
    – Projected Demand
    – Work Orders
    – Planned Orders
    – Lot Number of the ingredient reserved for the Work Order
    – Beginning Hand inventory
    – Projected Hand inventory
    – Safety Stock
    – Months on Hand
    – Targeted Months on Hand
  • To the client’s CMO (Contract Manufacturing Organization):
    – Work Orders
    – Planned Orders
    – Lot Number of the ingredient reserved for the Work Order

Business Benefits

  • Improved planning and scheduling of the pack-and-fill process
  • Minimization of deviation from the pack and fill plan
  • Prevention of shipment delays and quality issues

 

Technical Stack

  • Source Systems: Oracle EBS, Oracle ASCP
  • 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 Oracle Analytics and Data Integration. 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.  DiLytics team has communicated with all levels of staff, including our business leaders and senior management.”  –  Associate Director (Finance Systems)  

To get a copy of this success story in a downloadable format with more in-depth analysis, kindly provide us a little information about yourself in the form below

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.