Mohammad Pourbafrani

Full Stack Microsoft BI Developer | SQL Server | SSIS | SSAS | SSRS | Power BI

Summary

Full Stack Microsoft BI Developer with 9+ years of experience designing and delivering end-to-end BI solutions on the Microsoft stack, from source systems and ETL to data warehouses, semantic models, and reports. Built 50+ SSIS ETL packages, star-schema data warehouses, and SSAS Tabular models that handle tables of up to 1 billion records, plus 75+ Power BI and SSRS dashboards used by 270+ users. Strong background in SQL Server performance tuning and .NET/ASP.NET application development, with results including 3x faster queries, 50% faster ETL and 50% lower server load.

Experience

Aug 2023 – Present

Lead Business Intelligence Developer

IranHotelOnline · Travel & hospitality
  • Lead an end-to-end Microsoft BI platform (SQL Server, SSIS, SSAS, Power BI) serving 130+ users across 8 departments.
  • Developed 30 SSIS ETL packages and optimized pipelines, raising ETL efficiency by 50% on datasets of up to 200 million records and tripling dashboard refresh speed.
  • Redesigned SSAS Tabular models, cutting processing time by 50% on tables averaging 2 million records.
  • Delivered 40+ Power BI dashboards and standardized data quality checks, reducing data inconsistencies by 30%.
  • Full-time Aug 2023 – Mar 2025, part-time Apr 2025 – Sep 2026, full-time again since Oct 2026.
Apr 2025 – Oct 2026

Senior Business Intelligence Specialist

OMPFinex · Cryptocurrency exchange
  • Architected an enterprise Microsoft BI solution (SSIS, SQL Server, Power BI) consolidating cross-departmental pipelines into a centralized data warehouse for 150+ staff.
  • Built incremental SSIS ETL from a 500 GB MySQL source with hourly ingestion of 10,000+ rows, reliably loading tables of up to 1 billion records.
  • Designed star-schema data models and tuned SQL Server, improving query speed by 3x and cutting dashboard load times by 40%.
  • Delivered 20+ Power BI dashboards for finance, product, and customer operations, used daily by 100+ users.
Jul 2022 – Dec 2023

Business Intelligence Developer

Drkermany.com · Healthcare
  • Built 20 SSIS ETL packages migrating data from MySQL to a custom SQL Server data warehouse with tables of up to 80 million records.
  • Re-engineered reporting infrastructure, reducing server resource usage by 50% and improving system stability.
  • Delivered 15 Power BI dashboards for 40 users across 4 teams; analysis of marketing spend cut costs by 30%.
Jul 2021 – Nov 2022

Freelance BI & Software Developer

Self-employed · Freelance
  • Built a full stack asset management system for 5,000+ devices using ASP.NET, SQL Server, SSRS, and Power BI.
  • Delivered 10 dashboards tracking product metrics, financial KPIs, and user behavior across 5 business units.
  • Enabled a 30% gain in equipment allocation efficiency and a 20% reduction in maintenance costs.
Apr 2019 – Feb 2020

Freelance BI & Software Developer

Self-employed · Freelance
  • Developed an ASP.NET courier management application with real-time tracking, reducing manual errors by 40% and increasing efficiency by 30%.
  • Built a custom data warehouse with Power BI reporting, increasing data retrieval speed by 50%.
  • Created a KPI reporting system that reduced operational costs by 20% through optimized courier assignments and routing.
Apr 2018 – Oct 2019

.NET Developer & BI Specialist

Parham System
  • Developed a .NET remote water meter management application, automating data collection, reducing entry errors by 35% and increasing data accuracy by 25%.
  • Implemented SSRS dashboards for real-time monitoring of water usage and pressure, speeding decisions by 40%.
  • Optimized SQL Server queries and back-end processes, cutting response times by 30% for 50 concurrent users.
Apr 2016 – Nov 2017

.NET Developer & BI Specialist

SamerIT
  • Built a .NET hotel reservation system on SQL Server supporting 200 concurrent reservations and reducing manual workload by 40%.
  • Developed SSRS reports and dashboards for real-time monitoring, cutting report generation time by 30%.

Education

2008 – 2015

Bachelor of Science in Computer Science

Qom University

Certifications

2023

BI in Action

Nikamooz
2022

Power BI Dashboard Design

Nikamooz
2022

SSAS Tabular Modeling

Nikamooz
2022

Business Intelligence

Nikamooz
2022

SQL Server Querying

Nikamooz
2018

SQL Server Performance & Tuning

Nikamooz

Skills

Database & Data Warehouse
Microsoft SQL Server, T-SQL, Stored Procedures, Query Optimization, Indexing, Performance Tuning, MySQL, Data Warehousing, Star Schema, Dimensional Modeling
ETL & Integration
SSIS (SQL Server Integration Services), Incremental Loads, Data Pipelines, Data Migration, Data Quality & Consistency Checks, Data Governance
Analytics & Modeling
SSAS Tabular (SQL Server Analysis Services), DAX, Semantic Models, Model Processing Optimization
Reporting & Visualization
Power BI, Power Query, SSRS (SQL Server Reporting Services), Dashboard Design, KPI Reporting
Application Development
.NET Framework, ASP.NET, C#, Back-End Development, SQL Server-Backed Applications, Python
Professional
Solution Architecture, Requirements Gathering, Cross-Functional Collaboration, Project Management, Process Optimization
English
Upper-intermediate

Selected projects

Jul 2021 – Nov 2022

Asset management system

Self-employed · Freelance
  • Full stack system for managing 5,000+ devices.
  • ASP.NET · SQL Server · SSRS · Power BI
Apr 2019 – Feb 2020

Courier management application

Self-employed · Freelance
  • Web application for managing couriers and customers, with real-time tracking of rider locations.
  • SSRS statements for customers and couriers; a data warehouse and Power BI dashboard for performance analysis.
  • ASP.NET Framework · HTML · CSS · SQL Server · SSRS · Power BI
Apr 2018 – Oct 2019

Remote water meter management

Parham System
  • Software connecting to digital water meters over the internet, removing manual meter reading in remote areas.
  • Real-time consumption dashboards and a map-based dashboard for monitoring water pressure across pipelines.
  • .NET · SQL Server · SSRS
Apr 2016 – Nov 2017

Hotel reservation system

SamerIT
  • Analysis, database design, SSRS reporting and implementation of a reservation system supporting 200 concurrent reservations.
  • .NET · SQL Server · SSRS