Photo of Ethan Phan

Ethan Phan

Data Analyst | Business Optimization

Hello!

I'm Ethan Phan, an aspiring Data Analyst.

Welcome to my website where I showcase my projects, certifications, and skills.

Feel free to look around - and don't hesitate to reach out!

How We Help Businesses Scale

As part of a business optimization partnership, we help organizations expand their digital footprint and streamline internal operations. We design scalable online platforms and implement automation systems that enable efficient, long-term growth.

LunchMate - Co-Founder & Full-Stack Developer / UX Designer

Lunch Mate is a calendar-first school lunch ordering system where parents manage student meals and checkout, while admins run schools, menus, refunds, announcements, reporting, and staff permissions from one console. The platform combines consumer-grade UX with back-office controls for real school operations.

  • User experience design: parent dashboard with calendar ordering, upcoming orders, order history, profile, and announcements.
  • Identity and access control: Firebase Auth, role-based admin permissions, tenant resolution, and impersonation flows.
  • Data modeling: parent contacts, student linkage, order lifecycle, allergy/allergen tracking, and lifecycle status fields.
  • Admin operations tooling: school setup, classrooms, students, cycles, global menus, theming, announcements, email, and admin account management.
  • Payments engineering: Stripe checkout plus partial/full refunds, day-level bulk refunds, and balance-credit workflows.
  • Reporting and analytics: attendance/orders, kitchen summaries, labels, and sales reports.
  • Platform integration: Firebase (Auth/Firestore/Storage), Converge, ZeptoMail, and Node/Express API surface.

Business Website + Brand Redesign Package

Our Business Website + Brand Redesign Package combines a high-converting website refresh with a full visual identity update, including a newly designed custom logo tailored to your business.

  • Create clean, conversion-focused website structures
  • Deliver brand redesigns with custom logos and recognizable visual themes
  • Align site experience with business positioning and trust

Projects

Selected work in analytics, forecasting, and applied machine learning.

Divvy Rideshare Weather Analysis

Two years (2021-2023) of Divvy rideshare & Chicago weather data was stored in PostgreSQL tables & processed for analysis. Community-level weather sensitivity analysis was done using QGIS, Power BI, sklearn, & SQL. Findings were presented in a Figma presentation with Power BI visualizations and QGIS maps.

PostgreSQL QGIS Power BI scikit-learn SQL Figma
Project visual for Divvy Rideshare Data Analysis

Divvy Rideshare Data Analysis

Two months of Divvy bike rideshare data was stored in MongoDB and processed for analysis. The workflow included data cleaning, outlier removal, and statistical analysis using ArcGIS Pro, PyMongo, and Pandas. Insights were presented through Tableau, Power BI, and Matplotlib dashboards.

MongoDB ArcGIS Pro PyMongo Pandas Tableau Power BI
Project visual for Divvy Rideshare Data Analysis

Tri-Modal Facial Emotion Recognizer

As part of a three-person team, I helped build a facial emotion recognition system that fused text, audio, and video features using Bi-LSTM, RNN, and a BERT-GNN hybrid approach. The final system reached 68% test accuracy and was documented for both technical and non-technical audiences.

Bi-LSTM RNN BERT GNN Multimodal ML
Project visual for Tri-Modal Facial Emotion Recognizer

VIX Modeling Using Machine Learning

This project modeled the Stock Market Volatility Index (VIX) using 46 Economic Market Volatility trackers across 1990-2023. I built and tuned an OLS regression model with Elastic Net regularization in R, evaluated with LOOCV, and achieved strong predictive performance in a high-dimensional setting.

R OLS Regression Elastic Net LOOCV Time-Series Modeling
Project visual for VIX Modeling Using Machine Learning

Resume

Education

2020-2025

University of Toronto

Majored in: Applied Statistics, Communication, Culture, Humanities & Technology (CCIT)

Minored in: Computer Science

Skills

Machine Learning & AI

PyTorch Feature Engineering Neural Networks Regression Analysis Time Series Forecasting

Coding Languages

Python R C++ C Java JavaScript SQL NoSQL DAX

Data Analysis

Power BI Excel Tableau QGIS ArcGIS Pandas MongoDB

UI/UX

Figma Wireframing Interaction Design User Research Accessibility

Languages

English (Fluent) French (Professional)

Certifications

Dec 2025 Learning QGIS

Issuer: LinkedIn Learning

Beginner LinkedIn Learning course covering QGIS fundamentals, including installing QGIS, working with vector and raster data, creating 2D and 3D maps, styling and spatial analysis, and using plugins and Python basics to publish and automate workflows.

View credential

November 2024 Data Analytics Professional Certificate

Issuer: Coursera

IBM-authorized professional certificate focused on entry-level data analytics, covering analytical techniques, data visualization and dashboarding, and communicating insights using real-world datasets.

View credential

February 2020 CPA: Programming Essentials in C++

Issuer: C++ Institute

Foundational C++ certification covering core programming concepts, data types and control flow, functions, and object-oriented fundamentals (classes, inheritance, exceptions, and operator overloading), with practical labs aligned to the CPA exam track.

September 2019 Introduction to IoT

Issuer: Cisco Networking Academy

Introductory course on IoT and digital transformation covering connected devices and sensors, networking and cloud fundamentals, data and cybersecurity considerations, and real-world automation use cases across industries.

June 2019 CCNA Routing & Switching

Issuer: Cisco Networking Academy

Associate-level networking certification track covering configuration and troubleshooting of small to medium networks, including IPv4/IPv6 addressing, switching and VLANs, static and dynamic routing, ACLs, NAT, security fundamentals, and network operations.

Contact Me

Email ethan.phan@alumni.utoronto.ca Phone 647-554-3275 GitHub github.com/Ethann01 LinkedIn linkedin.com/in/ethan-phan-3296381a3