SAP BW/4HANA Experts in Germany

• 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.

Scope: Embedded as FP&A Data & AI Architect within the Finance function of a major European refrigeration manufacturer, leading the transformation of manual, fragmented financial reporting into an automated, governance-driven intelligence platform. Driving the shift from Excel-based controlling to structured data architecture, Power BI analytics, and AI-assisted financial operations.

Financial Data Integrity & ERP Governance

• Initiated and led GL vs. subledger reconciliation investigations, identifying and resolving structural mismatches between General Ledger and subledger data that had gone undetected prior to engagement
• Conducted asset analysis to identify items missing from General Ledger postings, surfacing gaps in fixed asset tracking and period-end completeness
• Validated SAP reports, establishing baseline data quality standards for Finance team consumption
• Established systematic SAP data validation framework ensuring ongoing integrity between ERP postings and downstream reporting outputs

Finance Reporting Transformation

• Designed and implemented a structured Transformation Project approach for converting manual Finance reports into fully automated processes
• Created and owns the Data Reporting Audit Log; a centralized tracking system capturing report owners, stakeholders, data sources, manual effort estimates, and automation opportunity scores across the Finance function
• Mapped the full reporting landscape identifying quick-win automation targets and strategic Power BI migration candidates
• Actively reducing manual Excel and PowerPoint dependency across FP&A workflows; replacing point-in-time snapshots with live, governed data models

Power BI & Analytics Enablement

• Introduced and presented Power BI as the strategic reporting platform to Finance leadership, building internal buy-in for the BI transformation roadmap
• Designed initial Power BI architecture aligned with SAP, Salesforce and Oracle data structures and FP&A reporting requirements
• Established report ownership, governance documentation, and data lineage standards enabling sustainable self-service analytics across the Finance team

Transformation Infrastructure & Collaboration

• Configured and deployed Jira as the transformation project management hub, establishing structured sprint workflows, backlog management, and progress visibility for Finance IT initiatives
• Proposed and initiated a dedicated FP&A Communication & Transformation Hub, a structured cross-functional forum aligning Finance, IT, and business stakeholders around the reporting transformation roadmap
• Positioned the Finance function as an active driver of data governance and digital transformation within the broader organization

Outcomes

• GL/subledger reconciliation gaps identified and investigation framework established within first two weeks of engagement
• Data Reporting Audit Log deployed; first structured inventory of Finance reporting landscape in company history
• Power BI transformation roadmap presented and approved by Finance leadership
• Jira-based project governance live; Finance transformation now tracked with full sprint visibility

Technologies: SAP FI/CO · Power BI · DAX · SQL · Excel (advanced) · Power Query (M) · Power Automate · VBA · Jira · Microsoft 365 · SharePoint · Salesforce (Sales Data) · Oracle HCM · Python

Migration of data models to SAP BW/4HANA and development

• Coordination of the migration from BW 7.5 to BW/4HANA
• Coordination of optimization measures
• Coordination of the implementation of work packages
• Requirements analysis with stakeholders

Technologies used: SAP BW/4HANA, ABAP ADT, BW Modeling Tools, ABAP, SAP FI/CO, SAP SD

• Collected, analysed, and interpreted HR data from multiple systems
• Conducted ad-hoc people data analyses for stakeholders
• Supported Employee Listening and ensured actionable survey insights
• Built intuitive dashboards and visualizations in SuccessFactors, PowerBI, and Qualtrics
• Produced regular reports and dashboards on key HR metrics
• Contributed to people analytics projects as a junior team member
• Collaborated with HR Tech and Data teams to improve data quality
• Ensured ethical and governed data use with Legal, Data Privacy, Labour Relations and Works Council

• The customer is undergoing a comprehensive transformation. All SAP ECC landscapes worldwide are being migrated to SAP S/4HANA, with the goal of introducing a standard template worldwide.

• The program also includes the “RISE with SAP” migration and modernization program, which may involve migrating the landscapes of selected country installations to the SAP Private Cloud.

• On the stakeholder side, the program reporting line extends to the company’s executive board and that of the implementation partner.

• Fiserv Germany’s ERP landscape currently includes several non-standard SAP tools and applications that extend the functionality of the ECC environment and can often be integrated into downstream systems. As part of the transition to SAP S/4HANA, it is essential to assess the core functionality, integration points and future viability of these applications in order to determine their alignment with the target architecture.

• The focus of the work is on providing expert advice and assessment to define the scope, strategy and roadmap for transitioning Fiserv Germany’s SAP ECC system to SAP S/4HANA.

• The recommended best practices from SAP are followed and a structured approach is used to ensure a smooth transition with minimal disruption while maximizing business value.

• This assessment forms the basis for a successful SAP S/4HANA transformation and ensures alignment with industry best practices, regulatory compliance and future scalability.

• Migration Strategy Definition – assessment of available transition approaches based on business objectives, technical feasibility and SAP Best Practices.

• Technical Readiness Assessment – conducting a system analysis to assess compatibility, custom code impact, data volume management, integration points and infrastructure readiness for SAP S/4HANA.

• Business Process Impact Analysis – reviewing the latest business process documentation to define the scope and effort required to implement the necessary functions in SAP S/4HANA and to identify opportunities for process optimization.

• Roadmap for Non-SAP Systems and Applications – assessment of third-party and legacy applications regarding their integration with SAP S/4HANA and recommendation of consolidation, migration or replacement strategies.

• Deployment & Implementation Planning – defining a phased approach for implementation, including project schedules, risk mitigation strategies and key milestones aligned with business priorities.

• This transformation takes place in phases: the Discovery phase leads to the Explore phase, which is followed by the Design phase and finally implementation.

• Program management

• Change management

• Requirements management

• Transition management

• Stakeholder management

• Risk management

• Comprehensive coordination

• 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.

• Led the design, implementation, and optimisation of SAP Analytics Cloud (SAC) dashboards, stories, and reports for business users.
• Worked closely with business stakeholders to gather and analyse reporting requirements, translating them into technical designs.
• Integrated SAC with SAP BW/4HANA, SAP S/4HANA, SAP HANA Views, and external data sources.
• Developed SAC Planning models and supported planning processes, including input forms, allocations, forecasts, and simulations.
• Configured live and import connections to SAP and non-SAP data sources.
• Conducted performance tuning, security setup, and ensured data accuracy in SAC environments.
• Provided training, documentation, and best practices for SAC adoption across the organization.
• Led incident management, change requests, and enhancements in SAC landscapes.

• 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)

• New IT strategy and organizational model combined with the introduction of IT service management and SAP S/4 preliminary study
• Significant cost optimization in the areas of operating, license and outsourcing costs
• Implementation of an IT security strategy according to ISO 27001 and NIS-2

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

• Implementation and mapping of regulatory requirements (CSRD, ESRS) in Shiny dashboards and backend functions
• Design and development of data-driven modules in Shiny incl. ESG metrics and reporting templates
• Integration of data sources (SQL, SAP HANA, APIs, CSV/Excel) via DBI, odbc, httr and readr
• Creation of interactive visualizations with plotly, highcharter and DT (DataTables)

• 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.