Microsoft SQL Server Expert

Financial reporting as an MVP. Follow-up assignment.

• Reports on profit and loss, balance sheet and cash flow
• Budget and personnel metrics (FTE)
• Implementation as an MVP with a fixed scope

• Founder of CheironX: AI-supported GRC management (ISO 27001, BSI IT-Grundschutz, TISAX, DORA)
• Strategic focus on Agentic AI and GenAI for modern IT Governance, Risk & Compliance Management
• IT interim management and strategic consulting

• Architected, Deployed and Supported hosted email solutions in Linux and Windows environments with enterprise-grade anti-spam and security architecture for service-provider environments.
• Managed Microsoft Azure environments including Virtual Machines, VNets, Storage, VPN, and Firewall configuration.
• Administered Microsoft Exchange Server (2010-2019), Microsoft Exchange Server SE, Active Directory, PKI, Hyper-V and Zimbra environments with disaster recovery planning and operational support.
• Led Microsoft 365 onboarding and migration projects from Exchange, IMAP, and Zimbra platforms to Microsoft 365.
• Prepare security and compliance to support Microsoft 365 Copilot.
• Implement information protection and data loss prevention by using Microsoft Purview.
• Implement retention, eDiscovery, and communication compliance in Microsoft Purview.
• Integrated Active Directory Domain Services (AD DS), Active Directory Certificate Services (AD CS), and Active Directory Federation Services (AD FS).
• Delivered secure hybrid infrastructure solutions integrating Microsoft Windows Server and Linux-based enterprise environments.
• Supported enterprise integration projects involving Debian, Ubuntu, CentOS, Red Hat, Barracuda ESG, Qmail and Zimbra Platforms.

• Operation and further development of the network and security infrastructure.

• Monitoring, analysis and resolution of network and security incidents.

• Cross-departmental collaboration with other teams on operations and further development, and reporting.

• Firewall vulnerability analysis.

• Firewall access requests.

• Troubleshooting IP communication issues on network and firewall infrastructure.

• Security-critical IT infrastructure, processing of personal data, compliance with legal requirements.

• Products: Palo Alto Networks Firewalls, Cisco ACI, Checkpoint Firewalls, F5

• Technologies: SDN, SDWAN, Cisco EPIC, Cisco ACI

• Creating concepts and architecture for domain integration (SEAT into the VW structure)
• Domain trusts and administration
• Operation and administration of Windows 2022/ 2025 servers and domains
• Domain restructuring
• GPO and SG editing and migration
• DNS restructuring and migration

Technologies: Windows 2022, Active Directory, ADFS, AD Azure Connect, DHCP, DNS, GPO, VMWare vSphere, Hyper-V, Powershell, Jira, MS Office 365,), SCCM, VSAN Fileservices, Approximately 800 servers, 400 users

• Developed a pilot system to control and monitor multiple GoPro cameras
• Implemented start, stop, status, media, download and diagnostic functions via COHN endpoints
• Built camera detection, individual and group control, and stable session/KeepAlive logic
• Set up a download pipeline with a queue, retry handling and temporary files
• Ensured consistent session, folder and file naming for multicamera recordings
• Integrated provisioning, certificates and network operations

• Extension of a Swing-based UI for recording Security Restricted Articles during baggage screening.
• Introduction of a new workflow for recording Deboarding Events.
• Extension of the reporting system for Security Restricted Articles and Deboarding Events.
• Implementation using JBoss Wildfly, PostgreSQL, spring-boot 3.x, Java 8/21, Swing, JSF, JAX-RS/Resteasy, Docker, Maven, Kiro.

Project – Evaluation and development of databases for a new product line for a measuring equipment manufacturer

• Current-state analysis
• Requirements analysis of the data storage layer
• Writing benchmark tests
• Design of the new database schema
• Database migrations
• Development of audit logging and Part11
• Creation of backup and recovery concepts
• Design of the persistence layer API
• Writing unit tests
• Creating requirements in Azure

Tools: C#, Visual Studio 2022, Azure DevOps, SonarQube, Git, RestSharp, WebServer, PostgreSQL, MS SQL, SQLite, MinIO, Podman, Docker, DataGrip, SQL Management Studio, HeidiDB, pgAdmin

Working Environment

• Insurance / Claims Management (Property, Liability, Automotive)
• REST-based ClaimAPI with Guidewire ClaimCenter

Scope

• Further development of the internal REST-based ClaimAPI with Guidewire ClaimCenter as the backend and various portals/front-end offices as clients, and with the following objectives: + increased AI-supported claims processing outside of Guidewire ClaimCenter + and support for all lines (property, liability, automotive).
• Further development of automated claims processing

Activities

• Interfacing IT & Business
• Design activities with documentation in Confluence, Jira: + Requirements engineering (functional and non-functional) + Design of REST endpoints and coordination with interface partners (esp. AI-colleagues) + Identification, design and evaluation of alternative solutions (moving away from a monolithic approach toward fine-grained endpoints, with code reuse across all lines if possible) + Creation / refinement of product backlog items in Jira, i.e. epics, user stories and tasks, incl. alignment with developers & POs during (pre-)refinement sessions + Using AXA Secure GPT when creating / refining user stories (description, acceptance criteria) and designing REST endpoints + Estimation and prioritization of user stories and tasks during Sprint Planning sessions + Coordination and support during the implementation of Product Backlog items + Driving decision making with preparation and presentation of decision-making documents
• Quality assurance: + Test management, including test case creation using Xray in Jira + Test execution using Bruno as REST client and in Guidewire ClaimCenter + Submission of test artifacts for PO approval + Analysis of production bugs

Methods Big Room Planning (aka PI-Planning in SAFe), Scrum, BPMN, EPK, UML, ERM, DDD

Tools / Tech Stack Teams, Confluence, Jira with Xray, OpenAPI/Swagger, REST, JSON, XML, MS Office, Bruno, GitHub repository (reading), Guidewire ClaimCenter, AXA Secure GPT (AXA's in-house GenAI solution based on Azure OpenAI)

As part of preparing and providing operational support for a company succession:

• Company analysis: Analysis of the overall economic, organizational and structural situation (current status, strengths/weaknesses, potential risks)
• Process analysis: Recording and documentation of all relevant business processes (BPMN, UML) in the areas of management, finance, purchasing, sales and operations
• Process optimization: Identification of weaknesses and inefficiencies, development and operational implementation of improvement measures
• Stakeholder management: Identification and analysis of all relevant internal and external stakeholders; structured communication and coordination with former and future owners, shareholders and employees
• Change management: Supporting employees and management throughout the handover process; building acceptance and trust among all parties involved
• Governance & documentation: Preparation and handover of structured operating manuals, process documentation and an organizational manual for the new business owner
• Risk & weakness analysis: Assessment of operational and strategic risks in the handover process and development of recommendations for action
• Operational support: Interim assumption of management responsibilities; ensuring business continuity during the transition phase

• Designed and developed a production-ready data platform based on Microsoft Fabric for an e-commerce company
• Built a scalable Medallion Architecture (Bronze, Silver, Gold) with Lakehouse and Delta Lake as the foundation for analytics and AI applications
• Developed a metadata-driven ETL platform with PySpark and a generic Incremental Loading Framework (SQL Server → Bronze → Silver → Gold)
• Developed reusable components for Microsoft Fabric Notebooks to standardize data integration, transformation, and validation
• Implemented automated data pipelines including monitoring, logging, error handling, and Delta MERGE strategies for stable production operations
• Built a business layer architecture for reporting, data warehousing, and reusable data products
• Integrated heterogeneous data sources via SQL Server, REST APIs, Amazon SP API, and Google Analytics 4
• Worked closely with business departments to analyze business requirements and translate them into scalable data architectures

Technologies: Microsoft Fabric, PySpark, Python, SQL Server, Delta Lake, Lakehouse, OneLake, Data Factory, Data Warehouse, REST APIs, Amazon SP-API, Google Analytics 4

• Built a data integration platform for high-, medium- and low-voltage assets to enable contextual analysis of time series with master data from SCADA control systems (IEC 60870 104), INIS and SAP.
• Responsible for the architecture and implementation of the solution, and acted as a sparring partner for the Product Owner.
• Technologies used: Kotlin, Spring Boot, Maven, TimescaleDB, PostgreSQL, liquibase, Elements IoT, Docker, Kubernetes, Grafana, Python, jupyter and various API gateways.

Development of AI and traditional models to analyze medical and patient data, including medication analyses, diagnosis analyses, forecasts, procedure analyses, dosage analyses, comorbidity analyses, prescription analyses, patient potential analyses, referral profile analyses, and prescription analyses. Analyses in the field of Real World Evidence.

Healthcare IT, pharmaceutical industry

Tasks, responsibilities:

• Gathering customer requirements
• Planning the subproject
• Designing and defining KPIs
• Designing and developing models and visualizations of results using customer dashboards
• Developing and implementing data warehouse adaptations
• Deriving recommendations for action

Methods, technologies:

• Simulation
• Artificial intelligence
• Python
• R
• SQL
• Microsoft Power BI
• Amazon Web Services
• Elasticsearch
• PostgreSQL
• Databricks
• Multivariate statistics

Product:

• Built a production-ready AI platform for generating brand-aware marketing images and videos from product data, user requirements, and uploaded media.
• Own the platform architecture, technical roadmap, API design, security, deployment workflow, operational reliability, and model-provider strategy.
• Developed the core platform in .NET and built supporting AI and workflow prototypes in Python, applying language-independent API contracts and structured interfaces between services and model providers.
• Implemented reliable background processing with RabbitMQ, persisted workflow state, idempotent handling, retries, failure recovery, logging, secure storage, authorization, and credit accounting.
• Made pragmatic build-versus-buy and model-routing decisions based on reliability, latency, cost, and maintainability rather than novelty.

Agent Orchestration & RAG Systems

• Built and compared agent workflows using Microsoft Agent Framework, LangGraph, and LangChain, including tool use, conditional routing, clarification steps, state management, and hand-offs between agents.
• Implemented reusable .NET components for agents, prompts, tools, model providers, structured responses, and retrieval with pyvector, making it easier to change AI providers without rewriting the core workflow.