Data Modeling Experts

• 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

• Impact: Structured requirements analysis and quality assurance as a foundation for the further development of a software solution.
• Analysis, documentation, and coordination of requirements. Conducting stakeholder analyses, interviews, and workshops to gather and validate requirements. Conducting requirements reviews and working closely with business departments and development teams.

Techniques & Tools: Requirements Engineering, Stakeholder Management, Workshop Facilitation, System Context Modeling, Requirements Reviews, Quality Scenarios, Miro, Jira, Confluence

Assignment focus: Leading digital restructuring in a highly regulated Defence and Aerospace environment. Focus areas: improving data flows and data quality, introducing paperless data collection in production, integrating machine data for automatic SPC calculation and process control, as well as cybersecurity analyses.

Main objectives:

• Analyze, structure and improve data flows and data quality in production
• Introduce paperless data collection in manufacturing areas
• Integrate machine data for automatic SPC data calculation and process control
• Implement digital restructuring while meeting regulatory requirements in the Defence environment

Measures and results:

• Analyzed and structured existing production data flows as a basis for control and reporting
• Established mechanisms to ensure data quality and availability across manufacturing areas
• Introduced paperless data collection in production — replacing manual and paper-based processes
• Integrated machine data for automatic SPC data calculation (control charts, Cp/Cpk) and real-time process control
• Conducted cybersecurity analyses in the production and IT environments

Area of responsibility: Project management for digital restructuring, paperless production, data management and data quality in a highly regulated Defence and Aerospace environment.

• I support medium-sized clients with their funding needs.
• I evaluate operational business processes and translate complex legal and regulatory requirements into business requirements, target models and actionable roadmap epics.
• I use Generative AI tools and automation in a targeted way to efficiently create requirements documentation, process analyses, evaluations, meeting preparation materials, customer analyses and decision papers.

• Project: ESU Windows and SQL Server Consolidation / Configuration Management in ServiceNow
• Prepared an as-is analysis of all servers worldwide
• Prepared an as-is analysis of all SQL servers worldwide
• Conducted requirements analyses for SQL and server migrations
• Coordinated requirements with partners for migrations to Hyper-V (on-premises) or Azure Cloud
• Facilitated regular status meetings (Jour Fixe)
• Developed roadmaps and solution models for server migrations
• Set up test scenarios
• Facilitated workshops for the rollout of a global admin team
• Designed data models (CMDB) in ServiceNow
• Led workshops for the CMDB data model
• Developed solution models for the CMDB
• Created end-to-end configuration documentation and work instructions for the CMDB
• Prepared reports for license management
• Defined KPIs for data quality in ServiceNow
• Created a service catalog
• Facilitated workshops to define service requests
• Acted as interface between requirements analysis and the ServiceNow development team
• Systems used: Windows 7, Windows 10, Microsoft Office 365/2010, Windows Server 20xx, SQL Server 20xx, SharePoint, Azure Cloud, Hyper-V, ServiceNow, various tools

• Development of a digital audit application for inspections in medical facilities. The goal is to connect on-site data collection, voice recording, documentation and downstream processes in one end-to-end, AI-supported workflow.

• Design and development of a Flutter audit app with Claude Code for the structured execution and documentation of inspections.

• Processing of voice recordings captured in the app through automatic transcription and AI-supported creation of structured inspection reports, followed by an approval process

• Connecting various data sources such as email, Odoo 19, attendance records and Google Drive via n8n to automate billing and follow-up processes

• Automatic provision of required documents and email delivery through n8n-controlled workflows, including the use of LLMs for text creation

• Skills: Flutter, Claude Code, LLM Integration, n8n, Odoo 19, Google Drive, Process Automation

AI-supported document processing and inventory management integration

Design and development of an AI-supported application for the automated processing of delivery and invoice documents, connected to SelectLine ERP. Documents are analyzed using AI, matched with orders and line items, and prepared for posting goods receipts.

IMPACT:

• Automated extraction of structured order, delivery and invoice data from PDF and image documents
• Automatic and manual mapping of documents to orders and order line items
• Integration with SelectLine ERP for order import, status synchronization and goods receipt postings
• Traceable processing through separate analysis, mapping and posting processes as well as technical logging
• Development of a containerized end-to-end architecture with AI analysis, workflow automation and relational data storage

KEYWORDS: AI, document analysis, OpenAI, n8n, SelectLine ERP, FastAPI, Python, JavaScript, MariaDB, Docker, REST API, PDF, OCR, mapping, inventory management, goods receipt, workflow automation

• Repaired a broken “ScrumBan” process, then established a pure Kanban system; increased output in the Kanban flow by 22% within four weeks

• Increased team autonomy and decision-making ability by implementing new decision strategies; resulting in up to 25% better outcomes

• Redesigned retrospectives (including one-to-one coaching and workshops), which led to consistent implementation of the resulting action items

• Intensive coaching of Product Owners (POs) to develop and support “Empowered Teams”, alongside leadership development to place agile frameworks and methods in a realistic context (“de-illusioning”)

• Supported change management processes to promote an agile company culture among management and teams, improving internal communication to increase transparency and effectiveness in agile processes

• 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

• Development of an agent-based governance platform for the automated assurance of EU AI Act compliance and ODA-compliant orchestration of AI services in complex enterprise environments.

• Design and implementation of an agent-based "Mission Control" framework (Aletheia Conductor) for autonomous state monitoring and process control.

• Development of "Compliance-as-Code" (CaC) solutions based on OPA/Rego for system-wide enforcement of regulatory guardrails.

• Integration of TM Forum ODA standards (TMF630, TMF622, TMF642) to ensure interoperability and standardization.

• Building a highly available event-driven architecture using Redpanda and CloudEvents v1.0 for near-real-time event processing.

• Implementation of an audit-proof "Evidence Chain" through cryptographic linking of trace logs in preparation for automated audits.

• Tech Stack: Java 21 (Quarkus Native), TypeScript (Next.js), Redpanda (Kafka API), CloudEvents v1.0, OPA (Open Policy Agent) & Rego, TimescaleDB, ZincSearch, Redis, TM Forum ODA, Git, GitHub, Clean Code Development, Like-C4.

• Requirements Engineering
• Process optimization and introduction of collaborative working models
• Process modeling with BPMN
• Analysis, specification, and documentation of logistics processes, IT systems, and data models
• Development of conceptual solutions
• Use case creation and documentation
• Data analysis with SQL
• Administration of Jira & Confluence

• Analysis of the Riester subsidy GeVos for provider change 2.0 in the AZUR subsidy management system
• Representation of the GeVos in BPMN 2.0 with Draw.io and Adonis
• Analysis of the data sets exchanged with the life insurance policy administration system and migration to the msg data sets
• Design and mapping of the interfaces to the new msg.ZulagenVerwaltung for various Riester subsidy GeVos at data field level

• Supporting the International Web Presence of the BA (IntWeb) project in the area of quality management, with the aim of taking responsibility for the quality of processes and project results while considering BA standards. The main objectives of the project are to give professionals abroad a quick overview of their opportunities for moving to Germany and to enable them to take the necessary steps consistently and with digital support by providing access to services.

• Defining the general guidelines in the QA handbook

• Summarising test results in QA reports for PLA

• Analysing project results for improvement opportunities

• Quality management of requirements analysis (particularly processes, methods, and tools)

• Ensuring compliance with SERA requirements

• Creating a cross-project test concept

• Agreeing on sprint completion reports

• Formal review of work results in accordance with requirements and/or the project plan

• Contact person for internal audit, external audits by auditors, or BRH (Federal Court of Audit)

• Technologies: JIRA, Confluence, MS Office, GitLab, Kubernetes