M7 WMS

Wine Warehouse Management Platform

Role: Full-Stack Engineer

PythonFastAPIPostgreSQL (Supabase)SQLAlchemyRAGClaude AIClaude CodeMulti-Agent OrchestrationNext.jsSwagger/OpenAPIRailwayVercel

End-to-end warehouse management system replacing a legacy fulfillment platform for a wine 3PL. Handles the complete operational spine: inventory receiving, FCFS/FEFO allocation, pick batching, packing, multi-carrier shipping, ShipCompliant integration, invoice reconciliation, and AI-powered operational assistance.

Project walkthrough

Part 1

Part 2

Part 3

Part 4

What we built

Designed and developed a scalable Python/FastAPI backend across 70 normalized database tables with UUID-based schemas, database constraints, audit trails, and trigger-driven automation.
Implemented a 13-state order lifecycle with a FULL-OR-HOLD allocation engine utilizing FCFS (First-Come, First-Served) and FEFO (First-Expired, First-Out) inventory strategies.
Built Retrieval-Augmented Generation (RAG) capabilities to enable intelligent document search, operational knowledge retrieval, and AI-assisted warehouse workflows.
Leveraged Claude AI and Claude Code to accelerate development, automate documentation generation, and support internal operational intelligence features.
Developed two Next.js portals—an internal operations, finance, and warehouse management console, and a client-facing winery portal—with a shared component library and auto-generated typed API clients from OpenAPI specifications.
Implemented role-based access control for 7 distinct user roles with route-level and data-level authorization.
Integrated billing margin analysis, carrier invoice reconciliation, and rate-card resolution workflows powered by PostgreSQL functions and optimized query pipelines.
Built and maintained comprehensive API documentation using Swagger/OpenAPI, improving integration efficiency across internal and external systems.
Deployed and managed cloud infrastructure using Railway and Vercel with CI/CD pipelines and environment-specific deployment workflows.

← Back to Logistics, Warehouse & Operations