Background
Inbound/outbound tracking lived in Excel files maintained by several people: version conflicts were constant, month-end reconciliation took two days, and management had no real-time view of stock or tickets.
Approach
- 1
Interviewed warehouse, dispatch and finance roles; mapped the actual process including edge cases
- 2
Designed a role-permission matrix and operation logs — every critical change traceable
- 3
Shipped the core ticket and inventory flow first; dashboards and exports two weeks later
- 4
Cleansed and imported historical spreadsheets, keeping originals for reference
Results
- Month-end reconciliation cut from two days to half a day
- One stock truth; version conflicts gone
- Management sees ticket and stock status in real time
Tech Stack
Next.jsNode.jsPostgreSQLEChartsDocker
