Measurable Impact & Key Results
Project Overview
An enterprise-grade multi-tenant SaaS ERP system engineered for colleges and universities. It streamlines campus administration across departments, academic terms, faculty rosters, subject catalogs, and student enrollment registers while maintaining 100% data isolation per campus tenant.
The Challenge & Pain Points
Educational institutions struggled with fragmented administrative spreadsheets, lack of multi-tenant isolation, manual roll number formatting, and privacy risks associated with plain-text student identification records.
The Technical Solution
Engineered a robust multi-tenant web application using PostgreSQL parameterized tenant scoping (WHERE college_id = $1), a database-backed RBAC permission matrix for 7 distinct institutional roles, and native AES-256-CBC cryptographic encryption for sensitive PII data.
Key Features & Deliverables
- SaaS Multi-Tenancy architecture ensuring strict college_id tenant data isolation.
- Granular RBAC permission matrix dynamically showing/hiding action buttons for Superadmin, Admin, Principal, HOD, Faculty, and Students.
- Native AES-256-CBC encryption for Aadhaar cards and sensitive identity numbers at rest.
- Auto-sequencing student roll number (IITD-CSE-2026-001) and staff employee ID generator.
- Quick access role-preset switcher for testing institutional workflows.