Back to Projects
Case Study2022 - 2023
School ERP Portal
An all-in-one portal managing student life cycles from registration and class scheduling to automated report card generation.
Role
Software Engineer
Sector
Education
app://school-scheduler
Students
1,420
Sync Rate
96.4%
Queued PDFs
0
Schedules Validation
Math 101 (Room 4B)CONFLICT FREE
Physics 202 (Lab A)CONFLICT FREE
The Challenge
- Generating high-volume PDF report cards on demand during finals week, causing server timeouts.
- Designing complex multi-class schedule matrices without room or teacher collisions.
- Slow loading student profile histories containing attendance and grading tables.
Our Solution
- Offloaded PDF generation tasks to a distributed background worker queue.
- Developed a custom scheduling validation engine to block booking conflicts.
- Optimized query paths and introduced eager-loading for relationships.
Measured Impact
"Successfully deployed in multiple schools, reducing final-term reporting overhead from several days to a few hours."
System Reliability Verified