Yurii

Yurii Kapusta
Data Analyst

Lviv, Ukraine | [open contact info](look above in the "contact info" section) | LinkedIn | GitHub | Tableau Public

PROFESSIONAL SUMMARY
Product-oriented Data Analyst focused on key product metrics (Retention, CVR, LTV).
Skilled in SQL, Python, and Tableau, with hands-on experience in funnel optimization,
cohort analysis, and A/B testing to drive product strategy and enhance user experience.

RELEVANT EXPERIENCE
Fuzzy Factory E-commerce Analysis (SQL+Python+Tableau)
● To address a high ~45% bounce rate at the entry stage, initiated a comprehensive
funnel analysis. Identified significant top-of-funnel friction (only 55.24% of users
proceeded to the catalog) and evaluated A/B test results to propose a winning landing
page variant that improved baseline CVR by 3%.
● To resolve checkout abandonment issues, uncovered a critical billing conversion
gap where 11.01% of users reached the billing stage, but only 6.83% successfully
completed the order. Highlighted this massive ~38% relative drop-off to stakeholders.
● To provide clear visibility into acquisition efficiency, developed a Tableau
Dashboard tracking Net Revenue, RPS, and Refund Rates, delivering actionable
insights into device-level performance.
Olist E-Commerce Data Analysis (Python)
● To identify the root causes of negative customer feedback, conducted exploratory
data analysis (EDA) linking delivery delays to poor customer reviews, providing
actionable insights to optimize logistical priorities.
● To solve the problem of low user retention (<1%), performed cohort analysis using
Python and recommended pivoting the business strategy to maximize AOV.
Delivery Time Prediction (Python)
● Applied ANOVA & Tukey's HSD to evaluate weather impacts, recommending
specific minute-buffers for delivery delays.
● Built a Lasso Regression model (R-squared of 0.81) for ETA prediction, optimizing
it for production by reducing to the top 6 features, improving the speed of forecasting.
SKILLS
Data Analysis & BI: SQL, Google BigQuery, Excel, Tableau, Power BI, Python
Tools & Version Control: Git, GitHub
Core Competencies: A/B Testing, User Acquisition Analysis, Cohort Analysis, ML
Languages: Ukrainian (Native), English (C1), German (B2)

EDUCATION
NTU "Kharkiv Polytechnic Institute" Bachelor's Degree in System Analysis | 2023 – 2027

CERTIFICATIONS
● Tableau ultimate course from zero to hero (Udemy, 2026)
● Python for Machine Learning & Data Science (Udemy, 2025)
● SQL - MySQL for Data Analytics and Business Intelligence (Udemy, 2024)