Schneider Electric · Supply Chain Planning Intern · 2025
Keeping high-risk orders on schedule
Built a daily exception-management process to find high-risk orders before pickup, clear the inventory and warehouse issues behind them, coordinate carrier execution, and feed root causes back through a shared Control Tower view.
SAP · Oracle · Advanced Excel · Control Tower
- Cadence
- Daily high-risk order review and pickup monitoring
- Measurement period
- 1 quarter of sustained exception management
- Outcome
- 30% improvement in on-time pickups
Get ahead of the pickup window
- 01 Morning risk review scheduled pickup date and customer-facing urgency
- 02 Validate inventory position on hand, in transit, backorders and open POs across SAP and Oracle
- 03 Prepare shipment warehouse readiness, documentation, pickup cutoff
- 04 Execute pickup carrier coordination, including earlier international cutoffs
Learn from what was missed
- 05 Review prior-day misses late and missed pickups from the previous run
- 06 Identify root cause inventory, warehouse readiness, documentation or ERP release
- 07 Assign action and owner corrective action with named stakeholder ownership
- 08 Publish performance Excel exception report into the Control Tower dashboard
Runs every morning, so each day's root causes reshape the next day's risk review.
30% improvement in on-time pickups over one quarter
Challenge
High-priority shipments missed scheduled pickups for reasons that had little to do with carrier availability: incomplete orders, warehouse readiness, documentation requirements, late ERP releases.
The pickup window is the constraint. Each of those causes had to be found early enough to act on it before the window closed — and the same causes kept recurring, so catching them once was not enough.
What I did
- Prioritized high-risk orders each morning, using scheduled pickup date and customer-facing urgency to decide where attention was needed.
- Validated the real inventory position for each priority SKU, checking stock on hand, in transit, backorders and open POs across SAP and Oracle.
- Coordinated warehouse and carrier readiness, making sure parts were picked and staged against the right cutoff — international pickups run earlier than domestic ones.
- Reviewed the prior day’s late and missed pickups to identify what had actually caused each one.
- Built an Excel exception and root-cause report showing misses, causes, corrective actions and owners, and published it to the Control Tower dashboard for shared visibility.
Decision
A missed pickup was rarely just a carrier problem. I structured the day around finding the order-level risk early enough to resolve the inventory, warehouse, documentation or system issue behind it before the pickup window closed.
Outcome
On-time pickups improved 30% over one quarter.
The process also closed the loop between daily execution and root-cause review, giving warehouse, planning, operations and leadership teams one shared view of what had been missed, why, and who owned the fix.