Skip to content
View Milad-Shabani's full-sized avatar
🏡
🏡

Block or report Milad-Shabani

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Milad-Shabani/README.md
Milad Shabani - Business Intelligence Engineer

LinkedIn Instagram Email Website Data interview question bank Followers Profile views

🧭 About me

Business Intelligence Engineer, 4+ years across telecom, pharma, manufacturing and marketplace operations. I build the layer between raw operational data and the decisions people actually make: warehouses that hold up under load, forecasts that answer a real business question, and dashboards a manager can act on in thirty seconds.

M.Sc. in Industrial Engineering, Kharazmi University. Based in Karaj, Iran, and open to remote work and relocation.

Currently

  • Freelance BI engineer for multiple clients: ETL, warehouse design, Power BI dashboards, KPI frameworks
  • Researching a multi-stage stochastic model for EV battery closed-loop supply chains in GAMS/CPLEX, manuscript in preparation
  • Writing a Persian question bank for data interviews, free and growing

🏗️ Selected experience

AsiatechData warehouse serving 500M+ records, with the ETL and OLAP layers on top
Samanehaye ModiriatBI and CRM delivery for Mapna, Digikala, Hamrah Aval, Saba Battery
EltiamPharmC#/SSIS pipeline pulling from the APIs of 15 pharmaceutical distributors into one warehouse
Health Network MalardVaccine demand forecasting and vaccinator scheduling during the COVID-19 campaign

📂 Featured projects

Pharmapulse

Pharmaceutical demand, inventory and working-capital intelligence. LightGBM quantile forecasting with ABC/XYZ segmentation.

S&OP Planning Engine

Forecast to feasible production plan for a five-line plant. Holt-Winters, linear programming, MRP.

Resource & Capacity Planning

A marketplace sales forecast turned into a day-by-day, DC-by-DC staffing and delivery plan.

User Analytics Pipeline

Incremental event streams into a warehouse and partitioned Parquet fact table, with quality gates.

Vaccination Forecasting

Daily vaccine demand across six centers: SARIMA against XGBoost, with backtesting.

Power BI Analytics

Dashboards and data models with PBIX files you can open and inspect.

🧰 Tech stack

BI & reporting Power BI DAX Power Query SSRS Excel
Data & warehouse SQL Server T-SQL SSIS SSAS Docker
Python & modeling Python pandas NumPy scikit-learn LightGBM and XGBoost GAMS and CPLEX
Enterprise & process Dynamics 365 Power Platform BPMN and UML Git Jira

📊 Activity

Contribution streak Contribution graph

🤝 Let's work together

Open to collaboration: BI and analytics engineering roles, freelance warehouse and dashboard builds, and Power BI training for teams.

Email LinkedIn Website Data interview question bank Instagram

I work in Persian and English.

Popular repositories Loading

  1. Food-manufacturing-sop-planning-engine Food-manufacturing-sop-planning-engine Public

    S&OP planning engine for a 5-line industrial cake & confectionery food manufacturer: demand forecasting (Holt-Winters), capacity- and labor-constrained production planning (LP), MRP, and a simulate…

    Python 1

  2. Powerbi-analytics-online-market Powerbi-analytics-online-market Public

    A collection of Power BI projects showcasing dashboards, reports, and data visualizations. Each project includes PBIX files, sample data, and documentation. Explore practical examples of data model…

  3. Resource-planning-capacity-forecasting Resource-planning-capacity-forecasting Public

    Resource Planning & DC Capacity Forecasting engine: turns a sales forecast into a day-by-day, DC-by-DC staffing and delivery plan.

    Python

  4. User-analytics-data-pipeline User-analytics-data-pipeline Public

    Realtime User Analytics Pipeline: joins a CSV user-profile dimension with incremental JSON event streams into a warehouse + partitioned Parquet fact table (SQLite/SQL Server/Postgres, quality gate,…

    Python

  5. Malard-vaccination-analytics-forecasting Malard-vaccination-analytics-forecasting Public

    Malard VaxForecast: synthetic COVID-19 vaccination operations dataset (5 centers + 1 supply center, Khordad 1400-1401) with a SARIMA vs XGBoost demand-forecasting comparison, backtesting, and a 30-…

    Python

  6. Pharmapulse-supply-chain-intelligence Pharmapulse-supply-chain-intelligence Public

    End-to-end supply chain intelligence for pharmaceutical demand, inventory, supply risk, and working capital. Synthetic large-scale project featuring LightGBM quantile forecasting, ABC/XYZ segmentat…

    HTML