Mei Lin Park
Data Analyst | SQL · Python · Tableau · Experimentation
Professional Summary
Data analyst with 4 years of experience in e-commerce and subscription analytics. Turns messy data from 10+ sources into clear dashboards and recommendations that leadership acts on. Analysis has driven a 14% lift in subscription retention and $1.2M in annual savings. Strong in SQL, Python, Tableau and A/B testing, with a habit of explaining results in plain English.
Professional Experience
Data Analyst
- Built a churn-risk analysis combining order history, support tickets and survey data; targeted retention offers lifted 90-day retention by 14%.
- Designed and analysed 30+ A/B tests on pricing and onboarding; one pricing test increased average order value 8% ($2.1M annualised).
- Created the executive KPI dashboard in Tableau (revenue, CAC, LTV, churn) used weekly by the leadership team.
- Rebuilt 25 reporting queries as tested dbt models, cutting dashboard refresh failures from weekly to near zero.
- Identified $1.2M a year in shipping savings by analysing carrier costs by zone and package size.
Junior Data Analyst
- Automated weekly sales reporting with SQL and Python, saving the sales operations team 8 hours a week.
- Analysed product return reasons across 120,000 orders; recommendations cut return rates on two top categories by 18%.
- Maintained Power BI inventory dashboards for 6 regional managers and trained them to self-serve.
- Cleaned and reconciled CRM data, reducing duplicate customer records by 32%.
Operations Assistant
- Built Excel trackers for order exceptions that became the basis for the team’s first automated report.
Projects
City Bike-Share Demand Forecast (portfolio): Forecasted hourly demand from 2 years of trip and weather data in Python; model achieved 11% MAPE. Interactive Tableau Public dashboard.
Airline On-Time Performance Analysis (portfolio): Analysed 6M flight records in BigQuery to rank causes of delay by airport and season.