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