Turning supply chain challenges into practical, scalable solutions.

From operating issue to sustained adoption

The approach combines supply chain leadership, SIOP, Lean problem solving, and enough technical knowledge to translate business needs into useful solutions.

Selected transformation cases

Project information is anonymized. Screenshots are recreated mockups with fictitious data (plants, parts, containers, units, people and locations) to protect the original information. Outcomes are clearly identified as measured, estimated, or projected.

Supply Chain Control Tower

End-to-end visibility • SIOP • Management decisions

Management visibility

Business issue

Service, materials, inventory, logistics flow, quality, and people indicators were reviewed in separate sources, making it harder to identify priorities and connect operational risks.

Solution and role

I designed a unified management view that connects key supply chain signals, highlights exceptions (service, materials and MRP, inventory, logistics, quality and people), and allows leaders to move from high-level performance to the detail behind each issue.

Business value

One management view
Improves visibility, supports SIOP and daily operating reviews, and helps focus decisions on the most relevant risks and actions.

Fictitious data to protect original information.

MRP Exception Management and ASN Automation

Planning discipline • SAP integration • Standard work

Implemented

Business issue

Recurring SAP exception messages and ASN updates consumed planning capacity and depended on individual work methods.

Solution and role

Defined the workflow, designed the business logic, developed and deployed an SAP-integrated solution, and led testing, training, adoption, and support.

Business value

~42 hours/week
Estimated planning capacity released, with daily use and more consistent execution.

Fictitious data to protect original information.

Automated Container Visibility

Inbound logistics • Carrier ETA • SAP ASN workflow

Implemented

Business issue

Teams checked carrier sources individually and then updated inbound information manually, slowing response to ETA changes.

Solution and role

Designed a workflow covering approximately 200 monthly containers that retrieves status and ETA directly from carrier websites, flags delays, refreshing carrier ETA information three times per week and using macros to update SAP ASNs.

Business value

20+ hours/week
Estimated administrative capacity released while improving shipment visibility and update consistency.

Fictitious data to protect original information.

Demand-Risk Scoring

SIOP input • Customer demand • Production scheduling

Implemented

Business issue

Weekly demand changes required time-consuming review and made anomalies harder to identify consistently.

Solution and role

Designed and implemented a scoring workflow using historical patterns and trends for customer service and production scheduling.

Business value

Weekly use
Faster analysis and easier identification of demand anomalies.

Intralogistics Capacity Analysis

Lean flow • Labor and equipment • Scenario planning

Decision support

Business issue

Production requirements were expressed in units per hour without a consistent model for routes, cycle time, labor, and material-handling equipment.

Solution and role

Defined the operating logic and built a repeatable planner (tuggers, drivers, pickers, scanners vs. required) to compare required and available capacity and evaluate flow alternatives.

Business value

Fact-based scenarios
Supports resource, route, and automation decisions without claiming unmeasured savings.

Fictitious data to protect original information.

Tools built on the floor

Practical tools I designed and built with SAP, VBA, Python, Power BI and web technologies to support the cases above. Impact figures are shown only where validated.

All screenshots are recreated mockups with fictitious data to protect the original information.

Fictitious data to protect original information.

Plant Layout Measurement

Converts static layouts into measurable inputs: calibrates scale and measures spaces and routes to compare layout alternatives.

Layout analytics

Fictitious data to protect original information.

PFEP and Route Modeling

Connects material points, routes, stops and replenishment logic on the actual floor; route builder for mobile equipment driven by the PFEP.

PFEP • Lean • Intralogistics

Fictitious data to protect original information.

Warehouse Capacity & Layout Planner

Evaluates usable area, product allocation by customer, volume and capacity constraints, with shortage alerts and a layout health score.

Capacity planning

Fictitious data to protect original information.

Material Coverage / Clear-to-Build

Checks the production plan against BOM and inventory, ranking shortage, coverage and exception signals (critical, urgent, alert) for faster decisions.

SAP PP/MM • Excel/VBA

Fictitious data to protect original information.

Interplant Route Monitoring

Uses supplier GPS and geofences across three routes to analyze cycle time, deviation and plant dwell, with responsible-contact lookup for fast escalation.

GPS • Geofencing • Maps

Fictitious data to protect original information.

Problem Solving Assistant

HTML form with guided questions about the problem; adds a prompt and exports a .txt (questions, answers and prompt). Pasted into Copilot, it asks any missing questions and generates the 8D, A3, Ishikawa and 5 Whys, solving the recurring difficulty of answering and using these tools correctly.

HTML • JavaScript • Generative AI (Copilot)