RUTHRAN RAGHAVAN
Case Study|Education Operations

Comptable Lite — Attendance & Hour-Tracking Platform

A role-based attendance and hour-tracking ecosystem for educational centers, professors, and students.

The Problem

Understanding the business challenge.

Educational centers coordinate schedules across administrators, freelance professors, and students manually, causing scheduling conflicts.

Tracking billable hours for freelance professors with spreadsheets is slow and error-prone.

Naive timezone handling causes session times to silently shift across date boundaries.

The Solution

Our AI-powered approach.

A role-based attendance and hour-tracking platform with automated timetable generation, smart rescheduling, and UTC-standardized time handling across admin, professor, and student portals.

Automated Timetable Generation

The admin dashboard auto-generates batch timetables across professors and students.

Smart Rescheduling

Cancelling a session automatically shifts the remaining batch schedule and updates end dates.

Role-Based Portals

Separate dashboards for admins, professors (session marking, hour tracking), and students (schedules, hour stats).

UTC-Standardized Scheduling

All session times are stored and computed in UTC to prevent date-shifting bugs across timezones.

Secure Auth Flows

JWT-based authentication with full login, signup, and password-reset flows.

Technical Architecture

Enterprise-grade technology stack.

Frontend
React 18 with React Router 7 and Tailwind CSS, built with Vite
Backend
Node.js and Express with JWT authentication
Vector Database
Not applicable — relational scheduling data, no retrieval system
Models
Not applicable — rule-based scheduling logic, no LLM integration
Retrieval
N/A

Security & Compliance

Privacy-first implementation.

  • JWT-based authentication with bcrypt password hashing
  • Dockerized deployment isolating the database from the application layer
  • Role-based access separating admin, professor, and student portals

Implementation Workflow

Structured deployment process.

1

Data Modeling

Designed a PostgreSQL schema for batches, sessions, professors, and students.

2

Scheduling Engine

Built automated timetable generation with smart rescheduling on cancellations.

3

Role-Based Portals

Implemented separate admin, professor, and student experiences.

4

Containerized Deployment

Packaged the backend and database with Docker Compose for consistent deployment.

Business Impact

Measurable outcomes.

Eliminates manual spreadsheet-based scheduling and hour tracking for education centers
Reduces scheduling conflicts through automated timetable generation
Prevents timezone-related session errors through UTC-standardized time handling
Gives freelance professors self-service visibility into their tracked hours

Target Industries

Versatile application across sectors.

Education
Operations

Experience it live

Try Live Demo