Case file 02 — School management system
EduPulse
A school doesn't run on paper and hope, or it shouldn't. EduPulse is the operating system underneath: academics, finance, HR, library, communication, all one connected reality instead of four disconnected simulations that quietly disagree with each other.
The glitch
A school isn't short on data, it's short on one place to put it. Attendance lives in a register. Fees live in a ledger. Grades live in a teacher's spreadsheet. Notices go out over whatever app happens to be fastest that day, four disconnected copies of a reality that should be one. Four very different users (admin, teacher, student, parent) all need to look at the same underlying system and see only their own slice of it, and that boundary can't be something the frontend politely agrees to respect. It has to be a law the database itself enforces, no exceptions, no workarounds, no agents slipping through.
Jacking in
Built 20+ connected modules covering academics, HR, finance, library and communication (students, teachers, attendance, gradebook, performance, class routine, HR, finance, library, communication, administration) as one coherent system, not four tools glued together and hoping nobody notices the seams.
Enforced all four roles at the database layer with Row Level Security, so the same rule protects the web console, the mobile app and the API at once. No surface gets to reinvent its own version of "who's allowed to see this."
Designed a command dashboard with live stats and an interactive revenue chart, pulling straight from the same tables the rest of the platform writes to. No parallel reporting layer quietly drifting out of sync with reality.
Shipped a native companion app with Expo and React Native for students, sharing types and grade-calculation logic with the web app through a TypeScript monorepo, so an attendance percentage can't diverge between what the phone says and what the web says.
Built the finance module end to end: fee structures, bulk invoicing, payment status, dues reporting, printable receipts, and a full accounts ledger with an income/expense breakdown. Money in, money out, one truth.
Scoped the student and parent portal down to the individual row: a signed-in student sees their own attendance, grades and fee invoices, and nothing else, enforced by the exact same rules protecting the staff console.