Data & Business Analyst — UWaterloo Math/Stats

Linsi Zhong

Actively looking for Data/Business Analyst roles. I turn multi-gigabyte datasets into decisions - SQL pipelines, statistical testing, and dashboards stakeholders actually use.

Résumé GitHub LinkedIn

Headshot

Selected work

04 PROJECTS

01 · Independent Project

Marketing Campaign A/B Testing Analysis

Ran an A/B test on 588K users to quantify the effect of ad exposure on conversion with a two-proportion z-test in Python, finding a statistically significant 43% relative lift in conversion rate (p < 0.0001). Validated the effect via logistic regression controlling for total ad exposure, day, and hour, then recreated the workflow in SQL with a Tableau dashboard visualizing conversion trends by day and hour.

SQLPythonTableauLogistic Regression

A/B test dashboard Marketing Campaign A/B Testing Analysis

02 · Independent Project

NovaMart Marketing Analytics

Built an end-to-end data pipeline with data cleaning and sentiment analysis on customer reviews. Delivered an interactive Power BI dashboard visualizing KPIs and data-driven recommendations to shift ad spend toward higher-performing channels, improving customer satisfaction.

SQLPythonPower BI

Power BI dashboard NovaMart Marketing Analytics dashboard

03 · Independent Project

Implementing and Comparing Optimal Survival Tree Algorithm

Cleaned an R-package dataset, built a life table, and constructed three survival models (Cox, RSF, OST) in R - identifying Cox as the top performer and OST as optimal relative to RSF based on Concordance and AUC. Achieved 82% final prediction accuracy by applying tree pruning to mitigate model overfitting.

RSurvival AnalysisCoxRSFOST

Model comparison Optimal Survival Tree Algorithm comparison

04 · Independent Project

Course Schedule Optimization

Built and solved a linear programming model in Python with Gurobi to optimize course-schedule assignments under real-world constraints, increasing professor satisfaction scores by 34%.

PythonGurobiLinear Programming

Schedule optimization Course Schedule Optimization model

Experience

Full résumé

Bank of Communications Business Analyst Intern May 2024 - Aug 2024

Automated data extraction and preprocessing for multi-gigabyte customer datasets using SQL queries, reducing manual data preparation time for weekly business reports.
Developed key features and preprocessed data using Python (pandas, NumPy) for a customer churn prediction model, boosting predictive accuracy by 16% and identifying 10 primary churn indicators.
Designed and deployed Tableau dashboards to track KPIs such as customer acquisition cost and product penetration, equipping the retail banking team with actionable insights for strategic planning.

University of Waterloo Bachelor of Mathematics, Mathematical Studies (Honours), Statistics Minor · President's Scholarship Sept 2020 - Oct 2024

Stack

Languages and tools I've shipped production work with.

Python R SQL SAS Matlab MySQL Snowflake AWS R Studio Excel Power BI Tableau NumPy pandas Matplotlib SciPy

Let's build something.

Open to conversations about developer tooling, API infrastructure, and systems work - or just a good professional connection.

Emaillinsi6280@gmail.com LinkedInlinsizhong GitHublinsi6280