AI and data-driven decision making

Hi, I'm Milad Shabani

I turn complex business problems into systems, data and intelligent solutions.

Milad Shabani
SQL
CRM
BI
AI
Scroll down

About me

👋

In one look

I turn business data and processes into infrastructure for better decisions.

My career path

  1. 1
    Process analysis
    Modeling processes with BPMN and capturing business requirements
  2. 2
    Process implementation
    Designing and deploying processes in CRM and ERP with Microsoft Dynamics
  3. 3
    Data warehouse and BI
    Data warehouse design, ETL development and management dashboards
  4. 4
    Forecasting and AI
    Forecasting, optimization and intelligent solutions built on that same data
  • Research focus
    Supply chain and planning, especially demand forecasting, capacity planning and resource allocation
  • Education
    M.Sc. in Industrial Engineering, Kharazmi University
  • Experience
    4+ years across telecom, pharmaceutical distribution, manufacturing and online marketplaces
Data engineering: warehousing and ETL
BI, dashboards and KPIs
AI and demand forecasting
Systems and business process analysis
Microsoft Dynamics CRM implementation
Supply chain planning and optimization
Read the full résumé

Experience

From data analysis to warehouses, dashboards and forecasting

Business Intelligence Engineer

Apr 2026 – present

Freelance — multiple clients

  • Build and tune ETL processes that integrate and cleanse data from multiple sources
  • Design management and operational dashboards in Power BI; define and track KPIs with DAX and Power Query

Business Intelligence Engineer

Aug 2025 – Mar 2026

Asiatech

  • Designed and built a data warehouse serving 500M+ records
  • ETL pipelines for high-volume data, OLAP models and interactive BI dashboards

BI Engineer — independent project

May – Aug 2025

Eltiam Distribution & Kharazmi Pharmaceutical

  • Pulled data from the APIs of 15 pharmaceutical distributors with C# in SSIS
  • Data warehouse, SSAS Tabular models in DAX and management dashboards in Power BI

BI Specialist & Systems Analyst

Feb 2024 – Apr 2025

Samanehaye Modiriat

  • BI and CRM delivery for MAPNA, Digikala, MCI and Saba Battery, among others
  • ETL in SSIS, Tabular models in SSAS, Power BI dashboards and RDL reports; processes built in Microsoft Dynamics

Data Analyst

Jun – Dec 2023

Namnik Co. (Kik Ashna)

  • Demand forecasting to plan production-line capacity
  • Data warehouse and ETL in SSIS, with Power BI dashboards

Data Analyst

May 2021 – Jun 2022

Malard Health Network

  • Daily vaccine demand forecasting with machine learning and time-series models
  • Resource allocation and vaccinator scheduling across vaccination centres

Education

M.Sc. Industrial EngineeringKharazmi University · 2023 – 2026
B.Sc. Industrial EngineeringBu-Ali Sina University · 2019 – 2023
Full resume

Organisations I have worked with

Skills

The tools I work with day to day

BI and visualization

Power BI
SSRS / RDL
Excel

Data warehouse and databases

SQL Server (T-SQL)
Data Warehouse Design
SSIS (ETL)
SSAS (Tabular)

Machine learning and optimization

Python
Machine learning
GAMS / CPLEX

Enterprise systems and process

Microsoft Dynamics 365
Power Platform
BPMN / UML
Visual Paradigm / Visio
Git / GitHub

Projects

Each one ships full code, sample data and an artifact you can open

Iran Housing: Where Does a Square Metre Cost What?

An interactive map of Tehran's 22 districts and Iran's 31 provinces, built from 516,947 real Divar listings and the Central Bank's transaction prices. District 1 asks 4× District 17 per square metre, and the cheaper districts rose fastest. Enter a budget to light up the neighbourhoods that fit, price a home with the in-browser model, and move the 12-month forecast with your own growth assumption.

4×north–south price gap
0.88pricing model R²
Python SVG maps Forecasting

Retail Banking: Who Will Leave, Which Loan Will Default?

Customer segmentation, a churn model trained on a time cutoff and a credit-risk model (PD/LGD/EAD), alongside a monthly P&L, a 12-month forecast and marketing-budget optimisation: how the bank grows customers and loans while keeping credit risk in check.

0.88churn model AUC
500Ktransactions
Python Machine learning SQL

Steel Trading: Fast Quotes Win the Deal

A Dynamics 365 Sales export (Dataverse tables with option-set metadata) goes through 71 quality checks into a star schema: what each marketing channel returned, why deals are lost, margin per ton. A win model ranks deals better than the probabilities reps type into the CRM.

74%win rate, quoted in under 4 h
0.67model AUC (CRM: 0.53)
Python scikit-learn Dynamics 365 Power BI

Research and teaching

Teaching and knowledge sharing

Ongoing

Data interview question bank

A free Persian reference of data and BI interview questions — SQL, modelling, Power BI and statistics — with answers that explain the reasoning instead of asking you to memorise it.

SQLPower BIStatistics
Open the question bank
2022

Teaching assistant, Inventory Control

Bu-Ali Sina University, Hamedan: tutorials on inventory models, reorder points and safety stock — the same concepts I now apply in production planning projects.

InventoryOperations research
Available

Training for teams

Hands-on training in Power BI, data modelling and building a first data warehouse, for teams that want to own their reporting. In Persian or English.

Power BIData modellingWorkshops
Ask about a session

Research

2026

M.Sc. thesis — Kharazmi University

Designing a sustainable EV battery supply chain under uncertainty with a data-mining approach: demand and return scenarios are generated from data rather than from arbitrary assumptions.

GAMSCPLEXData mining
2023

B.Sc. project — Bu-Ali Sina University

A review of data-mining methods for breast cancer prediction — the first place I learned that model accuracy without a baseline is a meaningless number.

ClassificationModel evaluation

Get in touch

For a role, a project, or training for your team