Microsoft SQL Server 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

Remote freelance role focused on Agentic AI strategy, secure application patterns, and reusable agentic workflows for a government agency.

• Development and implementation of an open-source Agentic AI strategy for a government agency, with a focus on GDPR, security, and self-hosted solutions
• Development of reusable agentic workflows and business applications that enable non-technical employees to solve business problems independently
• Implementation of nine business applications with Single Sign-On (SSO) and Azure PostgreSQL integration on Hetzner Linux servers

Techstack: Python, Streamlit, Anthropic SDK (Claude), Azure, Linux, PostgreSQL, MS SQL, Angular

Reporting and controlling using Power BI for a production ERP system

• Analysis of ERP data and interfaces for use in Power BI dashboards
• Evaluation and migration of existing reports (e.g. Excel) to Power BI
• Development of an authorization concept for selective data access
• Documentation and training on the use and customization of Power BI dashboards

Label: Power BI, Excel, SelectLine ERP, Microsoft SQL, SQL Server Management Studio

• Industry: Insurance, Trade, IT
• Customers & Projects: Consulting and selling insurance and similar services
• Main tasks: Insurance consulting (health insurance, retirement planning, wealth building); commercial services, inside and field sales; sales data analysis and forecasting; customer consulting and support; opening a new sales headquarters for private and business customers; business development & innovation management; business use case development; process optimization; stakeholder management; team leadership and training; preparation and delivery of trainings;
• Technologies used: Microsoft Office 365, Microsoft Teams, Jira, Draw.IO, Camunda 8, Java (8, 17,21,25), Git, Spring Boot, Spring Batch, Spring Data REST, Spring Web, Spring Security, J-Unit, Playwright, Lombock, Vaadin, H2, PostgreSQL (16, 17 18), pgAdmin, Docker, LLMs, JasperSoft Studio, JasperReports

• SAP S/4HANA upgrade from Release 2021 to 2025 and FI/CO transformation as part of a new TOM. Four streams and two SAP service providers; management during ongoing operations.

• Overall responsibility for time, quality and budget as well as cross-stream coordination of the four streams

• Coordination of process streams, business functions and SAP service providers

• Establishment and management of governance, planning, risks, dependencies, resources and escalations

• Provider management, regular management reporting, and preparation and execution of project and Steering Committee meetings

• Responsibility as Test Manager for test strategy, test planning, UAT, defect management and acceptance

• Result: Successful preparation for Go-live on 28.09.2026 during ongoing operations; quality and the planned absence of production interruptions ensured. Project governance established and positive feedback from management and stakeholders.

• Product Analytics, Mobile App Tracking & Tracking Governance (B2C Mobility App) – agile project management (Scrum/Kanban)
• Product Ownership for Product Analytics and Mobile App Tracking of the EnBW mobility+ app; gathering, prioritizing, and translating business requirements into actionable concepts and Azure DevOps user stories with acceptance criteria.
• Derivation of tracking requirements when introducing new app features (including Resilient Map), definition of tracking parameters (screens, events, custom definitions), and ensuring privacy-compliant tracking (Firebase, GA4, Adjust) based on the tracking concept.
• Design and adaptation of dashboards and funnel reporting for campaigns (GA4 validation, onboarding and order flow analyses, conversion funnels, charging start flow) to identify drop-off points and optimization potential.
• Management of the technical raw data export (Adjust to BigQuery) and connection to the data warehouse/data lakehouse, including data mapping; collaboration with international development teams, Data Engineering, Marketing/Sales, and Product Management.
• Establishment of standardized tracking architecture, naming conventions, and governance; analysis and expansion of tracking (new features and “blind spots”), test design, handover to testers, and quality assurance and approval before releases; documentation in Conceptboard.

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

• Expert in the company's architecture management area

• Support for standardizing the company's IT landscape

• Further development of architecture management

• Shaping the company's business architecture

• Restructuring, administration and maintenance of all IT assets

• Support in creating a unified software asset management and CMDB

• Creation of unified document management (e-file)

• Transition of documents into a central DMS structure

• Link between architecture management and the department's internal business process management

• Support in developing strategic and tactical development plans

• Organizing communication with key stakeholders

• Support in the conception, organization and coordination of the architecture office to be built up

• Accompanying and advising the entire architecture management process

• Advising the company's business units on architectural topics and their framework conditions

• MS Office, Windows 10, VBA

• ITIL, TOGAF, PowerBi, Kanban, Scrum

• Internal agency tools

• Open Touch Conversation, Webex, wire, bdbos

• MS Sharepoint, JIRA, Confluence

• ARIS, Archimate, BPMN

A nationwide service provider for occupational medicine, occupational safety and health management, focusing on prevention, health and digital transformation.

• Role: Responsible for establishing and further developing professional project portfolio management in the Digital Transformation & Data area. Managing and supporting strategic IT and transformation projects, as well as supporting the introduction and establishment of project management standards, methods and governance structures.

Key areas:

• Establishment and further development of IT project portfolio management
• Analysis and structuring of business and technical requirements
• Management and coordination of cross-functional IT initiatives
• Stakeholder management at department, management and service provider level
• Introduction and further development of project management methods and tools (including Jira, Confluence, MS Planner)
• Preparation of decision-making documents, target visions and implementation concepts in the context of digital transformation
• Management and coordination of transformation, digitalization and organizational projects
• Preparation of decision templates and management documents for executive committees
• Conducting workshops and stakeholder management with departments and IT teams
• Definition of requirements for dashboards, reporting and KPI management
• Participation in the Wissenskompass project (requirements analysis and MVP concept)
• Analysis and evaluation of AI support opportunities in Knowledge Management
• Investigation of AI use cases to improve knowledge provision and use
• Consideration of AI requirements as part of the Wissenskompass concept
• Coordination with strategic departments to further develop project management standards
• Introduction, configuration and training for Microsoft Planner to support project and task management
• Conducting user training and supporting employees in the introduction of new ways of working and tools

Creation of concepts for M365 implementation, especially Tenants, EntraID, EntraConnect and ExchangeOnline, taking BAS standards into account (mandatory baseline security requirements) in the project "Concept M365" with the aim of transferring the concepts to the M365 environments of Bitmarck and then handing them over to the customer.

• Creation of a current-state analysis of the existing M365 environments as well as the on-premises environments and the BAS standards.
• Creation of concepts for the topics Tenants, EntraID, EntraConnect and ExchangeOnline taking the BAS standards into account
• Design and implementation of an automated solution for creating standardized M365 tenants based on Microsoft M365 DSC (Desired State Configuration)
• Transfer of the concepts into the M365 environments
• Creation of detailed technical documentation

Design and implementation of a „unified-commerce“ platform for SMEs to sell and deliver multi-product bundles

Achievements: On-time design, delivery and customer acceptance of a 100% functional, CPQ-based „buy flow“ process for configuring and selling multi-product bundles within the specified time frame of 90 days. Successfully tested integration of various interface services for: customer search, enrichment of customer data, address validation, service qualification, phone number validation, credit check, appointment selection and Quote-to-Order transition.

Responsibilities:

• Strategic goal implementation: Derivation and implementation of strategic customer goals (e.g. release content, business value).
• Backlog Management: Creation and elaboration of backlog items (Initiatives, Epics, User Stories, Defects) in close coordination with the project team and customer.
• Prioritization & Releases: Responsibility for prioritizing the Product Backlog and implementing defined release goals.
• Deliverable Tracking: Tracking work results on the supplier and customer side.
• Roadmap & Release planning: Development and implementation of roadmaps and release plans together with the customer.
• Scope responsibility: Responsibility for the contractually agreed scope of services.
• Claim Management: Active claim and change management towards the customer.
• Team coordination: Management and coordination of the development team.
• Use of synergies: Use of synergies between customer projects and product development.
• Proposal preparation: Preparation of proposals (with supervision) and presentation on site to customers and partners.

Skills: Development, communication and implementation of product visions; Product Backlog Management; Stakeholder Management; Regular reporting to management and Steering Committees; Requirements analysis & engineering; Planning and documentation of workshops; Professional leadership and coordination of (distributed) project teams and external service providers; Epic Management; User Story specifications; Creation of use cases, support with software testing and User Acceptance Testing (UAT); Release Management and Sprint Planning; Design of TO-BE processes; Process optimization; Planning, design and specification of interfaces to existing and new systems; Identification, assessment and management of project risks; Active claim and change management; Facilitation of sprint planning and reviews; Data migration; Scrum; Kanban; REST API; JSON; XML; BPMN; UML; Jira; Confluence

• Worked as freelance Senior DevOps Consultant on-site for IBM at a European Union Agency, operating in a highly secure, air-gapped environment managing classified systems.
• Led automation and DevOps initiatives for a large-scale OpenShift platform (>400 nodes), driving deployment efficiency, GitOps adoption, and operational automation using Ansible, Python, and Bash while ensuring compliance with security requirements.
• Spearheaded automation of release and deployment workflows in a private cloud environment hosting 400+ OpenShift nodes, significantly improving deployment speed and reliability.
• Migrated existing playbooks, roles, and templates from Ansible Tower to Ansible Automation Platform (AAP), ensuring full compliance with fully-qualified collection names (FQCN) and preparing custom Execution Environments (EE) for containerized automation.
• Implemented GitOps Agent for AAP Controller Configuration as Code, enabling automated synchronization (CRUD) of Ansible Controller objects based on repository-stored configuration definitions using GitHub webhooks.
• Designed and automated complex multi-step operational workflows including environment cleanup, Helix cluster component re-creation, Kafka topic management, and OpenShift object lifecycle management across ~100 environments.
• Achieved a reduction of multi-day manual operations to under a few hours through automation improvements spanning multiple AAP clusters and OpenShift environments.
• Integrated Ansible Automation Platform with Thycotic (Delinea) Secret Server via lookup plugin to enhance secure credential management in automated processes.
• Managed deployment tasks, platform troubleshooting, and Istio network configurations while adhering to stringent EU PSC security and compliance standards.
• Collaborated with infrastructure and application teams to refine deployment procedures, develop naming conventions, and continuously improve automation coverage in an air-gapped, classified environment.

• Development of a production-ready Enterprise AI solution for the automated processing of invoices and business documents
• Integration of Azure AI Document Intelligence and LLM technologies into existing business processes
• Development of robust REST APIs for automated document processing and system integration
• Extraction, validation, and storage of structured invoice data in Azure SQL as a base for analytics and machine learning models
• Development of an AI-based recommendation engine with machine learning and deep learning to generate personalized product recommendations based on historical purchase data
• Implementation of logging, monitoring, error handling, and validation mechanisms for stable production use
• Collaboration with business teams to define business rules and integrate the solution into existing enterprise processes

Technologies: Python, Azure AI Document Intelligence, Azure OpenAI, Azure SQL Database, REST APIs, Machine Learning, Deep Learning, OCR, Pandas, JSON, Workflow Automation

• Fully on-premises LLM document-examination platform for a compliance-critical banking domain: agentic LangGraph pipeline with deterministic verification, every AI judgment structured and source-anchored; ~960 automated tests, zero data egress
• GPU throughput engineering (quantized serving, speculative decoding, prefix caching): 9.5x extraction speed-up, 500+ multi-document case files per day on a single A100
• AI-native EDI/EDIFACT integration platform (~116k LOC Java 25 / Spring Boot 4, 1,900+ tests): LLM-drafted partner mappings machine-verified before go-live (DFDL conformance, field-coverage checks, dry runs), ~99.5% byte match on real customer files — replacing weeks of manual mapping per partner