Юлія

Yuliia Dagdelen
Data Analyst
[відкрити контакти](див. вище в блоці «контактна інформація») Denizli, Turkey (remote) LinkedIn Telegram

Data Analyst with 7 years of experience managing international logistics and delivering 300+ shipments monthly.
Skilled in turning complex data into business insights using SQL, Python, Excel, and BI tools. Ready to drive
smarter decisions and boost profitability through data.

PROFESSIONAL EXPERIENCE

Data Analyst, Freelance 09/2024 – 05/2025
Provided freelance data analysis services using Python, SQL, Google Sheets, and
Tableau. Created dashboards, optimized SQL queries, and delivered business insights
through statistical analysis and A/B testing.

Project 1: [Sales Dashboard with SQL, Python & Tableau]
•

Built a sales analytics solution for an online store using SQL (data extraction), Python
(exploratory and statistical analysis), and Tableau (interactive dashboard).
Project 2: [A/B Test Analysis with Python & Tableau]
•

Analyzed A/B test results using statistical methods in Python and visualized key
conversion metrics in Tableau to identify statistically significant differences across user
segments.
Project 3:User Metrics Analysis (SQL)
•

The project supports cross-country activity comparison, identification of key markets,
and user segmentation by engagement and verification criteria.
Project 4: Global Sales Data Cleaning & Insights
•

Cleaned and analyzed multi-year global sales data across product categories, countries,
and sales channels. Identified key trends, profit drivers, and market patterns using SQL,
Python and data visualization.
Tableau projects
•

Transportation Associate, Deciem / The Abnormal Beauty Company 10/2023 – 05/2024
Collected, cleaned, and structured logistics data for reporting
•
Toronto, Canada
Used Excel and ERP data to monitor delivery KPIs
•

Suggested operational improvements based on data trends
•

Senior Logistics Coordinator, Carsfromwest 01/2018 – 12/2022
Reduced transportation costs by 15% through logistics data analysis and process
•
Remote (US-based)
optimization.
Built dashboards in Google Sheets to track delivery KPIs and delays, enabling faster
•

decisions.
Optimized routing for 300+ monthly vehicle deliveries using operational and external
•

data.
Improved delivery speed during crises via root-cause analysis and bottleneck
•

resolution.
Maintained inventory and delivery tracking systems across global vendors and time
•

zones.

EDUCATION

Master's in Transport & Information Technologies, 2011
National Transport University of Ukraine
TECHNICAL SKILLS:

SQL Python
advanced queries, JOINs, CTEs, aggregation, filtering, Pandas, NumPy, Matplotlib, Seaborn, Statsmodels
window functions
Visualization Tools
A/B Testing Tableau (Sales Dashboards), Google Data Studio
hypothesis design, p-value calculation, significance
testing, metric impact Google BigQuery
data preparation, cleaning, transformation
Excel / Google Sheets
formulas, pivot tables, charts, reporting

Business Analytics
revenue, LTV, conversion rate, churn, retention

LANGUAGES:

Ukrainian English
– Native – Advanced

Turkish
– Intermediate

ADDITIONAL EDUCATION & CERTIFICATION

Data Analyst Program, Mate Academy 2025
Modules: SQL, Python, A/B Testing, Product Analytics, Dashboards (Tableau)

Supply Chain Connection Program, Sheridan College 2023