Галина

Halyna Profile
Danchuk As a Business Analyst with advanced English proficiency, I bridge the gap
between data insights and business strategy. I specialize in identifying trends,
Data Analyst evaluating performance metrics, and translating complex data into actionable
recommendations that drive business growth. Skilled in SQL, Python,
halynadanchukda@gm
Tableau, and Google Sheets, I combine analytical rigor with a clear
ail.com
understanding of business needs. My background in teaching and
[открыть контакты](см. выше в блоке «контактная информация») international relations strengthens my communication, adaptability, and
ability to collaborate across teams and cultures. With additional training in
Lviv, Ukraine graphic design, I craft visually engaging dashboards and reports that make
Halyna Danchuk data-driven insights easy to understand and act upon. I bring strong
analytical thinking, problem-solving, and attention to detail to every project,
helenadanchukkk ensuring timely and accurate delivery of results that support informed
decision-making.
Halyna Danchuk

Professional Experience
Skills Data Analyst
2025
Spreadsheets
Pivot Tables, Data
Where Customers Come From and What They Buy
Cleaning, Visualization
Designed and executed SQL queries in BigQuery to prepare datasets for
•

analysis.
SQL
Performed exploratory data analysis (EDA) to identify key markets,
Advanced Queries,
•

product categories, and traffic sources.
Window Functions, Query
Conducted market, product, device, and traffic source analysis to find top-
Optimization, Common
•

performing segments.
Table Expressions (CTE)
Built pivot tables and visualizations (Python & Tableau) to present sales
•

dynamics across continents, devices, and channels.
Python
Applied statistical methods (correlation, ANOVA, group comparisons) to
Pandas, NumPy, Matplotlib,
•

test hypotheses and validate insights.
Seaborn, Exploratory Data
Generated actionable business recommendations to improve user
Analysis (EDA)
•

registration, weekend sales, and mobile experience.
Tableau Sales Performance Analysis
Interactive Dashboards, Cleaned and prepared data.
Data Storytelling,
•

Designed and applied pivot tables, formulas, and visualizations in Google
Publishing
•

Sheets to calculate key business metrics
Performed trend and seasonality analysis across years, months, and
Power BI
•

weekdays to detect demand fluctuations.
Data Visualization, Applied ABC analysis to segment product categories by contribution to
Reporting, Power Query,
•

sales and profitability.
DAX, Data Modeling Analyzed regional performance (Europe vs Asia, subregions, top
•

countries) to identify market leaders.
Statistics Prepared business insights and recommendations for optimizing product
Sampling, Hypothesis
•

mix and sales channels.
Testing, Correlation,
Statistical Significance A/B Testing Analysis: Impact of Website Background on User
Engagement
A/B Testing Designed and analyzed an A/B test (5,000 users) to evaluate the effect of a
•

Planning, Analysis, dark background on user engagement.
Reporting Processed and visualized data using Python (pandas, scipy, seaborn) and
•

Tableau.
Other Tools Conducted segment-level analysis by device and region.
•

Jupyter Notebooks, Google Applied non-parametric tests (Shapiro–Wilk, Mann–Whitney, Kruskal–
•

Analytics, Excel, Git, Wallis).
Microsoft Office
 Languages Visualized data distributions and group comparisons in Tableau, including
•

KPIs, user segmentation, and test summary dashboards.
English
C1+ A/B Test Analysis
Analyzed A/B test results to evaluate how website design changes affected
•

user behavior and conversion rates.
Education Processed and cleaned datasets using Python (pandas, NumPy).
•

Performed exploratory data analysis (EDA) to understand user actions and
•

Master’s Degree in test group distributions.
International Relations Applied Z-test for proportions to measure statistical significance of
•

(with honors), National conversion differences between control and experiment groups.
Lviv Politechnic University Built interactive Tableau dashboard to visualize A/B test results by
•

2023 – 2024 | Lviv, Ukraine country, device, and user journey.
Delivered actionable insights and recommendations for improving the
•

Bachelor's Degree in checkout process and registration flow.
International Relations
(with honors), National User Acquisition & Email Performance
Lviv Politechnic University Developed a complex SQL query with multi-level CTEs to merge tables of
•

2019 – 2023 | Lviv, Ukraine accounts, sessions, and email campaigns.
Performed data aggregation.
•

Implemented country ranking by number of accounts and emails.
•

Courses Performed data cleaning and structuring for further analysis.
•

Built an interactive dashboard in Data Studio with geographic maps,
•

Data Analyst course, graphs, and country rankings.
Mate Academy Analyzed user activity dynamics (account creation, email
•

2025 opening/visiting) over time.

Graphic Design Courses, English Teacher, Smart-space BOYAR
Creo 2022 – 2025
2020 Technologies or Tools: Google Classroom, Zoom, MS Office, Google Sheets,
Miro, ReadyTo
Designed and delivered tailored learning programs, ensuring measurable
•

performance improvement.
Supervised the online branch of the school, overseeing the quality of
•

delivery.
Applied data tracking and reporting to monitor progress and optimize
•

teaching strategies.
Produced structured reports and materials with accuracy and attention to
•

detail.
Strengthened cross-cultural communication, stakeholder management,
•

and time management skills in a fast-paced environment.

Achievements

Scholarship of Verhovna Rada for Analytical Research Study, 2022-2023
•

Multiple academic works and publications related to International
•

Relations, Political Science, and Sociology, 2019-2024
Awarded for volunteer work and providing charitable assistance, 2022
•

Recipient of an award from the Ternopil Regional Council for a 200 score
•

in the National History Exam, 2019
Recipient of awards from the Bohdan Hawrylyshyn Family Foundation,
•

2017-2019
Winner of Regional Olympiad in Maths, 2018
•

President of School Council, 2018
Winner of Regional Olympiad in Ukrainian Language and Literature,
•

2017