SAP Analytics Cloud Experts in Germany

• Independent consulting at the intersection of HR, Finance and IT
• Focus on People Analytics, HR Controlling, Pay Transparency, Compensation & Benefits and HR Transformation
• Analysis of complex HR and business data and development of reliable decision-making foundations for management and HR
• Design of KPI, reporting and BI solutions as well as data-based management models
• Consulting from analysis and concept development through implementation of transformation and optimization projects
• Focus on SAP Analytics Cloud, SAP BW and Power BI
• ISA = Insight · Structure · Alignment

• Designed and implemented enhancements in SAP BW on HANA 7.5 in the context of CRM migration and S/4HANA and BW/4HANA transformation programs
• Migrated SAPI data sources to the ODP framework as part of the S/4HANA migration
• Delivered SAP ECC data to Snowflake using BW data models and Calculation Views for Power BI analytics
• Integrated SAP and non-SAP data sources (including MS Dynamics)
• Improved reporting transparency through consolidated data models
• Optimized data loading processes for FI-CO data sources, significantly improving load times and system performance

• 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

• Led enterprise reporting modernization by migrating legacy SSRS reporting solutions to Power BI, supporting 500+ business users while ensuring full GDPR/DSGVO compliance.
• Designed and optimized Power BI and Microsoft Fabric semantic models using star schema, dimensional modeling, advanced DAX, and performance optimization techniques, reducing query latency by 25%.
• Delivered 20+ executive and operational dashboards featuring KPI scorecards, drill-through, bookmarks, and row-level security, improving reporting efficiency by 20%.
• Enabled self-service analytics through governed Power BI datasets, dataflows, and gateway architecture, increasing business-led reporting adoption by 35%.
• Configured an incremental refresh policy and query folding for a 50+ million row sales dataset, reducing daily report refresh times by 85%.
• Deployed automated ETL/ELT pipelines using Azure Data Factory, Microsoft Fabric, and Snowflake, reducing reporting delivery timelines by 40% through workflow automation.
• Spearheaded Microsoft Fabric analytics modernization initiatives including lakehouse architecture, OneLake integration, and centralized data platform development, reducing data latency from 2 hours to 20 minutes.
• Translated business requirements from 15+ stakeholders into scalable Power BI semantic models and dashboards, improving reporting consistency and reducing ad-hoc reporting requests by 25%.
• Applied Microsoft Copilot and generative AI tools to accelerate SQL development, DAX authoring, technical documentation, and testing activities, reducing development effort by approximately 15 hours per week.

Development and Implementation

• Conceptualization and implementation of the various requirements.
• Experience and ability to collaborate with other delivery teams
• Lead a team of 15 people taking care of matters including monitoring operations, delegating tasks and managing budgets.
• Act as product owner and represent the product vision, strategy and priorities in the area of production operations.
• Work closely with the members of the area including developers, analysts and QA to ensure the successful delivery of logistics features and improvements.
• Lead the process design and lead the build team for the SAP implementation (EU countries) and post-merger integration in SAP PP, QM, MM, APO and SD modules.
• Implemented and optimized MRP Live (MD01N) for multiple plants, improving planning runtime
• Worked with business users to transition from classic MRP to MRP Live
• Implemented SAP QM module, including quality planning and inspection lot processing, resulting in a 20% improvement in product quality compliance.
• Developed and tested custom reports using SAP Query and ABAP for MES data analytics, improving visibility into yield rates and resource utilization.
• Translate production requirements into clear and actionable user stories, acceptance criteria and technical specifications.
• Skilled in discrete, and process/manufacturing (PP-PI) environments; deep understanding of master data, production & process orders, recipe management, batch management, capacity & scheduling, shop floor control, and integration with QM, MM, EWM, MES.
• Worked in Variant configuration (VC)
• Supported international rollouts and transformation projects for SAP PP, QM, PPDS, aATP, EWM, and Variant Configuration within a global strategy.
• Tested functionalities for various business scenarios include interface systems
• Involved in SIT and UAT and cutover activities

Technology: Project Management, SAP PP, QM, MM, APO, ABAP OO, HANA Modelling, FIORI, SAP UI5, AMDP, SAP SD, SAP FICO and S4 HANA Emedded analytics

• Reorganizing and structuring business units in line with agile frameworks
• Scaling agile ways of working across multiple teams and departments
• Advising and supporting teams in forming squads and introducing new meeting structures
• Introducing agile portfolio management to align strategic initiatives
• Implementing metrics and KPIs to measure agile maturity and success
• Assisting in integrating agile methods into existing company processes

• Providing expertise in management consulting to support the improvement of frontier AI models for a leading AI lab

• Designed and developed interactive SAP Analytics Cloud (SAC) dashboards and reports for Finance, Supply Chain, Logistics, Procurement, HR, and Manufacturing, covering KPIs such as Profit & Loss, Balance Sheet, Fixed Costs, Headcount, Personnel Expenses, Stock Analysis, OTIF, Production Volume, BOM, Spend, and Compliance to Schedule.
• Built and optimized end-to-end ABAP CDS data models (Basic, Composite, and Consumption Views) using the VDM approach, integrating data from key SAP S/4HANA tables. Strong expertise in ABAP CDS, SQL, SAP data modeling,
• Collaborated with cross-functional teams to define KPI logic, standardized user story templates, resolved BI requests through JIRA, improved reporting performance, and delivered scalable, secure, and business-focused analytics solutions that enhanced decision-making and operational efficiency.
• Trained business stakeholders across various countries on SAP Analytics Cloud (SAC) dashboard usage and developed comprehensive training manuals to promote user adoption and enable self-service analytics.

IT infrastructure / SAP Grantor / SAP-BTP transformation project in the public sector for the digitalization of government funding programs. The goal was a clean-core-oriented SAP-BTP solution architecture with CAP/RAP services, APIs, integrations and operational readiness for Run, AMO and AMS structures.

• Industry: Public
• Budget 2026 5 Mio EUR
• Budget planned for 2027 8,7 Mio EUR
• Team size 45 FTE

• 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

AI Assistance and Target Vision for Partially Autonomous Energy Portfolio Management

Building an AI control layer directly on the up-to-date daily live portfolio of a large energy provider — not as an isolated pilot, but as an operational extension of the existing DB1 and portfolio management. The goal is the gradual development from assistance through monitoring/alerting to analysis agents with Human-in-the-Loop approvals, supplemented by a role-specific System of Engagement alongside the BI System of Record. At the same time, the business case, target vision and management pitch compared with static monthly reporting are being developed.

• AI control layer: Design and build on the existing live portfolio data product (several million contracts) — development stages assistance → monitoring/alerting → agents with Human-in-the-Loop approvals.
• LLM-supported data analysis: Semantic queries, SQL/tool integration and additional RAG components based on portfolio, plan-versus-actual and data quality data (Azure OpenAI, Snowflake), with drill-downs to individual contract level.
• Analysis agents: Multi-stage agents for variance and driver analyses of churn, price adjustments, volumes and procurement costs.
• Views concept: Role-specific interfaces for business units, management and C-level as a System of Engagement alongside the BI System of Record.
• Business case & pitch: Target vision and cost-benefit argumentation compared with static monthly reporting.
• LLM setup (privacy & security): Coordination with IT Security and Data Protection — EU region, data separation and approval processes.
• Agent architecture: Multi-stage agent pipelines (analysis → validation → summary) with documented data sources, tool calls, review steps and source references for each statement.
• Data foundation: Built on the up-to-date daily DB1 data product (Snowflake, dbt) — portfolio, plan-versus-actual and data quality metrics as the common basis for all AI analyses.
• Guardrails & evaluation: Evaluation and approval processes for LLM responses relating to management-relevant statements — test sets, metrics and human review.
• Prototyping & validation: Iterative validation of agent responses with the business unit — test question catalogue, feedback loops and response quality for each release.
• Roadmap & development stages: Detailed stages from assistance → monitoring/alerting → partially autonomous management, including transition criteria and governance for each stage.
• Integration: Integration into the existing BI and data landscape — BI remains the System of Record, while the AI layer provides interactive drill-down paths as the System of Engagement.
• Enablement: Enablement of business users — prompting guides, training and an operating model for ongoing use.
• Management: Coordination of business units, Data Engineering, IT Security and Data Protection.
• Change Management: Communication and expectation management with business units and management throughout the development stages.

Results:

• Built on an existing up-to-date daily data product with several million contracts
• Established an LLM setup coordinated with Data Protection and IT Security in the EU region, including data separation and approvals
• Defined three development stages through to partially autonomous management
• Designed role-specific views for business units, management and C-level
• Developed the business case and management pitch for the development stages
• Established an iterative response-quality validation process with the business unit
• Designed the operating model for assistance operations and initiated validation

Stack: Azure OpenAI, Azure AI Foundry, Snowflake, dbt, React, TypeScript, Entra ID, RAG, Agentic AI, analysis agents, Human-in-the-Loop, Prompt Engineering, LLM Evaluation, LLMOps, GDPR / EU region, Azure DevOps, Python, SQL, Change Management

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

• Responsibility for batch release as per EU guidelines by ensuring the requirements have been met.
• The batch and its manufacture comply with the provisions of the marketing authorisation (including the requirements for importation where relevant).
• Manufacture has been carried out in accordance with GMP.