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.