Manufacturing ERP System
Discrete Manufacturing & Production Planning
A full production ERP spanning BOM, planning, procurement, WIP and costing — modernised from a legacy desktop system.
BOM → Costing
Scope
Desktop → Web
Modernised
Multi-plant
Entities
Flask + Angular
Stack
Overview
An end-to-end manufacturing ERP covering bill-of-materials, production planning, procurement, material issue, work-in-progress and cost variance. The platform modernises a legacy desktop application into a Flask + Angular + PostgreSQL stack.
The business problem
Critical production logic lived in an ageing desktop system that was hard to maintain, impossible to access remotely, and disconnected from modern reporting needs.
The solution
I rebuilt the core into a modular Flask REST backend with a normalised PostgreSQL model and an Angular front end, preserving deep manufacturing logic while adding audit trails, multi-entity support and modern reporting.
My responsibilities
- Modelled BOM, routing, WIP and costing in a normalised schema
- Built production planning, procurement and material-issue modules
- Implemented rejection / rework and subcontractor tracking
- Delivered cost-variance analysis and Excel report exports
Challenges solved
- Porting deep procedural logic without losing business rules
- Linking production orders to forecasts and inventory accurately
- Modelling inventory valuation across multiple methods
Key features
Architecture highlights
- Modular Flask REST API with master-detail data hierarchies
- Normalised PostgreSQL model for multi-entity manufacturing
- Process routing with operation sequences and machine mapping
- Batch processing for cost roll-ups and reporting
- Comprehensive audit trail across production records
Technologies used
Scalability
A modular service layout lets new manufacturing modules slot in independently, while multi-entity support scales across plants.
Performance
- Set-based SQL for cost roll-ups
- Indexed master-detail access paths
- Batched report generation
Security
- User authorization levels per module
- Audit trail across all production records
- Validated master-data entry
Screenshots
Product screenshots available on request (NDA-protected).
Architecture diagram
Detailed system architecture available on request.
Related work
View allQuality Lifecycle Management Platform
Manufacturing Quality (Forging)
Standardised manufacturing quality and eliminated errors from outdated process documents through strict version control.
Human Resources Management System
Human Resources & Workforce Management
Automated the full employee lifecycle — attendance, leave, payroll and recruitment-to-onboarding — in one integrated system.
Print Shop Management ERP
Printing Press & Job-Shop Manufacturing
Quote-to-dispatch ERP for a printing press: scheduling, job costing, inventory and multi-process production tracking.