Olena

OLENA SAPOHOVA
DATA ANALYST
[открыть контакты](см. выше в блоке «контактная информация») GitHub
[открыть контакты](см. выше в блоке «контактная информация») LinkedIn

Telegram Tableau

Kyiv, Ukraine / remote

Summary
Data Analyst with strong skills in SQL, Python, and data visualization, experienced in
exploratory data analysis, statistical evaluation, and A/B testing. An adept at
transforming raw data into actionable insights that drive informed decision-making. My
background in engineering and manufacturing provides a solid foundation in analytical
thinking, process optimization, and structured problem-solving.

Skills
SQL: Python:
Advanced Queries, Window Functions, Query Pandas, NumPy, Matplotlib, Seaborn, Exploratory
Optimization, Common Table Expressions (CTE) Data Analysis (EDA)

Tableau: Statistics:
Interactive Dashboards, Data Storytelling, Sampling, Hypothesis Testing, Correlation,
Publishing Statistical Significance

Spreadsheets: A/B Testing:
Pivot Tables, Data Cleaning, Visualization Planning, Analysis, Reporting

Other Tools: Languages:
Jupyter Notebooks, Looker Studio, Excel, Git, Trello, English (Intermediate)
PyCharm

Experience
Data Analyst From Jan 2025

Developing and optimizing SQL queries for data extraction and analysis.
•

Performing data exploration, cleaning, transformation, and calculations using NumPy and Pandas.
•

Creating data visualizations using Matplotlib and Seaborn.
•

Building dashboards and analytical reports in Tableau, Google Sheets, and Looker Studio.
•

A/B testing using statistical methods in Python and calculating key conversion metrics.
•

Identifying insights from data and providing recommendations.
•

PORTFOLIO:

Project 1 (SQL, Python, Tableau) – [Sales analysis for an online store: calculation and analysis of key
sales metrics, dynamic analysis, statistical analysis of relationships, calculation of correlation coefficients,
and statistical tests to compare differences between groups]
Sales analysis
•

Dashboard
•
Project 2 (SQL, Python, Tableau) – [Analysis of A/B test results: calculation of conversion metrics that
represent different stages of the user journey on the website for four separate tests, both at the total level
and across the dimensions]
A/B testing
•

Dashboard
•

Project 3 (SQL Project) – [SQL query for analyzing the dynamics of account creation, user activity based
on email metrics(sends, opens, clicks), and assessing behavior across categories such as sending interval,
account verification, and subscription status]
Data analysis with SQL
•

Project 4 (Google Sheets Project) – [Dashboard for company sales analysis: sales (revenue, profit, number
of orders, units sold), order processing time, sales dynamics with the ability to analyze by country and
category]
Dashboard
•

Project 5 (Python Project) – [Exploratory Data Analysis of company operations with Python: data
overview, data cleaning, sales analysis, process analysis, sales dynamics, visualizations, conclusions &
recommendations]
EDA of Company Operations
•

Process engineer, Top Quality Project LLC 2021 – 2024
Conducted analysis and calculations of equipment utilization and labor resources, and implemented
•

changes that led to increased production volumes.
Optimized information workflow between the Sales and Production departments and set up automated
•

data-analysis reports, which reduced data-processing time and accelerated managerial decision-making.
Reduced production costs and improved product quality through the implementation of new materials
•

and onboarding of new suppliers.
Increased manufacturing productivity by introducing efficient technologies and Lean Manufacturing
•

principles.
Developed and implemented new products using advanced technologies.
•

Enhanced database normalization to optimize accounting processes and change management in the IT
•

Enterprise software system.

Process engineer, Merx Interio LLC 2016 – 2021
Continuous involvement in the development and implementation of new kitchen furniture models and
•

prototypes.
Developed and implemented templates for fast calculation of material consumption and creation of
•

product specifications, which significantly accelerated the preparation of documentation for similar
products across different sizes and colors.
Reviewed and adapted specifications for more than 900 products in various size and color variations for
•

integration into the updated database into the SAP system.

Education
National Technical University of Ukraine "Kyiv 1999 – 2005
Polytechnic Institute",
Specialist in Physical and Biomedical Electronics

Additional Education
Data Analyst, Mate academy

Accountant, School of market economy