EJ
Open to opportunities · Krakow, Poland
EJ
EU Work Permit

Elchin Jabbarli

Data Analyst & BI Developer

Turning geospatial & transactional data into executive insights with Python, SQL, and Power BI. 5+ years optimizing 1,500+ routes and building dashboards used across Turkey & DACH markets.

5+
Years Experience
1,500+
Routes Optimized
10K+
Stores Analyzed
3+
Power BI Dashboards
Krakow, Poland · No sponsorship required
About

Bridging data, geography, and business strategy

A short story about who I am and how I work.

I'm a Data Analyst and BI Developer with over five years of experience translating complex geospatial and transactional data into actionable executive insights. My work has spanned FMCG at PepsiCo and enterprise operations at Cahan Holding Group, where I've owned everything from raw data wrangling to interactive C-suite dashboards.

At PepsiCo, I designed and optimized 1,500+ sales routes across the Turkey business unit using K-Means clustering and TSP heuristics — reducing monthly planning time by roughly 60%. I also built a portfolio of Power BI dashboards (Customer Management Scorecard, DACH Retail Performance) that are now used across Turkey and Germany for real-time KPI monitoring.

I hold an M.Sc. in Computer Science (Data Science track) from WSB University and a B.Sc. in Econometrics from Suleyman Demirel University. I work fluently in Azerbaijani, Turkish, and English, with basic Polish — and I hold an EU work permit with no sponsorship required.

5+ Years in Industry

FMCG (PepsiCo) & enterprise holdings (Cahan Holding) — operations analytics, route optimization, BI dashboards.

M.Sc. Computer Science

Data Science specialization at WSB University, Poland — ML, Data Mining, Statistical Analysis, Deep Learning.

Multi-Market Exposure

Built dashboards used across Turkey (1,500+ routes) and DACH Germany (10,000+ retail locations).

End-to-End Skillset

From data engineering (SQL, ETL, VBA) to ML modeling (K-Means, XGBoost, TSP) to BI visualization (Power BI, Tableau).

Skills

A full-stack data toolkit

From raw data pipelines to executive-ready dashboards and ML-powered optimization.

Data Analysis

Python (NumPy, Pandas, Scikit-learn)95%
SQL92%
ETL & Data Pipelines88%
Exploratory Data Analysis (EDA)90%

BI & Visualization

Power BI (DAX, Power Query)95%
Tableau80%
Looker75%
Matplotlib & Seaborn90%
Azure Maps85%

Machine Learning

K-Means Clustering92%
Random Forest / XGBoost85%
SVM & Logistic Regression82%
TSP / Route Optimization90%

Programming & Tools

Python95%
SQL92%
VBA (Excel Macros)88%
Git85%
Flask80%

Domain Expertise

Route OptimizationSales AnalyticsCustomer SegmentationSLA TrackingExecutive DashboardsGeospatial Analysis
Experience

5+ years driving impact with data

From FMCG route optimization to enterprise BI dashboards used across multiple markets.

Data Analyst (Route Optimization & BI)

PepsiCo·Krakow, Poland
Mar 2024 — Present

Owning route optimization and BI for the Turkey business unit while building executive dashboards for the DACH Germany market.

Designed & optimized 1,500+ sales routes across Turkey BU using geospatial analysis and K-Means clustering, integrated into the GeoVision platform for territory planning.

Built automated route scheduling system in Python (Pandas, NumPy, Scikit-learn) with TSP optimization — cut monthly planning time by ~60%.

Developed 3+ Power BI dashboards including Customer Management Team Scorecard and DACH Retail Performance Dashboard for real-time KPI monitoring.

Self-initiated DACH Germany dashboards tracking visit performance and SKU availability across 10,000+ retail locations; recognized by senior management.

Engineered VBA macros automating Excel report generation, saving ~8 hours/week of manual processing.

Mentored 2 interns and 1 full-time employee on route design processes and reporting standards.

PythonPandasNumPyScikit-learnPower BIDAXPower QueryAzure MapsVBAGeoVision

Data Analyst

Cahan Holding Group·Baku, Azerbaijan
Jul 2019 — Feb 2023

Supported Sales & Marketing with end-to-end analytics — from data cleaning to interactive Power BI dashboards for stakeholders.

Performed data cleaning, preprocessing, and transformation for the Sales & Marketing department using Python (NumPy, Pandas).

Executed SQL queries to retrieve and analyze large-scale datasets, generating reports that supported strategic decisions.

Conducted EDA to identify trends, patterns, and anomalies in sales and customer data, optimizing marketing campaigns.

Developed and maintained interactive Power BI dashboards visualizing key performance metrics for stakeholders.

PythonSQLPower BIDAXPower QueryPandasNumPy
Projects

Selected work

A snapshot of recent analytics, ML, and BI projects shipped across FMCG operations.

Route Optimization Engine

Full-stack geospatial app with K-Means + TSP

Featured

Built a full-stack route optimization web app with a Flask backend for geospatial data upload. K-Means clusters customers into territories; a nearest-neighbor TSP heuristic sequences optimal visits. Reduced total route distance by ~15%.

~15%
Distance saved
1,500+
Customers
5 regions
Clusters

Key features

  • Flask web server for geospatial data upload
  • K-Means clustering for territory segmentation
  • Nearest-neighbor TSP heuristic for route sequencing
  • Visit frequency assignment (weekly / biweekly / monthly)
  • Day scheduling for 1,500+ customers across 5 regional clusters
  • Automated monthly route plan generation
PythonScikit-learnFlaskTSPK-Means

DACH Retail Performance Dashboard

Multi-page Power BI dashboard for 10K+ stores

Featured

Multi-page Power BI dashboard tracking Hero SKU Instore Achievement, Chilled Availability, and Permanent Tool Adoption KPIs across the DACH region. Integrated Azure Maps for store-level geospatial drill-downs.

46%
Hero SKU
55%
Chilled Avail.
23%
Tool Adoption

Key features

  • Multi-page dashboard tracking 3 KPI categories
  • Store-level geospatial drill-down via Azure Maps
  • Filter by route, store type, and wholesaler
  • Time-series & categorical visualizations
  • Rolling 12-month visit performance trends
  • 10,000+ retail locations covered
Power BIDAXPower QueryAzure Maps

Customer Management Team Scorecard

SLA performance dashboard with process analytics

SLA performance dashboard with gauge charts and process-level bar charts tracking Opening, Update, and Closure times. Identified 3 bottleneck processes reducing SLA compliance.

12
Process cats
3 found
Bottlenecks
MoM + YoY
Views

Key features

  • Gauge charts for SLA tracking
  • Opening / Update / Closure time analytics
  • MoM and YoY improvement percentages
  • 12 process category visualization
  • Transaction detail drill-downs
  • Interactive map for geographic monitoring
Power BIDAXPower Query
Education

Academic background & certifications

A blend of computer science (data science) and econometrics, backed by industry-recognized certifications.

Education

M.Sc. Computer Science — Data Science

2023 — 2025
WSB University · Poland
Machine LearningData MiningStatistical AnalysisDeep Learning

B.Sc. Econometrics

2013 — 2018
Suleyman Demirel University · Turkey
Statistical modelingEconometric analysisQuantitative methods

Certifications

  • Google Data Analytics Professional Certificate

    Google · 2022

  • Data Analyst with Python

    DataCamp · 2022

  • Data Analyst in SQL

    DataCamp · 2022

  • SQL (Intermediate)

    HackerRank · 2022

  • SQL (Basic)

    HackerRank · 2022

  • Data Analytics

    QSS Analytics · 2019

🌍

Languages

AzerbaijaniNative
TurkishNative
EnglishFluent
PolishBasic
Contact

Let's build something with data

Open to data analyst, BI developer, and analytics engineering roles. Feel free to reach out.

Available for new opportunities

EU work permit · No sponsorship required · Based in Krakow, Poland

Send a message

I'll get back to you within 24 hours.

This opens your email client pre-filled with your message.