Lee Chun Yong
← All projects

Project 05

Scheduling automation for AMD

Replaced a 45-minute Excel VBA scheduling process with a Python and React tool that does the same job in about 10 seconds.

Period
Aug 2025
Context
SUTD Service Design Studio · Team lead, 6 people
Stack
Python · React · Vite · Automation
Result
45 min → 10 s

The problem

Scheduling ran on legacy Excel VBA macros: 45 minutes per run, error-prone, and hard for anyone to maintain.

What I did

  • Led a team of six from framing the problem through to handover.
  • Rewrote the scheduling logic in Python. A run went from 45 minutes to about 10 seconds.
  • Built a React/Vite dashboard for uploading data, viewing assignments and flagging scheduling conflicts.
  • Ran the repository: branching strategy, pull requests and code review.
  • Added an AI chatbot to help non-technical staff maintain the code after handover.