• File

Сергій

Аналітик даних

City of residence:
Bila Tserkva
Ready to work:
Remote

Contact information

The job seeker has provided: Phone numberMessenger

Name, contacts and photo are only available to registered employers. To access the candidates' personal information, log in as an employer or sign up.

Uploaded file

Quick view version

This resume is posted as a file. The quick view option may be worse than the original resume.

Bila Tserkva, Ukraine/Remote

SERHII LEBED [open contact info](look above in the "contact info" section)
[open contact info](look above in the "contact info" section)
Data Analyst LinkedIn | Telegram | DOU

Summary

Data analyst specializing in product analytics, A/B testing and statistics. I work with SQL, Python (pandas, NumPy,
Matplotlib/Seaborn), Tableau, Excel and Google Sheets.

Worked on projects involving e-commerce sales and user behavior analysis, calculating key business metrics such
as Revenue, Orders, Average Order Value (AOV), Revenue per Session (RPS) and Session-to-Order Conversion Rate.
Evaluated A/B test results by analyzing conversion funnel metrics, comparing test groups and identifying statistically
significant changes.

Experienced in building interactive dashboards using Tableau and Looker Studio to communicate findings and
support data-driven decisions. Interested in applying skills in IT, Health Care, Product Company, Logistics, Retail,
E-commerce. English: Intermediate.

Skills

Spreadsheets: Pivot Tables, Data Cleaning, Visualization
SQL: Advanced Queries, Window Functions, Query Optimization, Common Table Expressions (CTE)
Python: Pandas, NumPy, Matplotlib, Seaborn, Exploratory Data Analysis (EDA)
Tableau: Interactive Dashboards, Data Storytelling, Publishing
Statistics: Sampling, Hypothesis Testing, Correlation, Statistical Significance
A/B Testing: Planning, Analysis, Reporting
Other Tools: Jupyter Notebooks, Google Analytics, Excel, Power BI
Language proficiency: Ukrainian – Native; English – Intermediate

Portfolio

1. Online Store Sales & Traffic

Project description

Goal: Analyze store sales, traffic, and user behavior using statistical methods in Python and prepare data for a
Tableau dashboard to track core revenue drivers and correlations.

Project stages

1. Data loading: SQL query to BigQuery joins sessions, session parameters, user accounts, orders and product
catalog
2. Data cleaning and checks: Data types, missing values and duplicates. Distribution across devices, browsers,
traffic sources and categories
3. Metrics calculation: Core sales metrics (Revenue, Orders, AOV, RPS, Session-to-order rate) and daily
dynamics per category, continent, channel and device
4. Export and visualization: Result table is saved to CSV and used in the Tableau dashboard

5. Conclusions: Statistically significant correlations for daily traffic vs sales and cross-continent revenue
dynamics

2. A/B test

Project description

Goal: Analyze A/B test results using statistical methods in Python and prepare data for a Tableau dashboard that
shows key conversion metrics and where they changed significantly.

Project stages

1. Data loading: SQL query to BigQuery joins test groups, sessions, session parameters, events, orders and new
accounts
2. Data cleaning and checks: Data types, missing values and duplicates. Distribution of groups inside each
test.
3. Metrics calculation: 6 metrics: add_payment_info, add_shipping_info, begin_checkout, new_accounts,
sessions with order, first_visit (each divided by sessions)
4. Export and visualization: Result table is saved to CSV and used in the Tableau dashboard
5. Conclusions: Statistically significant changes for each test, metric and dimension

Professional Experience

Data Analyst | Remote | Jul 2026 – Present

● Cleaned, structured and processed raw datasets using Google BigQuery, Python (pandas) and Google
Sheets to prepare them for analysis.

● Analyzed data to find trends and patterns, and turned the results into general, marketing and business
conclusions.

● Evaluated A/B tests using statistical methods and hypothesis testing to compare groups and measure the
impact of changes.

● Created dashboards and visualizations in Tableau, Looker Studio (Google Data Studio) and Python
(Matplotlib/Seaborn) to present results clearly.

● Presented findings as clear recommendations to support product and business decisions.

Education

Data Analytics | Mate academy | Jul 2026 – Nov 2026

● Coursework focused on SQL, Python, Google BigQuery, Google Sheets, Statistics, A/B Testing, Product Analysis
and Data Visualization.

● Practical projects: cleaned and analyzed datasets, evaluated A/B tests and built dashboards in Tableau and
Looker Studio to present findings and recommendations.

Similar candidates

All similar candidates

Candidates at categories

Candidates by city


Compare your requirements and salary with other companies' jobs: