Government School ERP System — Full-Stack Platform for a Real Government School Client
Designed and built a bilingual, full-stack ERP system for a government school in Uttar Pradesh — replacing paper attendance registers, handwritten admission forms, and manual Mid-Day Meal logs with a secure, role-based digital platform.
Architected the full data layer — a 25+ model relational schema (PostgreSQL + Prisma) mapped directly from the client's actual government paperwork, including India's UDISE+ admission forms and Form-34 Transfer Certificates, not a generic template.
Built defense-in-depth security — role-based access control enforced at the server layer (not just route guards), brute-force account lockout, and a login system designed around a real constraint: students without personal phones authenticate by admission number instead.
Shipped a bilingual UI from day one — Hindi and English throughout, using next-intl, so the interface actually works for the people using it, not just the developer testing it.
Automated the admission pipeline end-to-end — a 30+ field digital intake form (photo + document uploads to cloud storage) that auto-generates student accounts and credentials in a single atomic transaction.
Still actively building — Mid-Day Meal tracking and automated report card generation are next. Open to freelance and contract work where someone needs to own both the system architecture and the day-to-day execution. If it's real, complex, and needs to actually ship — let's talk.
Like this project
Posted Aug 9, 2026
Government School ERP System — Full-Stack Platform for a Real Government School Client
Designed and built a bilingual, full-stack ERP system for a government...