PROFESSIONAL[EDTECH]2024–2026
College Vidya EdTech Platforms
Large-scale EdTech LMS & ERP modules serving 20K+ active students across academic delivery, student portals, and enrollment workflows.
20K+
Active Students
Daily active learners across programs
9× Faster
Query Speed
Targeted composite indexing on heavy cohort queries
72%
RAM Savings
Streamed CSV report generation pipelines
Engineered With
ReactNext.jsNode.jsPostgreSQLPrismaRedisTypeScript
The Problem & Context
Rapid growth in student enrollment caused significant database contention during semester start periods. Heavy analytical reporting queries timed out while student login and lecture viewing were sluggish.
The Messy Part (Behind the Build)
Refactoring legacy unindexed relational queries across tables with millions of academic event records without taking down the production system.
Architecture & Design Decisions
PostgreSQL with optimized composite indexes, Node.js / Express API services, React & Next.js frontend interfaces, Redis query cache for high-frequency course catalogs.
Engineering at EdTech Scale
Serving 20,000+ daily active learners requires zero tolerance for sluggish endpoints or downtime during peak live lecture hours.
Key Deliverables
- Role-Based Access Control (RBAC): Secure authorization across students, faculties, academic advisors, and administrative superusers.
- Reporting Optimization: Re-engineered unindexed reporting joins that were locking tables; reduced peak query duration from 2.5 seconds to ~280ms.
- Streaming Exports: Converted in-memory array aggregation of 100K+ rows to streaming Node.js pipelines, cutting server RAM consumption by 72%.
What I'd Do Differently Today
Introduce read-replicas for internal operational dashboards earlier to isolate analytical query load from student transactional traffic.
Related Work & Systems
PERSONAL
BusinessOS
Commercial-grade financial operating system for SMEs with ledger-first accounting, immutable transaction journals, integer minor-unit money calculations, and multi-tenant audit logs.
PROFESSIONAL
Microsoft Teams & Calendar Engine
Hiding deep Microsoft Graph API complexity behind an automated calendar & meeting sync engine for 20K+ EdTech users.