
Mohammad Moradi
IT-Consultant
Data Engineering, Business Intelligence, Data analytics
​
I am an experienced freelance IT Senior Consultant (Microsoft Fabric , Power BI and Data Engineer) with over 25 years of expertise in Data Engineering, Business Intelligence, and Data Analytics. I offer my services as an independent IT consultant.
Throughout my career, I have been responsible for the design, development, deployment, and operation of Business Intelligence and data analytics solutions. I have worked with a broad range of modern technologies, including Microsoft Fabric, Azure SQL, MS SQL Server, Power BI, Azure Data Factory, Azure Analysis Services, Azure Synapse, Azure Databricks, Azure Blob Storage, Logic Apps, Azure Automation, Power Apps, Azure DevOps, QlikView, Informatica PowerCenter, SAP HANA, SAP BW, Azure IoT Hub, Event Hub, Eventstream, Eventhouse, and OpenAI, as well as Lakehouse architectures and data warehouse solutions.
I leverage these technologies to help organizations efficiently store, process, analyze, and visualize large-scale data.
My core competencies include:
​
BI Solutions and Data Analytics:
-
Managing the full lifecycle of BI and data analytics solutions, including requirements analysis, design, development, deployment, monitoring, and operations.
​
Data Architecture:
-
Design, development, and implementation of scalable data architectures using Azure services.
-
Integration of data from on-premises and cloud systems into Azure SQL Database, Azure Data Lake, Azure Synapse Analytics, Azure Databricks, Microsoft Fabric, and Power BI.
​
Microsoft Fabric:
-
Design, development, and implementation of Microsoft Fabric architectures with Lakehouse layers (Bronze, Silver, Gold), data warehouses, OneLake, shortcuts, and semantic models.
-
Development and deployment of notebooks, data warehouse tables, stored procedures, views, and Fabric data pipelines.
-
Migration of existing data and ETL processes from Azure Synapse to Fabric, conversion of semantic models from Import Mode to Direct Lake Mode, and reuse of existing Azure Databricks data in Microsoft Fabric.
​
Power BI:
-
Power BI expert with extensive experience in architecture, development, and administration.
-
Design and implementation of a modern Power BI architecture and the development of reports and apps.
-
Creation of tabular models with Row-Level Security (RLS) and Column-Level Security (CLS).
-
Integration of data from SAP HANA, SAP BW, Azure Databricks, Azure Synapse, REST APIs, and other sources into Power BI semantic models.
-
Creation of golden semantic models for reporting.
-
Administration of the Power BI platform via the Admin Portal and Admin API.
-
Development of semantic models and reports for managing premium capacity, including monitoring, capacity planning, and license management, with automated data provisioning via the Power BI REST API and storage in Azure SQL through Data Factory pipelines.
-
Efficient integration of SAP HANA and SAP BW data into Power BI reports, including data extraction from SAP backends via Azure Data Factory and storage in a central database or Lakehouse used by Power BI.
​
Database Development and Management:
-
Building and implementing Data Lakes, Lakehouses, Data Warehouses, and Data Marts.
-
Provisioning Azure SQL Databases, MS SQL Databases, Azure Analysis Services, and Azure Databricks catalogs and schemas.
-
Development of efficient T-SQL queries and the design and optimization of tables and views in Azure SQL, MS SQL, Azure Synapse, Azure Databricks, and Microsoft Fabric.
-
Ensuring database stability and performance through effective monitoring.
-
Implementation of Data Lakehouse zones (Landing, Bronze, Silver, Gold) and Microsoft Fabric Data Warehouse.
​
ETL, Data Ingestion, and Transformation:
-
Development and management of ETL processes using Azure Data Factory, data storage in Azure Data Lake, data preparation and training in Azure Databricks and Microsoft Fabric, as well as data modeling and provisioning of fact and dimension tables in Azure Synapse Analytics.
-
Efficient extraction of data from systems such as SAP BW, SAP HANA, LeanIX, Splunk, Monitis, CRM 360, ServiceNow, REST APIs, and others, with loading into Azure SQL Database, Lakehouse, and Azure Synapse Analytics.
​
Cloud Infrastructure and Automation:
-
Configuration and management of cloud infrastructure, resource monitoring, and cost optimization.
-
Planning and deployment of Azure resources, including Azure SQL Databases, Azure Data Factory, Azure DevOps, Azure Virtual Networks (VNETs), Private Endpoints, Azure VMs, and more.
​
Azure DevOps:
-
Setting up DevOps projects, creating repositories and branches.
-
Implementation of CI/CD pipelines for ADF pipelines, Azure SQL databases, Microsoft Fabric, and Power BI.
​
Security and Governance:
Implementation of security policies including encryption, data masking, and access control.
​
Real-Time Analytics:​
-
Real-time Analytics: Design and development of real-time analytics solutions based on Azure IoT Hub, Event Hub, Microsoft Fabric Event Stream and Eventhouse, including the secure and reliable transmission of IoT device data to the cloud.
​
Artificial Intelligence (AI):
-
Implementation of AI solutions using OpenAI LLMs and RAG.
-
OpenAI API integration, Natural Language to SQL (NLSQL).
-
Implementation of advanced AI solutions on Azure Databricks using LLMs and RAG.
-
Building AI chatbots with Voiceflow and Replit, as well as creating real-time avatar streams.
Professional experience
11/2012 – 01/2017
Consultant (Enterprise Solution, BI / ETL)
01/2012 – 10/2012
IT-Operations Manager eCommerce
04/2011 – 12/2011
IT Consultant (BI, CRM)
Bridging IT GmbH
Frankfurt a.M.
neckermann.de GmbH
Frankfurt a.M.
Altran GmbH & Co. KG
​Frankfurt a.M.
07/2006 – 01/2011
Business Improvement Consultant (BI / ETL / Reporting)
British Telecom BT(Germany) GmbH
BT Global Services
Echborn
07/2006 – 01/2011
Business Improvement Consultant (BI / ETL / Reporting)
Monster Worldwide Deutschland GmbH /Jobpilot GmbH
Bad Homburg
Monster Worldwide Deutschland GmbH /Jobpilot GmbH
Bad Homburg
03/2017 –
Freelance IT-Consultant
Freelance IT-Consultant
Bad Homburg
11/2012 – 01/2017
Consultant (Enterprise Solution, BI / ETL)
Bridging IT GmbH
Frankfurt a.M.
01/2012 – 10/2012
IT-Operations Manager eCommerce
Neckermann.de GmbH
Frankfurt a.M
​
04/2011 – 12/2011
IT Consultant (BI, CRM)
Altran GmbH & Co. KG
​Frankfurt a.M.
07/2006 – 01/2011
Business Improvement Consultant (BI / ETL / Reporting)
British Telecom BT(Germany) GmbH
BT Global Services
Echborn
04/2002 – 06/2006
Softwareentwickler und
Server Administrator
Monster Worldwide Deutschland GmbH
/Jobpilot GmbH
Bad Homburg
02/2001 – 08/2001
Consultant (Solution Developer for E-business)
Avanade Deutschland GmbH
Wiesbaden
​
Education
Master of Science in Information and Communication Technology
​
Diplom-Ingenieur Bewässerung
​
Certificates
Microsoft Certified: Azure Data Engineer Associate
Microsoft Certified: Fabric Analytics Engineer Associate
ITIL® V3 Foundation Certificate in IT Service Management
IBM WebSphere Application Server V6.1 Administration on Linux
Implemented Technologies

Microsoft Fabric, Azure Databricks
Data Ingestion (SAP HANA, SAP BW)
Azure Synapse
Data sources: SAP BW, SAP HANA, Splunk, Monitis, Service NOW, LeanIX, SharePoint, Microsfot CRM
Azure Event Hub,
Azure IoT Hub,
Eventhouse,
Azure Stream Analytics
Logic Apps, Power Apps
Informatica PowerCenter 9.x
Oracle 11gR2, 12c
QlikView Server Cluster, Publisher
SQL Server, Azure SQL, Azure AS
Power BI Service, XMLA
Azure DevOps
Data Dakehouses, Data Warehouses, Delta Lake, Azure Blob Storage
OpenAI API Integration, LLM, RAG
AI-Chatbots, Real time Avatar Streams
Microsoft Purview, Azure Monitor
Azure PowerShell & Azure Automation
Python, SQL, Parquet, XML, Json
Microsoft IIS, SharePoint
Business Intelligence
-
Requirements analysis, Design, Development, Rollout, Operation and Optimization of the Business Intelligence solutions based on MS SQL, Microsoft Power BI, Azure SQL, Azure Analysis Services, Azure Synapse analytics, Azure Data Factory, Azure Databricks, Azure automation, Microsoft Flow, Microsoft Logic Apps, Power Apps and Azure DevOps.
-
Full life cycle of Business Intelligence solutions, including prototyping, proof of concepts, design, interface implementation, testing and maintenance.
-
Power BI Architecture design , Development and Administration
-
Development of Tabular model and deploy the tabular model into the Power BI Premium capacity using Power BI XMLA endpoint
-
Implementation of RLS (Row Level Security) and CLS (CLS (Column Level Security) in Power BI
-
Power BI Administration (Managing Power BI Premium Capacities, Monitoring Usage, Data Privacy and Security, Audit and perform Capacity maintenance & ensure compliance with platform)
-
Power BI Performance troubleshooting and platform Testing and tuning, license tracking activities.
-
Collect information about workspaces, datasets, reports, dashboards, users, capacities, permissions, schema, refresh history, gateway, data source definition by using Power BI Activity Log, Power BI Rest API’s and Power BI Admin Rest API and storing the historical data in an Azure SQL DB for Auditing & Monitoring
-
Administration and support of the QlikView systems suite of products (QlikView Developer, QlikView Server, Publisher and QlikView Enterprise Management.
-
Installation, configuration and maintenance of the QlikView Server Cluster, Publisher, Web servers and QlikView Management
​​​​
Microsoft Fabric
-
Design, development, and implementation of a Microsoft Fabric architecture with Lakehouse layers (Bronze, Silver, Gold), Data Warehouse, OneLake, shortcuts, and semantic models.
-
Development and deployment of notebooks, data warehouse tables, stored procedures, views, and Fabric data pipelines.
-
Migration of existing data and ETL processes from Azure Synapse to Fabric, transitioning semantic models from Import Mode to Direct Lake Mode, and utilizing existing data from Azure Databricks in Microsoft Fabric.
-
Implementation of Virtual Network (VNet) integration, service endpoints or private endpoints, workspace identity, network configuration, and best practices to enforce network and identity standards in Fabric workspaces.
​
Real-time Analytics
-
Design and development of real-time analytics solutions based on Azure IoT Hub, Event Hub, Microsoft Fabric Event Stream, and Eventhouse, including the secure and reliable transmission of IoT device data to the cloud.
​
ETL & Data Warehouse​
-
Development and implementation of ETL workflows using Azure Data Factory, Informatica PowerCenter, and SSIS.
-
Integration and transfer of data from various source systems such as SAP BW, SAP HANA, Splunk, Monitis, ServiceNow, LeanIX, and SharePoint into Microsoft Fabric, Azure Data Lake, Azure Databricks, Azure SQL, and Azure Synapse (in a VNET) using Azure Data Factory pipelines, T-SQL, Spark SQL, and Azure Databricks notebooks.
-
​Cloud Data Warehousing.
-
Logical Data Warehouse with Azure Synapse Analytics Serverless SQL Pool
-
Enterprise data lake, Data Lakehouse, lake house zones (Landing, Bronze, Silver, Gold)
-
Daten migration from On perm to Azure data Lake, Azure SQL Database, Databricks and Azure Synapse analytic
-
Enterprise Job Scheduling und Workload Automation
Database Management​​
-
MS SQL / Azure SQL Datenbank Design and Development
-
Develop and deploy Tabels and views in Azure Synapse severless SQL pool, Azure Synapse dedicated SQL pool
-
Develop and deploy Tables and Views in Azure Databricks SQL
-
Operation, administration, troubleshooting, optimization of databases (Azure SQL, MS SQL)
-
Azure SQL Auto Scale UP/Down
-
Data Migration
-
Backup und Archivierung
-
Deployment
​
Azure Cloud
-
Planning, deployment and configuration of Azure Resource Groups and Resource:
-
Azure SQL databases, Azure Analysis Services databases
-
Azure Synapse analytics (Serverless SQL pool & Dedicated SQL pool)
-
Azure Storage, ​Data Lakehouse
-
Azure Databricks, Azure Data Factory pipelines
-
Azure Automation, Azure Monitoring, Key Vault, Azure DevOps
-
Microsoft Flow, Microsoft Azure Logic Apps, Power Apps
-
Azure Virtual Network (VNET)
​
Azure DevOps
-
Setup Azure DevOps project, create repo, branches
-
Azure DevOps Continuous Integration and Continuous Delivery (CI/CD) pipelines
-
Providing Infrastructure as code (IaC) using Azure DevOps
​
IT Service Management
-
IT Service Management. Supports in Incident/Problem-, Change- and Release-Management
-
Deployment Management
SERVICES
Mohammad Moradi
Freiberuflicher IT-Berater
​
Telefon: +49 (0) 151 149 43 528
E-Mail: mmoradi@bipilot.de
​
QlikView Server Cluster