David Gao

Data & Operations Leader

Hi, I'm David

I automate the boring stuff so people can focus on what actually matters. Python, AI agents, SQL, React, Databricks — or whatever the job needs. If I don't know how, I'll figure it out.

About Me

Education

McGill University

McGill University

Desautels Faculty of Management

Master of Management in Analytics

2023 – 2024 · Montreal, QC

UBC

University of British Columbia

Bachelor of Management, Finance (Honours)

2015 – 2019 · Kelowna, BC

Who I Am

I'm a data and operations guy who gets genuinely excited about automation. My thing is taking the boring, repetitive work off people's plates — the manual scheduling, the payroll calculations, the copy-pasting — so they can focus on the decisions that actually matter.

I use whatever tools get the job done: Python, AI agents, React, SQL, Databricks. And if I don't know how? I'll figure it out. That's probably my biggest strength — I've never met a problem I couldn't eventually solve, even if it meant learning something entirely new to get there.

Outside of work I'm building Lego, dabbling in options trading (most of my money is safely in ETFs, don't worry), and reading when I can — always open to book recommendations. I studied finance and worked in wealth management, so investing genuinely fascinates me.

Oh, and I'm a bit obsessed with the Artemis program. I actually flew out to see the launch in person — they scrubbed it, obviously — but that's me in the photo with the rocket. No regrets.

Experience

Boba Cafe
Family Business

Boba Cafe

Director of Data & Operations · 2021 – Present

Visit bobacafe.net

Full-stack technology and operations overhaul for a growing bubble tea chain across ~10 locations in Russia, serving 40–50 part-time employees. Built and deployed multiple production systems end-to-end — entirely solo.

Operations & Data

Payroll Automation

Google Sheets pipeline (IMPORTRANGE, QUERY) reading directly from the scheduling system, applying pay rates and bonus tracking — saving managers 30 hrs/month (720+ hours to date)

Theft & Cash Reconciliation

Daily cash reconciliation combining POS data with manager-reported envelope counts in PowerBI; AI anomaly detection has directly identified 3 employee theft incidents

Telegram Order Bot

Google Apps Script bot scanning Gmail every minute during business hours, auto-parsing Yandex Food delivery orders and broadcasting to staff — handling 10+ orders daily

Data Infrastructure

Databricks pipeline pulling raw transaction, daily sales, and product-level data from the POS API — powering store profitability and product health reporting across all locations

Article

Business Analyst

Article

eCommerce · Furniture

2024 – Present

Toronto, ON

  • Designed and led end-to-end A/B test comparing CGI vs. real photography for email campaigns; presented findings to leadership and recommended switching to CGI assets, saving $800K+ USD annually in marketing production costs with no measurable impact on conversion or revenue
  • Built an AI agent using Databricks Genie, enabling 10+ VPs and Senior Directors to query live business data in natural language — eliminating multi-day analyst bottlenecks and increasing data transparency across the organization
  • Developed an in-house cross-sell algorithm analyzing attachment rates across 4,000+ active SKUs, replacing a costly third-party vendor (tens of thousands/month) with a daily auto-refreshed Tableau feed
  • Reduced org-wide dependence on static dashboards by deploying live Google Sheets via Coefficient, giving business users direct access to raw data without analyst intermediation
  • Built and maintained Tableau dashboards for product performance and financial results, used weekly by cross-functional stakeholders
Article

Payment Analyst

Article

eCommerce · Furniture

2021 – 2024

Toronto, ON

  • Reviewed and labeled hundreds of transactions weekly in Sift Science to train fraud detection models, maintaining data quality for Article's fraud prevention pipeline
  • Managed 5-10 chargebacks per week across Stripe, Affirm, and PayPal, achieving a ~70% recovery rate through timely order cancellations and evidence submissions — recovering an estimated $50K-$100K+ USD annually
  • Built a payment processor fee analysis pipeline benchmarking Article's fee structure across processors; analysis confirmed competitive positioning despite multi-million dollar annual processing volume, informing strategic vendor decisions
Canaccord Wealth Management

Licensed Investment Advisor Assistant

Canaccord Genuity Wealth Management

2020 – 2021

Vancouver, BC

  • Owned end-to-end administration of a $5M private placement, preparing and tracking 100+ personalized subscription agreements to ensure full execution before closing date
  • Supported a high-volume private banking practice serving hundreds of clients, managing account openings, KYC/AML onboarding, ID validation, and trade order execution for equities
  • Processed and triaged high volumes of client communications on behalf of advisors, tracking wires, processing cheque deposits/withdrawals, and coordinating ~12 private placement deals annually
  • Onboarded 200+ clients within 2-week windows during deal closes, managing compliance documentation under tight deadlines
Sun Life Financial

Administrative Assistant

Sun Life Financial

2019 – 2020

Vancouver, BC

  • Supported 3 financial advisors simultaneously, managing client correspondence, form processing, and document routing to clients and head office
  • Coordinated annual review outreach, contacting clients to schedule advisor meetings for portfolio reviews and upsell opportunities
  • Maintained advisor calendars and managed end-to-end meeting booking pipeline across a multi-advisor practice

Projects

Insurance Fraud Detection

McGill Capstone Project

Led a team to build ML classification models to detect undeclared smokers in insurance applications. Delivered feature importance analysis and an ethical AI framework.

Marketplace Assistant

Personal Tool

A quick-copy response tool for marketplace selling. Customizable templates for common buyer questions.

Try it →

Skills

Languages

Python SQL R JavaScript Google Apps Script

Platforms

Databricks MS Azure React Google Colab

Visualization

Tableau Power BI Coefficient Google Sheets

Focus Areas

Gen AI Machine Learning A/B Testing Automation OR-Tools

Let's Connect

Open to opportunities, collaborations, and interesting conversations.