Зоряна

ZORIANA SHCHESNIAK
Junior Data Analyst

Summary
I have a strong mathematical background and analytical thinking, with
a focus on working with data and business metrics. I work with SQL,
Python, Google Sheets, cohort analysis, A/B testing, and data

[open contact info](look above in the "contact info" section) visualization. I am able to structure datasets, identify patterns, and turn
them into clear insights for decision-making.
Telegram
[open contact info](look above in the "contact info" section) Project Experience
LinkedIn User Retention Analysis (Cohort Analysis in SaaS)
Lviv, Ukraine 🔗 link here
Tools: SQL, Google Sheets
Skills Description: Conducted cohort analysis to evaluate user retention
and compare promo vs organic acquisition channels using SQL
Hard Skills
SQL and Google Sheets.
Python My tasks: Data extraction and transformation using SQL
Data Cleaning & Validation Data cleaning and date standardization
Data Visualization Cohort building and month offset calculation
Business Metrics Analysis Retention rate calculation and cohort table creation
Conversion Rate Analysis User behavior and acquisition channel analysis
ARPU Analysis Results: Built cohort retention model
LTV Analysis Identified differences between promo and organic users
Retention Analysis Analyzed user lifecycle behavior across cohorts
Churn Analysis
Product Analysis Stack Overflow Developer Survey Analysis (Pandas)
A/B Testing (Experimentation)
Probability Theory & Mathematical Statistics
🔗 link here
Tools: Python (Pandas)
Requirements Gathering & Analysis
Description: Analyzed Stack Overflow Developer Survey dataset to
Advertising Industry Analysis
study developer demographics, work patterns, Python usage, and
Data Storytelling
compensation using Pandas.
Tools
My tasks: Data loading and cleaning
Google Analytics
Tableau, Looker Studio, Power BI Descriptive statistics and missing value handling
Pandas, NumPy, Matplotlib, Seaborn, Data filtering, grouping, and aggregation
Jupyter Notebook Python usage and learning path analysis
BigQuery Remote work and compensation analysis
Google Sheets, Excel
Top-N and percentile-based filtering
Soft Skills Results: Identified Python usage rate among developers
Strong analytical thinking
Analyzed remote work distribution
Critical Thinking
Attention to Detail Explored compensation differences by country
Time Management Detected education patterns in high-paid respondents
Accurate
Languages Work Experience
English - Pre-Intermediate
Math Teacher
Ukrainian - Native
Arlamivskovolianska Gymnasium, Mostyska City Council
Education Lviv Oblast, Ukraine
Data Analysis 2017 - 2025
GoIT - start your career in IT Worked with educational data in the electronic system “Novi
2026 Znannia”: data collection, structuring, and analysis
Mathematics, Specialist degree Analyzed students’ performance to identify trends and problem
Ivan Franko National University of Lviv areas
2005- 2010 Prepared reports and visualizations for attestation evaluation