Катерина

KATERYNA KOLESNYK
Data Analyst

About Me
Data analyst with hands-on experience in SQL, Python, and Tableau, backed by a
strong quantitative background in Economics and Finance. Built an end-to-end e-
commerce analysis using Python and BigQuery, covering data cleaning, sales
trend analysis, correlation and statistical hypothesis testing, and published
[open contact info](look above in the "contact info" section) interactive Tableau dashboards. Publishing a growing portfolio of SQL and Python
data projects on GitHub, each with documented business context. Skilled in Google
Telegram
Sheets for data cleaning, pivot tables, and reporting. Presented research at
[open contact info](look above in the "contact info" section) academic conferences and co-authored published theses during university
studies.
LinkedIn
WORK EXPERIENCE
GitHub

Alytus, Lithuania, remote Data Analyst — Independent Projects, Feb 2026 – Present
Analyzed multi-year sales datasets using SQL (BigQuery) and Python to
identify trends, correlations, and business insights
Designed and ran A/B tests, applying statistical hypothesis testing to
EDUCATION evaluate conversion metrics across audience segments
Simon Kuznets Kharkiv National University of Built interactive Tableau dashboards to visualize sales performance and
Economics customer behavior
Master's Degree in Economics, 2024–
2025 (with honours)
Portfolio
Bachelor's Degree in Finance, Banking SQL Projects (Link to review) — Business-oriented BigQuery queries covering
and Insurance, 2020–2024 window functions, CTEs, and query optimization, with documented business
context. Tools: SQL, BigQuery
ADDITIONAL EDUCATION
Python Project: E-commerce Sales Analysis (Link to review) — End-to-end
Data Analyst course at Mate Academy, analysis of e-commerce sales data: cleaning, exploratory analysis,
2026 Certificate correlation and statistical hypothesis testing, visualized in interactive
Additional coursework in public finance Tableau dashboards. Tools: Python, Pandas, NumPy, SciPy/statsmodels, SQL,
and investment analysis (Prometheus) BigQuery, Tableau
Certificates
Python Project: Global Sales Data Analysis (Link to review) — Multi-year
SKILLS retail sales dataset (2010–2017): data cleaning, exploratory analysis, and
business insights across product categories, regions, and sales channels,
Technical Skills: including profitability, shipping time, and seasonality analysis. Tools: Python,
SQL: Advanced Queries, Window
Pandas, NumPy, Matplotlib, Seaborn
Functions, CTE, Query Optimization
Python: Pandas, NumPy, Matplotlib,
Seaborn, Exploratory Data Analysis A/B Testing Project (Link to review) — Automated Python pipeline for
Tableau: Interactive Dashboards, Data statistical significance testing (two-proportion z-test) across multiple
Storytelling, Publishing conversion metrics and audience segments, visualized in Tableau. Tools:
Spreadsheets: Excel, Google Sheets — Python, SQL, BigQuery, statsmodels, Tableau
Pivot Tables, VLOOKUP, SUMIFS, Data
Cleaning, Visualization
Statistics: Sampling, Hypothesis Tableau Dashboards (Link to review) — Interactive dashboards for sales
Testing, Correlation, Statistical performance, customer behavior trends, and A/B test results. Tools: Tableau
Significance
A/B Testing: Planning, Analysis,
Reporting
ACHIEVEMENTS
Other Tools: Jupyter/Colab, Git, Power BI,
Published 4 research papers (2023–2026) on industry cluster analysis,
MS Access, Statistica, HTML
corporate liquidity, and the agrarian sector in economics/finance academic
Transferable Skills: Knowledge of SDLC, journals and conference proceedings
Waterfall, Agile concepts (Scrum, Kanban)
Presented research at the VII All-Ukrainian Scientific-Practical Conference
(Kyiv National Economic University, 2023)
LANGUAGE Completed the international Jean Monnet module on financial system
transformation and digital economics (EU experience for Ukraine)
English (Intermediate)