Academic Engineering

School Work & Academic Projects

A structured portfolio of academic software engineering, full-stack application development, and coursework completed during the Diploma in Applied AI & Analytics (DAAA) at Nanyang Polytechnic.

OpenGlimpse AI School • Year 2
Backend & Systems Engineer (Programmes & Attendance)
  • Atomic Route Allocation: Engineered bus route management for SCCCI delegations with single-route integrity constraints.
  • SQL Query Optimization: Diagnosed and resolved cross-programme double-counting bug in PostgreSQL attendance subqueries.
  • Automated Test Suite: Built 34 independent endpoint tests verifying 100% pass rate against live database fixtures.
Node.js / Express PostgreSQL & Sequelize React SQL Optimization 34 Unit Tests
GitHub: OpenGlimpseAI/OpenGlimpse View Case Study →
GenConnect Platform School • Year 1 (Featured)
Lead Developer & Full-Stack Architect
  • OOP Matchmaking Engine: Built modular Python classes scoring dialect compatibility and shared interests between seniors and youth.
  • Tiered Authentication: Implemented Singpass mock flows and biometric facial verification tailored for elderly accessibility.
  • GitLab Version Control: Led repository architecture with 195+ commits, 17 feature branches, and zero-conflict merges.
Python (OOP) Flask Jinja2 Singpass Mock 195+ Commits
GitLab: opediumgg/genconnect View Case Study →
SIT Club Digital Portal School Coursework • Year 1
Frontend Developer & UI Designer
  • Sub-Initiatives Hub: Engineered dedicated showcase portals for Dev Swift (iOS) and NYP Cloud student tracks.
  • Responsive Layouts: Implemented fluid CSS Grid and Flexbox structures supporting mobile (320px) to desktop displays.
  • Industry Alignment: Designed and validated in alignment with IBM SkillsBuild web design accessibility standards.
HTML5 / CSS3 JavaScript ES6 Bootstrap 5 IBM SkillsBuild
GitLab: opediumgg/sitclub View Case Study →