Recommended expert

Gurpreet Dhami

Digital Finance Consulting – Advanced Data Analysis

Gurpreet Dhami
Munich, Germany

Experience

May 2024 - Aug 2024
4 months

Anonym – German building materials manufacturer

  • Creation of the profit center report and statistical key figures report
  • Gathering and analyzing requirements regarding the forecast for revenue and costs
  • Implementation of various time series analyses and optimization of predictions
  • SAP process knowledge, SQL, Python
  • Python with various libraries for time series analysis and machine learning
Jan 2024 - Jan 2025
1 year 1 month

Anonym – Leading European defense contractor

  • Consulting, performance optimization, and support for the IBCS-compliant creation and adaptation of various reports, including the cost center report, Quality Management report, and various reports in the areas of Finance, HR, and Sales
  • Gathering and analyzing requirements for cost center reporting
  • Creating and adapting ETL pipelines with Pentaho Data Integration software and SQL
  • IBCS-compliant visualization of the cost center report using Power BI and Zebra BI
  • Consulting on a more performant technical implementation of incremental and rolling updates of very large and wide fact tables to optimize daily data refresh of SSAS Tabular models on SQL Server Analysis Services
  • Consulting and support for the adaptation of various other reports
  • Knowledge of SAP ERP, controlling, SQL, VertiPaq, and tabular model development with DAX
  • MS Power BI Report Server, MS SQL Server Analysis Services, Oracle 19c database and Pentaho Data Integration, Tabular Editor 3, DAX Studio, Zebra BI, PowerShell, Jenkins
Jan 2024 - Jan 2025
1 year 1 month

Anonym – Large German laboratory service provider

  • Consulting and support for replacing manual, Excel/PowerPoint-based profit center reporting with an automated IBCS-compliant Power BI reporting system, including connection to on-premises SAP BW/4HANA systems and other data sources
  • Gathering and analyzing requirements for profit center reporting
  • Creating and adapting ETL pipelines with SAP BW/4HANA and SQL
  • MS Power BI, Tabular Editor 3, DAX Studio
Jan 2023 - Apr 2023
4 months

Anonym – Leading European energy utility company

  • Implementation of Microsoft Power Automate (Process Advisor) as a process mining solution and development of a comprehensive operational Power BI report to analyze SAP PM (EAM) and MM processes of two business units
  • Consulting on technical requirements for secure integration of the new solution into the existing Azure Cloud IT infrastructure (firewall rules, Azure Storage Accounts, access management, Power BI REST API connection via service principal)
  • Gathering and analyzing requirements for the SAP Plant Maintenance / Enterprise Asset Maintenance and Materials Management process under analysis
  • Coordinating data engineering to extract relevant tables and attributes from SAP development, test, and production systems
  • Implementing the ETL process in Microsoft Azure Databricks using SQL and Python/PySpark
  • Modeling/visualizing the target process as a BPMN 2.0 model
  • Creating views/visualizations with the necessary filter configurations
  • Business analysis and presentation of findings to business units
  • SAP process knowledge, process mining, Power Query M, tabular model development with DAX
  • MS Process Advisor/Minit Client, MS Azure Databricks, MS Power BI, Tabular Editor 3, DAX Studio, Azure Cloud services, QPR Enterprise Architect, Camunda Modeler
Jan 2023 - Apr 2023
4 months

Anonym – Leading European industrial gases corporation

  • Development of a Power BI report including ETL with Power Query M for SAP authorization management (RBAC concept)
  • Gathering and analyzing requirements
  • Creating dashboard mockups and validating them with future users
  • Identifying relevant data from existing exports
  • Modeling data as star/galaxy schema
  • Implementing the ETL process and Power BI report
  • Validating the report
  • Tabular model development with DAX, SQL, Power Query M
  • MS Power BI, Tabular Editor 3, DAX Studio, Google Sheets
Jan 2022 - Jul 2022
7 months

Anonymous – a leading European insurance company

  • Revised an existing Power BI reporting system
  • Simplified and optimized existing Power BI dashboards
  • Enabled true self-service BI for business users (drag and drop without technical skills)
  • Reduced load times to a maximum of 3 seconds
  • Improved compliance and data quality by eliminating manual imports
  • Optimized data transfer costs between Power BI Cloud and on-premises infrastructure
  • Data analysis, software and data engineering, SQL, Power Query M, DAX, C#
  • Power Platform (Power BI, Power Apps), Denodo, Snowflake, Power BI Helper, Tabular Editor, DAX Studio, ALM Toolkit, Excel, C# .NET 6.0 console app
Jan 2022 - Jul 2022
7 months

Anonymous – a global leader in electronics

  • Developed a Power BI report including ETL with MS SQL Server for the SAP AR process (accounts receivable)
  • Requirements gathering and analysis
  • Business-IT communication between stakeholders from various departments and subsidiaries
  • Created dashboard mockups and validated them with future users
  • Identified relevant data from the SAP ERP system
  • Modeled data as star/galaxy schema
  • Built the ETL process with T-SQL on MS SQL Server 2017
  • Created the Power BI report and optimized joins for resource-efficient report table generation
  • Developed tabular models with DAX, SQL/T-SQL, Power Query M
  • MS Power BI, Tabular Editor 3, DAX Studio, MS Visual Studio 2019, MS SQL Server Analysis Services (SSAS)
Jun 2018 - Aug 2019
1 year 3 months

Digital Finance Consulting – Advanced Data Analysis

KPMG AG WPG

  • Digital finance consulting with a focus on advanced data analysis
Mar 2018 - May 2018
3 months

KPMG AG WPG

  • Developed a prototype for performance management in the company for a webinar "Data-driven predictive planning in pharmaceutical companies"
  • Researched and developed use cases for the planning process
  • Evaluated the data analytics features of the BOARD software
  • Created a data model and screens for demonstration
  • Collected and integrated data using ETL tools (Power Query, Alteryx)
  • Trained machine learning models and implemented a time series analysis
  • Conducted research on forecasting out-of-stock situations and optimization potentials for perishable goods
  • Technically implemented big data machine learning pipelines with Apache Spark
  • Performed testing activities and provided technical consulting for the BOARD 10 CPM tool
  • Assisted with account management for a strategic corporate steering system at a German commercial bank
Nov 2016 - Aug 2017
10 months

KPMG AG WPG

  • Supported quality assurance of SAP migration projects for a leading Bavarian automotive client (migration concepts, test procedures, data migration verification, customizing)
  • Worked in account management
  • Prepared and conducted onboarding workshops for interns and student assistants
  • Assisted with IT audits for various clients (review and analysis of IT system settings and processes)
  • Performed software acceptance testing of the SAP audit software Ispicio_S
Oct 2014 - Feb 2016
1 year 5 months

Capgemini GmbH

  • Worked on a software engineering project for a network and service resource management system at a German telecom provider
  • Developed a multithreaded Java tool to validate data models and import large CSV files into an Oracle 10g database
  • Developed show cases for the Digital Customer Experience Innovation Lab using open source platforms
Oct 2014 - Feb 2016
1 year 5 months

KPMG AG WPG

  • Analyzed and optimized the year-end audit (bachelor’s thesis): market analysis of available automation solutions, function analysis, technical implementation concepts
  • Implemented a data cleansing solution in Java to increase audit efficiency
  • Conducted market research on GDPR/EU-GDPR software solutions
  • Developed an Excel-VBA solution to consolidate timesheets
  • Participated in IT audits (review and analysis of IT system settings and processes)

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Professional Services (3.5 years), Telecommunication (1.5 years), Manufacturing (1 year), Aerospace and Defense (1 year), Healthcare (1 year), and Automotive (1 year).

Professional Services
Telecommunication
Manufacturing
Aerospace and Defense
Healthcare
Automotive

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (4 years), Business Intelligence (3 years), Finance (2 years), Audit (2 years), Quality Assurance (1 year), and Operations (0.5 years).

Information Technology
Business Intelligence
Finance
Audit
Quality Assurance
Operations

Skills

  • Data Modeling / Visualization
  • Data Modeling / Etl / Performance Optimization
  • Process Mining
  • Ibcs-compliant Visualization Of Financial Data
  • Power Bi Performance Optimization
  • Programming / Automation
  • Visualization
  • Corporate Performance Planning Software
  • Job Automation
  • Forecasting
  • Planning And Visualization Of Processes & Architecture
  • Data Modeling / Etl
  • Operational Processes And Data Model Semantics
  • Microsoft Power Bi
  • Ms Power Bi Report Server (Self-hosted)
  • Sql
  • Zebra Bi Ibcs Visuals
  • Microsoft Fabric / Azure Databricks / Apache Spark
  • Microsoft Process Advisor
  • Ms Sql Server, Oracle 19c, Postgres
  • Dax (Data Analysis Expressions), Ms Power Query M
  • Ms Sql Server Analysis Services (Ssas) Tabular
  • Tabular Editor 3, Dax Studio, Ms Vertipaq
  • Pentaho Data Integration
  • Microsoft Power Platform / Power Apps
  • Snowflake, Databricks, Denodo
  • Board
  • Python, Java, C#, Powershell
  • Jenkins Ci, Gitlab Ci
  • Machine Learning
  • Camunda Bpmn Modeler, Qpr Enterprise Architect
  • Snowflake, Denodo, Alteryx
  • Sap R/3, Sap S/4hana, Sap Business Bydesign
  • Sap Analytics Cloud
  • Sap Bw/4hana

Languages

German
Native
English
Advanced

Education

Apr 2018 - Sep 2022

Technical University of Munich

Master's in Management & Technology (TUM Business Administration) · Management & Technology · Munich, Germany

Apr 2017 - Dec 2017

Technical University of Munich

Master's in Business Informatics · Business Informatics · Munich, Germany

Jan 2016 - May 2016

Halmstad University

Erasmus+ exchange semester · Halmstad, Sweden

...and 1 more

Certifications & licenses

SAP Analytics Cloud (SAC) – Analysis, Planning, and Integration

TH Brandenburg, SAP AG

SAP BW/4HANA – Data Flow and BusinessObjects Reporting

TH Brandenburg, SAP AG

SAP BW/4HANA – Data Modeling and BusinessObjects Lumira

TH Brandenburg, SAP AG

Business Process Integration with SAP S/4HANA 2020

TH Brandenburg, SAP AG

Leadership Through Motivation Compact Course Badge

FdM Training, TU Munich

Project Management Course (according to Project Management Institute)

Munich University of Applied Sciences

Profile

Created
Last Update
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Gurpreet based?

Gurpreet is based in Munich, Germany and can operate in on-site, hybrid, and remote work models.

What languages does Gurpreet speak?

Gurpreet speaks the following languages: German (Native), English (Advanced).

How many years of experience does Gurpreet have?

Gurpreet has at least 5 years of experience. During this time, Gurpreet has worked in at least 1 role and for 9 different companies. The average length of individual experience is 5 months. Note that Gurpreet may not have shared all experience and actually has more experience.

What roles would Gurpreet be best suited for?

Based on recent experience, Gurpreet would be well-suited for roles such as: Digital Finance Consulting – Advanced Data Analysis.

What companies has Gurpreet worked for in recent years?

In recent years, Gurpreet has worked for Anonym – German building materials manufacturer, Anonym – Leading European defense contractor, Anonym – Large German laboratory service provider, Anonym – Leading European energy utility company, and Anonym – Leading European industrial gases corporation.

Which industries is Gurpreet most experienced in?

Gurpreet is most experienced in industries like Professional Services, Telecommunication, and Manufacturing. Gurpreet also has some experience in Aerospace and Defense, Healthcare, and Automotive.

Which business areas is Gurpreet most experienced in?

Gurpreet is most experienced in business areas like Information Technology (IT), Business Intelligence, and Audit. Gurpreet also has some experience in Finance, Quality Assurance (QA), and Operations.

What is Gurpreet's education?

Gurpreet holds a Master in Management & Technology from Technical University of Munich, a Master in Business Informatics from Technical University of Munich and a Bachelor in Business Informatics from Munich University of Applied Sciences.

Does Gurpreet have any certificates?

Gurpreet has 6 certificates. Among them, these include: SAP Analytics Cloud (SAC) – Analysis, Planning, and Integration, SAP BW/4HANA – Data Flow and BusinessObjects Reporting, and SAP BW/4HANA – Data Modeling and BusinessObjects Lumira.

What is the availability of Gurpreet?

Gurpreet is immediately available part-time for suitable projects.

What is the rate of Gurpreet?

Gurpreet's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Gurpreet?

To hire Gurpreet, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1200
900
600
300
Market avg: 940-1100 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.