OMS-360 — Enterprise Order Management System
Business problem
A mid-size retail operation needed to replace spreadsheet-driven order tracking with a real system — one where an order's status, inventory impact, and fulfillment state stayed consistent no matter which team touched it.
Architecture
Workflow
Testing strategy
- ✔Functional testing of order states
- ✔Regression on every release
- ✔API contract testing (Postman/Newman)
- ✔SQL-level data integrity checks
- ✔End-to-end business workflow validation
Challenges & solutions
Challenge — Order status could drift out of sync with inventory when two updates landed close together.
Solution — Built targeted concurrency test scenarios and traced the fix through to a database constraint, then locked it into the regression suite so it can't silently reappear.
Challenge — Refund flows touched three services, making manual testing slow and error-prone.
Solution — Automated the full refund path in an end-to-end test, cutting a 20-minute manual check down to a repeatable script.
Tech stack
Database design
Business benefits
- ✔Order-to-fulfillment status is trustworthy across every team
- ✔Release regression time dropped once critical paths were automated
- ✔Clear audit trail for every order state change
Outcome — Now used as the reference project for our Automation & CI/CD and Enterprise Tooling training modules.


