SAP Analysis for Microsoft Office Expert

• Implementation of data models in BW/4HANA, ABAP CDS Views, HANA Calculation Views, AMDP Scripts, OData Services, object-oriented ABAP in BW, SAC.
• Adjustments in BPC for BW/4HANA.

• Management Reporting
• Analysis of COGS and close cooperation with Accounting
• Variance analysis vs Plan/Forecast
• Development of sales controlling
• Business partnering for the CSO area

• Interim SAP BW Senior Consultant

• Analysis and optimization of the analysis authorization concept

• Analysis of the existing SAP BW authorization concept, particularly the mechanisms for assigning analysis authorizations to various organizational units.

• Development of an enhanced concept to standardize authorization management.

• Prototypical implementation of a solution for multidimensional authorization linking without additional CompositeProviders.

• Use of dynamic control via Customer Exits in combination with an authorization ADSO, in which permitted combinations can be centrally maintained.

• Application of the Cartesian product concept for precise modeling and authorization of permitted combinations from multiple analysis authorization dimensions, enabling flexible and consistent access control.

• The new structure simplifies the management of complex authorizations, reduces redundancies, and makes extensions easier.

• It was initially implemented as a prototype to create a well-founded basis for decisions regarding further strategic direction.

• After successful validation and positive evaluation by the project team, the solution was further developed productively as part of a User Story and rolled out across the entire SAP BW system.

• Virtual key figures & OLAP calculations

• Capital Lock Up Ratio (CLR%)

• Development and implementation of complex virtual key figures using BAdI RSROA_OLAP_BADI, including:

• Net Service Revenue – 3 Month: Dynamic calculation of three-month totals across all periods of the selected year.

• Capital Lock Up Ratio %: Key figure for measuring capital tied up, calculated as the ratio of NSR to the cumulative NSR three-month total from P1 to the current drilldown period; used to analyze how much capital is tied up in the company before it is converted into revenue – essential for liquidity management.

• Implementation of a mechanism for simultaneously passing two FISCPER intervals:

• One interval for displaying the period.

• One interval for restricting the data.

• Objective: Implementation of a moving average based on a dynamic drilldown period to determine capital tied up accurately for each period.

• Account hierarchy-based key figure management

• Development of dynamic key figure assignment based on account hierarchy nodes as an enhancement of the existing key figure management solution.

• Implementation of BAdI RSROA_OLAP_BADI combined with an easy-to-maintain Customizing table in which the rules for key figure assignment can be defined flexibly.

• Runtime-based mapping of approx. 135 key figures according to the individually maintained rules, without manual system changes.

• Replacement of an earlier AMDP-based SQL logic in which every change to a node or key figure required a code adjustment, clearing the ADSO, and a time-consuming reload (approx. 2 hours).

• The new solution enables ad hoc adjustments via SM30 maintenance – without a new transport, without data reloading, and with significantly reduced system load.

• Significant reduction in maintenance and development effort.

• Avoidance of long loading times and complex AMDP adjustments.

• Increased flexibility in managing key figure assignments, effective immediately without system changes.

• Improved performance and flexibility when analyzing reports.

• Significant reduction in maintenance effort through dynamic control and modularization.

• Contribution to the strategic development of the reporting and authorization system in the SAP BW environment.

• Development of a generic ABAP framework for integrating SAP Analytics Cloud (SAC) Export APIs into SAP BW/4HANA

• Design and implementation of a reusable handler and service class architecture for the automated transfer of data from SAC into BW ADSO structures.

• Automated push reporting with dynamic query integration (SAP BW/4HANA)

• Design and implementation of an ABAP-based push reporting framework for automatic email notifications based on BW query results.

• Development of a central ABAP class for generating the HTML email body, including embedded MIME images (KPI screenshot, logo, etc.) and dynamic recipient management.

• Remote hierarchy & access concept for user-specific WBS structures (Deloitte, 2025/2026)

• Design and implementation of a virtual SAP BW/4HANA hierarchy for user-specific control of WBS elements in complex engagement structures. The objective was to eliminate redundant leaf nodes and ensure that each user sees only their own area of responsibility – both in the F4 value help and within analytical queries.

• For this purpose, I developed a fully dynamic hierarchy generator based on an ADSO that determines the relevant subtrees at runtime and makes them available to the system without physical hierarchy loading. The solution eliminated duplicate structure paths, drastically reduced the data volume per user, and enabled secure, high-performance navigation without visibility of other users’ project data.

• I also analyzed system-side limitations of the SAP standard F4 hierarchy resolution and, based on this, developed an alternative input and proposal concept for users with global views (“ALL”), fulfilling both security and performance requirements.

Technological focus: BW/4HANA, virtual/remote hierarchies, ADSO design, ABAP-based runtime generation, complex F4 logic, access concepts, performance optimization of large hierarchy structures.

• Greenfield implementation of S/4HANA Embedded Analytics as well as reporting and planning processes with SAP Analytics Cloud (SAC).
• Integrated production, sales, and inventory planning, as well as financial planning and management reporting.
• Inventory forecasts implemented through SAC Machine Learning.
• Integration of S/4HANA data and HR data (Factorial) into SAP Datasphere (various tables with real-time replication, related data flows, and analytical models)

• Controlling reporting/planning application
• Supporting the department in defining change requests
• Testing and accepting developments

• Led a transformation program in Corporate Finance & Procurement across 25+ countries
• End-to-end implementation of SAP S/4HANA and Coupa for 60 regional companies
• Integration following company acquisitions, including financial reporting, HR systems and governance
• Managed cross-functional teams, change management and stakeholder engagement
• Post-merger integration in close coordination with the works council for the introduction of IT systems and GDPR topics

• Development of ABAP CDS Views in S/4

• Consumption via oData service by reporting tools like Power BI

• Project Argo: SAP BW/4 Hana Project Lead, Program and Application Manager, SAP BW/4 Hana Consultant, Architect, and Developer.
• Migration of FI data models from SAP BW 7.x to BW/4 Hana.
• Revision and implementation of the user and authorization concept.
• SAP S/4 Hana, SAP Basis, SAP BW/4 Hana data modeling and use of the SAP BW Migration Workbench.
• Use of Business Content, BAPI, BW/4 Hana, Hana Studio, HANA Views, Analytical Views, virtual tables, and Hana Native SQL.
• Working with ADSO, Open ODS Views, Composite Provider, Hybrid Provider, SAP Solution Manager, Query Designer, Analysis for Office, Lumira, and Fiori.
• Use of SAP SAC (Stories, Data Models, Data Analyzer, CDS Views) as well as application management and monitoring of process chains and load jobs.

• Spearheaded the development of BW Bridge and Datasphere models, integrating S/4HANA, BW/4HANA, and BDC to enable real-time analytics in SAP Analytics Cloud (SAC).
• Designed and implemented Calculation Views using SAP HANA Modeler, aligning with LEONI's requirement for expertise in BW/4HANA modeling and Eclipse.
• Authored comprehensive technical documentation and RICEFW objects, ensuring clarity and alignment with business requirements.
• Conducted training sessions for internal teams on Datasphere and BW Bridge, fostering knowledge transfer and self-sufficiency.

• Further development of BW applications for First Data GmbH
• Migration of 3.x data sources to 7.x
• Adaptation/redesign of existing ABAP coding to ABAP-OO
• Creation of new data flows in BW 7.5
• Support of daily operations
• Operation and monitoring of BW applications
• Authorizations
• Deletion concept for business partners in BW
• Data archiving concept
• Development of program for automatic creation of SD orders
• ABAP, ABAP-OO, BAPI
• SAP BW 7.x
• SAP ERP

• Design, operation, and stabilization of the BW/4HANA and HANA reporting landscape; data modeling, ODP extraction, process chains, and production troubleshooting in a regulated corporate environment.

• Conduct as-is process analysis
• Provide industry benchmark
• Optimize planning and reporting procedures (e.g. with application of VBA macros)
• Revise R&D hourly rate calculation
• Provide operational support in monthly closing
• Perform year end audit and annual budget