Data Architects in Germany

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

Embedded Analytics & AI-assisted BI

Design and development of an integrated analytics solution based on ASP.NET Core, Power BI Embedded, and LLM services to provide context-based business information.

Development of an AI agent with Function/Tool Calling for the secure orchestration of REST APIs, SQL data sources, and technical services within defined business processes.

Building automated BI workflows including workspace management, deployment processes, and scheduled refresh via the Power BI REST API.

Implementation of secure service-to-service communication with Microsoft Entra ID and Service Principal, and integration into existing enterprise system landscapes.

Technologies: ASP.NET Core, C#/.NET, Power BI Embedded, Power BI REST API, LLM API, AI Agents, Function/Tool Calling, Entra ID

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

• Architected and deployed private cloud data platform on VMware vSphere, integrating Greenplum MPP, Apache Kafka, Kubernetes, and Apache Solr, and developed real-time ingestion pipelines with Kafka Connect and Schema Registry.
• Led Oracle Exadata to Greenplum migration, rearchitected data models, optimized storage, implemented RabbitMQ with Debezium for CDC, and deployed VectorDB for Generative AI.
• Designed and executed multi-cloud migration PoC across AWS, Azure, and GCP, defined KPIs for throughput, latency, and cost efficiency, executed bulk data transfers, validated analytics and streaming workloads, and delivered full-scale architecture recommendations.
• Assessed legacy on-premises infrastructure and designed modern cloud-native data platforms using Greenplum and containerized microservices, advising on scalability, disaster recovery, and high-availability.

• Delivered MVP-focused full-stack architecture for a health-sector client: Vite/React frontend, backend services on Google Cloud Run, and Supabase for database plus IAM/authentication.
• Supported product requirements engineering and prioritized cost-aware workload placement, implementing browser-side/edge computation where feasible before moving logic to backend services.

• 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

• Taught Python, Pandas, data analysis, visualization and Power BI to 250+ students.
• Guided practical projects from data preparation and exploratory analysis through visualization and dashboard creation.
• Explained complex analytical concepts clearly to audiences with different levels of technical experience.

• Definition of the software architecture
• Design and development of modules
• Supporting internal employees in the learning and onboarding process
• Tools: SAP CAP / CDS, Java 21, SAP Hana, SAP Business Technology Platform (BTP)

Development of a route planner for incident communication.

• Development of the REST API
• Set up a patch system for maintaining the routing graph
• Expansion of the testing infrastructure
• Performance and memory optimization (JMeter, JFR)

Technologies: Java 21, Spring Boot, JGraphT, Flyway, MapStruct, Caffeine, ShedLock, JMeter, Kubernetes, JFR

• DWH modernization
• Migration from Informatica PowerCenter to IDMC/CDI
• Migration from IBM DB2 to Databricks

Technologies: Informatica IDMC, Databricks

Evaluation, structuring, and handling of complex tenders for Sogeti as well as as part of larger Capgemini proposals. Focus on analyzing demanding customer requirements, deriving solid solution concepts, and translating technical, functional, and commercial aspects into convincing proposal storylines. In close alignment with delivery, sales, account, and bid teams, scalable and implementable Quality Engineering solutions were designed, evaluated, and prepared for customer decisions. This included selecting suitable role profiles and right-shore staffing options, assessing available skills and capacities, as well as the commercial preparation of reliable price and effort calculations.

A special focus was on bid management and handling service proposals (RfP/RfI analysis), solution design, presentation and management materials, as well as the functional and technical evaluation of customer requirements in the context of Quality Engineering & Testing, agentic AI-supported test automation using modern quality assurance approaches.

SOGETI projects:

• BMW: Development of a test strategy including test management, test automation, and provision of a rightshore delivery model.
• GEA: SAP Business Assurance and Quality Engineering for an SAP rollout including test governance, test automation, AI agent layer, and hypercare concept.
• AIXTRON: SAP S/4HANA Cloud migration explore phase with QA assessment, testable blueprint structure, staffing, and scalable Sogeti delivery approach.
• Deutsche Glasfaser: Quality Engineering & Testing for DG development squads, including ServiceNow and Salesforce, testing automation and governance.
• ERGO: RfP/proposal support for Managed Service Test Data Provisioning as well as a Jira/Atlassian rollout with assessment, target picture, MVP, rollout, and governance.
• Munich Re: Proposal and solution design in the insurance environment with a focus on test data provisioning, process analysis, compliance, and automation.
• BWI: Project/proposal context in the public/IT service environment with reference to Quality Engineering, Test Factory, and digital transformation support.
• Rolls-Royce: Proposal/project support in the Sogeti context with a focus on structured RfP analysis, solution design, and customer-oriented proposal preparation.

• Consultant for system architecture, AI agents & integration, coach for data & process logic, Graph-RAG approaches, security and data protection.
• On-premise AI solutions with high compliance and performance requirements.
• Architecture decisions, operational setup, strategic prioritization & deployment.
• Technologies: LiveKit JS SDK, LiveKit Agents, Web Audio API, JS, AudioWorklet, Loki, vLLM, Zscaler, Docker, Neo4j, MySQL, Python.
• Models: GPT-OSS 20B, Whisper large v3 turbo, Qwen3-TTS.

(Technology)

• Design and implementation of an SAP BTP CAP microservice to consolidate cross-system transactional checks between SAP Sales Cloud (C4C) and On-Premise SAP CRM (05/2024– 06/2025)
• Bi-directional Cloud-to-On-Premise integration enabling real-time validation of Contact lifecycle and open document dependencies prior to record updates (05/2024– 06/2025)

Responsibilities / Deliverables

• development of custom CAP (Cloud Application Programming) services on SAP BTP
• API design, data mapping, and end-to-end integration across C4C (Cloud Runway) and legacy CRM (Traditional Runway)