Northern Railway Portal
Production trainee-management system replacing paper workflows at Northern Railway WTC
The Problem
Trainee records, attendance, and certificate workflows were managed entirely on paper, which created delays, duplicate records, and poor traceability across departments.
Architecture
System:React + MUI -> Node.js/Express layered API -> PostgreSQL
React -> Express routes/controllers/services -> PostgreSQL + PDF generation
Key decisions:
- Layered API architecture
because Separating routes, controllers, and services reduced coupling and made business logic easier to test and evolve. - State-machine trainee lifecycle
because A five-state model prevented invalid transitions and created consistent records for training progress. - Automated certificate generation
because Generating PDFs from structured data removed manual formatting and reduced administrative workload.
Impact
- Replaced paper-based trainee workflows with a centralized portal
- Implemented a 5-state trainee lifecycle model
- Automated attendance and certificate generation
- Supported concurrent usage across training operations
What I’d Do Differently
I’d add a full audit trail and role-based analytics dashboards earlier so supervisors can track bottlenecks and compliance without manual exports.