Яна

YANA PISKOVA
Junior Data Analyst
[відкрити контакти](див. вище в блоці «контактна інформація») [відкрити контакти](див. вище в блоці «контактна інформація») Telegram: @Yan4uk1807
LinkedIn: [відкрити контакти](див. вище в блоці «контактна інформація») Cherkasy, Ukraine

SUMMARY
Detail-oriented Junior Data Analyst skilled in SQL, Python (Pandas, NumPy), Excel, and Power
BI. Experienced in data visualization, A/B testing, and exploratory data analysis, delivering
insights on marketing performance and user behavior to identify key drivers of engagement
and conversion. Strong analytical thinking, teamwork, and time management, featuring self-
discipline, trustworthiness, and a passion for learning.

HARD SKILLS
SQL
Python
Data Cleaning & Transformation
Exploratory Data Analysis (EDA)
A/B Testing and Statistical Analysis
Data Visualization & Reporting

TOOLS
Tableau Amplitude PostgreSQL, MySQL Pandas, NumPy, Matplotlib
Power BI Looker Studio Excel and Google Sheets Jupyter Notebook
PROJECT EXPERIENCE
Project 1: Analysis of Delivery Terms
https://public.tableau.com/app/profile/.68054697/viz/Analysisofdeliveryterms_17605220421890/Analysisofdeliveryterms
Tools: Tableau Public, Data Visualization, Dashboard Design
Description: Developed interactive Tableau dashboard to analyze sales trends, subcategory
profitability, and delivery term efficiency.
My tasks:
Created time series overview of sales/profit to identify key performance patterns.
Explored profitability by subcategory/shipping mode to highlight high-margin segments.
Designed delivery analysis: order count by delivery days and avg. time across U.S. states.
Implemented dynamic filters and map visualizations for user-friendly data exploration.
Result: Identified key performance patterns and high-margin segments, enabling data-driven
sales/delivery optimizations.
Project 2: Revenue metrics
https://public.tableau.com/app/profile/.68054697/viz/Final_project_Piskova_Yana/RevenueMetrics

Tools: Tableau Public, SQL, Data Visualization, Dashboard Design
Description: Developed an interactive Tableau Public dashboard to analyze Monthly Recurring
Revenue (MRR) and paid user behavior for a subscription-based product.
My tasks:
Prepared and aggregated payment data in SQL at the user–month level and calculated MRR.
Implemented business logic for New MRR, Expansion, Contraction, and Churn using window
functions.
Built time-series visualizations of MRR and paid users to identify key trends.
Analyzed churned revenue and revenue change drivers.
Added dynamic filters by period, age group, and language for flexible segment analysis.
Result: Identified key revenue growth and churn drivers, as well as high-impact user segments,
enabling data-driven decision-making for subscription revenue optimization.
WORK EXPERIENCE:
Elysium Furniture Factory
Accountant
March 2024 – Present
Payroll accountant.
Primary documentation management.
Production accountant.
Key Achievement: Successfully transitioned to a new production management program.

McDonald's
Administrative assistant
December 2012 – May 2024
Hiring and dismissal of staff.
Contract management and payment of invoices.
Control of cash documentation.
Key Achievement: Organized successful restaurant openings.

EDUCATION:
IT School "GoIT"
June 2025 - December 2025
Certificate in Data Analysis

Genius.space
September 2023 - November 2024
Accountant course for individual entrepreneurs

Cherkasy State Technological University
September 2006 - June 2011
Master’s Degree in Finance

LANGUAGES:
English – Pre-Intermediate, Ukrainian – Native