Warehouse Automation System

Identified an inefficiency on the warehouse floor and worked with a third-party WMS vendor to consolidate three fragmented inventory tables into a single intuitive view, reducing cognitive load and bridging the skill gap between experienced and new staff.

My Contributions

• Identified the inefficiency and pitched the consolidation to management and the WMS vendor
• Tested the new tables, reported bugs, and documented edge cases
• Collaborated with WMS developers on schema and SQL changes
• Trained staff on the new workflow with practical tips and best practices

The warehouse relied on three separate tables that staff had to cross-reference simultaneously:

1. Inventory pallet contents (what items are where)
2. Collection status (items picked and ready)
3. Customer order tracking (item locations for the day)

This forced staff to mentally consolidate data across three views, increasing cognitive load and error risk during high-volume operations.

Working with the WMS development team, we designed a single unified table consolidating all three functions. Initial testing revealed the table was static (only updated by warehouse input). I traced this to order date misalignment between systems; we then implemented dynamic synchronisation to keep it live.

• Mapped variables and dependencies to understand the full data landscape
• Identified essential vs. redundant fields to reduce cognitive load
• Coordinated tight deadlines via documentation, calls, and detailed PDFs