Tesca Institute Operations CRM
A high-performance operations CRM and learning management suite built on the MERN stack for student admissions, course enrollments, and revenue metrics.
Students managed
Fee collection tracking
Time saved on admissions
Problem & Context
A dedicated educational operations platform built for Tesca Spoken English and IELTS Academy. The system powers day-to-day institute management: student enrollments, batch scheduling, fee installment tracking, trainer allocation, and executive revenue reporting.
Institute leadership relied on physical registers and disconnected spreadsheets to track tuition payments, batch capacities, and student attendance, causing operational delays and lost revenue.
Engineering Strategy
Developed a unified MERN stack operations CRM featuring batch capacity counters, automated fee due alerts, trainer schedules, and executive financial charts visualizing monthly enrollment revenue.
React Single Page Application with Tailwind CSS for rapid state updates. Express.js / Node.js REST API with JWT session tokens and MongoDB document persistence. Automated PDF invoice generation and financial reporting pipelines.
Architectural & Technical Choices
Built automated fee schedule trackers with multi-installment alerts and payment status tracking.
Created interactive batch capacity visualizers to prevent classroom over-enrollment.
Implemented executive dashboard metrics tracking month-over-month revenue growth, student retention, and course popularity.
Engineering Challenges Overcome
⚠️ Challenge: Preventing concurrent batch booking conflicts when multiple front-desk staff enroll students simultaneously.
✓ Solution: Utilized atomic MongoDB conditional updates with optimistic concurrency locks on batch seat counters.
⚠️ Challenge: Generating professional fee receipts and registration forms quickly during peak admission hours.
✓ Solution: Engineered server-side headless PDF rendering generating downloadable receipts in under 400ms.
