SQL Experts in Cologne

Project: Introduction of statutory-compliant electronic invoicing (outbound, Germany) in SAP for an international technology group.

• Project management: Planning, steering and reporting of the E-Invoicing outbound rollout across all affected business areas, including budget and resource coordination.
• UAT: Structured user acceptance test with key users per business area, test cases per invoice scenario, and consolidated test results for decision making.
• Defect management: Handover and tracking of defects in Jira, including validation of the generated invoices against the statutory schemas.
• Cutover, go-live and hypercare: Readiness checks and cutover planning aligned with the statutory deadlines, coordination of go-live and stabilization during hypercare.
• Stakeholder management and reporting: Alignment with Finance, Tax, business departments and IT, preparation of status reports and decision papers, and consistent follow-up of open items.
• Change management and documentation: Communicated process changes to the business departments, enabled key users, and created process and compliance documentation to ensure traceability and audit readiness.

Analysis and optimization of end-to-end processes in various business areas such as sales, procurement, order processing, and logistics. Redesign of the ERP system. Identification of optimization potential, especially in areas with media discontinuities and manual activities, as well as creation of a prioritized transformation roadmap with clear business cases and implementation recommendations. Management of automation initiatives. RPA at the production site in China. Evaluation and introduction of relevant AI use cases, as well as building basic AI capabilities within the organization. Training internal project team members and supporting them throughout the transformation process to develop a culture of continuous improvement. Close collaboration with IT and external implementation partners, with reporting to senior management.

Main responsibilities and achievements:

• Analysis of business processes and design of automated processes
• Training and support for employees in China and Germany
• 20% cost savings in logistics
• Regular status reports to senior management

With project PRIZMA, DB will modernize its infrastructure on the one hand, and develop a fail-safe IT landscape on the other hand, which can be restored quickly and securely in case of a disaster.

• Capture current architectures of existing systems as well as methodical consulting and development of target architectures
• Deepen and maintain the building plan / target IT landscape
• Implement technical architecture concepts & architecture descriptions
• Implement migration concepts for updating and further developing the platform and information systems
• Assess submitted improvement suggestions as part of the project
• Capability management: identify capability gaps, develop target visions, and support transformation planning within the enterprise architecture.
• Create a compatibility matrix of the components in use and compare dependencies of specific versions
• Create an IT concept for extending the platform with the following topics: hardware and software requirements, security, licensing, high availability, load balancing, backup & recovery, update strategy, monitoring integration, etc.
• Coordinate with business architects as well as technical architects from the cross-functional architecture area of the PRISMA program for the topics (backup, Active Directory, monitoring, Citrix, and business applications ...)
• Status meetings and alignment of project planning with the Release Train Engineer / Project Manager
• Advise the Release Train Engineer / Project Manager in identifying project risks
• Advise the System Architect Engineers in steering the implementation of the concept
• Implement the IT concept
• Document the infrastructure

Label: MS Project, LINUX, Windows, ORACLE, Java, REST, SharePoint, Microsoft Exchange, UML, Enterprise Architect, BPMN, AZURE, AWS, V-MODEL, Micro Service, VisualStudio, SAP S/4HANA, SCRUM(SAFE), ESB (TIBCO), Python, Innovator, LeanIX (TOGAF), Ansible, Ansible Tower, Ansible Automation, ROBOT, SpringBoot

• 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

• SPA for automated communication of medical findings with role-based access (Sanctum)
• Server-side LLM integration (OpenRouter) with structured processing
• Automated sending via SMS/voice call (Twilio, ElevenLabs) with queue + status retry
• Full test coverage with 80+ documented test cases

Technologies: PHP, Laravel, LLM API (OpenRouter), Twilio, ElevenLabs, Laravel Sanctum, PHPUnit, Playwright, Docker, REST

• Supporting the DevOps team in Terraform-managed, multi-region AWS infrastructure to achieve environment parity.
• Developed end-to-end CI/CD pipelines using AWS CodePipeline, CodeBuild, and CodeDeploy, automating the build and deployment.
• Maintained pre- and post-deployment scripts to automate critical tasks such as database schema migrations and environment sanity checks.
• Implemented CI/CD flow specifically for hotfixes via separate Git branches, managing back-merge activities from feature branches to release branches to ensure code integrity through automated conflict resolution.
• Deployed a dedicated, lightweight sanity check application hosted cost-effectively on Azure Container Apps to run automated health and basic functional checks as a post-deployment activity triggered via pipeline.
• Investigated production incidents through code changes and AWS CloudWatch logs.
• Coordinated integration of Dynatrace APM and its APIs for monitoring purposes.
• Full stack QA strategist for a high-traffic e-commerce platform built on a layered architecture for the back-end testing of core platform services, especially the order management system in Zed and Glue layers.
• Managed automation activities, testing process, and refactoring practices.
• Responsible for framework migrations, setup, and training for new automation frameworks.
• Promoted a shift-left approach within the QA team and created the test concept.
• Participated in meetings with IT managers, business owners, product owners, and team members.
• Designed and implemented contract testing to validate API schema compatibility between the order management system and the Zed and Glue layers, reducing production-relevant breaking changes by approximately 3%.
• Led the migration to a multi-environment framework that enabled test execution across 4 country configurations from a single codebase.
• Integrated automated unit and functional tests directly into the GitLab CI/CD pipeline, reducing pipeline runtime by 32%.
• Coached and trained 5 QA engineers across Germany and Hungary in test automation, framework architecture, and best practices.
• Architected a layered backend test automation framework separating business logic, API request builders, and the database layer.
• Piloted AI-assisted testing with Playwright Agents, the Playwright MCP Server, and GitHub Copilot for automated test generation, execution, and self-healing Playwright scripts.

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

• Created an application to control measurement hardware with a Tauri application using React.JS and TypeScript on Raspberry Pi
• Developed a cloud application for storing and analyzing measurement results using Spring Boot and React.JS
• Built a Tauri application for printing ZPL labels on Windows
• Technologies: Java, JavaScript, Tauri, Rust, React.JS, AWS, Kubernetes, Docker, GitLab CI/CD, REST API (JSON), Maven, CI/CD, PostgreSQL

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

Industry: digital sovereignty, public sector

Responsibilities:

• Project coordination (teams: consulting, development, testing, deployment/operations)

Products and standards:

• Jira, Confluence, Asana, Miro, Mural
• Open Source, Keycloak, Open Xchange, ownCloud

Project: Digitalization of Warehouse Processes | Building a Data Analytics Platform.

• Built a web-based workforce allocation system that digitized daily shift planning by matching worker expertise to operational zones, replacing manual coordination with a structured workflow adopted across the site, saving supervisors time on daily planning.
• Developed a real-time operational visibility dashboard giving supervisors a live view of task throughput and outstanding workload across warehouse zones throughout the day, helping reduce overtime and idle labour costs.
• Developed a slotting optimization solution to improve warehouse picking efficiency and reduce picking time per order, working directly with operations teams from concept through production deployment.

Technologies used: Python, Django, PostgreSQL, Pandas, NumPy, HTML, Java, JavaScript, Docker, Kubernetes, AWS, Power BI, GitHub Actions CI/CD, GitOps, Claude, OpenAI

• 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

• Backend WordPress web development.