MDX Experts in Germany

Zerobits is my vehicle for AI-powered automation and custom software development with a clear principle: AI solutions that reach production, not pilot stage. I design and build the systems myself - from first concept and architecture through implementation to deployment and operations.

My focus is on replacing repetitive, manual work with reliable automation and connecting disconnected tools and data sources into one dependable overall system.

Selected work:

• Design and implementation of LLM-based agent systems and RAG pipelines (Anthropic Claude, Mistral, MongoDB Atlas Vector Search + RAG)
• Workflow orchestration for long-running, fault-tolerant business processes using Temporal (temporal.io): saga patterns, event-driven architecture, retry and compensation logic, connecting third-party APIs and internal services into automated end-to-end processes
• Full stack product development: SaaS architecture on Kubernetes, TypeScript/React/NestJS, admin tooling with refine.dev and MUI
• AI-assisted development workflow as standard practice to deliver production software at a fraction of traditional timelines
• Full stack product development: multi-tenant SaaS architecture running on Kubernetes, backend with NestJS/Node.js and Python, frontend with TypeScript, React and Next.js, admin tooling with refine.dev and MUI, CI/CD with GitHub Actions

One of these projects is a product I own and operate - free of any NDA restrictions. I'm happy to demonstrate it end to end.

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

Task

• Further development of a new ERP system with Blazor
• Creation 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

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

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

• Designing a planning solution to improve energy efficiency

• Creating a concept for an energy management system

• Planning a measures planning component to gradually reduce energy consumption

• Evaluating planned measures by assessing opportunities, risks, and effectiveness for integration into planning

• Defining requirements for a data model to compare planned vs actual data in the dashboard

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

• Expanding accantec PerCon permission management to IBM Planning Analytics

• Analyzing permission requirements and aligning with IBM Cognos Analytics and Tableau

• Extending accantec PerCon with IBM Planning Analytics via REST API

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

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

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

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

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

• Optimizing, extending, and operating a long-standing BI planning landscape

• Upgrading the Jedox solution from version 2019.1 to 2022.2

• Optimizing ETL processes and reports, and implementing automated ETL

• Connecting various accounting and management systems

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

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

• Developing planning scenarios for FP&A and creating budget monitoring reports

• Designing and implementing new OLAP cubes and reporting

• Conducting user trainings based on customer requirements

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

• Migrating and optimizing an existing Jedox solution

• Merging reporting and planning systems in Jedox

• Building a central group reporting with plan vs actual comparison for FP&A

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

• Producing forecast reports, managing permissions, and training users in an international setting

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

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

• Conducting user trainings for report creation

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

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

• Creating ETL processes to load dimensions and OLAP cubes

• Building reports, planning input 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

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

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

• Reviewing and adjusting existing reports

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

• Migrating a Jedox solution from version 5 to 2022.2

• Performing a system update with configuration adjustments and performance issue analysis

• 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 metrics with MDX

• Supporting users with Power BI requests

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

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

• Establishing flow cytometry experiments, including NGS workflow antibody panel design, to investigate how various drug treatments affect TNF receptor expression and influence activation and exhaustion of human-derived T cells.
• Conducting projects on the effects of various drug treatments on a human ex vivo wound healing skin model, performing PAS staining and quantifying the length of the epithelial tongue following injury.
• Investigating effects of drug treatments on hair follicles and ex vivo wound healing skin samples at the transcriptomic level by analyzing expression of specific target genes using quantitative PCR (qPCR).
• Managing daily ordering and inventory of laboratory consumables and equipment, following ISO 9001 standards.

• 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

• Ongoing support on a Lucanet project in Hamburg (logistics/financial market)
• Advising on budgeting issues
• Advising on questions related to asset accounting
• Support in reporting
• Lucanet implementation for a client near Munich (retail/building materials)
• Support with initial setup
• Preparation of data imports from Excel
• Development of (SQL) interface to Navision data
• Ongoing support on a Lucanet project in Munich (pharma/medical)
• Data output in SQL Server
• Support and advice on setting up consolidation (legal)
• Ongoing support on a Lucanet project in Cologne (publishing)
• Preparation of Excel imports
• Support during initial setup (project restart)
• Ongoing support on a Lucanet project in Ludwigsburg (chemicals, printing inks, hobby paints)
• Connecting Lucanet to existing data warehouse solution (SQL)
• Ongoing support on a Lucanet project in Bad Staffelstein (solar industry)
• Connecting Lucanet to existing data warehouse solution (SQL)
• Integration of Lucanet reporting package
• Support and advice on setting up consolidation (legal & management)
• Ongoing support on a Lucanet project in Zeven (transport and logistics)
• Administration of existing Lucanet solution
• Integration of Lucanet reporting package
• Support and advice on setting up consolidation (legal & management)
• Support for planning, forecasting
• Lucanet implementation for a client in Luxembourg (retail)
• Installation and setup
• Support with initial setup
• Preparation of data imports Excel/DWH interface
• Lucanet implementation for a client in Nuremberg (manufacturing)
• Support with project restart
• Design for reporting and planning
• Setup of import packages
• Lucanet in-house consultant for an international software group focusing on M&A
• Consulting and support for the corporate holding and business units regarding implementation, rollout and operation of the Lucanet disclosure management solution
• Lucanet implementation for a client in Wassertrüdingen
• Database setup and configuration
• Connection of source systems with Lucanet interfaces
• Consolidated financial statements setup
• Support in the consolidation process
• Support in the reporting process
• Support of Lucanet for a client in Stuttgart
• Support in the consolidation process
• Support in the reporting process
• Support in the planning process
• Sparring partner for the specialist department
• Support of Lucanet for a client in Landau
• Implementation of cost center allocation in Lucanet
• Support in the consolidation process
• Lucanet carve-out support for a client in Waldstetten
• Database setup and configuration
• Design and implementation of BI software for a personnel service provider in Nuremberg
• Integration of 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 for an elevator company in Nuremberg
• Integration of 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 for a logistics company in Leipzig
• Integration 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 for a corporate group in Freilassing
• Integration 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 advice for creating a data warehouse
• Support in report creation in Power BI
• Support in transforming an existing DWH solution to SAP BW
• Analysis and documentation
• Ongoing consulting on processes
• Support in designing BW/SAC models
• Reporting in SAC
• Rebuilding a BI environment for an international company from Berlin (manufacturing/trade)
• Connecting SAP BO to new DWH (SSIS)
• Creation of tabular model cubes (SSAS)
• Creation of reports and KPIs
• User training