Case study 02 — Operations platform · Published
MW Supply Platform
- Period
- 2024 – 2025
- Role
- Sole developer — data model, backend, dashboard
- Stack
- Python · FastAPI · React · Supabase · PostgreSQL
Problem
A bottled-water operation tracked customers, daily deliveries, bottle inventory, and payments by hand. Bottles went missing, settlements lagged, and the owner had no operational picture.
Constraints
- 01Daily delivery cadence — the system must keep up with round trips
- 02Bottle-level inventory: every container tracked in and out
- 03Payment status visible at a glance for collections
- 04Operators primarily on phones in the field
Architecture
What was built
- Customer ledgers with delivery history and balances
- Bottle movement tracking across fills, deliveries, and returns
- Billing and payment monitoring with settlement views
- One operational dashboard for daily decisions
Outcome
Impact
Reduced manual tracking across water-supply workflows
Status
Published and in operation