Skip to content
Work

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.