Multi-Role School ERP Platform
A multi-tenant academic management platform supporting multi-role access panels.
Project Overview
The School ERP is an enterprise management system developed to replace manual paperwork in educational institutes. It manages academic scheduling, fee tracking, attendance registries, and grades logs under a unified system.
The Business Problem
Managing communications between administrators, teachers, and parents was fragmented. Calculating fee dues, tracking partial payments, and notifying parents about student absences required significant manual work.
Multi-Tenant Database & Automated Alert Core
We engineered a multi-role modular dashboard architecture:
Multi-Role Permission Grid
Programmed a database access controller defining strict permission routes for Admins, Teachers, Parents, and Students.
Automated Attendance Alerts
Built an API service that scans daily attendance files and triggers automated SMS/email alerts to parents for absent students.
Accounting & Fee Ledger
Programmed a financial dashboard that calculates term-wise fee dues, records partial payments, and prints digital receipts.
Academic Planner & Gradebooks
Created gradebook sheets allowing teachers to enter assessment marks and automatically compute class aggregates.
Technology Stack Used
Challenges Solved
- !Designing a flexible database schema to support variable grading weights and partial payment terms.
- !Ensuring low-latency rendering of student aggregate charts when querying heavy academic tables.
Project Results
- Automated the attendance logging process, sending SMS notifications to parents within 10 minutes of classes starting.
- Successfully integrated fee accounting, reducing school fee payment delays by 35%.
- Created an intuitive portal used daily by 50+ teachers and over 1,200 student profiles.
Future Roadmap
Integrating direct online credit card payment portals.
Building a custom portal for school bus GPS tracking.