Yurii

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

PROFESSIONAL SUMMARY
Data Analyst with 3+ years of experience in e-commerce, financial services, customer operations and
logistics. Builds reporting data marts, incremental ETL pipelines and dashboards using advanced SQL,
Python, Power BI and Looker. Experience includes conversion and retention analytics, workload
forecasting, reporting automation and translating business requirements into reliable reporting solutions.

TECHNICAL SKILLS
SQL & databases: Advanced SQL, CTEs, window functions, DDL/DML, query optimization; PostgreSQL,
Amazon Redshift (AWS), Microsoft SQL Server, MySQL.
BI & data pipelines: Power BI, DAX, Power Query, Power Pivot, Looker, Redash, Excel, PivotTables;
ETL/ELT, data marts, data modeling, semantic modeling, data quality.
Python: pandas, NumPy, scikit-learn, Matplotlib, Seaborn, automation; FastAPI, SQLAlchemy, Pydantic.
Analytics: KPI reporting, funnel and cohort analysis, segmentation, retention, lifetime value (LTV), attribution,
workforce planning, forecasting.
Machine learning (hands-on): Regression, classification, random forests, gradient boosting, clustering, PCA,
model evaluation.
Workflow: Git, Confluence, requirements gathering, stakeholder communication, documentation.
AI-assisted development: OpenAI Codex, Claude Code.

PROFESSIONAL EXPERIENCE
ODDITY
Data Analyst | Oct 2025 - Present
- Contributed to a 25% increase in new-user conversion by refining pre-purchase segmentation across
acquisition sources, products, geographies and customer behavior.
- Built and maintained Looker reports and Amazon Redshift SQL models for acquisition, retention,
email/SMS performance, engagement and conversion KPIs.
- Integrated quiz, order, Google Analytics 4 (GA4) and Klaviyo events into analysis-ready funnels and
cohorts, with new and returning user logic and time-window attribution.
- Reworked recurring refreshes into staged incremental ETL pipelines with rolling lookbacks and validation
checks to improve reliability and avoid repeated full-history processing.
- Diagnosed attribution and data-quality issues involving campaign IDs, time zones, duplicates and
late-arriving events; translated findings into business recommendations.
Aventus IT
Data Analyst | Mar 2025 - Aug 2025
- Built and maintained Power BI dashboards for Collections and Call Center operations to track
performance and operational KPIs.
- Reduced report refresh time by 20-30% through SQL query optimization in Microsoft SQL Server and
PostgreSQL.
- Designed reusable Power BI report templates for rollout and scaling across new projects.
- Standardized Confluence documentation for report structures, 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 in Power BI using KPI-based rules for
selected reporting periods.
- Analyzed weekly and monthly ticket-topic trends using average handling time (AHT), resolution rate and
service-level agreement (SLA) metrics; partnered with Learning and Development on targeted training for
complex 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 random forest classifier (RandomForestClassifier) to predict suitable freight-load availability
by area using truck specifications and dimensions, acceptable rates and broker-contract status.
- Achieved an F1-score of 0.93 to support brokers and dispatchers in route planning and reducing 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

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

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