Microsoft SQL Server Experts in Cologne

• Planning and implementation of a migration strategy for master and transaction data for the continuous loading of a cloud-independent database
• Creation and pilot implementation of a company-wide Business Data Model for customers, suppliers, contracts, products, prices, consumption, invoices, and dunning
• Concept and consulting for a Data Governance Framework incl. definition of committees, roles, processes, and metadata model
• Operationalization of the Data Governance Framework with definition of data standards
• Sub-project management in two pilot projects (PoCs) for Data Governance systems (ErwinDIS and Atlan)
• Training and coaching the data team in migration, data quality, and data modeling

• Project: ESU Windows and SQL Server consolidation / Configuration Management in ServiceNow
• Creation of an as-is analysis of all servers worldwide
• Creation of an as-is analysis of all SQL servers worldwide
• Creation of requirements analyses for SQL and server migrations
• Coordination of requirements with partners for migrations to Hyper-V (on-premises) or Azure Cloud
• Moderation of jour fixe meetings
• Creation of roadmaps and solution models for server migrations
• Setup of test scenarios
• Moderation of workshops for the introduction of a Global Admin Team
• Creation of data models (CMDB) in ServiceNow
• Conducting workshops for the CMDB data model
• Creation of solution models for the CMDB
• Creation of seamless configuration and work documentation for the CMDB
• Creation of reports for license management
• Creation of KPIs for data quality in ServiceNow
• Creation of a service catalog
• Moderation of workshops for creating service requests
• Interface between needs analysis and 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

• Coordination and planning, execution, documentation, and analysis of test cases
• Development of test concepts considering best practices (e.g., test pyramid) with a focus on reliable, automatable test runs
• Implementation and maintenance of test cases according to the test concepts
• Technologies: Citrix Workspace, Shopify, Jira, Xray, MS Teams, MS SharePoint, Confluence, MS Office 365

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

• Structured analysis and evaluation of business processes

• Gathering, documenting, and prioritizing requirements

• Creating business-friendly and technically executable process models

• Use of Camunda tools

• Deriving requirements and interfaces from BPMN diagrams

• Coordination with stakeholders and business units

• Translating business requirements into technical solution designs

• Implementing efficient and tailored applications

• Systematic collection, analysis, and documentation of requirements

• Prioritizing and validating requirements in close collaboration with stakeholders

• Alignment between business and development to ensure shared objectives

• Creating use cases, user stories, and acceptance criteria

• Continuous requirements and change management throughout the project lifecycle

• Define project goals and create project plans

• Delegate tasks and monitor project progress

• Monitor budgets and inform stakeholders

• Mendix: Architecture, development, and maintenance of custom applications (Microflows, Domain Model, Security, XPath)

• Modeling Mendix workflows for process optimization

• Develop scalable apps with Mendix including REST/SOAP integration with SAP, SQL, Azure & SharePoint

• UI design for Mendix using Atlas UI, Fluent UI, HTML, CSS, JavaScript

• Develop web & mobile apps with Mendix using agile methods (Scrum, Kanban)

• Implement business logic with Mendix Microflows and Nanoflows

• Performance optimization and architecture improvements for Mendix applications

• Conduct Mendix training

• Create technical documentation and best practices for Mendix

• Coaching and mentoring for low-code development with Mendix

• Automation of the database major / minor releases for the TKeasy project

• Concept for database major / minor release automation

• As-is analysis

• Evaluation of Redgate Flyway functionality

• Concept creation

• Products: Redgate Flyway, GitHub, Quest, Erwin Data Modeller, Oracle, Atlassian Jira, Atlassian Confluence

• Skills: Docker, Continuous Delivery, Continuous Integration, Redgate Flyway, Major Releases, Minor Releases

• Analysis of business requirements
• Integration of different data sources such as ERP systems, production systems, and external data sources
• Implementation of load processes and processing logic with MSSQL
• Data modeling and optimization of data models
• Setting up data quality management incl. data profiling with dynamic programming
• Support in designing and establishing data governance, especially in the areas of data quality management and data protection
• Support in developing BI solutions with Tableau to help decision-making processes

• Responsibility, also as rollout manager, for the successful transition of a basic OZG platform into the client's standard operations by planning and implementing measures along Service Transition and Service Operation according to ITIL, including workshops in a SAFe environment with more than 40 operational stakeholders
• Building and maintaining cross-organizational stakeholder relationships by organizing and running various information sessions on technical configurations and user guides (platform and EfA services)
• Designing and improving various operational and project documents such as the ITIL operations manual, OLA, SLA, service support concept and rollout instructions
• Modeling project-based processes according to BPMN 2.0, EPK and UML related to OZG services with the goal of integrating them into the operational e-government process landscape (SOA)
• Coordinating operational stakeholders and KPI reporting to the project management team using agile methods according to SAFe
• Tech stack / tools: Microsoft 365 (SharePoint, OneNote, Outlook, Teams), Skype for Business, Cisco Webex, ADONIS, MindManager, Jira, Confluence

• Design, planning and execution of complex acceptance tests for a document exchange platform for the German justice authorities.
• Validation of decrypted and certificate-based message exchange via web platform, mobile app, and Java API.
• Documentation of test cases, execution steps, and test results.
• Technologies: Windows 11/10, Ubuntu, iOS, Android, Bash for Windows, Java 17, IntelliJ, Git, Jira, Confluence, Citrix Server, xJustiz standard implementation, specific justice software.

The Helaba ATLAS project aims to modernize core systems and make them future-proof. As part of the subproject, the existing legacy system for international payments is being replaced by a modern web-based application.

• Analysis of functional and technical requirements
• Analysis and optimization of business processes
• Process modeling
• Preparation and facilitation of workshops
• Defining project scope and prioritizing requirements
• Business process management (analysis, modeling, and optimization)
• Specification of user stories
• Designing business and authorization concepts
• Testing and acceptance
• Designing mockups in Figma
• Creating the UI/UX style guide for web applications Approach: Scrum (agile) Technologies: Jira, Confluence, MS Teams, Conceptboard, Java, Vaadin, Figma

• Implementation of analytics and automation solutions for the Anti Financial Crime business unit
• Providing the infrastructure, including reusable data models and feature ingestion for production ML and rule based models in the areas of Account Take-Over and Card fraud detection, as well as Customer Risk Assessment
• Tools used: Snowflake, dbt, Looker, AWS, Python, Airflow, Metaflow

• A warehouse valuation system was reimplemented using Java, Spring Boot, and Camunda. The backend solution focuses on integration and batch calculations, the frontend on managing formulas and reviewing results.
• Java 21
• Spring Boot
• JPA
• Maven
• REST
• Kafka
• PostgreSQL
• DB2
• Liquibase
• Google Cloud Storage
• Keycloak
• GitLab CI/CD
• Helm
• Terragrunt
• SonarQube
• Angular
• IntelliJ
• JUnit 5
• Mockito
• Open API

• Developed a shop website
• Integrated an AI language model
• Developed tools for AI-powered webhooks
• Technical tools: REACT.js; Elevenlabs; MCP; n8n; HTTP

• Network elements, network, operational and operator-related systems
• Supporting around 20 different products (managed agile)
• Requirements analysis and management (functional and non-functional)
• Test concept and planning (scope, test phases, effort, schedule, resources, organization, etc.)
• Aligning approach with clients and service providers
• Managing and assisting in creation of test cases for system, integration and end-to-end tests
• Guiding and supporting test execution
• Defect management and planning bug fixes with external providers
• Preparing and facilitating workshops
• Regular reporting and creating automated test reports
• Further development of agile testing methodology and configuration of supporting tools
• Conceptual support in developing a quality seal for rating product and service quality of internal and external providers
• Requirements engineering based on ISO/IEC 25010, Scrum, SaFE
• BMC Remedy, Atlassian Confluence, Atlassian Jira (including plugins Xray, Structure), Microsoft Office (incl. Visio), Obsidian, doxis document management system, Gitlab, Obsidian