MDX Experts in Germany

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.

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

Tasks

• Further development of a new ERP system with Blazor
• Generation of e-invoices in the XRechnung and Zugferd formats
• UI/UX design Client-server system
• Windows 11 Technology
• Microsoft .NET 9, Git, Azure DevOps, ASP.NET, MSSQL, Blazor Programming languages
• C#, MVVM Development tools
• Microsoft Visual Studio .NET 2022 Database
• MSSQL Industry
• Other

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

• Replacement of a Java application and the Oracle DB for loading the internal WerWasWo system using SSIS.
• Development of SSIS packages to load text files into the database (SQL Server)
• Development of a database project for deployment on various servers
• Creation of queries to monitor the loading runs
• Development of a PowerShell script to automate the deployment of the SSDT projects.
• Oracle, SQL Developer, Microsoft SQL Server 2022 on-premises, SQL Server Management Studio v21, Visual Studio 2022, SSIS, SSDT, PowerShell.

• Developing test strategy: Designing and implementing a comprehensive test strategy for digital rail projects.
• Defining test approaches: Establishing and documenting methodical test approaches to maximize coverage and efficiency.
• Team management: Assigning roles and responsibilities within the test team to ensure effective and goal-oriented test execution.
• Setting test principles to ensure test integrity and quality.
• Integration and system testing based on specific specifications and standards.
• Infrastructure development for automated test environments, including test systems and test patterns.
• Testing Yemba event detection algorithms in a vehicle data logger using generative artificial intelligence.
• Test case development for internal purposes and for partner companies (device manufacturers).
• Performance and load testing to ensure system stability and scalability.
• Ensuring compliance with relevant standards such as CENELEC, EN50126 and EN5012.

• Ongoing support for a Lucanet project in Hamburg (logistics/financial market)
• Consulting on budgeting topics
• Consulting on fixed asset accounting issues
• Support with analyses
• Implementation of Lucanet at a customer near Munich (retail/building materials)
• Support with the initial setup
• Preparation of Excel data imports
• Development of an SQL interface to Navision data
• Ongoing support for a Lucanet project in Munich (pharmaceuticals/medical)
• Data output to SQL Server
• Support and consulting in setting up legal consolidation
• Ongoing support for a Lucanet project in Cologne (publishing)
• Preparation of Excel imports
• Support with the initial setup (project restart)
• Ongoing support for a Lucanet project in Ludwigsburg (chemicals, printing inks, hobby paints)
• Connecting Lucanet to an existing data warehouse solution (SQL)
• Ongoing support for a Lucanet project in Bad Staffelstein (solar industry)
• Connecting Lucanet to an existing data warehouse solution (SQL)
• Connecting the Lucanet Reporting Package
• Support and consulting in setting up legal and management consolidation
• Ongoing support for a Lucanet project in Zeven (transport and logistics)
• Administration of the existing Lucanet solution
• Connecting the Lucanet Reporting Package
• Support and consulting in setting up legal and management consolidation
• Support with planning and forecasting
• Implementation of Lucanet at a customer in Luxembourg (retail)
• Installation and setup
• Support with the initial setup
• Preparation of Excel/DWH interface data imports
• Implementation of Lucanet at a customer in Nuremberg (manufacturing)
• Support with the project restart
• Design of reporting and planning
• Setup of import packages
• Lucanet in-house consultant at an international software group with a focus on M&A
• Consulting and support for the group holding company and business units regarding the implementation, rollout and operation of the Lucanet Disclosure Management solution
• Implementation of Lucanet at a customer in Wassertrüdingen
• Database setup and configuration
• Connecting source systems using Lucanet interfaces
• Preparation of consolidated financial statements
• Support with the consolidation process
• Support with the reporting process
• Support for Lucanet at a customer in Stuttgart
• Support with the consolidation process
• Support with the reporting process
• Support with the planning process
• Sparring partner for the specialist department
• Support for Lucanet at a customer in Landau
• Implementation of cost center allocation in Lucanet
• Support with the consolidation process
• Support for a Lucanet carve-out for a customer in Waldstetten
• Database setup and configuration
• Design and implementation of BI software at a staffing services provider in Nuremberg
• Connecting various source systems
• Development of data warehouse and ETL processes
• Creation of several cubes and data marts
• Ongoing support and further development
• Based on: Cubeware Importer, SQL Server, TM1
• Design and implementation of BI software at an elevator company in Nuremberg
• Connection to Navision BC
• Development of data warehouse and ETL processes
• Creation of several cubes and data marts
• Based on: Cubeware Importer, SQL Server
• Design and implementation of BI software at a logistics company in Leipzig
• Connection of various source data
• Development of data warehouse and ETL processes
• Creation of several cubes and data marts
• Based on: Cubeware Importer, SQL Server, TM1
• Design and implementation of BI software at a corporate group in Freilassing
• Connection of various source data
• Development of data warehouse and ETL processes
• Based on: Cubeware Importer, SQL Server, TM1
• Design and implementation of a new reporting environment based on SQL Server and Power BI
• Best practice consulting for the creation of a data warehouse
• Support with report creation in Power BI
• Support with transforming an existing DWH solution to SAP BW
• Analysis and documentation
• Ongoing consulting on processes
• Support with designing BW/SAC models
• Reporting in SAC
• Rebuilding the BI environment at an international company from Berlin (manufacturing/retail)
• Connecting SAP BO to the new DWH (SSIS)
• Creation of tabular model cubes (SSAS)
• Creation of reports and KPIs
• User training

• Business intelligence development in the logistics sector.
• Migrating existing reporting and analysis solutions from Cognos to Microsoft BI.
• Using Microsoft SQL Server, SSAS, Power BI, and other Microsoft BI platform components.

• Design, architecture & development/programming of ETL/ELT data pipelines, DWH, BI solution
• Technical project lead, POC – proof-of-concept creation
• Liaison between business units and technical teams
• Azure DevOps Boards & Jira
• Data modeling & data engineering – data warehouse & data mart
• Azure (Data Factory, Azure SQL, Azure DevOps CI/CD, Azure Data Lake V2, Business Central REST API, OData API, OAuth2 tokens)
• SharePoint lists & API for ADF, Firebird DB, Postgres DB, DB2
• Power BI (Power Query), DAX, Excel PBI add-on, GIS data
• Automated ETL process monitoring/logging, performance monitoring, error monitoring – capturing & resolution
• Index performance tuning & statistics monitoring, Transact-SQL
• Data security – MFA (multi-factor authentication) & OAuth2, MS Graph, Azure networks & firewalls, gateways, roles, user groups – with read/write permissions
• Sources – Vario Bill, Camunda, Radius, Geo Database, OTRS, PAST, MS Dynamics Business Central, Azure Blob Data Lake, SharePoint lists

• Implement the BI solution and replace the old BI landscape
• Sub-project lead for Sales Bonus Plan: Extend the existing solution and migrate to Azure
• Sub-project lead for Cognos migration: Expand the existing data warehouse based on MS technologies
• Analyze business requirements and create the technical solution
• Expand the relational DWH database
• Develop the ETL processes (SSIS)
• Develop the multidimensional database (OLAP cubes/SSAS)
• Use of MS SQL Server 2016 (SSMS, SSIS, SSAS, SSRS), MS SQL Server PDW, Oracle, Power BI, Delta Lake, Databricks, Synapse