Microsoft Fabric Experts

• Redesign of the company's BI infrastructure: replacement of a fragmented landscape of manually maintained Excel solutions and CSV imports with a centralized Power BI environment featuring a unified data model as the company-wide single source of truth
• Consolidation of previously isolated reporting logic into a central semantic model – eliminating redundant files, manual data transfers, and inconsistent metrics between departments
• Forecasting & planning: Design and implementation of company-wide liquidity planning in Power BI – from business logic to a fully automated, data-source-driven planning model replacing the previous manual Excel process; enables rolling forecasts and continuously up-to-date cash flow transparency for management
• Optimization of existing Power BI dashboards in terms of performance, structure, and analytical value using an AI-native approach
• Analysis and improvement of the data model, including data quality analyses, data cleansing, and consistent modeling using star schema, DAX, and Power Query
• Incident & anomaly analysis: Identification, investigation, and explanation of data anomalies, including root-cause analysis and concrete recommendations for action
• AI solution architecture: Connecting Business Central and Power BI to LangDock via MCP (Model Context Protocol) for AI-supported data usage
• Creation of a historical data layer as a basis for trend and time-series analyses
• AI-supported automation: Design and development of AI skills, agents, loops, and processes for the automated analysis and interpretation of reports
• Automated reporting workflow: Setup of scheduled, automated email distribution of AI-generated analyses and recommendations to stakeholders
• Gathering and documentation of business requirements and coordination with business departments and IT as part of requirements engineering / product owner activities
• Breaking down overall requirements into clearly defined work packages and tasks
• Definition, prioritization, and management of milestones throughout the entire project lifecycle

Tools: POWER BI, M365, Copilot Studio, MIRO, Microsoft Business Central, Microsoft Fabric, Claude AI, ChatGPT, LangDock, MS VS Code

Two parallel workstreams: (1) Tech Due Diligence for acquisitions and portfolio companies. (2) AI strategy certification and AI governance consulting.

• Tech assessments for PE/VC acquisitions: code reviews, architecture analysis, scalability assessment
• Tech assessment frameworks and integration roadmaps for portfolio companies
• TÜV SÜD certification program: AI governance, EU Artificial Intelligence Act (EU AI Act)
• Strategic AI roadmap development for mid-sized companies

Results:

• Delivered several tech DD reports for investment decisions
• Developed integration roadmaps for portfolio companies
• TÜV SÜD “AI Strategy & Application Expert” (expected 31.12.2026)

• New development and further development of the existing MS Dynamics CRM

IT systems: Microsoft Dynamics Customer Service, SharePoint, DevOps, SAP IS-U

• CRM implementation / further development
• Taking over from the previous service provider
• Business process analysis
• Agile project organization
• Business analysis / requirements engineering with AI support
• Use of AI in development
• Analysis of master data processes
• CRM customer data management
• Requirements documentation
• Stakeholder management
• Workshop moderation

• Leading enterprise BI transformation across Power BI & Microsoft Fabric, delivering scalable data models, automated reporting, and high-performance analytics solutions for commercial and operational leadership.
• Building and optimizing Power BI Dataflows, Fabric Lakehouse datasets, semantic models, and automated reporting pipelines to improve data scalability, governance, and reporting performance.
• Driving dashboard modernization and KPI governance by translating complex business requirements into executive-level insights, interactive visualizations, and decision-ready analytics.
• Designing end-to-end Microsoft Fabric architectures integrating data ingestion, transformation, virtualization, and enterprise reporting across cross-functional business domains with SAP BW to Qlik to Power BI migration.
• Delivering AI-enabled reporting capabilities, threshold-based alerting, and automation frameworks within the Power BI ecosystem to accelerate business decision-making.
• Partnering with commercial leadership, analytics teams, and IT stakeholders to standardize KPIs, optimize BI strategy, and deliver scalable, business-critical reporting solutions.
• Recognized for combining strong stakeholder leadership, technical architecture expertise, and business-driven analytics to deliver impactful enterprise BI transformation initiatives.

Enterprise Analytics Modernization – Germany-based enterprise reporting platform for operations and management analytics, used by 1,000+ internal users across multiple departments.

• Lead end-to-end Power BI and Microsoft Fabric reporting initiatives, delivering scalable dashboards and semantic models supporting daily operational and strategic decisions, achieving 30% faster decision turnaround and 25% reporting efficiency gains.
• Designed unified enterprise datasets using Microsoft Fabric Lakehouse and OneLake, automating historical data processing and reducing manual reporting effort by 40%.
• Built and maintained automated ingestion pipelines using Fabric Dataflows Gen2 and Data Pipelines, improving data refresh reliability to 99.8% uptime and ensuring consistent data quality.
• Implemented enterprise reporting governance, including Row-Level Security (RLS), workspace strategy, deployment pipelines, and documentation, increasing dashboard adoption by 35%.

Technologies used: Power BI, Microsoft Fabric, DAX, Power Query, SQL, Azure Data Fundamentals, Semantic Modeling, RLS, Agile

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

Tools: Fabric, AWS, dbt, Power BI, SQL, DWH, R, Python

• Supported customers in implementing an architecture design for extracting and preparing data
• Planned the design and implementation of the BI and DWH platform
• Ensured the scalability and performance of the data platform

• Advising companies on building, migrating and optimising BI and reporting landscapes (Power BI, SQL, Python, ETL)

• 5 client engagements in real estate and finance since 05/2025: taking over and stabilising existing reporting, automating recurring standard and management reports, building cash-flow models

• Proposal and feasibility assessments for BI and reporting projects

• Using AI-assisted development (Claude Code) to accelerate automation, tooling and web/app development

• Custom ERP system

• Problem: A client's core processes ran on scattered, siloed Excel files with no central data storage – error-prone, hard to scale and impossible to analyse end-to-end.

• Approach: Captured the business processes and requirements, modelled the data and developed iteratively together with the business team.

• Implementation: Built a tailored, web-based ERP system with a central database, role-based modules and automated reporting – delivered using AI-assisted development in Claude Code.

• Timesheet app

• Starting point: Time tracking based on an overgrown, macro-heavy Excel template – maintenance-intensive, single-user and error-prone.

• Implementation: Migrated all functionality and VBA macros into a standalone web app with central data storage, multi-user support and automated reporting.

• Cash-flow modelling

• Starting point: The existing cash-flow model covered standing investments only; project developments were missing from steering.

• Implementation: Built and extended the CF model to include project-development cash flows.

• Optimisation: Reviewed and optimised existing CF models and expanded the KPI outputs for reporting and steering.

• Data Engineering: Design and implementation of scalable data pipelines
• Legacy migrations to Microsoft Fabric (Lakehouse, Dataflows Gen2, Pipelines)
• BO Universe migrations to MS Fabric / Semantic Models / Power BI
• Taskforce for data-driven transformation projects involving Azure Fabric / Oracle / MSSQL

UEF 3.0 · Semantic Government Overlay (SGO) · Autonomous Systems (UAS / dual use)

• Designed: Semantic Government Overlay (SGO) – AI-guided administration without replacing existing specialist procedures. Read-only semantic layer over registers and specialist processes based on the Federal Information Management (FIM). Decision authority remains with the case worker (architecture principle).
• Developed: Reference architecture with source-backed, derived statements (Executable Ontologies OWL/RDF/SHACL). Technically guaranteed purpose limitation and no-write-path principle in specialist data – auditable, without a central data pool.
• Anchored: Regulation as a design principle: EU AI Act (high-risk obligations for public-sector AI, fundamental rights impact assessment under Art. 27), GDPR, NIS2, and administrative automation limits (§ 35a VwVfG, § 31a SGB X) as technical control points in the architecture.
• Created: Methodical tool for pilot organizations: data pipeline assessment (phase 0), compliance blueprint, and management summary as a decision-ready package for public administration.
• Specified: UEF 3.0 as a successor architecture to TOGAF – decision paper, canonical ontology, six-layer architecture, read/actuate boundary, federation registry, terminology concordance, and release delta as a closed specification status.
• Architected: AI-native mission OS for autonomous UAS and ground robotics as a tactical layer on top of a separately approved autopilot. Run-time assurance according to ASTM F3269-21 (Simplex pattern): the verified safety controller keeps authority, the AI function provides suggestions.
• Designed: Three-tier architecture – Tier 0 autopilot with 650 Hz flight control on RTOS, Tier 1 AI OS with semantic world model and multi-agent cluster, Tier 2 swarm and ground mesh. Zenoh as the primary fabric, MAVLink as the only authenticated command path (single writer). Result: graceful degradation – loss of the mission, not of the aircraft.
• Secured: Two-gate chain on the read/actuate boundary – governance gate (can-question: AI Act risk class per actuation, enforced human oversight under Art. 14, immutable log) before the RTA safety monitor (is-it-correct question: flight envelope, geofence, energy reserve) with revert to the baseline controller.
• Anchored: Dual-use architecture with common core and build-time fork instead of runtime switch. Three separate legal levels: civil variant – UAS under the EASA Basic Regulation (EU) 2018/1139 with the limited applicability under Art. 2(2) of the AI Act, ground robotics under the Machinery Regulation 2023/1230 with the full high-risk obligation chain, Cyber Resilience Act for both; unarmed carrier variant as defense material under AWG/AWV and Dual-Use Regulation 2021/821 (BAFA approval); armed variant under KrWaffKontrG. Each variant lives under exactly one dominant legal regime. Evidence base: AI BOM, SBOM, and complete data lineage.
• Analyzed: System analysis and realignment of grown engineering system landscapes. Approach concept for consolidation without migration – semantic layer over the existing sources instead of data transfer. Result: decision-ready implementation concept including an evaluation model for the target architecture.

• Built and maintained Power BI dashboards (DAX, Power Query, data modeling) tracking KPIs across 15+ global manufacturing sites — primary reporting tool for EU leadership decision-making.
• Developed a multi-screen Power Apps application (configurator-style tool) with SharePoint-based workflow integration for the sales team — designed jointly with business stakeholders and IT.
• Built and maintained automated Power Automate workflows connecting to SQL databases; independently identified and deployed an LLM-driven automation use case that eliminated 90% of manual reporting effort — self-pitched to leadership and taken end-to-end into production.
• Built a Python-based data pipeline (SQL) extracting, modeling, and validating data across 10+ EU plants — establishing reliable data models and KPIs for cross-site reporting.

• Developed KPI dashboards using Power BI and DAX for 4+ business units, improving reporting transparency and strategic decision support.
• Migrated enterprise finance data views into dbt models, implementing modular SQL transformations, version-controlled data pipelines, and automated documentation to create a scalable analytics layer.
• Built dimensional data models in Snowflake for enterprise finance data, enabling scalable forecasting and supporting executive decision-making.
• Designed end-to-end ETL/ELT pipelines using Snowflake and SAP HANA, integrating data from 3+ enterprise systems.
• Automated monthly reporting workflows using SQL and Power BI, delivering strong business impact by reducing manual effort by 80%.
• Collaborated with finance stakeholders to translate business requirements into analytical data models, supporting strategic decision-making cycles.
• Delivered ad-hoc financial reports using Power BI, reducing turnaround time by 60%.
• Implemented data validation logic in SQL, resolving 95% of recurring data quality issues.

• Partner with commercial, sales, and medical affairs teams to translate business questions into structured analyses and interactive Power BI dashboards, enabling data-driven decisions in a regulated pharma environment.
• Design and maintain Power BI dashboards that integrate data from Veeva CRM, SharePoint and Databricks, providing real-time visibility into sales trends, territory performance, and commercial KPIs across multiple markets.
• Query and join multiple tables in Databricks using SQL to build clean, analysis-ready datasets, applying transformations such as filtering, aggregation, and window functions to prepare data for reporting.
• Implement Power Automate flows to automate data refresh processes and trigger alerts for KPI thresholds, improving the timeliness and reliability of commercial analytics reporting.

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