Production ERP for steel fabrication, deployed and running daily operations at Kumar Brothers (Bokaro). Scope: - 172 API endpoints across 3 versioned APIs (v1 legacy CRUD, v2 lot-level inventory, v3 drawing-based production tracking) - Drawing-based Kanban production tracking with per-component stage management - Dual inventory system: simple counts (v1) + lot-level traceability with immutable audit trail (v2) - Goods Receipt Note (GRN) and Dispatch workflows with weighbridge integration - Auto material deduction at fabrication stage with double-deduction prevention - 6-role RBAC (Boss, Supervisor, Store Keeper, QA Inspector, Dispatch Operator, View-only) - Excel import with 90+ column alias matching, auto-linking profiles to raw materials - Scrap management with recovery and loss analytics Infrastructure: - FastAPI 0.128 + SQLAlchemy 2.0 + PostgreSQL on Google Cloud SQL - Deployed to Google Cloud Run via GitHub Actions + Cloud Build (Workload Identity Federation) - 78 end-to-end tests running against live deployment - JWT auth with python-jose + bcrypt Live: kbsteel-backend-498310931350.asia-south1.run.app GitHub: github.com/mangod12/industryERP