Kandypack — Rail & Road Supply Chain System
The Challenge
A distribution system spanning rail and road logistics needed a database design that could stay consistent across 10+ modules — inventory, orders, routes — without data anomalies, plus a real application layer on top of it.
My Approach
I designed the full ER diagram and relational schema from requirement analysis, normalized to 3NF, and implemented the tables with defined primary/foreign keys and constraints across 10+ modules. I wrote the SQL queries for reporting and data retrieval, from inventory to order processing, as part of a full-stack system with a Next.js frontend, a TypeScript backend, and a Dockerized CI/CD pipeline.
Outcome
A normalized, constraint-enforced database backing a working full-stack system, with SQL reporting queries covering the system's core inventory and order-processing workflows.