Gurpreet Dhami
Digital Finance Consulting – Advanced Data Analysis
Experience
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
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
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
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
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
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
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)
Digital Finance Consulting – Advanced Data Analysis
KPMG AG WPG
- Digital finance consulting with a focus on advanced data analysis
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
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
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
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).
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).
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
Education
Technical University of Munich
Master's in Management & Technology (TUM Business Administration) · Management & Technology · Munich, Germany
Technical University of Munich
Master's in Business Informatics · Business Informatics · Munich, Germany
Halmstad University
Erasmus+ exchange semester · Halmstad, Sweden
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
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Gurpreet based?
What languages does Gurpreet speak?
How many years of experience does Gurpreet have?
What roles would Gurpreet be best suited for?
What companies has Gurpreet worked for in recent years?
Which industries is Gurpreet most experienced in?
Which business areas is Gurpreet most experienced in?
What is Gurpreet's education?
Does Gurpreet have any certificates?
What is the availability of Gurpreet?
What is the rate of Gurpreet?
How to hire Gurpreet?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a
Nearby freelancers
Professionals working in or nearby Munich, Germany