Summary
Business & data analyst with 4+ years of experience turning business needs into actionable insights, defining and tracking organizational KPIs, and designing dashboards and decision-support reports for executives. Direct experience partnering with sales, marketing, and production teams across telecom, pharma, manufacturing, and tech to identify improvement opportunities and deliver data-driven solutions. Proficient in Power BI, SQL, DAX, and Python, with hands-on experience designing data architecture (warehouse/ETL) at a scale of 500M+ records.
Work Experience
BI Engineer
Apr 2026 – Present (5 mos)Independent — Multiple Clients, Tehran
- Analyzed business requirements, identified improvement opportunities, and delivered data-driven insights.
- Developed and optimized ETL pipelines to integrate, clean, and manage data from multiple sources.
- Designed management and operational dashboards in Power BI; defined and tracked KPIs and built analytical reports with DAX and Power Query.
- Optimized SQL queries and analytical models to speed up reporting and improve BI system performance.
BI Engineer
Aug 2025 – Mar 2026 (7 mos)Asiatech Data Transfer Company, Tehran
- Partnered with business stakeholders to analyze requirements and deliver scalable, data-driven solutions.
- Designed and implemented ETL pipelines to transfer and integrate large-scale data from multiple sources.
- Designed and built a data warehouse supporting 500M+ records for enterprise reporting and analysis.
- Designed and developed interactive BI dashboards and reports to support data-driven decision-making.
- Designed OLAP models and implemented advanced calculations and metrics to extract analytical insights.
BI Analyst & Systems Analyst
Feb 2024 – Apr 2025 (1 yr 2 mos)Samaneh-haye Modiriat (Management Systems Co.), Tehran
Contributed to BI and CRM deployment/development projects for MAPNA, Saba Battery, Digikala, Hamrah-e-Aval, Mavara-ye Fonoun, Iran Sheet Metal Industries, Kimia Speedy, and Steel Arvin, including:
- Analyzed and advised on business-process improvements (sales, marketing, production) for clients.
- Optimized data-warehouse structure and built/improved ETL processes using SSIS.
- Designed and developed OLAP (Tabular) models using SSAS.
- Designed and implemented analytical reports and management dashboards using Power BI.
- Designed data models and authored RDL forms; analyzed and tested software systems and APIs.
- Deployed a CRM information system and aligned interactive layers for clients.
- Implemented and developed required processes in Microsoft Dynamics.
- Designed and developed a customer portal with an optimized UI for users, customers, and representatives.
Data Analyst
Jun 2023 – Dec 2023 (6 mos)Namnik Co. (Kik Ashna), Karaj
- Analyzed production data and forecast demand to improve production-line capacity planning and support operational decisions.
- Designed and developed Power BI analytical dashboards; processed data with DAX and Power Query (M).
- Designed and built a data warehouse and ETL process using SSIS.
Data Analyst
May 2021 – Jun 2022 (1 yr 1 mo)Malard Health Network, Malard
- Analyzed data and developed daily vaccine-demand forecasting models using machine-learning algorithms and time-series models.
- Optimized resource allocation and vaccinator scheduling at vaccination centers to increase efficiency and productivity.
Courses & Certifications
Business Intelligence — Eng. Imanpour, Tose'e Institute
150 hrs · 2023
Certificate
Statistics in Data Science — Dr. Ayvazian, Tose'e Institute
75 hrs · 2023
Certificate
Microsoft Dynamics CRM (Basic & Advanced) — Management Systems Co.
46 hrs · 2024
Certificate
Data Engineering — Dr. Mohammad Fozouni, Asiatech
85 hrs · 2025
Certificate
Machine Learning — Dr. Sharifi-Zarchi, Sharif University
48 hrs · 2024
No certificate
Additional Skills
- Hands-on with SSIS, SSRS, and SSAS for data processing and analysis
- Proficient in DAX and M for data processing and analysis in Power BI
- Able to design and present analytical reports and management dashboards; UML modeling
- Familiar with the BPMN modeling standard; business-process analysis and optimization
- Implemented required processes in Microsoft Dynamics; built RDL forms with complex SQL queries
- Familiar with machine-learning models and libraries; hands-on with Pandas, NumPy, and Matplotlib in Python
- Familiar with KPIs and organizational-unit processes
- Systems thinking, team spirit; A/B test design and analysis
- Familiar with Power Platform (Power Apps, Power Automate, Power BI)
- Able to translate analytical findings into clear narratives for non-technical teams
- Root-cause analysis and identifying behavioral patterns in operational data
- Defining success metrics and measuring the impact of analytical projects
Notable Projects & Academic Experience
Master's Thesis (2026): Designing a sustainable EV battery supply chain under uncertainty using a data-mining approach.
BI Engineer | Independent Project — Eltiam Distribution & Kharazmi Pharmaceuticals (May–Aug 2025, 3 mos): Developed a BI system for Kharazmi Pharmaceutical Co. and Eltiam Distribution, including data extraction from 15 drug-distribution company APIs using C# in SSIS, data-warehouse design, SSAS Tabular models with DAX, and management dashboards in Power BI.
Personal Website (2024): Designed and launched MiladShabani.ir
Selected GitHub Projects
All 17 projects, with full code and sample data, at github.com/Milad-Shabani
PharmaPulse: Pharma Supply Chain Intelligence: LightGBM quantile forecasting for 42 SKUs across 14 distribution centres, ABC/XYZ segmentation, reorder points and safety stock, supplier risk and the cash conversion cycle. (live dashboard)
Steel Sales CRM Intelligence: A Dynamics 365 export taken through 71 data-quality checks into a star schema: campaign payback, lost-deal reasons, margin per ton and BPMN 2.0 lead-to-cash processes, with a win model that scores the open pipeline better than the CRM's own probabilities. (live dashboard)
Supermarket Marketplace Intelligence: 780K rows of sales and Dynamics 365-style CRM data, LightGBM quantile forecasting that treats the sale calendar as a feature, and a churn model on an RFM panel with a time-based split. (live dashboard)
Retail Banking Analytics: Customer segmentation, churn and credit-risk models, a 12-month forecast, scenario planning and marketing-budget optimisation. (live dashboard)
COVID-19 Vaccination Demand Forecasting: SARIMA against XGBoost across five vaccination centres, evaluated two ways: over a 45-day horizon SARIMA stays usable while XGBoost diverges. (live dashboard)
Battery Plant CRM + S&OP Engine: The CRM pipeline folded into the demand forecast, capacity across four lines solved as a linear program with machine and labour limits, and MRP exploded through the bill of materials. (live dashboard)
Iran Population and Labour Market: A bilingual data story about a statistical illusion: unemployment fell from 12.4% to 7.5% while participation dropped 2.6 points. (live dashboard)
Delivery Marketplace: Growth or Profit?: Per-city P&L, cohort analysis, a 12-month forecast validated on rolling origins (12–14% WAPE) and a constrained reallocation of the promotion budget. (live dashboard)
Teaching & Volunteer Activities
Teaching Assistant — Inventory Control
Bu-Ali Sina University, Hamedan · 2022
Member, Iranian Red Crescent Society
Malard County · since 2016