bg

Transform Your Supply Chain Planning and Marketing Strategies with Google Cloud and SAP Integration

Cloud Marketplace

Solving OTIF Delays: Boosting Delivery Efficiency for a UAE Giant During Peak Festival Season

This UAE-based conglomerate stands at the forefront of the healthcare, beauty care, prestige products, and fast-moving consumer goods sectors, catering to the evolving demands of the Saudi and Middle Eastern markets. Renowned for its diverse portfolio and commitment to quality, the company plays a pivotal role in enhancing the lifestyle and well-being of its customers across the region.

Challenges

During peak seasons, the conglomerate faced challenges in maintaining its hallmark efficiency, particularly in meeting the heightened demand for timely deliveries, which put a strain on its OTIF (On-Time In-Full) performance metrics. The underlying reasons for these challenges included:

Complex Supply Chain: Its global operations, involving multiple logistics, retail, and manufacturing segments, presented coordination challenges, affecting the timeliness and completeness of deliveries.

Data Fragmentation: Critical data, essential for effective OTIF tracking, was scattered across various Oracle systems, including Oracle Warehouse Management System (WMS), Oracle E-Business Suite (EBS), and Oracle Transportation Management (OTM). 

Forecasting Difficulties: Predicting demand accurately was hindered by the vast scale of operations and market variability, leading to either surplus inventory or shortages.

Logistical Inefficiencies: Varied regulations across regions and the complexity of international logistics further complicated the delivery process, impacting OTIF performance.

Why did they choose Pluto7? 

They chose Pluto7 for our quick turnaround—achieving results in just 4 weeks. Our expertise in Oracle data transformation and deep knowledge of the Google Cloud landscape stood out. We excel in merging domain expertise with data engineering skills, essential for tackling Oracle system challenges. 

Leveraging our experience in solving inventory challenges for other enterprises using Gen AI, AI, and ML, we utilized Google Cloud components and our decision intelligence platform, Planning in a Box, to help them turn OTIF issues into opportunities, optimizing delivery metrics and turning potential losses into gains.  

Solutions

Data Foundation using Google Cloud Cortex

Using the Google Cloud Cortex Framework, we created a data foundation on the customer’s own Google Cloud tenant, which set the stage for solving multiple use cases, starting with OTIF.

Real-Time Data Analytics

We blended internal data with external data to provide real-time data analytics with a Gen AI layer on top, making it possible to query enterprise-wide Oracle data in natural language and receive instant responses.

Process Mining for Spotting Bottlenecks

Through process mining, we mapped the conglomerate’s supply chain in real-time, quickly identifying bottlenecks. This insight led to targeted enhancements, significantly boosting OTIF delivery performance.

Real-Time Warehouse Insights

We’ve enabled instant visibility into warehouse operations, allowing for on-the-spot routing and inventory distribution adjustments. This change means decisions are made with current data, leading to more efficient operations and fewer delays.

Integrated Throughput Analysis

By combining data from various Oracle systems, we enabled the conglomerate to get a clear view of operational flow. 

Identifying Delays and Recommendations for Improvement

We’ve pinpointed precise delay sources within the supply chain, providing targeted recommendations for quick fixes. This approach ensures continuous operation improvements, reducing wait times and enhancing overall speed.

Outcomes

The transition to a streamlined, proactive system brought about significant improvements:

  • Built a strong data foundation, making it possible to add more use cases on the same infrastructure.
  • Transitioned from a siloed data environment to realizing tangible business value within just 4 weeks.
  • Integrated data from Oracle WMS, EBS, and OTM, creating a single view for all relevant metrics. 
  • Real-time warehouse visibility enabled the conglomerate to optimize routing and inventory distribution for enhanced efficiency.
  • Detected precise delay points within the supply chain and used AI to suggest actionable steps, reducing resolution times by 30%.
  • Lowered excess inventory, optimizing warehouse space and reducing holding costs.

 

Enable Decision Intelligence Into Every Corner Of Your Product And Operations.

industry image

Industry Healthcare| Wellness

Platform Planning-in-a-box| Platform-enablement

Challenges

  • Complex Supply Chain: Its global operations, involving multiple logistics, retail, and manufacturing segments, presented coordination challenges, affecting the timeliness and completeness of deliveries.
  • Data Fragmentation: Critical data, essential for effective OTIF tracking, was scattered across various Oracle systems, including Oracle Warehouse Management System (WMS), Oracle E-Business Suite (EBS), and Oracle Transportation Management (OTM).
  • Forecasting Difficulties: Predicting demand accurately was hindered by the vast scale of operations and market variability, leading to either surplus inventory or shortages.
  • Logistical Inefficiencies: Varied regulations across regions and the complexity of international logistics further complicated the delivery process, impacting OTIF performance.

Results

  • Built a strong data foundation, making it possible to add more use cases on the same infrastructure.
  • Transitioned from a siloed data environment to realizing tangible business value within just 4 weeks.
  • Integrated data from Oracle WMS, EBS, and OTM, creating a single view for all relevant metrics. 
  • Real-time warehouse visibility enabled the conglomerate to optimize routing and inventory distribution for enhanced efficiency.
  • Detected precise delay points within the supply chain and used AI to suggest actionable steps, reducing resolution times by 30%.
  • Lowered excess inventory, optimizing warehouse space and reducing holding costs.

Products Used

  • Google Cloud Cortex Framework
  • Google Cloud Storage
  • Google Cloud Dataflow
  • Dataproc
  • BigQuery
  • Vertex AI
  • Cloud Functions
  • Cloud Build
  • Artifact Registry
  • Source Repositories
  • Secret Manager
  • Looker on Google Cloud
  • Looker Embedded Analytics
  • Cloud Monitoring
  • Cloud Identity and Access Management (IAM)
  • Cloud Key Management Service (KMS)
  • Cloud Data Catalog