Олена

Olena Kotsur
DATA ANALYST
[відкрити контакти](див. вище в блоці «контактна інформація») [відкрити контакти](див. вище в блоці «контактна інформація») Drohobych, Ukraine Olena Kotsur | LinkedIn
Olena @OlenaKotsur

PROFILE
I am a data analyst with strong analytical and technical skills, experienced in working with Python, Pandas,
NumPy, SQL, Excel, Tableau, and Power BI. I possess a solid understanding of data processing, visualization,
and statistical analysis, enabling me to transform complex datasets into actionable business insights. I am
detail-oriented, structured, and skilled in presenting analytical findings clearly and effectively. I am seeking
an opportunity to apply my expertise in data analysis to support strategic, data-driven business decisions

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, Git
•

Language: English Intermediate, Ukrainian Native
•

PROFESSIONAL EXPERIENCE
Data Analyst 04/2025 – 10/2025
Freelance / Project-based
•Conducted data analysis and visualization using Python (Pandas, NumPy), SQL,
Tableau, and Power BI.
•Built interactive dashboards to track sales performance, marketing metrics, and
customer behavior.
•Performed A/B testing, statistical analysis, and data quality validation.
Technologies: Python, Pandas, NumPy, Matplotlib, SQL, Excel, Tableau, Power BI,
•

Google BigQuery, Google Colab, GitHub

PROJECTS
GitHu profile
Tableau Projects
You can find all my analytical projects — including Tableau dashboards (session analysis, salary analysis, email
metrics), A/B testing, and Python-based data analysis — on my GitHub profile .
Module Task Description
SQL Projects
Email Campaign Performance Analysis (SQL, BigQuery) — built a multi-CTE SQL query to analyze user
account activity and email performance by country, ranking top 10 markets by engagement, and preparing
data for BI dashboards.
A/B Test Analysis
Python Projects
A/B Test Analysis — Python, SQL, Google BigQuery, Plotly, Tableau. Conducted end-to-end A/B test analysis to
evaluate the impact of marketing experiments. Built SQL pipelines, performed z-tests for statistical
significance, and visualized results with Plotly and Tableau dashboards
Portfolio Project 1..ipynb
Python Projects
E-commerce Data Integration & Dashboard — SQL, Python, Google BigQuery, Plotly. Developed a data
pipeline combining user sessions, orders, and email campaigns from multiple BigQuery tables. Performed
data cleaning, feature enrichment, and built interactive dashboards to analyze customer behavior, conversion
funnel, and marketing performance.
EDUCATION
Data Analytics Program
Mate academy
Completed an intensive Data Analytics course focused on data processing, visualization, SQL, and Python.
Built analytical projects using Tableau, Power BI, and Python.
kotsur-certificate