School ERP (VPS SMS)
An enterprise school management platform spanning admissions, academics, fees, payroll, transport and parent communication.
Context
Running a modern educational institution (such as Vivekananda Public School) involves juggling dozens of disparate operational domains: admissions, student lifecycle, academic calendars, complex multi-component fee structures, class timetabling, examinations and report card generation, staff payroll, transportation routes, and parent communications.
Most off-the-shelf school management software are either fragmented point solutions or clunky legacy systems. The goal was to build a unified, high-performance, enterprise-grade School Management System (SMS) that provides a single source of truth for school administrators, principals, teachers, students, and parents.
What we built
We engineered a modular monolith School ERP with an ASP.NET Core backend and an Angular frontend featuring 29 domain modules, 68 REST controllers, and 83 specialized services.
Backend — ASP.NET Core Modular Monolith
- Architecture & Patterns: Modular monolith with clear domain boundaries, CQRS patterns, and global query filters for soft deletion.
- Interceptors & Auditing:
AuditInterceptor: Automatically tracks entity creation, modifications, timestamps, and active user identities.AcademicYearLockInterceptor: Enforces transactional data locking when academic periods are finalized.
- 29 Specialized Domain Modules:
- Admissions & Student Management: Complete student records, roll numbers, sibling relations, and document tracking.
- Academics & Lesson Plans: Multi-section division, subject allocation, syllabus progress, and Excel-based lesson plan import.
- Attendance Engine: Period-wise and daily attendance logging with automated absent alerts to parents.
- Examination & CCE Grading: Exam schedules, mark sheets, grade scales, and automated report card generation.
- Fee Collection & Finance: Multi-tier fee structures, installment management, concession rules, receipt generation, and dues tracking.
- Staff HR & Payroll: Faculty directory, leave management, automated monthly salary slips, and deduction calculations.
- Transport & Fleet: Bus routes, pickup/drop points, driver records, and student bus allocation.
- Hostel Management: Room/bed allocations, wardens, and residential fee tracking.
- Communication Suite: Multi-channel notifications via email, SMS, and in-app feeds.
- Role & Policy Authorization: Fine-grained permissions with JWT authentication and session validation.
Frontend — Angular with Signal Reactivity
- Built with modern Angular (Standalone Components) using Signals for fine-grained reactivity.
- ExcelJS & SheetJS (
xlsx) for bulk data import and export (marks, attendance sheets, student lists). - JsBarcode integration for automated generation of student/staff ID cards, admission codes, and library barcodes.
- Clean administrative dashboards and dedicated portals for staff, teachers, and parents.
Database & Testing
- MySQL database driven by Entity Framework Core (EF Core) with 35+ migration versions.
- Unit and integration testing suite via
SchoolService.Tests(xUnit).
Outcome
The platform unifies all institutional operations into one cohesive digital environment. Administrators gain real-time oversight of collections and student metrics, teachers save hours on grading and lesson planning, and parents stay informed through timely notifications and academic progress reports.