Олександра

OLEKSANDRA KHROL
DATA ANALYST
Kharkiv, Ukraine/ remote • [open contact info](look above in the "contact info" section) • [open contact info](look above in the "contact info" section)
Linkedin
Telegram

SUMMARY
Data Analyst skilled in SQL (window functions, CTEs, query optimization), Python (Pandas, NumPy,
Matplotlib, Seaborn), and Tableau. Graduated top of my cohort at Mate Academy's Data Analytics
program, holding first place in the student ranking for most of the course. Completed an end-to-end
analysis of 328K+ e-commerce sessions — from BigQuery queries and EDA to statistical hypothesis
testing — delivering business recommendations and a two-page interactive Tableau dashboard;
designed and analyzed an A/B test in a separate project. Previously collected field data for UNICEF
among residents of frontline cities and built a speech-therapy program from scratch in an
educational institution, with two master's degrees earned with honors. Experienced in turning raw
data into decisions backed by statistical significance.

WORK EXPERIENCE
Data Analyst From May 2026 – Present

Analyzed 328K+ e-commerce sessions end-to-end (BigQuery SQL, Python EDA, statistical
testing, Tableau), identifying that revenue scales with traffic (r = 0.90) at a stable 9.6%
conversion — delivering 7 data-backed business recommendations on channel, device, and
seasonal strategy.
Built a two-page interactive Tableau Public dashboard (KPI cards, dynamics with moving
averages, parameter-driven tables, cross-filtering) that turns the full analysis into a self-service
tool.
Evaluated 4 concurrent A/B tests on 3.2M event rows (334K sessions): validated randomization
with chi-square SRM checks, measured 6 funnel metrics across device/channel/continent
segments, and issued ship/no-ship decisions — including one roll-out (+12.5%
add_payment_info) and one immediate rejection that flagged a UX regression.
Detected and fixed a data-quality issue (NULLs exported as zeros inflating registered-user
metrics to 100%), preventing incorrect conclusions downstream

Household Survey Enumerator — International Medical Corps Feb 2026 — Apr 2026
(UNICEF partner)
Collected around 230 household survey responses in KoBoToolbox among residents of frontline
communities, performing quality checks and data cleaning that fed reports used to target aid
distribution across Kharkiv and 15 cities of Kharkiv oblast.

Speech Therapist — Kindergarten 2021 — 2023
Built the institution's speech-therapy program from scratch: designed diagnostics and
progress-monitoring for 22 children per year with semi-annual reporting — 100% of children
achieved full program mastery and speech-disorder correction.

Primary School Teacher — Special School (speech & developmental disorders) 2018 — 2022

Taught 2 classes (23 students), maintaining individual development plans and systematic
progress records; analyzed learning outcomes and produced regular performance reports for
parents and administration.
EDUCATION
Data Analyst course at Mate academy
Graduated: 2026
Frontend Developer at CyberBionic Systematics (selected for the IT Generation state grant program)
Graduated: 2023
Master’s Degree Special Education (with honours) in H.S. Skovoroda Kharkiv National
Pedagogical University
Graduated: 2022
Master’s Degree Primary Education (with honours) in H.S. Skovoroda Kharkiv National
Pedagogical University
Graduated: 2019

PROJECTS
Project 1 (SQL Projects) – used the e-commerce database in BigQuery (collected data to help
analyse trends in account creation, user engagement with emails (sends, opens, clicks), and to
assess behaviour across categories such as sending intervals, account verification and
subscription status) wrote an SQL query to create a dataset and created a visualisation in
Looker Studio based on the data obtained.

Project 2 (Tableau Projects) – quick Tableau practice dashboard analyzing a same-day retail
invoice sample (972 transactions, 4 countries): revenue trends over time, by country, and by
hour, plus a quantity-vs-revenue view.

Project 3 (Python Projects) – building sales analytics for an online shop using three tools:
SQL, Python and Tableau.

Project 4 (A/B Testing) – the aim of the project is to analyse the results of A/B testing using
statistical methods in Python and to create a visualisation that illustrates key conversion
metrics.

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, Power BI
Knowledge of SDLC, Waterfall, Agile concepts (Scrum, Kanban)
Languages: English (Intermediate)
ACHIEVEMENTS / VOLUNTEERING
Ranked #1 among cohort students at Mate Academy Data Analytics program for most of the
course, 2026
625 SQL & Python tasks solved during the Data Analytics program, 2026
Selected for the IT Generation state grant program (Ministry of Digital Transformation of
Ukraine) — 1,830 grants for 47,996 applicants, around 26 candidates per place, 2022
Two Master's degrees with honors, graduated first in class
2nd place, school Mathematics Olympiad (Regional), 2014
Cat Shelter Volunteer — "Lapky Kharkiv" (@lapki.kharkiv), Kharkiv, 2024 — present.Support a
30+ cat shelter in wartime Kharkiv: fundraising campaigns, sponsor outreach, and awareness
communications; personally adopted 4 shelter cats.