Дарина

Daryna Dzhura
Junior Data Analyst
Kyiv, Ukraine | [open contact info](look above in the "contact info" section) | [open contact info](look above in the "contact info" section)
LinkedIn: [open contact info](look above in the "contact info" section) | GitHub: github.com/Darina917345
Tableau Public: public.tableau.com/app/profile/daryna.dzhura8229

PROFILE
Applied Mathematics student with hands-on experience in SQL, Power BI, Tableau, and Excel, building end-to-end
analytical projects: from data cleaning and modeling to KPI dashboards and trend analysis. Strong foundation in
statistics and relational databases. Seeking a Junior Data Analyst role or internship (part-time alongside studies) to turn
complex datasets into actionable insights.

PROJECTS
E-Commerce Sales & Performance Analysis SQL (PostgreSQL), Power BI, Git
GitHub: github.com/Darina917345/ecommerce-sales-analysis
Analyzed 99,441 orders across 9 relational tables to answer 10 business questions on revenue, retention, logistics,
and payments; designed the PostgreSQL schema and wrote 12 SQL scripts.
Audited data quality (missing delivery dates in ~3% of orders, 610 products without a category, 31 invalid geo-
coordinates) and resolved each issue with documented rules.
Built RFM segmentation and retention analysis using CTEs, joins, and window functions (NTILE): 96.9% of customers
bought only once, pointing to an opportunity for loyalty campaigns. Showed that delivery speed drives satisfaction:
average review score 4.4 for 0–7 day deliveries vs 3.7 for 15+ days.
Designed a 6-page interactive Power BI dashboard with DAX measures (total revenue 13.22M, AOV ~137), fed by a
PostgreSQL view as a single source of truth so SQL and dashboard figures match.
Global Tech Layoffs: Event Tracking Analysis Tableau, Excel
Tableau Public: Global Tech Layoffs dashboard
Built an interactive Tableau dashboard (KPI cards, events trend, geographic map, impact segmentation, top
industries) tracking 4,588 layoff and shutdown events across 2,975 tech companies, March 2020 – September 2026.
Cleaned and categorized the dataset in Excel by impact type (Full Shutdown, Mass Layoff, Minor/Moderate,
Undisclosed); identified 372 full company shutdowns.
Found the layoff peak in 2023 (1,389 events, ~265K employees laid off) and that Mass Layoffs are only 7% of events
but account for ~68% of ~931K reported job cuts.
Mapped geographic and industry concentration: the US accounts for 63% of events, followed by India (349); Finance,
Retail, and Healthcare are the most affected industries by event count.

SKILLS
BI & Visualization Tableau Public, Microsoft Power BI (Power Query, DAX), MS Excel (Pivot Tables, advanced
formulas)
Databases & Querying SQL (PostgreSQL): CTEs, window functions, joins, aggregations, data transformation
Tools Git, GitHub, VS Code

EDUCATION
Bachelor of Applied Mathematics Expected graduation: 2028
National Technical University of Ukraine “Igor Sikorsky Kyiv Polytechnic Institute” (KPI), Kyiv
Relevant coursework: Mathematical Statistics, Probability Theory, Relational Databases & Information Systems, Data
Visualization, Algorithms & Data Structures

LANGUAGES
Ukrainian: native (C2) | English: upper-intermediate (B2)