PySpark Expert

• Design, development, and productive rollout of an Enterprise HR Copilot based on Microsoft Copilot Studio to automate internal HR processes
• Development of an AI-supported assistant for answering employee inquiries based on a SharePoint knowledge base and internal company HR documentation
• Integration of the Copilot into Microsoft Teams, including welcome logic, user guidance, and role-based routing
• Automation of HR processes and approval workflows with Microsoft Power Automate to reduce manual processing steps
• Development of realistic HR documents and response templates with Azure OpenAI, taking business requirements and consistent company policies into account
• Implementation of prompt strategies, knowledge management, and response optimization to improve response quality and user acceptance
• Close collaboration with business departments to analyze requirements and integrate the AI solution into existing company processes

Technologies:

Microsoft Copilot Studio, Microsoft Teams, Azure OpenAI, SharePoint, Power Automate, Power Platform, Microsoft 365, Prompt Engineering, Workflow Automation

• 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

Project: Defect Generation on Test-Bench Images of Metal Surfaces Environment: Automated Visual Inspection (AVI), Metallurgy & Manufacturing

• Objective & Implementation: Designed, architected, and trained Generative Adversarial Networks (Pix2PixHD / SPADE) for image-to-image transformation. Targeted generation of synthetic material defects (e.g., cracks, inclusions, scale) on rough metal surfaces under real test-bench lighting conditions for privacy-compliant and efficient dataset expansion (data augmentation).
• Technical Design: Implemented robust Generative AI and computer vision pipelines in Python and PyTorch. Used semantic segmentation approaches for mask-controlled defect synthesis and subsequent evaluation with EfficientDet object detection models.
• Business Impact: Massive dataset upscaling (10x) without time-consuming and costly physical test-bench runs, while significantly improving the detection performance of automated inspection systems.

Technologies & Skills Used: Python | PyTorch | SPADE | Pix2PixHD | EfficientDet | Machine Learning | Semantic Segmentation | Computer Vision

• Development of an AI-powered project organization tool for a civil engineering company that intelligently links project, task, tender, schedule, and document data through a knowledge graph.
• Implementation of AI features for document analysis, information extraction, context-based assistance, and voice-based data capture based on Microsoft Azure AI, reducing administrative effort, making information available faster, and supporting project teams in decision-making.
• Tech stack: Python, React, TypeScript, FastAPI, Claude Code, Codex, Graphify, PostgreSQL, Microsoft Azure AI Foundry, Azure OpenAI, Azure AI Speech, Azure AI Document Intelligence, Microsoft Graph, Microsoft Entra ID, Docker, Git, CI/CD.

• This project involved extraction of intelligence data to support report writing for a company that provides geopolitical, global, commercial intelligence. The data have been gathered from a number of resources (interview transcripts, online data, internal documents), and then a knowledge base has been build from it. This was the basis of a complex RAG system, that was evaluated against a golden dataset. Agents have been used to find out the contradicting intelligence, the statements supporting each other, and to store back the generated knowledge.

Used: Python, RAG, LangGraph, LangChain, deepeval, MCP

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

Designed and developed an Azure-based AI and data platform transforming distributed project documents into searchable, structured knowledge for an enterprise AI assistant. Combined incremental document processing, hybrid keyword/vector retrieval, knowledge graph extraction, and conversational AI for Microsoft Teams and Microsoft 365 Copilot. Implemented Python document-processing pipelines for PDF, Word, Outlook and text files; Azure Cosmos DB lifecycle management; Azure AI Search; Azure AI Foundry and Azure OpenAI; identity-aware retrieval with Microsoft Entra ID; project authorization; a TypeScript Microsoft Agents SDK agent; Pulumi infrastructure; resilient scheduling, retry and diagnostic tooling. Technology stack: Python, TypeScript, FastAPI, Pydantic, Azure AI Foundry, Azure OpenAI, Azure AI Search, Azure Cosmos DB, Blob/Table Storage, Container Apps/Jobs, Service Bus, Key Vault, Entra ID, Docker, Pulumi, pytest, Microsoft Teams and Microsoft 365 Copilot.

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

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

• 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

Built Python-based AI microservices and integrations for an AEC/VR Unity-based SaaS app, focusing on LLM/VLM capabilities, retrieval-backed systems, RESTful APIs, containerized deployment, and an automation microservice for the CAD-to-Unity pipeline.

• Developed a custom Hybrid A* based algorithm in C# to simulate hospital scenarios and detect early-stage design conflicts from collision/spatial data and generate structured reports.
• Solved and automated the time-consuming problem of converting CAD files to usable Unity environments with a custom-engineered and real-time pipeline using a ZeroMQ-based communication layer to distribute workloads across multiple processes and achieve real-time performance.
• Built a Dockerized FastAPI pipeline for CAD-to-Unity automation, combining vision-based object matching, image embeddings, and precomputed metadata to automatically map CAD objects to Unity behavior scripts, assign properties, and reduce repeated AI inference calls.
• Created documentation and examples to help technical users understand, configure, and extend the AI automation pipeline.

Architected and maintained data products for renewable energy operations, covering wind turbine, grid-meter, and weather data. Built scalable ETL/ELT pipelines in Azure Databricks using Delta Lake (bronze/silver/gold layers) and processed data in various formats, including structured and semi-structured data. Contributed to a data quality framework supporting table and column documentation, outlier detection, and completeness metrics across all datasets within a data product. In addition, implemented a DORA KPI Databricks dashboard used across all data products. Optimized CI/CD processes in Azure DevOps to streamline deployment across development, test, and production environments.

Technology stack: Azure Databricks, PySpark, SQL, Delta Lake, Unity Catalog, Azure Data Lake, APIs, Dremio, Azure DevOps, YAML, Git, Databricks Workflows, Application Insights, Terraform, OpenAI API, Codex, LLM-assisted workflows

• Acted as technical consultant to optimize multi-layer ensemble models combining ResNet, CNN-BiGRU-Attention, and XGBoost.
• Guided implementation of a Logistic Regression meta-learner to solve class imbalance problems, achieving 92.86% accuracy and 0.9644 AUC on PTB-XL and Chapman-Shaoxing datasets.

I designed and developed an AI-powered multi-tenant platform on Azure that transforms SAP process recordings into technical documentation, presentations and automated tests, processing over 15,000 process recordings for enterprise customers like Würth. I owned the architecture, the production releases and the DevOps setup. I also designed a multi-tenant system with SSO and role-based access on Azure. Implemented an MCP Server with Dynamic OAuth Authentication.

Main Tasks:

• Sprint planning and feature preparation
• Design the multi-tenant platform architecture (FastAPI, SQLAlchemy, PostgreSQL row-level security for tenant isolation)
• Develop AI pipelines with Prefect for transcription (Azure Speech API), document generation and SAP screen-recording analysis (Claude, gpt-4-mini)
• Design and implement an MCP server to expose tenant knowledge to LLM clients (Claude), with async retrieval and reranking
• Implement LLM cost tracking, rate limiting and client pooling for Anthropic/OpenAI/Azure OpenAI endpoints
• Set up CI/CD: Docker images to Azure Container Registry, GitHub Actions, Azure Static Web Apps, Alembic migrations in containers
• Manage production releases and execute live data migrations for enterprise customers
• Define engineering standards and architecture patterns for the team

Environment: Azure / Azure Foundry / Python / FastAPI / Prefect / React / PostgreSQL