Educational institute management system
Case study · Educational institute · Pakistan · Jul 2025 – Oct 2026
Records, attendance, a portal and an app, all on one database.
A portal, a mobile app, fingerprint attendance and safe spreadsheet imports, all on one database, with automatic tests on every change.
Results
- 195 data models in one database
- 283 API endpoints
- 2,221 commits in four months
How it works, step by step
- Portal: Staff and students sign in; each sees only their part
- Mobile app: The same accounts and data on a phone
- Fingerprint: Attendance recorded straight from the scanner
- Imports: Old spreadsheets moved in; gaps flagged, never guessed
- Database: One source of truth for every record
- Auto-checks: Every update is tested before it goes live
Delivered for this client
- Portal (App): Student records, classes and attendance for staff and students
- Mobile app (App): The same accounts and data on the phone
- Attendance + imports (Automation): Fingerprint scanners and old spreadsheets feed the database safely
- Public website (Website): The institute's website, live
Role and stack
Architecture, build, testing and data migration. Built with Next.js, Express, Prisma, PostgreSQL, Expo, BullMQ.
Built by Usama Ali, a GTM & AI Automation Engineer who designs, builds and runs end-to-end systems for sales and operations. Get in touch.