← All workCase study 11

Skulbee

A school management platform — academic sessions, timetables, class and subject assignment, student records and lesson notes — delivered ticket by ticket through review.

Type

Platform

Status

Active development

Context

DOT Solutions · backend engineering

Period

2026

Source

Private

TypeScript

Private repository

25+

PRs merged through review

SES

production email delivery

(01) Overview

Backend engineering on a school management system covering academic session and term management, class timetables, subject-teacher assignment with coverage statistics, student records with bulk XLSX upload, lesson notes with search, and school profile management. Alongside the features I set up the engineering foundation the team works in: a local development stack, Scalar API documentation, a pnpm migration, structured logging, unit tests, and production email delivery over Amazon SES. Delivered as more than twenty-five reviewed and merged pull requests against tracked tickets.

(02) Architecture

TypeScript backend with a ticket-driven delivery workflow · academic session/term model · timetable and assignment matrix APIs · atomic student ID generation · XLSX bulk upload · Amazon SES email · Scalar API docs · containerised local dev stack

(03) What was built

01Shipped the academic session and term management API, the class timetable document module, and the subject-teacher assignment write path with slot reads.
02Built the assignment matrix listing API and a coverage statistics endpoint, so a school can see at a glance which subjects have no teacher assigned.
03Delivered student records work: a stats strip, XLSX bulk upload with a downloadable template, and an atomic student ID generator behind a configurable ID format.
04Implemented lesson notes with search and real session/term wiring, plus per-subject teacher resolution.
05Established the engineering foundation: a local development stack, Scalar API documentation, a pnpm migration, structured logging and unit tests, all in one groundwork PR.
06Set up production email delivery over Amazon SES.
07Fixed real defects found in review — a staff-list query returning 500 instead of 422, and a student profile 500 caused by missing nationality and state-of-origin fields.

(04) Stack

TypeScript / Node.js / MongoDB / pnpm / AWS SES / Docker