OLAP Experts in Germany

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

• Building, implementing and selling automated Data Science solutions such as Scorecard Factory and Forecast Factory
• Implementation of automated end-to-end cloud processes
• Development of LLM and NLP models
• Creation of interactive reports
• Support for national and international large corporations as well as medium-sized companies in implementing ML projects

Engaged as an independent BI consultant for a FinTech SaaS platform, building and maintaining the end-to-end Microsoft Azure and Fabric analytics stack behind a multi-tenant accounting product used by business owners to track their own financial performance.

• Partnered with finance stakeholders to translate complex accounting workflows into real-time BI dashboards (P&L, Cash Flow, Balance Sheet), helping 2000+ business owners track cash flow and overall financial health effortlessly.
• Developed 10+ interactive dashboards, giving each business owner personalized, real-time visibility into their own sales performance, accounts receivable aging, and operational costs.
• Enforced strict enterprise data governance by implementing dynamic Row-Level Security (RLS) via DAX to isolate each business owner's data within the shared multi-tenant model.
• Maintained and extended an Azure ELT pipeline (Azure Data Factory, Azure SQL Database, Azure Synapse) that automated data ingestion and transformation.
• Contributed to a team-wide platform migration from Azure to Microsoft Fabric to optimize capacity licensing costs.
• Designed and implemented a Microsoft Fabric ELT pipeline (Lakehouse, Pipelines, PySpark) that automated data ingestion and transformation, replacing the prior Azure pipeline.
• Modeled cleansed data into a Star Schema within the data warehouse using T-SQL, powering the Power BI Semantic Model.
• Leveraged AI tools, including Copilot and Claude, as development partners across the entire ELT pipeline, from data ingestion to KPI reporting and visualization.
• Supported agile delivery processes, using Jira to track development tasks and Confluence to maintain technical and project documentation.

• Consulting on complex IT, accounting, controlling, and business intelligence projects from the analysis phase through implementation to go-live support
• Work as consultant, project manager, and subproject manager
• Focus on business process analysis and implementation
• Controlling: sales, marketing, project, financial, and cost controlling
• Accounting: General Ledger, Accounts Receivable, Accounts Payable, asset accounting
• Implementation and training of SAP R/3 FI/CO
• Operational experience in controlling, sales, human resources, and commercial project management before my consulting work

• Led the migration of the existing DWH, including HR data, application processes, project business and time tracking, from an MS SQL Server environment to Azure Databricks
• Refactored existing data models and ETL processes and extended them with new objects and functionalities
• Used Azure Databricks (Unity Catalog, Notebooks, Spark SQL, Databricks Dataflows) and Power BI
• Technologies: MS SQL Server 2019 (SSMS, SSIS), Power BI, Delta Lake, Azure Databricks

• Led design, development, and deployment of data solutions supporting a major pharma acquisition for Takeda Pharmaceutical Company, delivering transparency reporting systems across Azure,Databricks (Python and Shell Scripting) platforms.
• Owned,Designed and developed scalable ELT pipelines to process Customer and Product data using Azure, complex SQL, Databricks, and shell scripting, enabling efficient data integration and processing across multiple sources including job orchestration and workflow automation.
• Implemented performance optimization techniques (query tuning, parallelism, workload optimization), improving system efficiency and processing time.
• Applied strong analytical and problem-solving skills to assess technical solutions and support business requirements for compliance and transparency reporting.
• Designed scalable data foundations suitable for downstream analytics and AI workloads.
• Led data quality initiatives by assessing multiple source data, defining quality metrics, and establishing processes for monitoring and continuous improvement.

• Interim Head of Controlling at a medium-sized industrial group in mechanical engineering: setup of group controlling, preparation for the planned IPO, realignment of monthly reporting
• Project at a medium-sized company in the steel and mechanical engineering industry: further development of cost and performance accounting; setup of a structured overhead cost sheet to determine hourly and overhead allocation rates for pre- and post-calculation; setup of a profit center accounting system to show the P&L by business unit
• Interim CFO at a startup in optics / photonics: preparation of financial and liquidity plans to prepare for financing rounds and funding projects; contact person for investors in due diligence processes; setup of monthly reporting for internal and external stakeholders; preparation of annual financial statements together with an external tax advisory firm (inventory valuation, provisions, etc.); contact person for project sponsors in funded development projects; optimization and digitalization of business processes in finance
• Interim Head of Finance at a startup in robotics: introduction of business processes; support during financing rounds
• Project at a medium-sized mechanical engineering company: introduction of cost and performance accounting

• Energy Management (2023-08-01 – today):

• Designing a planning solution to increase energy efficiency

• Creating a concept for an energy management system

• Planning a component for action planning to gradually reduce energy consumption

• Evaluating planned measures based on opportunities, risks, and effectiveness for inclusion in the planning process

• Designing requirements for a data model to compare planned and actual data in the dashboard

• Consulting (2023-05-01 – today):

• Extending the accantec PerCon authorization management system to IBM Planning Analytics

• Analyzing authorization requirements and comparing them with IBM Cognos Analytics and Tableau

• Extending accantec PerCon with IBM Planning Analytics via REST API

• Printing (2023-04-01 – today):

• Supporting the introduction of a data warehouse solution with IBM Cognos Analytics 11

• Supporting the introduction of a reporting system based on a standard data warehouse

• Supporting report developers and developing custom controls to optimize the user interface

• Healthcare (2020-08-01 – 2023-03-31):

• Optimizing, extending, and operating a historically grown BI planning environment

• Updating the Jedox solution from version 2019.1 to 2022.2

• Optimizing ETL processes and reports, and implementing automated ETL processes

• Connecting different accounting and administration systems

• Writing completed plans back to source systems and implementing complex allocation logic

• Building and maintaining dimensions and hierarchies (corporate structure, P&L)

• Developing planning scenarios for FP&A and creating reports to monitor the budget

• Designing and implementing new OLAP cubes and reporting

• Providing user training according to customer requirements

• Industrial Sector (2020-04-01 – 2020-12-31):

• Migrating and optimizing an existing Jedox solution

• Combining the reporting system and planning system in Jedox

• Building a central group reporting system with plan-versus-actual comparisons for FP&A

• Optimizing KPI calculations and existing reports, and creating new reports

• Creating forecast reports, managing authorizations, and providing user training in an international environment

• Finance (2020-05-01 – 2023-03-31):

• Further developing and operating an existing Jedox solution

• Designing and developing new OLAP cubes for controlling

• Building hierarchies in dimensions (e.g. P&L) and updating the Jedox system in a Linux environment

• Providing user training on report creation

• Trade Fair (2020-06-01 – 2023-03-31):

• Designing and developing a BI planning solution in Jedox with a data warehouse structure

• Creating ETL processes to load dimensions and OLAP cubes

• Building reports and plan-entry forms, and implementing business logic (P&L, allocation logic)

• Implementing planning and analysis reports as well as a security concept in Jedox

• Industrial Sector (2021-03-01 – 2023-03-31):

• Migrating and optimizing an existing Jedox solution

• Updating the Jedox solution and migrating ETL processes from Pentaho Kettle to Jedox Integrator

• Optimizing SQL queries, analyzing the system, eliminating redundancies, and developing new ETL processes

• Analyzing and adapting existing reports

• Staffing Services (2022-07-01 – 2022-10-31):

• Migrating a Jedox solution from version 5 to 2022.2

• Updating the system, adjusting configurations, and analyzing performance issues

• Optimizing the OLAP database by streamlining dimensions and removing unused cubes/data

• Finance (2021-10-01 – 2022-02-28):

• Creating OLAP cubes in Microsoft SSAS

• Building dimensions and hierarchies and calculating KPIs with MDX

• Supporting users with Power BI requests

• Establishing the Microsoft Fabric platform with the company as the central data warehouse and reporting system.
• The company migrated several operational systems including D365 to new version. The new data warehouse is based on a Fabric/Power BI architecture with Azure cloud Entra Authentication.

Tasks Performed:

• Full administrative responsibility for the Fabric platform F64 and F32 capacities, as well as two F8 capacities for development and prototyping.
• Integration of Fabric with Microsoft Entra.
• Data modeling for the data warehouse bronze, silver and gold layers using data modeling tools.
• Star Schema as well as entity relationship modeling.
• Data modeling for data marts and for dimensional modeling and Power BI (semantic model).
• Design of data models for Microsoft SSAS multidimensional and tabular OLAP cubes using DAX and MDX.
• Definition of design patterns for the ETL team for loading OLAP cubes (Tabular and MD), star schemas and data vault structures.
• Planning and managing team of 4 ETL and reporting developers.
• Performance Tuning of Power BI reports, particularly the semantic layer, as well as the Fabric notebooks
• SQL Performance Tuning.
• DB Design for Azure SQL.
• Reporting directly to project senior management.

Label: Power BI, Fabric, Analysis Services (multidimensional and tabular), D365, SSIS, Tabular Editor, SQL Server and Azure SQL, TOAD Data Modeler, DBSchema, Visual Studio Code, DAX Studio, SSMS, Visual Studio, Jira and Confluence.

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

• While running FP&A processes, initiated and implemented changes therein, improving depth, speed, and accuracy: performance analysis; monthly reporting to the shareholders; forecasting/estimating; annual planning/budgeting
• Quantified and formulated a strategic plan for the Group
• Provided insights leading to operational and strategic decisions
• Ensured timely progress in strategic projects
• Corporate Finance
• Data Analytics
• Presentation/Pitching
• Stakeholder Management
• Strategic Planning / Budgeting

• Responsibility for group-wide financial management with a focus on management, PE, and lender reporting.
• Focus on an integrated financial model (P&L, balance sheet, cash flow), robust liquidity and covenant management, and preparation of decision-ready materials for financiers, auditors, and rating stakeholders.
• Establishment of reporting standards, data logic, and closing routines for high-frequency scalability.
• Further development of an integrated financial model (P&L/BS/CF), including scenario capabilities, sensitivities, and driver-based forecasting logic.
• Design and management of a rolling liquidity plan (short-/mid-term), including working capital mechanisms and financing instruments.
• Preparation and quality assurance of lender reporting, including covenant calculations, bridge analyses, and variance explanations.
• Support for the CFO agenda in financier and stakeholder communication (Q&A, documentation logic, key messages, data consistency).
• Coordination and content input for rating- and financing-related deliverables (e.g., presentations, data rooms, management commentary).
• Management of IFRS/accounting topics (e.g., IFRS 16 lease logic, accrual and reconciliation concepts) to ensure reporting and audit readiness.
• Standardization of reporting structures, templates, and KPI definitions across entities to increase transparency, comparability, and speed.

• Testing the SekIDP and related components
• Test design, execution and automation, microservices, GitHub Enterprise, Eclipse, Katalon Test Platform, API Testing, Confluence 8, JIRA/Xray, Draw.io, Swagger/OpenAPI, Postman, Docker, Kubernetes, Podman, PuTTY, E-Health, Telematik, Gematik standards, EPA, E-Rezept, sektoraler IDP, encryption, XaDES, PaDES, DICOM, HL7, FHIR, IHE, ICD, SSO, SAML/Shibboleth, OAuth, smartcards, JWT, two factor authentication Android and iOS, Wireshark, BrowserStack, Cypress, gRPC, REST, SOAP, WS-Security, Linux Shell, PowerShell, SSH/SSL, Java, Kotlin, Cordova, Gradle, Groovy, Python, TypeScript

• Highly successful role as lead data analytics expert at a US consulting startup.
• Managed stakeholder expectations by ensuring team delivery velocity using Agile and Lean practices.
• Trained and assembled international offshore data science teams of DevOps engineers, BI developers, and technical support specialists.
• As Sparecodes' data analytics experts, we improved our clients’ business outcomes through requirements management, dashboard and report development, migration, automation, and production support using IBM Cognos, AWS, SAP, Oracle, Teradata, CRM, ERP, Confluence, and Microsoft.
• Provided effective coaching and mentoring for international, multicultural teams in a remote environment, covering new tools and techniques, Agile best practices, internal and external communication, and presentation skills.
• Coordinated technical processes efficiently, including managing and implementing project changes and control processes.
• Promoted strong team engagement and supported employees’ career development, including business change management through coaching.
• Enhanced project status reports by providing insights into team productivity, predictability, and backlog burn-down, leading to improved project outcomes.
• Successfully led the coordination and implementation of software solutions for clients in mechanical engineering, including automation system integration and customization to meet client needs.