Bihar State Madrasa Education Board · Government
BSMEB Academic Portal
A results portal for 3,000 schools that stopped timing out
- Role
- Full Stack Developer & Team Lead
- Year
- 2022
- Stack
- ReactJs · MySQL8 · HTML5 · CSS3 · Bootstrap5
The problem
The board administers admissions, registrations, staff records, and examinations for more than 3,000 schools. The queries behind those screens ran against over a million records and took a full minute to return — long enough that staff assumed the system was broken and reloaded, multiplying the load that caused the problem. Examination season concentrates almost all of that traffic into a few days, so the failure mode arrived exactly when the system mattered most. Payments were failing at a rate that generated its own support burden.
The approach
The bottleneck was the data layer, not the interface, so that is where the work went first — profiling the real queries against production-scale data rather than a seeded development set, which is the only way the pathological cases show up. Payment reliability was treated as a second, separate problem: gateway failures needed to be distinguished from user error before anything could be fixed, which meant instrumenting the flow before changing it. I led the team delivering this across a three-year engagement.
What I built
Admissions and registration
End-to-end intake for schools and students, replacing a process that could not scale past its own paperwork.
Teacher and institution management
Records for staff and member madrasas across the state, with the access control a government body requires.
Examination management
The system's peak-load surface: scheduling, records, and results for the board's examination cycle.
Query performance rebuild
Restructured the queries and indexing behind the heaviest screens, taking response times on 1M+ record tables from 60 seconds to 1.2.
Payment gateway integration
Integrated SabPaisa and NTT Data, lifting successful transactions by 30% and cutting failures by 20%.
Results
- Core query response time
- 60s1.2s
- Schools served
- 3,000+
- Records under query
- 1M+
- Payment success rate
- +30%
- Payment failures
- −20%
- Engagement length, as team lead
- 3 yrs
How to read these
- Query timings are measured against the board's production dataset, which grows each examination cycle.
Keshav was instrumental in building our IT infrastructure and developing our web systems from scratch. His technical expertise and dedication greatly enhanced our digital capabilities.
Dr. Md. Noor IslamController of Examinations, Bihar State Madrasa Education Board