Multi-Tenant School Management SaaS: 24 Modules, 361 Tests
Client work · Sole engineer · shipped
A per-school SaaS platform covering the full operational surface: academics, admissions, student records, fees, payments, attendance, exams, timetabling, transport, inventory, payroll, leave, accounting ledger, reporting and document generation.
The detail
Tenant isolation is enforced twice - once in the data access layer and again with database row-level security - because a school platform leaking data between tenants is not recoverable.
Payments treat the signature-verified webhook as the only source of truth, with idempotent capture so a payment is recorded exactly once regardless of retries or a user closing the tab. All money is integer arithmetic in the smallest currency unit, never floating point.
Highlights across the modules: QR-code attendance check-in, timetabling that guarantees no teacher is double-booked, live GPS transport tracking with geofence alerts, and bulk certificate generation.
228 unit tests and 133 end-to-end tests green in CI, with a real object-storage container in the pipeline so file handling is genuinely exercised rather than mocked.
NestJS, TypeScript, PostgreSQL, Prisma, Redis, React, React Native.
What I did
- Architected and built the entire monorepo - API, web portal, mobile app and shared packages
- Implemented tenant isolation twice, in the data layer and again with database row-level security
- Built the payments flow treating the verified webhook as the only source of truth with exactly-once capture
- Wrote all 24 feature modules covering the full school operational surface
- Built background job processing for invoicing, reminders and absence notifications
- Set up CI with a real object-storage container so file handling is genuinely tested
- Wrote 228 unit and 133 end-to-end tests
- Produced the deployment setup with production containers and reverse proxy
Stack
TypeScript, NestJS, PostgreSQL, React, Full-Stack Development, Prisma, Redis, BullMQ, Razorpay, React Native, OpenAPI, Docker, S3
Case study: https://www.siddhvasudev.com/projects/multi-tenant-school-management-saas-24