Data & Analytics in Finance
Aktualisiert am 11.10.2024
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 11.10.2024
Verfügbar zu: 100%
davon vor Ort: 100%
SAP Analytics Cloud
SAP BW
SAP
QlikView
Tableau
MS Power BI
Finance Reporting
Analytics
German
Native
Hindi
Native
English
Fluent

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
nicht möglich

Projekte

Projekte

8 Monate
2024-05 - heute

Implementation of integrated planning solution in SAP Analytics

Senior Product Owner SAP Analytics Cloud
Senior Product Owner SAP Analytics Cloud
  • ? Implementation of integrated planning solution in SAP Analytics Cloud using S/4 HANA Public Cloud and Datasphere as source for following modules:
    • Cost Center Planning incl. tarif simulations
    • Headcount and demand planning
In-tech GmbH
Munich
11 Monate
2024-02 - heute

Road to SAC

Project Lead
Project Lead
  • Pilot project at Promos to create SAC standard content in real estate industry and upskill Promos for SAC reporting and planning
    • Design of standard SAC content (functional / technical) for real estate and finance to deploy to real estate customers
    • Design of SAC governance (authorization concept and naming convention)
    • Implementation of advanced functionalities in SAC using Javascript, data actions and complex calculation
Promos consult GmbH
Berlin
2 Jahre
2023-01 - heute

various Projects

Senior Manager Reporting & Systems
Senior Manager Reporting & Systems
  • Proof of Concept: SAC for Reporting and Planning to decommission CCH Tagetik and QlikSense
    • Planning model in SAC to replicate CCH Tagetik business consolidation logic incl. data writeback to SAP BW on HANA 7.5
    • Live Reporting on SAP BW on HANA 7.5 to replicate QlikSense Dashboards
  • Project: Implementation of Management Summary Report in Qlik
    • Data Engineering in SAP BW on HANA 7.5
    • Visualization and complex calculations in Qlik
    • Replication of BW section access in Qlik via BW load
  • Project: Qlik Sense Rollout in local entity in Mendrisio (Switzerland) including system setup, consultancy for BI architecture and user training
    • Data Engineering in Qlik as no SAP BW available
    • Data Load from different source systems (SAP ERP, DOP, Access, Excel) using Qlik as warehousing and consolidation tool
  • Several Projects: implementation of several Qlik Dashboards for Finance, Controlling and Production
    • Discussion of optimal BW architecture with external developers
    • Implementation of Qlik Dashboards using advanced ETL and formulas
    • Handover of Dashboards to business unit
Heraeus Holding Group
Hanau, DE, Mendrisio, CH
5 Monate
2023-10 - 2024-02

Proof of concept for the implementation of SAC

SAC / Business Intelligence Manager
SAC / Business Intelligence Manager
  • Proof of concept for the implementation of SAC as the standard planning and reporting tool at Walter AG
    • Comparison of SAC, SAP BPC, SAP IBP, Power BI with focus on: technical factors, business factors, reporting/ planning/ analytics functionalities, user experience & vendor quality
    • Prototyping of native SAC planning to shift from SAP IP solution
Walter AG
Tübingen
1 Jahr 3 Monate
2021-10 - 2022-12

Development of a planning application

Digital Expert for Controlling and Finance
Digital Expert for Controlling and Finance
  • Merck wide pilot project: Successful implementation of integrated Lifescience CapEx planning solution in SAP Analytics Cloud
    • Development of a planning application for CapEx including copy data actions, data actions for plan data restatement, data actions for complex calculations
    • Development of an analytical application for master data collection and update in SAC
    • Definition and usage of formulas/key figures on different levels in SAC (model and story)
    • Analysis and comparison of different planning scenarios (BPC live connection vs native planning in SAC)
    • Optimizing BW queries for SAC consumption for live and import connections.
    • Data writeback to source systems via OData interface and OpenAPI (ABAP and python script)
    • Usage of SAP Dataspehere as transformation and consolidation system 
  • Interaction with both technical & non-technical audiences across the organization to collect planning requirements, steer development and showcase solution
  • Business Analytics in CapEx Controlling including data modelling with Python, R and SQL
Merck KGaA
Darmstadt
1 Jahr
2020-10 - 2021-09

Controlling & Finance projects

Business Intelligence Manager
Business Intelligence Manager
  • Project: Successful Implementation of Global Sales Controlling Solution in BW and SAC for daily sales reporting.
    • Development of BW application for daily sales reporting including frontend development of BW queries in Eclipse / HANA Studio, ABAP code review
    • Design and development of SAC dashboards for live reporting of sales data including R widgets
  • Project: Successful Implementation of Corporate Sales Forecasting Solution for monthly sales forecasting
    • Development of forecasting algorithm in python/R to extrapolate sales volume based on current sales
    • Data consolidation in SAP Datasphere
    • Design and development of dashboards in Power BI to visualize results
  • Definition of functional requirements for reporting, planning and MEC and design of management dashboards/storylines
Fresenius Kabi AG
Bad Homburg
2 Jahre 5 Monate
2018-05 - 2020-09

Product Division Controlling

  • Project: Development of a new controlling concept as part of the restructuring of the "Aircraft Engineering Services" business unit
    • Business partner for discussion with IT to customize SAP FI/CO
  • Development and automation of controlling tools with focus on front-end reporting using Excel-VBA, SAP-BW-BI and Access-(VBA)
    • Development of BW queries for aircraft maintenance in BEX analyzer
    • Development of Oracle data base for aircraft maintenance
    • Harmonize SAP and non-SAP data with Power Query and create report for aircraft maintenance with Power BI
  • Project: Reintegration of Lufthansa Technik to Lufthansa Group
  • Budget planning for the Product Division and support in improving the budget process (cost center planning, cost unit planning, consolidation)
  • Project: Cut costs and create value by Business Excellence
  • Execution of period-end closings (monthly, quarterly and annual financial statements)
Lufthansa Technik AG
Frankfurt am Main

Aus- und Weiterbildung

Aus- und Weiterbildung

Technische Universität Darmstadt
M.Sc Industrial Engineering (focus finance and mechanical engineering) - Final Grade: 1,12

California State University Fullerton, USA
Semester abroad (Economics, Finance, Numerical Mathematics) - Final Grade: 1,0

Technische Universität Darmstadt
B.Sc. Industrial Engineering (focus finance and mechanical engineering) - Final Grade: 1,58

Freiherr-vom-Stein-Schule, Gymnasium Frankfurt am Main - A-Levels (Abitur): 1,0


Certifications

11/2018

Scholar of Studienstiftung des Deutschen Volkes for outstanding academic performance

Kompetenzen

Kompetenzen

Top-Skills

SAP Analytics Cloud SAP BW SAP QlikView Tableau MS Power BI Finance Reporting Analytics

Produkte / Standards / Erfahrungen / Methoden

SAP Analytics Cloud (Planning and Reporting)
SAP Datasphere
SAP BW on HANA
SAP R/3 (FI, CO, SD, MM)
Reporting: Microsoft Power BI, QlikSense
Microsoft Office ? Word, PowerPoint, Excel, Access

Programmiersprachen

VBA
SQL
M
DAX
R
Python
JavaScript

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
nicht möglich

Projekte

Projekte

8 Monate
2024-05 - heute

Implementation of integrated planning solution in SAP Analytics

Senior Product Owner SAP Analytics Cloud
Senior Product Owner SAP Analytics Cloud
  • ? Implementation of integrated planning solution in SAP Analytics Cloud using S/4 HANA Public Cloud and Datasphere as source for following modules:
    • Cost Center Planning incl. tarif simulations
    • Headcount and demand planning
In-tech GmbH
Munich
11 Monate
2024-02 - heute

Road to SAC

Project Lead
Project Lead
  • Pilot project at Promos to create SAC standard content in real estate industry and upskill Promos for SAC reporting and planning
    • Design of standard SAC content (functional / technical) for real estate and finance to deploy to real estate customers
    • Design of SAC governance (authorization concept and naming convention)
    • Implementation of advanced functionalities in SAC using Javascript, data actions and complex calculation
Promos consult GmbH
Berlin
2 Jahre
2023-01 - heute

various Projects

Senior Manager Reporting & Systems
Senior Manager Reporting & Systems
  • Proof of Concept: SAC for Reporting and Planning to decommission CCH Tagetik and QlikSense
    • Planning model in SAC to replicate CCH Tagetik business consolidation logic incl. data writeback to SAP BW on HANA 7.5
    • Live Reporting on SAP BW on HANA 7.5 to replicate QlikSense Dashboards
  • Project: Implementation of Management Summary Report in Qlik
    • Data Engineering in SAP BW on HANA 7.5
    • Visualization and complex calculations in Qlik
    • Replication of BW section access in Qlik via BW load
  • Project: Qlik Sense Rollout in local entity in Mendrisio (Switzerland) including system setup, consultancy for BI architecture and user training
    • Data Engineering in Qlik as no SAP BW available
    • Data Load from different source systems (SAP ERP, DOP, Access, Excel) using Qlik as warehousing and consolidation tool
  • Several Projects: implementation of several Qlik Dashboards for Finance, Controlling and Production
    • Discussion of optimal BW architecture with external developers
    • Implementation of Qlik Dashboards using advanced ETL and formulas
    • Handover of Dashboards to business unit
Heraeus Holding Group
Hanau, DE, Mendrisio, CH
5 Monate
2023-10 - 2024-02

Proof of concept for the implementation of SAC

SAC / Business Intelligence Manager
SAC / Business Intelligence Manager
  • Proof of concept for the implementation of SAC as the standard planning and reporting tool at Walter AG
    • Comparison of SAC, SAP BPC, SAP IBP, Power BI with focus on: technical factors, business factors, reporting/ planning/ analytics functionalities, user experience & vendor quality
    • Prototyping of native SAC planning to shift from SAP IP solution
Walter AG
Tübingen
1 Jahr 3 Monate
2021-10 - 2022-12

Development of a planning application

Digital Expert for Controlling and Finance
Digital Expert for Controlling and Finance
  • Merck wide pilot project: Successful implementation of integrated Lifescience CapEx planning solution in SAP Analytics Cloud
    • Development of a planning application for CapEx including copy data actions, data actions for plan data restatement, data actions for complex calculations
    • Development of an analytical application for master data collection and update in SAC
    • Definition and usage of formulas/key figures on different levels in SAC (model and story)
    • Analysis and comparison of different planning scenarios (BPC live connection vs native planning in SAC)
    • Optimizing BW queries for SAC consumption for live and import connections.
    • Data writeback to source systems via OData interface and OpenAPI (ABAP and python script)
    • Usage of SAP Dataspehere as transformation and consolidation system 
  • Interaction with both technical & non-technical audiences across the organization to collect planning requirements, steer development and showcase solution
  • Business Analytics in CapEx Controlling including data modelling with Python, R and SQL
Merck KGaA
Darmstadt
1 Jahr
2020-10 - 2021-09

Controlling & Finance projects

Business Intelligence Manager
Business Intelligence Manager
  • Project: Successful Implementation of Global Sales Controlling Solution in BW and SAC for daily sales reporting.
    • Development of BW application for daily sales reporting including frontend development of BW queries in Eclipse / HANA Studio, ABAP code review
    • Design and development of SAC dashboards for live reporting of sales data including R widgets
  • Project: Successful Implementation of Corporate Sales Forecasting Solution for monthly sales forecasting
    • Development of forecasting algorithm in python/R to extrapolate sales volume based on current sales
    • Data consolidation in SAP Datasphere
    • Design and development of dashboards in Power BI to visualize results
  • Definition of functional requirements for reporting, planning and MEC and design of management dashboards/storylines
Fresenius Kabi AG
Bad Homburg
2 Jahre 5 Monate
2018-05 - 2020-09

Product Division Controlling

  • Project: Development of a new controlling concept as part of the restructuring of the "Aircraft Engineering Services" business unit
    • Business partner for discussion with IT to customize SAP FI/CO
  • Development and automation of controlling tools with focus on front-end reporting using Excel-VBA, SAP-BW-BI and Access-(VBA)
    • Development of BW queries for aircraft maintenance in BEX analyzer
    • Development of Oracle data base for aircraft maintenance
    • Harmonize SAP and non-SAP data with Power Query and create report for aircraft maintenance with Power BI
  • Project: Reintegration of Lufthansa Technik to Lufthansa Group
  • Budget planning for the Product Division and support in improving the budget process (cost center planning, cost unit planning, consolidation)
  • Project: Cut costs and create value by Business Excellence
  • Execution of period-end closings (monthly, quarterly and annual financial statements)
Lufthansa Technik AG
Frankfurt am Main

Aus- und Weiterbildung

Aus- und Weiterbildung

Technische Universität Darmstadt
M.Sc Industrial Engineering (focus finance and mechanical engineering) - Final Grade: 1,12

California State University Fullerton, USA
Semester abroad (Economics, Finance, Numerical Mathematics) - Final Grade: 1,0

Technische Universität Darmstadt
B.Sc. Industrial Engineering (focus finance and mechanical engineering) - Final Grade: 1,58

Freiherr-vom-Stein-Schule, Gymnasium Frankfurt am Main - A-Levels (Abitur): 1,0


Certifications

11/2018

Scholar of Studienstiftung des Deutschen Volkes for outstanding academic performance

Kompetenzen

Kompetenzen

Top-Skills

SAP Analytics Cloud SAP BW SAP QlikView Tableau MS Power BI Finance Reporting Analytics

Produkte / Standards / Erfahrungen / Methoden

SAP Analytics Cloud (Planning and Reporting)
SAP Datasphere
SAP BW on HANA
SAP R/3 (FI, CO, SD, MM)
Reporting: Microsoft Power BI, QlikSense
Microsoft Office ? Word, PowerPoint, Excel, Access

Programmiersprachen

VBA
SQL
M
DAX
R
Python
JavaScript

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.