Христина

Khrystyna Fesechko
Chernihiv, Ukraine | Remote

[відкрити контакти](див. вище в блоці «контактна інформація»)

[відкрити контакти](див. вище в блоці «контактна інформація»)

https://github.com/khrystynafesechko-dotcom

SUMMARY
Data Analyst with 10+ years of commercial experience, including 2+ years of
professional experience in data analytics and reporting. Strong professional
expertise in Excel and Google Sheets, with hands-on experience in data analysis, KPI
reporting, data validation, and working with large datasets. Hands-on experience
with SQL, BigQuery, PostgreSQL, Power BI, and Tableau through personal projects,
with a solid understanding of BI reporting principles, ETL/ELT concepts, data
modeling, and data quality practices. Experienced in identifying trends, anomalies,
and data discrepancies, investigating KPI deviations, and translating business
requirements into clear analytical tasks and reporting solutions.

TECHNICAL SKILLS
SQL & Relational Databases — personal projects
• SQL — complex queries for data extraction, transformation and analysis
• JOIN, CTE, subqueries, GROUP BY, aggregate functions
• Window functions and analytical calculations
• Data validation and quality checks
• Working with large datasets
• Relational database concepts: primary keys, foreign keys and relationships
• Data modeling and normalization fundamentals
Data Analysis & Business Analysis — personal projects
• Analysis and interpretation of business, product and marketing KPIs
• Funnel, cohort, retention and customer behavior analysis
• Quantitative analysis to identify trends, patterns and performance drivers
• Data validation and investigation of data inconsistencies
• Translating business questions into analytical tasks
• Data-driven analysis and formulation of actionable insights
Power BI & Data Visualization — personal projects
• Power BI — dashboard and report development
• Power Query — data transformation, cleaning and preparation
• DAX — measures and calculated columns
• Data modeling and relationships
• Interactive dashboards, KPIs and business reporting
Excel & Google Sheets
• Advanced Excel and Google Sheets
• Pivot Tables and advanced formulas

• XLOOKUP, INDEX/MATCH, SUMIFS
• Power Query
• Data aggregation, analysis and reporting
Data Engineering / Cloud — personal project
• Google BigQuery
• ELT pipeline development
• Staging and analytical layers
• SQL transformations and data cleaning
• Data Quality & Validation
• SQL JOINs and control metrics
Python
• Python for Data Analysis — currently learning

WORK EXPERIENCE
Data Analyst (E-Prescription Operations) -“BAZHAYEMO ZDOROVYA” Pharmacy
2024 – Present
• Process and analyze 200K+ rows of data from multiple sources, performing
daily checks to ensure data completeness, consistency, and accuracy.
• Conduct daily validation of data extracts, identifying errors, missing records,
inconsistencies, and unexpected changes in key metrics.
• Investigate data issues and discrepancies to identify root causes and determine
whether problems originate from source systems, data processing, or business
processes.
• Collaborate with cross-functional teams to investigate and resolve data quality
issues and ensure accurate and timely reporting.
• Prepare and maintain KPI reports twice a month using Excel and Google Sheets,
including data aggregation, validation, KPI tracking, and analysis of significant
changes and deviations.
• Communicate data quality issues, findings, and KPI changes to relevant
stakeholders to support timely decision-making.

Pharmacy Store Manager - “PODOROZHNYK” Pharmacy, 2020-2024
Medical Representative – ARTERIUM LTD, 2018-2020
EARLY CAREER
Pharmacist — Various pharmacies , 2012-2020

EDUCATION & CERTIFICATIONS
• Specialist Degree in Pharmacy – National University of Pharmacy, Kharkiv
(2007-2012)
• Google Data Analytics Professional Certificate.
• IBM Databases and SQL for Data Science Certificate
• Visual Analytics with Tableau Certification
• Python for Data Analysis (currently learning)
• ENGin English Program graduate Certificate.

LANGUAGES
• Languages: Ukrainian (Native), English – B2+

PROJECTS
Superstore Sales Dashboard in Power BI
Power BI | DAX | Power Query | Data Modeling
https://github.com/khrystynafesechko-dotcom/Superstore-Sales-by-KF
• Cleaned, transformed, and validated transactional sales data using Power
Query.
• Designed a structured analytical data model for sales reporting using fact and
dimension concepts.
• Created DAX measures for Revenue, Profit, Profit Margin, Sales Quantity, and
other KPIs.
• Built an interactive Power BI dashboard with product, customer, sales, and
profitability analysis.
• Applied relationships, filtering, and DAX calculations to support interactive
analytical reporting.
• Investigated data quality issues and validated calculated results against source
data.
Social Media Advertising Analytics
BigQuery | SQL | Power BI
https://github.com/khrystynafesechko-dotcom/Social_Media_Advertising_Analytics
• Built an ELT pipeline in BigQuery to transform raw data into analytics-ready
tables.
• Loaded raw datasets into staging tables and performed Data Quality &
Validation checks.
• Identified and handled duplicates, NULLs, invalid IDs and inconsistent data
formats.
• Developed complex SQL transformations using CTEs, JOINs, aggregations and
window functions.
• Created clean analytical tables and validated transformation results using
control metrics.
• Built a relational data model and connected analytical tables in Power BI.
• Developed interactive Power BI dashboards for advertising performance
analysis.
Healthcare Appointment Attendance Analysis
Google Sheets | Pivot Tables | Dashboard
https://github.com/khrystynafesechko-dotcom/Healthcare-Appointment-Attendance-
No-Show-Analysis
• Analyzed healthcare appointment data to identify patterns in attendance and
no-show behavior.
• Examined relationships between attendance and patient demographics, health
conditions, SMS reminders, waiting time, weekdays, age groups, gender, and
neighbourhoods.

• Used Pivot Tables, data aggregation, and dashboard visualization to explore
key factors associated with missed appointments.
• Presented analytical findings through an interactive Google Sheets dashboard.