Особисті дані приховані

INNA ZDOROVETS
DATA ANALYST
[відкрити контакти](див. вище в блоці «контактна інформація») [відкрити контакти](див. вище в блоці «контактна інформація») Lviv, Ukraine
LinkedIn : [відкрити контакти](див. вище в блоці «контактна інформація») Telegram : https://t.me/I3doro8

SUMMARY
Data Analyst with hands-on experience in SQL (BigQuery), Python, Excel, Power BI, Tableau, and Google
Analytics. Skilled in data cleaning, validation, exploratory data analysis (EDA), KPI reporting, business metrics
analysis, and building interactive dashboards that support data-driven decision-making.
I bring 24 years of experience working with large-scale public sector databases, ensuring data quality, optimizing
processes, and translating business requirements into analytical solutions. My portfolio includes end-to-end
analytics projects across e-commerce, marketing, business intelligence, and public-sector/humanitarian data,
demonstrating the ability to turn raw data into actionable insights.

SKILLS
HARD SKILLS : Data Cleaning & Validation, Data Transformation, Data Quality Assurance, Exploratory Data
Analysis (EDA), Business Metrics, KPI Reporting, Product Analytics, Marketing Campaign Analysis, Data
Visualization, Data Storytelling, A/B Testing, Statistical Analysis, Requirements Gathering.
TOOLS : SQL (BigQuery), Python (Pandas, NumPy, Matplotlib, Seaborn, Jupyter Notebook), Power BI,
Tableau, Advanced Excel, Google Sheets, Google Analytics
SOFT SKILLS : Analytical Thinking, Attention to Detail, Problem Solving, Accountability, Adaptability,
Organizational Skills, Results-oriented, Communication.

PROJECT EXPERIENCE
Ukraine Displacement Analytics Dashboard (UNHCR, 2018–2025)
GitHub: https://github.com/innazdorovec-9592/ukraine-displacement-dashboard
Live dashboard: https://app.powerbi.com/view?
r=eyJrIjoiN2RmMWE3NTMtYjY5ZS00NDRkLTk2ZWUtNzgyNTU4Y2FjZGFkIiwidCI6IjQ0NTE4MjdkLTljYmQtNGM1OS1iZmU2LThiNTBi
ODJkMDBlMCJ9
Tools: Python (pandas, deep_translator, pycountry), Power BI (Power Query, DAX)
Description: Analysis of internal and external forced displacement of the Ukrainian population (IDPs and
refugees abroad, 2018–2025) based on UNHCR open data
My Tasks: Built a full data pipeline — cleaning and translating raw UNHCR data, running a data quality audit
(duplicates, missing values, format validation), aggregating the data, and designing an interactive two-page
Power BI dashboard with dynamic DAX measures
Result: A published, publicly accessible dashboard summarizing the current humanitarian situation (3.7M IDPs
as of 2025, top host countries for Ukrainian refugees), used as a self-directed reporting and analysis tool

Python Data Analysis: Stack Overflow Developer Survey Insights
https://colab.research.google.com/drive/10EveziOFpiWXOp9x1x_--oZEHoPPk-7C?usp=sharing
Tools: Python (Pandas, Matplotlib, Seaborn).
Description: End-to-end analysis of 10k+ developer records to identify global recruitment and salary trends.
My Tasks: Data cleaning, statistical modeling (distribution/percentiles), and complex multi-level data
aggregation.
Result: Interactive visualizing compensation benchmarks and tech stack popularity.

Conversion Analysis: Google Merchandise Store
https://public.tableau.com/app/profile/inna.zdorovets/viz/_Final_Project_1/Dashboard1

Tools: SQL (CTEs, Joins), BigQuery, Tableau.
Description: conversion analysis of the Google Merchandise Store
My Tasks: Data cleaning, SQL-based metric extraction, and building visual dashboards in Tableau.
Result: interactive tool for the marketing department that allows you to independently research conversions

Sales & Profit Analytics Dashboard
https://app.powerbi.com/view?
r=eyJrIjoiODQwNzY1ZmEtODMyNi00MTZlLWE3MzUtZDJlYTU5ZThiZTRlIiwidCI6IjQ0NTE4MjdkLTljYmQtNGM1OS1iZmU2LThiNTB
iODJkMDBlMCJ9

Tools: Power BI Desktop, Power Query, DAX, Calculation Groups, Power BI Service
Description: developed an e-commerce dashboard featuring clean data architecture and intuitive drill-through
navigation.
My Tasks: Clean and validate datasets, extract metrics using BigQuery, write DAX formulas, and build
dashboards in Power BI.
Result: Deployed advanced metrics and Calculation Groups to optimize performance and enable self-serve
analysis.

E-commerce Metrics Analysis | SQL & Google Sheets Dashboard
https://docs.google.com/spreadsheets/d/1CTkg1FRvZ7FnvNMtRlB6SmfyXfVFFGoGpMjZciVJpm4/edit?gid=0#gid=0

Tools: SQL (CTEs, Joins), Google Sheets, Pivot Tables.
Description: Analysis of e-commerce performance to identify growth areas and operational bottlenecks.
My Tasks: Data cleaning, SQL-based metric extraction, and building visual dashboards via pivot tables.
Result: Identified critical issues in order fulfillment, analyzed AOV correlation with country income, and
optimized assortment structure.

WORK EXPERIENCE
Pension Fund of Ukraine, Lviv | Jul. 2021- now
Deputy Head of Department
Process and Efficiency Management: Coordination of the work of the department (40 people) to ensure
the accuracy and timeliness of payments.
Data Quality: Monitoring and verification of large data sets.

Pension Fund of Ukraine, Kherson | Jun. 2002 - Jul. 2021
Chief Specialist of the Pension/Methodology Departmentї
Working with algorithms: Working with algorithms and formulas for calculating benefits. Ensuring
compliance of data with regulatory requirements.
Audit and Data Cleaning: Detection of system errors in databases.
Project activities: Participation in the development and implementation of a new information system (2017–
2020). Formation of Business Stories and technical requirements for software developers.
Training and adaptation: Conducting trainings for personnel.

School No. 1, Gornostayivk, Kherson Region| Sept. 1998 - Jun. 2002
Mathematics and Computer Science Teacher
Teaching algorithmization, logic and data processing (based on computer science).

EDUCATION LANGUAGES:
Kherson State University, Sept.1993 - Jun. 1998 English - pre-intermediate
Teacher of Mathematics and Computer Science Ukrainian - native
Prometheus Jan. 2025 - Feb. 2025
Business Analyst
"IT School GoIT" Oct. 2025 - May. 2026
Data Analytics