Work

Leading master data management for Thrasio's catalog operations, partnering with catalog, operations, and tech teams to automate SKU workflows and enforce data quality standards across Oracle NetSuite and downstream systems.

• Rebuilt the SKU creation and update workflow as a Streamlit web app, cutting the average SLA from 24 hours to 30 minutes — a 95% reduction.
• Automated multi-step data validation and NetSuite integration, eliminating an estimated 5 hours of manual spreadsheet work per analyst per week.
• Implemented Google OAuth authentication for internal tooling, enabling secure, role-based access for MDM team members.
• Authored data governance SOPs and field-level data dictionaries adopted across the catalog team.

Supply Chain Business Analyst responsible for BI dashboards, ad hoc reporting, and data quality initiatives supporting the purchasing, planning, and warehouse teams.

• Built Power BI dashboards for the purchasing team covering Inventory Stocking Levels and Purchase Order Tracking, using Azure SQL and Business Central Web Services as data sources.
• Reduced report refresh time by 50% by standardizing data fetching methods and query patterns across the BI layer.
• Maintained a 95% on-time delivery rate for purchase orders by coordinating across marketing, planning, and warehouse teams.
• Identified and corrected KPI calculation errors in presale and supply chain reports, contributing to approximately $70,000 in annual cost savings.

Managed organizational databases, maintained data integrity across client records, and provided technical support to operations and sales teams using MS Office and ERP systems.

• Built operational and sales reports in Excel and ERP, reducing manual lookup time.
• Modeled company-specific trends using SQL, Excel, and Python on internal datasets, improving data processing efficiency by 10%.

Provided bilingual (English/Mandarin) service to over 100 donors and participants by email and in person at the 2023 GVA Relay for Life, Swangard Stadium, Burnaby.

• Coordinated setup and participant support for the 2023 GVA Relay for Life at Swangard Stadium, Central Park, Burnaby.
• Translated event processes and logistics for participants in both English and Mandarin.

Statically generated portfolio using Next.js 16 App Router, Tailwind v4, shadcn/ui, MagicUI, and @react-pdf/renderer for server-side PDF generation.

A Streamlit web application that streamlines SKU update and creation requests for Thrasio's MDM team. Authenticated users can process, validate, update NetSuite records, and trigger email notifications in a single workflow, replacing a fragmented multi-step spreadsheet process.

• Reduced average SKU request SLA from 24 hours to 30 minutes — a 95% improvement.
• Integrated Google OAuth for secure, role-based access control.
• Automated NetSuite record updates and outbound email notifications end-to-end.

A Streamlit app that parses raw Star Citizen Game.log files and generates meaningful statistics and event summaries, helping players quickly review session performance without digging through log files manually.

• Parsed and surfaced play session KPIs including session duration, death counts, and travel logs.
• Enabled players to instantly identify the cause of death for each in-game event.

Collaborated with data analysts from Vancouver General Hospital to develop predictive clustering models forecasting CDI outbreaks from canine screening data collected between 2017 and 2022.

• Built CDI forecasting models in R using clustering and correlation analysis on 5 years of canine screening and infection records.
• Delivered exploratory and risk analysis in Tableau, surfacing correlations between canine alert frequency and CDI case counts.

Used the Box-Jenkins method and dynamic regression approaches on SteamDB data (2020–2022) to fit a multiplicative seasonal ARIMA model and produce a 6-month server utilization forecast.

• Fit a seasonal ARIMA(2,1,2) × (0,1,1) model with a 7-day period using R.
• Forecast 9,487,428 peak concurrent players against an actual of 9,484,341 — 99.97% accuracy.

Hackathon project using geospatial clustering to identify optimal locations for new vaccination sites, drawing on 20 census datasets from the Hong Kong government and 5 independent sources.

• Compiled and cleaned 20 relational census datasets from the Hong Kong government and 5 independent sources using R and Alteryx, saving the team 10 hours of data preparation.
• Streamlined geospatial visualizations in Tableau, saving the project team approximately 2 hours per day during development.

Analyzed amenity density and distribution across the Greater Vancouver Area using OpenStreetMap data to build a predictive model for average regional household income.

Coursework in statistical modelling, machine learning, data systems, and applied mathematics. Completed capstone and research projects in collaboration with industry and healthcare partners.

• Dean's List 2021
• Vancouver Coastal Health: Canines-for-Care — CDI forecasting with VGH data analysts
• Steam Server Usage Forecast — seasonal ARIMA time-series study