Катерина

Kateryna Fen
DATA ANALYST
[відкрити контакти](див. вище в блоці «контактна інформація») [відкрити контакти](див. вище в блоці «контактна інформація») Telegram LinkedIn GitHub

Lviv, Ukraine / remote

SUMMARY

Detail-oriented Data Analyst with a background in applied mathematics and strong skills in SQL, Python,
and Tableau. Experienced in analysing data, creating visual reports, and turning numbers into clear
insights. Tutored students in mathematics, strengthening my communication and analytical skills. Also
worked as a dressmaker in a large company, developing strong attention to detail and teamwork skills. I
enjoy learning new tools and finding practical ways to use data. Looking to apply analytical and
mathematical skills to contribute to business growth and efficiency. In my free time, I like sports, which
helps me stay focused.

EXPERIENCE

Data Analyst 10/2024 – Present
Self Employed
Extracting, cleaning and analysing data using tools like SQL, Python
•

Creating dashboards in Tableau
•

Analysing A/B tests results
•

SKILLS

Spreadsheets SQL Python
Pivot Tables, Data Cleaning, Advanced Queries, Window Pandas, NumPy, Matplotlib,
Visualization Functions, Query Optimization, Seaborn, Exploratory Data
Common Table Expressions Analysis (EDA)
Tableau (CTE)
Interactive Dashboards, Data A/B Testing
Storytelling, Publishing Statistics Planning, Analysis, Reporting
Sampling, Hypothesis Testing,
Other Tools Correlation, Statistical
Jupyter Notebooks, Git Significance

Languages
English (Upper-Intermediate)

PORTFOLIO:

Accounts and Emails Data (SQL)
Request for data that will help analyse account creation dynamics, user activity by email (sending,
•

opening, clicks), and evaluate behaviour in categories such as sending interval, account verification, and
subscription status.
The data will allow comparing activity between countries, identifying key markets, and segmenting users
•

according to various parameters.
Link to GitHub
•
Wholesale Store Sales Analysis (Google Sheets)
Wholesale store sales analysis.
•

Includes key performance indicators, identification of major trends in sales dynamics with visualization,
•

company performance results by geographic distribution, product categories, and sales channels.
Also includes ABC analysis and visualization of its results.
•

Link to Google Sheets
•

Furniture Store Analysis (SQL, Python, Tableau)
Online store sales analytics using three tools: SQL, Python, and Tableau.
•

The goal of this analysis is to explore sales and sessions to identify key business insights.
•

The project includes correlation analysis, statistical analysis of differences between groups and numerous
•

visualizations.
Link to GitHub
•

Link to Tableau
•

A/B test Significance (SQL, Python, Tableau)
Analysing the statistical significance of A/B tests on conversion rate.
•

The goal of the project is to analyse the results of A/B testing using statistical methods in Python and
•

create a visualization that shows key conversion metrics in Tableau.
Significance was calculated by the total test results, and there are also results broken down by segments.
•

Link to GitHub
•

Link to Tableau
•

EDUCATION

Lviv Polytechnic National University 2020 – 2021
Master's Degree in Mathematics
(with honours)

Lviv Polytechnic National University 2016 – 2020
Bachelor's Degree in Applied Mathematics

ADDITIONAL EDUCATION

SKELAR IT Analytics Intensive
skelar_intensive_certificate

Data Analyst course at Mate academy
mate_academy_certificate

Genesis Analytics Week at Genesis academy
genesis_analytics_week_certificate

ACHIEVEMENTS

Conference Presentations
Filtering methods analysis of satellite images using Google Earth Engine cloud platform based on water
•

objects in Ukraine. (2021)
Collection of abstracts
Geospatial database of electricity-generating capacities in Ukraine. (2019)
•

Collection of abstracts