Personal information hidden

YANA ZAMLYNNA
DATA ANALYST
Data Analyst with skills in SQL, Python, and R, experienced in data analysis and
working with real-world datasets. Analyzed sales and marketing performance
using e-commerce data and applied data science and econometric methods in
academic research, including a bachelor’s thesis. Worked on team projects,
contributing to data interpretation and presenting clear, data-driven insights
within deadlines. Comfortable collaborating in team environments, adapting to
new tasks quickly, and communicating analytical findings in a clear and
structured way.

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
[open contact info](look above in the "contact info" section) (EDA)
Tableau: Interactive Dashboards, Data Storytelling, Publishing
[open contact info](look above in the "contact info" section)
Statistics: Sampling, Hypothesis Testing, Correlation, Statistical
Telegram Significance
A/B Testing: Planning, Analysis, Reporting
LinkedIn Other Tools: Jupyter Notebooks, Google Analytics, Excel, Git
Languages: English Intermediate
Bila Tserkva/Kyiv, Ukraine,
remote, relocate EXPERIENCE
Can work during blackouts thanks to a fiber-optic
internet connection and a portable power station Data Analyst, From Feb 2026 - now
Built SQL queries to solve analytical tasks and extract insights from
EDUCATION datasets
Used Python for statistical analysis and exploration of relationships
Master’s degree in Economic between variables
Cybernetics and Data Science Created visualizations and dashboards using Tableau and Looker
(with honors) Merged, cleaned, and analyzed datasets in Google Sheets;
developed supporting visualizations
Kyiv National Economic University
named Vadym Hetman Portfolio:
2020-2025 Project 1 (SQL, Python and Tableau)
Built an end-to-end e-commerce sales analytics project using SQL, Python, and
Tableau. Extracted and transformed data from Google BigQuery, performed
exploratory and statistical analysis in Python, analyzed sales dynamics and customer
ADDITIONAL EDUCATION behavior across multiple dimensions, and developed interactive Tableau dashboards
to visualize key business insights and performance metrics.
Project 2 (A/B Testing Analysis)
Data Analyst course at Mate academy Analyzed A/B testing results using statistical methods in Python and created
visualizations to demonstrate key conversion metrics and user behavior trends across
THE FUNDAMENTALS OF SOFTWARE different test variations and audience segments.

TESTING AT QATESTLAB SQL Projects
Collected and analyzed data on account creation and email engagement (sent,
opens, clicks), including user segmentation by country, sending intervals, account
verification, and subscription status to identify key markets and usage patterns.
ACHIEVEMENTS Spreadsheets
Analyzed and visualized sales dynamics across product categories, items, and
1st Place, 91st Student Scientific Conference countries, and performed ABC analysis to identify key contributors and segment
“Innovative Projects for the Economic performance.
Recovery and Competitive Development of
Python Projects
Ukraine”
The main goal is to clean the data and perform analysis to uncover valuable insights
into the company’s operations.
Invited speaker at the plenary session of the
All-Ukrainian Scientific and Practical Economist, Retail Banking Department, Oschadbank, August 2024
Conference “Forum of Young Economists-
Cyberneticians: Modeling the Economy: Card issuance and account opening support for retail clients
Problems, Trends, Experience” Document verification and processing according to bank
procedures