Project · Production Management

Production Planning &
Supply Chain Performance

Ensured consistent monthly production targets by driving end-to-end planning, supply chain coordination and real-time performance monitoring in a complex industrial environment — contributing to $20M+ annual revenue and 97% On-Time Shipment.

Production Planning Supply Chain Power BI · SAP HANA Operations Management Data-Driven Decisions
97%
On-Time Shipment on invoiced deliveries
$20M+
Annual revenue contribution
90%
Lead-time reliability achieved

High-pressure industrial production environment with strong dependency on supply chain reliability and forecast accuracy. Monthly targets required tight coordination between production, procurement and customer service — with constant variability in supply, lead times and customer demand.

Context

Challenges

Challenge 01

Achieving monthly production targets despite supply uncertainties

Challenge 02

Lack of real-time visibility on production and stock status

Challenge 03

Coordination complexity between production, procurement & customer service

Challenge 04

Managing urgent deliveries and critical parts shortages

Challenge 05

Balancing cost vs. urgency — air freight vs. sea freight decisions

What I did

Actions Taken

1

Production Planning & Launch Orders

Defined and drove the Master Production Schedule (PDP) in coordination with the Industrial Director and Customer Service. Responsible for initiating production launch requests to the planning department — translating demand and stock status into concrete manufacturing orders.

2
Shopfloor ownership

Operator Priority Management

Communicated daily production priorities directly to operators on the shopfloor — adjusting sequencing in real time based on supply availability, urgency of orders, and customer commitments.

3

Weekly Supply Chain Coordination

Led weekly cross-functional meetings with procurement and supply chain teams to anticipate shortages and realign delivery schedules.

4

Weekly Stock Monitoring & Reporting

Built and maintained a structured weekly reporting system with full visibility across the supply pipeline.

Parts status per product lineDelivery date trackingCritical shortages dashboard
5

Power BI Dashboard — connected to SAP HANA

Developed a real-time production performance dashboard enabling dynamic priority adjustments and data-driven decisions at the shopfloor level.

6
Collaborative decision

Input on Logistics Mode Selection

Contributed to transport mode decisions (air vs. sea freight) by providing production-side visibility — lead times, urgency levels, and shopfloor impact — enabling supply chain and management to make informed trade-offs between cost and delivery performance.

Outcomes

Results

Monthly targets met

Consistent production target achievement across all periods

Real-time visibility

Improved stock & production status via Power BI live data

Faster decisions

Reduced response time to supply disruptions significantly

Logistics cost optimized

Air vs. sea trade-offs managed by production impact analysis

Supply disruptions reduced

Proactive weekly monitoring contained cascade effects

Stack

Tools & Technologies

Power BI

Real-time Dashboard

SAP HANA

ERP & Data Source

Microsoft Excel

Reporting & Planning

Supply Chain Mgmt

Coordination & Planning

PDP / MPS

Production Scheduling

Data Analytics

Decision Making

Proof of work

Dashboard Preview

Power BI Dashboard
Production Performance Dashboard — Power BI × SAP HANA Live Data