Yurii

Yurii Kretov
DATA ANALYST | BUSINESS INTELLIGENCE
Odesa, Ukraine | [відкрити контакти](див. вище в блоці «контактна інформація») | [відкрити контакти](див. вище в блоці «контактна інформація»)

PROFESSIONAL SUMMARY
Data Analyst with 3+ years of experience across e-commerce, financial services, customer operations and
logistics. Advanced SQL user with hands-on experience building reporting data marts, incremental ETL pipelines,
semantic models and dashboards in Power BI, Looker and Redash. Uses Python for data analysis, automation,
forecasting and machine learning. Experienced in translating business requirements and complex datasets into
reliable reporting solutions that support operational and commercial decisions.

CORE SKILLS
SQL & data: Advanced SQL, CTEs, window functions, DDL/DML, query optimization, data modeling, ETL/ELT, data
marts, data quality; PostgreSQL, Amazon Redshift (AWS Redshift), Microsoft SQL Server (MS SQL), MySQL
BI & spreadsheets: Power BI, DAX, Power Query, Power Pivot, Looker, Redash, Excel, PivotTables, dashboard
design, semantic modeling
Python: pandas, NumPy, scikit-learn, Matplotlib, Seaborn, automation, data processing, OOP; FastAPI, SQLAlchemy,
Pydantic
Analytics: KPI reporting, call center and collections analytics, workforce planning, funnel and cohort analysis,
segmentation, retention, LTV, attribution, forecasting, anomaly investigation, stakeholder communication
Machine learning (hands-on practice): Regression, classification, decision trees, RandomForestClassifier, gradient
boosting, KNN, clustering, PCA, model evaluation and regularization
Workflow: Git, Confluence, requirements gathering, documentation, cross-functional collaboration

PROFESSIONAL EXPERIENCE
ODDITY
Data Analyst | Oct 2025 - Present
Contributed to a 25% increase in new-user conversion by optimizing pre-purchase segmentation logic across
acquisition source, product, geography and customer behavior.
Built and maintained Looker reporting and Redshift SQL models for acquisition, retention, email/SMS campaign
performance, engagement and conversion metrics.
Unified quiz, order, GA4 and Klaviyo event data into analysis-ready funnels and cohorts, including new-versus-
returning user logic and time-window attribution.
Refactored recurring refreshes into staged incremental pipelines with rolling lookbacks and validation checks,
avoiding repeated full-history processing and improving reliability.
Investigated attribution and data-quality anomalies involving campaign identifiers, time zones, duplicate records and
late-arriving events; converted findings into clear recommendations.
Aventus IT
Data Analyst | Mar 2025 - Aug 2025
Built and maintained Power BI reporting for Collections and Call Center operations, enabling teams to track
performance and key operational KPIs.
Reduced refresh time for existing reports by 20-30% through SQL query optimization in Microsoft SQL Server and
PostgreSQL.
Designed reusable Power BI report templates that could be migrated and scaled across new projects.
Established standardized Confluence documentation covering report structure, DAX metric calculations and
underlying SQL queries.

PROFESSIONAL EXPERIENCE - CONTINUED
Simply Contact
Operational Data Analyst | Mar 2024 - Jan 2025
Developed and deployed a workload forecasting model that improved staff-allocation efficiency by 25% and helped
reduce the ticket backlog by 15%.
Created and optimized Power BI dashboards for operational and management reporting, cutting data refresh time
by 40% and improving KPI visibility.
Automated bonus calculations for agents and team leaders by building a Power BI report that applied KPI-based
rules for selected reporting periods.
Built a Power BI report with weekly and monthly views of ticket-topic performance, tracking Average Handling Time
(AHT), Resolution Rate, SLA and related KPIs to identify topics that were becoming increasingly complex for
agents.
Partnered with the Learning and Development team to turn these findings into targeted training sessions and
seminars addressing agent knowledge gaps in high-complexity ticket categories.
Grosspeak LLC
Data Analyst | Nov 2022 - Feb 2024
Automated SQL and Python data pipelines, reducing processing time by 40% and improving the consistency of
recurring reporting.
Built Redash dashboards for real-time monitoring of commercial and operational KPIs.
Developed a RandomForestClassifier to predict whether a suitable freight load would be available in a selected area
based on truck specifications and dimensions, acceptable rate and broker-contract status.
Achieved an F1-score of 0.93, helping brokers and dispatchers plan driver routes and reduce the risk of downtime
between loads.

EDUCATION
Master's Degree in Marketing | 2022 - 2024
V. N. Karazin Kharkiv National University
Bachelor's Degree in Marketing | 2018 - 2022
V. N. Karazin Kharkiv National University

CERTIFICATIONS
Mastering DAX Calculations in Power BI - Udemy, 2025
ML Algorithms from Scratch - Stepik, Aug 2026
SQLAlchemy: Practical Work with DB in Python - Stepik, Sep 2026
Start ML - Karpov Courses, 2023
FastAPI for Continuing Users - Stepik, May 2026
TOEFL iBT, 2023

LANGUAGES
Ukrainian - Native | English - Upper-Intermediate (B2)