EPAM DAE Trainee

Yusufjon Tolibjonov

Data Analyst

Transforming raw data into actionable insights. Specialized in SQL, Python, and Power BI to drive data-driven decisions.

3rd Year Student
4 Languages
skills_analysis.py
SQL
95%
Python
88%
Power BI
85%
Excel
90%
Git
80%

Skills & Tools

Data Analysis

SQL PostgreSQL Excel Data Cleaning ETL

Programming

Python Pandas NumPy Git

Visualization

Power BI Dashboards Reports DAX

Languages

Uzbek - Native English - C1 Russian - B2 Korean - B1

Experience & Education

2025 - Present

Data Analytics Engineering Trainee

EPAM Systems

Currently enrolled in the DAE (Data Analytics Engineering) trainee program, learning advanced data engineering concepts and best practices.

2025

Data Analytics Course

Najot Ta'lim

Completed 7-month intensive data analytics program covering SQL, Python, Excel, Power BI, and practical data analysis projects.

2023 - Present

Electrical and Computer Engineering

Ajou University in Tashkent

3rd year student pursuing a degree in Electrical and Computer Engineering, building a strong foundation in technical problem-solving.

Featured Projects

Power BI

Financial Analysis Dashboard (P&L)

Problem

Company lacked visibility into profit margins across products and regions, making it difficult to identify underperforming areas.

Dataset

50K+ transactions, Revenue, COGS, Operating Expenses, Net Income (2021-2024)

KPIs

Gross Profit Margin, Net Profit Margin, Operating Margin, YoY Growth, Revenue by Category

Insights

Identified 15% cost reduction opportunity in logistics. Q4 showed 23% higher margins than Q1-Q3 average.

Recommendations

Optimize supply chain in low-margin regions. Focus marketing budget on high-performing Q4 period.

Power BI DAX Data Modeling Excel
View Project
SQL + Python

E-commerce Analysis

Problem

Online store experienced high cart abandonment rates and needed to understand customer purchase patterns.

Dataset

100K+ orders, Customer data, Product catalog, Transaction logs (2022-2024)

KPIs

Conversion Rate, AOV, Cart Abandonment Rate, Customer Lifetime Value, Repeat Purchase Rate

Insights

Mobile users had 40% higher abandonment. Peak sales occurred Tuesday-Thursday. Electronics category drove 45% of revenue.

Recommendations

Improve mobile checkout UX. Launch targeted promotions on peak days. Expand electronics inventory.

PostgreSQL Python Pandas Power BI
View Project
Power BI

Sales Performance Analysis

Problem

Sales team lacked real-time visibility into performance metrics and regional sales trends.

Dataset

200K+ sales records, 50 sales reps, 5 regions, Product hierarchy (2020-2024)

KPIs

Total Revenue, Sales Growth %, Quota Attainment, Win Rate, Average Deal Size, Sales Cycle Length

Insights

Top 20% of reps generated 65% of revenue. North region underperformed by 18%. Deal size increased with longer cycles.

Recommendations

Implement mentorship program pairing top performers with struggling reps. Reallocate resources to high-potential territories.

Power BI SQL DAX Excel
View Project
Python

Customer Segmentation Analysis

Problem

Marketing team used one-size-fits-all approach, resulting in low engagement and high customer churn.

Dataset

75K customers, Purchase history, Demographics, Behavioral data, RFM metrics

KPIs

RFM Score, Customer Segments, Churn Rate by Segment, CLV by Segment, Engagement Rate

Insights

Identified 5 distinct segments: Champions (12%), Loyal (18%), At-Risk (25%), New (20%), Dormant (25%). Champions had 8x higher CLV.

Recommendations

Create personalized campaigns per segment. Implement win-back program for At-Risk. VIP program for Champions.

Python Pandas K-Means Power BI
View Project
SQL + Excel

Marketing Campaign Analysis

Problem

Company spent $500K annually on marketing but couldn't measure ROI or identify best-performing channels.

Dataset

30 campaigns, Multi-channel data (Email, Social, PPC, Display), Conversion tracking

KPIs

ROAS, CAC, Conversion Rate, CTR, CPM, Campaign ROI, Attribution Model

Insights

Email had 4.2x ROAS (highest). Display ads had negative ROI. Social media drove awareness but low direct conversions.

Recommendations

Increase email budget by 40%. Cut display advertising. Use social for top-of-funnel only with retargeting.

SQL Excel Power BI Google Analytics
View Project
Python + SQL

Operations Analysis

Problem

Warehouse experienced inefficiencies in order fulfillment, leading to delayed shipments and customer complaints.

Dataset

150K+ orders, Warehouse logs, Inventory levels, Shipping data, Staff schedules

KPIs

Order Fulfillment Time, On-Time Delivery %, Inventory Turnover, Pick Accuracy, Labor Productivity

Insights

Monday mornings had 3x longer fulfillment times. Zone B had 15% lower pick accuracy. Stockouts caused 22% of delays.

Recommendations

Add staff on Monday mornings. Retrain Zone B team. Implement automated reorder points for high-velocity items.

Python SQL Power BI Excel
View Project

Let's Work Together

I'm currently looking for data analyst opportunities. Feel free to reach out if you have a position that matches my skills!