• Файл

Сергій

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

Місто проживання:
Біла Церква
Готовий працювати:
Дистанційно

Контактна інформація

Шукач вказав: ТелефонМесенджер

Прізвище, контакти та світлина доступні тільки для зареєстрованих роботодавців. Щоб отримати доступ до особистих даних кандидатів, увійдіть як роботодавець або зареєструйтеся.

Завантажений файл

Версія для швидкого перегляду

Це резюме розміщено у вигляді файлу. Ця версія для швидкого перегляду може бути гіршою за оригінал резюме.

Bila Tserkva, Ukraine/Remote

SERHII LEBED [відкрити контакти](див. вище в блоці «контактна інформація»)
[відкрити контакти](див. вище в блоці «контактна інформація»)
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.

Схожі кандидати

Усі схожі кандидати

Кандидати у категорії


Порівняйте свої вимоги та зарплату з вакансіями інших підприємств: