AD.
INITIALIZING_SYSTEM
000%
AD.
PROJECT 04EdTech Operations & Revenue CRM · 2024

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.

RoleFull-Stack Developer
Timeline6 weeks
Core StackReact, Node.js, Express.js
Live Site ↗GitHub ↗
Tesca Institute Operations CRM - Screenshot and interface preview
1000+

Students managed

99%

Fee collection tracking

50%

Time saved on admissions

// The Objective

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.

The Core Bottleneck:

Institute leadership relied on physical registers and disconnected spreadsheets to track tuition payments, batch capacities, and student attendance, causing operational delays and lost revenue.

// The Solution

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.

// Decisions

Architectural & Technical Choices

DECISION 01

Built automated fee schedule trackers with multi-installment alerts and payment status tracking.

DECISION 02

Created interactive batch capacity visualizers to prevent classroom over-enrollment.

DECISION 03

Implemented executive dashboard metrics tracking month-over-month revenue growth, student retention, and course popularity.

// Problem Solving

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.

// Capabilities

Shipped Product Features

Executive revenue overview with monthly financial growth charts and target tracking
Student admission and batch allocation engine with real-time seat counters
Tuition fee payment ledger with installment tracking and receipt generation
Faculty schedule management and classroom assignment calendar
Student attendance tracking and course completion certification workflow
Technologies & Frameworks
ReactNode.jsExpress.jsMongoDBMERN StackTailwind CSSCharts
← Previous Case StudyTesca Global Lead CRMNext Case Study →Water Reminder App