Павло

Pavlo Stepanenko
Data Analyst

[відкрити контакти](див. вище в блоці «контактна інформація») • [відкрити контакти](див. вище в блоці «контактна інформація») • Telegram • LinkedIn • Kyiv, Ukraine

ABOUT ME
I enjoy digging into complex processes and finding solutions through data. Confident with Python, SQL
(including Google BigQuery), Google Sheets, and visualization tools. My attention to detail helps me deliver
clear insights and solid analysis. I have experience working in teams and organizing workflows, including as a
group leader. With upper-intermediate English, I feel comfortable in international settings.

EDUCATION
National Technical University of Ukraine “Igor Sikorsky Kyiv Polytechnic Institute” Kyiv, Ukraine
Bachelor of Computer Engineering 2020 - 2024
GPA: 84/100

University of Applied Sciences Amberg-Weiden Online, Germany
Course “Algorithms and Data-Structures” July 2023

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
Languages: English (Upper-Intermediate), Ukrainian (Native)

EXPERIENCE
Data Analyst (from July 2025 )
Responsibilities:
Cleaning, preprocessing, and structuring datasets using Google Sheets and Python
Preparing and cleaning data for further visualization and analytical reporting
Creating data visualizations using Python libraries such as Matplotlib and Seaborn
Building interactive dashboards in Power BI for business reporting
Developing data visualizations and analytical reports using Excel
Preparing ad hoc reports to support business decisions and stakeholder requests
Ensuring data quality, accuracy, and consistency across multiple data sources
Portfolio:
SQL Projects: Link
Email analysis (Analyzed monthly email activity by calculating each account's share of total emails sent,
along with identifying the first and last email dates per account to highlight engagement distribution
and timelines)
Sales analysis (Collected data to analyze account creation dynamics and email-based user activity:
sending, opening, clicking)

Tableau Projects: Link
A/B Testing (Dashboard for analyzing A/B test results, including key and secondary metrics, group
comparisons, statistical significance, and visualized impact of changes)
Sales Analysis (Dashboard for analyzing sales across various indicators: product categories, regions,
time periods, and sales channels, with filtering and trend tracking)

Session Analysis (Dashboard for analyzing user sessions: count, duration, traffic sources,
devices, behavior patterns, and interaction effectiveness)
Python Projects: Link
Company Analysis (Merged multiple datasets into one, performed data cleaning and preprocessing,
visualized key metrics, and evaluated company performance across different channels)
E-commerce Sales Analysis (Queried sales data from Google BigQuery using SQL, performed data
analysis in Python with libraries like Pandas and Matplotlib, and built an interactive dashboard in
Tableau to visualize key sales metrics)

COURSES
Architecting Smart IoT Devices (December 2023, Coursera), course by EIT Digital
Object-Oriented Design (June 2022, Coursera), University of Alberta
Design Patterns (June 2022, Coursera), University of Alberta
Object-Oriented Data Structures in C++ (July 2022, Coursera), University of Illinois Urbana-Champaign