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.
