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

• 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

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

• PRISMA project
• Ansible automation
• Windows third-level support for Windows NT, Windows 2000, Windows 2013, Windows 2016, Windows 2019

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

• Concept for database major / minor release automation

• Assessment of the current state

• Evaluation of Redgate Flyway functionalities

• Concept development

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

• Knowledge: 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

• Developed a SCIM-compliant Python interface to connect external systems
• Expanded and enhanced UCS modules in Python
• Extended and newly developed Helm charts for container orchestration in Kubernetes
• Maintained and further developed CI/CD pipelines in GitLab
• Implemented automated tests with Pytest and Playwright

'Nubus' is based on a microservice architecture, relies on open source technologies, and runs in Docker containers.

UCS is an IAM complete solution based on Debian, used as an alternative to Microsoft's Active Directory. The work was characterized by the close integration of infrastructure and application logic.

• Further development of the existing e-commerce platform based on SAP Commerce (Hybris) to meet the growing demands of digital commerce.
• Ensuring the scalability and performance of the backend, so the platform remained stable and efficient even under heavy user load.
• Development and integration of new OCC REST APIs and services for modular extensions and flexible adjustments, to implement new features quickly.
• Optimization of data flows and interfaces, which significantly improved platform efficiency and system performance.
• Ensuring a maintainable and scalable code base by using Clean Code principles, proven design patterns, and a future-proof architecture.
• Reduction of errors through extensive testing with JUnit, Mockito, and load tests with Gatling, supported by the introduction of automated test processes.
• Improved system performance through targeted refactoring measures and efficient database queries, especially to handle peak loads.
• Use of modern cloud and monitoring tools such as Kubernetes, Google Cloud Platform (GCP), and Grafana to ensure a stable and monitored infrastructure.
• Clear improvement in efficiency, scalability, and reliability of the platform, which now meets the demands of a dynamic and growing e-commerce market.

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

• 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

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

• Further development of the application landscape for Planing, Forecasting and Pricing

• Communication with internal stakeholders to standardize the application landscape across all companies

• Optimization of vendor management

• API and batch processing

• Creation of operating concepts

• Ensuring compliance with requirements and operating processes

• Supporting solution design as well as the implementation and further development of new applications and services

• ServiceNow

• Virtual Machines (Windows / Linux)

• M365 Products

• Azure DevOps

• Web Applications

Focus:

Consulting in reporting and project management for Power BI

Goal:

Creation of IT application dashboards for business areas

Activities:

• Technical consulting and support in managing and coordinating an existing reporting setup
• Structured collection, analysis, and preparation of business reporting requirements
• Technical coordination with defined internal contacts
• Design and optimization of Power BI reports to improve data analysis
• Development of concepts and recommendations for the further development of an efficient and transparent reporting system
• Support in the user-friendly visualization of relevant company KPIs as a basis for decision-making

Tools/Skills: MS-PowerBI, DAX, MS-Office 365, PowerQuery M, BCS