Implementation of Supply Chain Analytics Enabled Improved Operational Efficiency and Agility in Responding to Market Demands

 

Established in the year 2000, the client is a leading creator, developer, and worldwide supplier of power semiconductors, with a diverse variety of Power Metal-Oxide-Semiconductor Field-Effect Transistor (MOSFET), Insulated-Gate Bipolar Transistor (IGBT), Intelligent Power Module (IPM), and Power (Integrated Circuit) IC products. It also installs proprietary wafer processing and packaging technologies at partner foundries to facilitate the design and manufacture of advanced power products. The client was using:

  • Homegrown ERP for Bookings, Billings, Inventory, Backlog, etc
  • Homegrown Supply Chain Planning system
  • Oracle EBS for Financial and Purchasing transactions

 

The client’s business users were using heavy Excel-based reporting by: 

  • Requesting IT for data extracts from various data sources
  • Extracting data into Microsoft Access DB and utilizing it for reporting/manipulating data off it

 

Due to Excel-based reporting, the turnaround time for report generation was very high. Also, high dependence on IT meant a sub-optimal experience for business users. Besides this, the business users were facing the following challenges: 

  • No visibility into Bill of Materials (BOM) to cleanse part names, wafer names & identify part shortages
  • Hard to analyze inventory by part, wafer, and technology used along with their status
  • Inability to compare supply and demand to determine inventory level
  • Identification of product demand and adjusting the production and inventory as per it
  • Ineffective comparison of constrained and unconstrained forecasts in production capacity limitations

 

Hence, the client wanted to improve its reporting infrastructure by bringing in elements of automating the report generation process, minimizing manual intervention in obtaining data for reporting, improving reports’ performance, and making reports accessible to a wide set of users. 

 

Solution

DiLytics implemented the solution on Oracle Analytics and provided the reports and dashboards in the following areas:  

  • Booking: Booking history, Booking summary
  • Billing: BOM summary with alternatives
  • Backlog: Backlog compensation
  • Wafer usage, Wafer shipment history, Revenue per Wafer
  • PoS and Marketing Forecast: PoS History, Market Data vs Billing
  • Marketing Plan; Marketing Performance
  • Open Purchase Orders
  • Capacity Planning
  • Activities

 

DiLytics also implemented Hyperion Planning, empowering the client’s Finance & Accounting team to perform the following: 

  • Revenue and Expense Analysis
  • Budgeting and Forecasting
  • Reporting on EBS data

 

As part of the solution, DiLytics provided the following services: 

  • Gather and document business requirements
  • Infrastructure sizing and environment set up
  • Design and build Enterprise Data Warehouse (EDW)
  • Design and develop ETL
  • Model the Facts and Dimensions in Oracle BI Repository
  • Create attributed and metrics
  • Design and develop Oracle Analytics metadata
  • Build Oracle Analytics reports
  • Conduct conference room pilot
  • Perform system integration testing
  • Execute UAT
  • Deploy the solution
  • Train End-users and IT personnel

 

The solution was implemented in a time frame of 16 weeks. 

Business Benefits

  • Access to comprehensive supply chain data to make informed decisions and address critical needs promptly. This led to improved operational efficiency and agility in responding to market demands.
  • Reduced lead times and capital costs with effective capacity planning conducted by taking into account current demand, future demand, and manufacturing capacity.
  • Better operational efficiency by gaining valuable insights into the Annual Operating Plan (AOP), sales forecast, and sales backlog.
  • Improved customer satisfaction with the help of projected month-end distributor inventory using KPIs like billed quantity, remaining quantity, and constrained PoS quantity.
  • Improved efficiency to determine products in high demand and adjust production and inventory accordingly.
  • Enhanced insights into process bottlenecks and inefficiencies without resorting to IT’s help; getting exception alerts based on defined conditions.
  • Efficient decision-making with sharing of the same view (having data from multiple systems, side-by-side) and metric definitions across functions.
  • Visibility into data 24×7 in a self-service way along with the ability to view data at a summary level with the option to drill down into relevant details.

Technical Stack

  • Source Systems: Homegrown ERP, Homegrown Supply Chain Planning, Oracle E-Business Suite (EBS), Oracle Manufacturing Execution System
  • Data Integration Tool: Oracle Warehouse Builder
  • Data Warehouse: Custom Data 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.

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.