Mohammad Moradi
IT-Consultant
Data Engineering, Business Intelligence, Data analytics
​
20+ years of experience in Data Engineering, business intelligence (BI) and Data Analytics.
Throughout my career, my role in projects has encompassed the design, development, deployment, and operation of Business Intelligence (BI) and Data Analytics solutions. I have leveraged technologies such as 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, Microsoft Fabric, QlikView, Informatica PowerCenter, SAP Hana, SAP BW, Lakehouse, and Data Warehouse to enable companies to efficiently store, process, analyze, and visualize large datasets.
My core competencies include:
-
Involved in the full life cycle of Business Intelligence solutions, including prototyping, proof of concepts, design, interface implementation, testing and maintenance.
-
Data modeling. MS SQL and Azure SQL Database design, Development and Deployment
-
Data Engineering, Cloud Data warehousing, Data Transformation with Azure Data Factory
-
ETL development with tools such as Azure Data Factory, Informatica PowerCenter, SSIS
-
Design, development, and implementation of ETL processes using Azure Data Factory, Azure Databricks Notebook, for efficient data extraction from various sources, including SAP BW, SAP HANA, CRM 360, Splunk, Monitis, ServiceNow, LeanIX, REST API, and more, as well as loading the extracted data into Azure SQL DB, lakehouse zones (Bronze, Silver, Gold), and Azure Synapse.
-
Planning, deployment and configuration of Azure Resource Groups, Azure SQL databases, Azure Analysis Services databases, Azure Synapse analytics, Azure Databricks, Azure Data Factory pipelines, Azure Virtual Network (VNET), Microsoft Flow, Azure Logic Apps, Power Apps, Azure Storage, Delta Lake, Azure Automation, Azure Monitoring, Key Vault, Azure DevOps
-
Design and development of Azure Logic Apps, MS Flows to schedule, automate, and orchestrate tasks and workflows
-
Migrating Data to Azure data Lake, Azure SQL Database, Databricks and Azure SQL Data warehouse/Azure Synapse analytic and controlling and granting database access
-
Power BI Architecture, Development and Administration.
-
Power BI Administration (Managing Power BI Premium Capacities, Monitoring Usage, Data Privacy and Security, Audit and perform Capacity maintenance & ensure compliance with platform).
-
Designed and deployed the tabular model into the Power BI Premium capacity using Power BI XMLA endpoint
-
Azure DevOps Continuous Integration und Continuous Delivery (CI/CD)
-
ITIL® V3 Foundation Certificate in IT Service Management
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 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.
​
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