Recommended expert
Gurpreet Dhami
Digital Finance Consulting – Advanced Data Analysis
Experience
May 2024 - Aug 2024
4 months Lorem ipsum dolor sit amet
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 Lorem ipsum dolor sit amet
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 Lorem ipsum dolor sit amet
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 Lorem ipsum dolor sit amet
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 Lorem ipsum dolor sit amet
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 Lorem ipsum dolor sit amet
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 Lorem ipsum dolor sit amet
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 monthsDigital Finance Consulting – Advanced Data Analysis
KPMG AG WPG
- Digital finance consulting with a focus on advanced data analysis
Mar 2018 - May 2018
3 months Lorem ipsum dolor sit amet
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 Lorem ipsum dolor sit amet
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 Lorem ipsum dolor sit amet
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 Lorem ipsum dolor sit amet
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)
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
NativeEnglish
AdvancedEducation
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
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
William Nguyen
Product Owner Frontend
View Profile
Philipp Grunert
Data Scientist & Data Engineer
View Profile
Marco Skulschus
Business Analyst, Data Warehouse Developer
View Profile
Felix Reimann
SAP Analytics & Planning Expert
View Profile
Yannick Reinke
Power Platform Developer
View Profile
Stefan Corsten
SSIS Development
View Profile
Jonathan Staude
AI Consultant
View Profile
Daryoosh Dehestani
Data Analyst & MLOps-Engineer
View Profile
Henok Abraham
Founder and Managing Director
View Profile
Martin Thomas
Interim Controller
View Profile
Ashkan Zadeh
Microsoft Azure Senior Data Engineer / Senior Data Scientist
View Profile
Karl Estermann
incl. CI/CD, automation
View Profile
Robert Wunsch
SAP Senior Consultant BI/BW
View Profile
Frank Schneiderlöchner
Principal Consultant
View Profile
Stephan Martin
Sabbatical, professional development
View Profile
Stefan Dangubic
BI Consultant in Controlling
View Profile
Germo Görtz
BI Developer
View Profile
Vitali Haberkorn
Power BI Expert
View Profile
Kerstin Burgen
Reporting and Analytics for HR
View Profile
Benedict Baur
Reporting Application for Equity Information
View Profile
Doris Nyffenegger
Expert Consultant
View Profile
Eduard Van kleef
Workshop Leader 'Introduction to AI Development Tools'
View Profile
Andreas Flegel
CRM Consultant, BI Expert, Project Manager, Coach
View Profile
Markus Groh
Data Solution Architect, Founder
View Profile
Eric Bouendeu
Quality Assurance Manager (QSV)
View Profile
Thomas Urban
Consultant
View Profile
Christian Dröge
Requirements Engineer
View Profile
Tim Safarowsky
Freelance Business Intelligence Consultant
View Profile
Willi Ziegenhagel
Data Analyst
View Profile
Thomas Reick
BI Consultant and Power BI Developer
View Profile
