Jorge's Portfolio logoJorge's Portfolio

Connect with me

Back to project
Case Study

Aurora Language Center

AI-Powered School Management Platform

Ongoing (8+ months)
3 engineers
Full Stack Developer & AI Lead

Aurora is a comprehensive school management platform built specifically for language schools. It combines modern web technologies with AI-powered features to streamline operations, from student enrollment to progress tracking, serving 500+ students across multiple branches.

Language schools typically operate with fragmented systems - spreadsheets for enrollment, paper for attendance, and disconnected apps for communication. This creates data silos, manual work, and poor visibility into student progress.

No unified view of student journey across programs
Manual class scheduling causing frequent conflicts
Paper-based attendance and progress tracking
Delayed communication with parents (24-48h lag)
No insights into student performance trends
Difficulty managing teacher schedules across branches
Room utilization at only 66%

A unified platform that handles the entire student lifecycle with AI assistance for scheduling optimization, progress predictions, and automated parent communications.

Single source of truth for all school data
AI-powered scheduling to maximize room utilization
Real-time progress tracking with predictive insights
Automated parent communication via WhatsApp/Email
Multi-tenant architecture for school networks
Mobile-first design for teachers and parents
Integration with payment gateways

Built with a modern microservices approach using event-driven architecture for real-time updates and loose coupling between services.

Student Service

Manages student profiles, enrollment, documents, and learning paths

FastAPI
PostgreSQL
S3
Elasticsearch

Scheduling Engine

Handles class creation, room allocation, teacher assignment with AI optimization

Python
Google OR-Tools
Redis
Celery

Progress Tracker

Records assessments, generates reports, predicts outcomes using ML

FastAPI
Scikit-learn
Pandas
Chart.js

Communication Hub

Manages notifications across WhatsApp, Email, SMS, and Push

n8n
Evolution API
SendGrid
Firebase

Analytics Engine

Business intelligence, custom reports, and executive dashboards

Metabase
PostgreSQL
dbt
Plotly

Development Phases

1

MVP Development

3 months
  • Core student management and enrollment
  • Basic class scheduling with conflict detection
  • Teacher portal with attendance tracking
  • Parent access portal with progress view
2

AI Features

2 months
  • Smart scheduling algorithm with OR-Tools
  • Progress prediction model training
  • Automated reminder workflows
  • FAQ chatbot for common queries
3

Scale & Polish

Ongoing
  • Multi-branch support with data isolation
  • Native mobile apps (React Native)
  • Advanced analytics and forecasting
  • Public API for third-party integrations

Challenges & Solutions

Complex scheduling constraints (teacher availability, room capacity, student preferences, consecutive class limits)

Implemented constraint satisfaction solver using Google OR-Tools with weighted optimization. Teachers can now be scheduled in seconds instead of hours.

Real-time sync across multiple devices and branches

WebSocket-based updates with Redis pub/sub for instant notifications. Implemented optimistic UI updates for better UX.

WhatsApp integration without official Business API access

Deployed Evolution API for reliable WhatsApp messaging. Built queue system to respect rate limits and handle retries.

15h/week

Admin Time Saved

Per coordinator

94%

Room Utilization

+28% (from 66%)

89%

Parent Response Rate

+45% improvement

0

Scheduling Conflicts

-100% (from 12/month)

4.8/5

Student Satisfaction

+0.9 points

Frontend

Next.js 14
React
TypeScript
Tailwind CSS
React Native

Backend

Python
FastAPI
Celery
Redis

Database

PostgreSQL
Redis
Elasticsearch

AI/ML

Scikit-learn
Google OR-Tools
Pandas

Integration

n8n
Evolution API
SendGrid
Stripe

Interested in similar solutions?

Let's discuss how AI can transform your business processes

The Apprentice

AI Assistant

The Apprentice

Hello! I'm The Apprentice, Jorge's AI assistant. I can help you explore his portfolio, learn about his projects, or answer questions about his work in AI engineering. What would you like to know?