Ukraine's #1 job service
Сергій
Аналітик даних
- 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.
You can get this candidate's contact information from https://www.work.ua/resumes/21013477/
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.
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.
Similar candidates
-
Data analyst
Remote, Ternopil -
Junior Data Analyst
Remote -
Молодший спеціаліст з аналітики даних
50000 UAH, Remote -
Аналітик баз даних
Remote, Cherkasy -
Аналітик даних
40000 UAH, Remote -
Аналітик
Remote