Kevin Tran
Data Analyst, Product and Revenue Analytics
Atlanta, GA | (404) 555-0136 | [email protected] | github.com/kevintran-data
Professional Summary
Data analyst with 5 years in e-commerce and fintech analytics. Built the retention model behind a win-back program worth $2.4M a year and replaced 20+ manual reports with self-serve Looker dashboards. Strong in SQL, Python and experiment analysis.
Technical Skills
- Languages: SQL, Python (pandas, scikit-learn), R
- BI and data: Looker, Tableau, dbt, Snowflake, BigQuery, Excel
- Methods: A/B testing, Regression, Cohort analysis, Forecasting, Data modeling
Professional Experience
- Built a churn-risk model in Python (logistic regression) that targets a win-back campaign now recovering $2.4M a year.
- Rebuilt revenue reporting in dbt and Looker, replacing 20+ spreadsheet reports and cutting month-end close by 2 days.
- Analyzed 40+ A/B tests a year with product teams, including the checkout change that lifted conversion 6%.
- Wrote the team's SQL style guide and review checklist, adopted by 9 analysts.
- Segmented 1.2M customers by purchase behavior in SQL, informing an email strategy that raised repeat orders 14%.
- Built Tableau dashboards for inventory and marketing used daily by 35 people across 4 teams.
- Found a tracking bug that double-counted mobile orders, correcting a 9% overstatement in reported revenue.
- Built a Python demand forecast for the top 300 products, cutting peak-season stockouts 18%.
- Automated 12 weekly branch reports with SQL and Excel Power Query, saving 10 hours of manual work a week.
- Produced the quarterly loan performance pack for the board.
- Removed 8,000 duplicate member records in SQL before a CRM migration.
- Answered 15+ ad hoc data requests a month from branch and lending managers.
Education
Certifications
- Google Data Analytics Professional Certificate