Skip to content
All projects

Staff Leave Management System

A full-stack leave management web app with separate OLTP and OLAP databases, ETL pipelines and an executive dashboard for administrative decision-making.

Role
Full-stack developer (freelance)
Organization
Kasetsart University
Period
Apr 2026 – Jun 2026
Type
Full-stack web application

Highlights

  • Decoupled OLTP for real-time transactions and OLAP for analytics
  • ETL pipelines feeding an interactive executive dashboard
  • Unit tests with Jest and end-to-end tests with Playwright in Docker
  • User manual, developer guide and video demos for long-term maintainability