I will analyze your warehouse inventory discrepancies and reconciliation issues
Manufacturing Systems, SAP EWM Application Support, Material Planning
About this Gig
Physical stock doesn't match the system and the gap keeps coming back? I analyze warehouse inventory discrepancies the way it's done on a live operation: compare, isolate, explain, and recommend.
What I do:
- Physical vs system stock comparison from your count sheets and system extracts
- Inventory exception analysis: batch, quantity, and bin discrepancies
- Root cause analysis process gaps, master data, or execution issues
- A practical reconciliation workflow you can repeat- Operational recommendations to stop the same gap recurring
What you get is a structured, reviewable report not a black box. I work from data you provide (Excel/CSV); I never need access to your systems.Background: ~5 years in electronics manufacturing warehouse operations, including inventory reconciliation on 1,500+ active bins. No fake guarantees: I tell you what the data supports and flag what needs checking on the floor.
Programming language:
SQL
Technology:
Excel
•
Google Sheets
•
Power Query
Expertise:
Business Insights
•
Trends
•
Anomaly detection
FAQ
What data do you need?
Your count sheets and system stock extracts in Excel or CSV: material, batch, quantity, bin/location. A small sample is fine to start.
Do you need access to our WMS or ERP?
No. I work from files you share. No system access, ever.
Can you guarantee you'll find the root cause?
No honest analyst can guarantee that from data alone. I report what the data proves, what's likely, and what to verify physically.
My data is messy. Is that a problem?
Messy is normal. Tell me what's messy and I'll tell you if it's workable before we start.
Do you work with non-SAP warehouses?
Yes. The method works for any WMS/ERP as long as I get location-level stock data.
