Web Dev
A cowboy-themed typing game where you take down bandits by typing real programming syntax with speed and accuracy.
Next.js · React · TypeScript · Tailwind CSS +4
Management Engineering · University of Waterloo
Tristan
Ko
Management Engineering student at the University of Waterloo, passionate about data and problem-solving through analytics.
Experience
Roles across product analytics, software, and supply chain.
Provincial Product Analyst
Current
Sep 2026 – Dec 2026
Allstate Insurance Company of Canada · Markham, ON (Remote)
Focused on risk-selection strategy for the Ontario market, alongside the team's recurring performance reporting.
- Analyzed historical claims data to spot underperforming customer segments, helping senior leaders shape a safer, more profitable pricing strategy for Ontario.
- Contributed to the team's recurring performance reports, assisting in data compilation and quality checks for stakeholders.
- Modernized team reporting by transitioning workflows and Power BI dashboards from legacy software to Microsoft Fabric for automatic data updates.
Junior Technical Analyst
Jan 2026 – Apr 2026
Ontario Ministry of Transportation · Toronto, ON
Handled software troubleshooting across internal web applications and built centralized databases to streamline internal tracking.
- Resolved complex data-flow and communication issues between the website frontend, backend server, and database to keep internal applications running smoothly.
- Wrote precise database migration scripts to securely update large sets of records without data loss or system errors.
- Built a centralized database system to track employee work arrangements, replacing scattered spreadsheets with a single, organized platform.
Supply Chain Intern
May 2025 – Aug 2025
Iovate Health Sciences International Inc. · Oakville, ON
Streamlined supply chain operations by building automated inventory tools, data pipelines, and performance dashboards.
- Created an automated Excel inventory tool for over 800 products to calculate exact reorder quantities and schedules, cutting manual planning time by over 90%.
- Built Python scripts to automatically upload and sync supply chain data, completely eliminating manual entry mistakes.
- Designed clear Power BI dashboards for team-wide metrics and analyzed warehouse shipping errors to reduce fulfillment mistakes by 35%.
Projects
Open any project for the full story, the stack, and links.
AI & ML
AI-driven housing market forecasting model using macroeconomic data, financial indicators, and machine learning.
Python · pandas · NumPy · scikit-learn +2
AI & ML
Playful AI resume roaster that turns brutal feedback into friendly, actionable career advice.
Next.js · React · CSS · Framer Motion +3
Web Dev
AI-powered music recommendation app with personalized insights and playlists.
Next.js · React · Tailwind CSS · Node.js +3
Data
Desktop productivity app for managing study sessions and visualizing learning progress.
Python · PySide6 · SQL · pandas +1
Web Dev
Financial analytics platform with industry-based stock analysis and real-time market insights.
Next.js · TypeScript · Tailwind CSS · Recharts +2
Data
Automated calendar system with dynamic event management and scheduling features.
Excel · VBA
Data
Personal finance management tool with budgeting, expense tracking, and forecasting.
Excel · VBA
Games
Top-down 2D RPG featuring combat, exploration, and progression systems.
Python · Pygame
Games
Interactive multiplayer game built for fast, in-person group play.
React · Next.js · CSS · TypeScript +1
Games
Space-themed infinite runner with custom pixel art and original audio.
Java · AWT · Swing · Graphics2D +2
Let’s
connect
Interested in working together or just want to say hi? Reach out through any of these.