Skulbee
A school management platform — academic sessions, timetables, class and subject assignment, student records and lesson notes — delivered ticket by ticket through review.
25+
PRs merged through review
SES
production email delivery
// stack
// 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
// 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.
// what was built
- ·Shipped the academic session and term management API, the class timetable document module, and the subject-teacher assignment write path with slot reads.
- ·Built the assignment matrix listing API and a coverage statistics endpoint, so a school can see at a glance which subjects have no teacher assigned.
- ·Delivered student records work: a stats strip, XLSX bulk upload with a downloadable template, and an atomic student ID generator behind a configurable ID format.
- ·Implemented lesson notes with search and real session/term wiring, plus per-subject teacher resolution.
- ·Established the engineering foundation: a local development stack, Scalar API documentation, a pnpm migration, structured logging and unit tests, all in one groundwork PR.
- ·Set up production email delivery over Amazon SES.
- ·Fixed 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.