Microsoft Excel Experts in Cologne

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

• Managed end-to-end data workflows for LCA and carbon footprint assessments, including data collection, validation, structuring, and LCI modeling for metal alloys, ensuring high data quality and traceability.
• Developed a basic Excel automation tool to simplify carbon footprint calculations of metal alloys, replacing repetitive modelling in the software that previously took several hours.
• Communicated environmental impact results through quantitative analysis, visualizations and reports to support the broader project strategy.
• Performed environmental hotspot and scenario analysis to identify key impact drivers and assess opportunities for emissions reduction.

• 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

• 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

• Planning, optimization, and analysis of SEA and Meta campaigns
• Planning and execution of automations and mailings
• Optimization of landing pages (funnel, structure, copy, image)
• Creation of creatives, media plans, and reports
• Planning and support for the move to server-side tracking

PLANT-MY-TREE®-per-order

The application enables Shopify merchants to automatically place tree-planting orders for every incoming order. By integrating ecological contributions directly into the purchase process, the manual effort for tracking and billing reforestation initiatives is eliminated. The system increases transparency for end customers through real-time visualizations of the ecological impact directly in the storefront. The architecture is based on a modular monolith with Spring Boot in the backend and an integrated React app inside the Shopify admin area. The solution uses webhooks to capture order data in an event-driven way and integrates the weclapp ERP system for automated monthly invoicing. An app proxy mechanism provides dynamic statistics such as CO2 compensation and planted trees without any performance loss for the merchant shop.

Tasks:

• Design of the modular software architecture based on Spring Modulith to ensure high maintainability
• Development of the event-driven business logic for evaluating Shopify orders via webhooks
• Implementation of automated invoicing by connecting the weclapp REST API
• Building the frontend using React Router and Shopify App Bridge for native integration
• Design of the database model and implementation of the persistence layer with JPA/Hibernate and Prisma
• Integration of internationalization processes for global use in the frontend and email communication
• Automation of deployment processes using Docker and GitLab CI/CD

Project skills: Java 25, Spring Boot, Spring Security, Spring Modulith, Hibernate, JPA, REST API, PostgreSQL, Maven, Liquibase, React, TypeScript, React Router, Vite, Node.js, Prisma, Zod, Docker, Docker Compose, GitLab CI/CD, Shopify CLI, Shopify App Bridge, Polaris, weclapp, i18next, Lombok, Vitest

• Integration of medical modalities (including ultrasound) into the existing IT infrastructure (DICOM, HL7) – put into operation within the planned timeframe.
• Administration and optimization of PACS systems for efficient archiving and distribution of radiology image data across multiple locations.
• Ensuring consistent data quality and seamless interoperability in data exchange between HIS, RIS, and PACS.
• Close collaboration with medical staff to analyze and digitally optimize clinical workflows.
• Requirements management and test coordination when implementing clinical requirements in complex IT structures.

• Sourcing contractors, temp labour and direct-search suppliers
• Advisor to procurement and HR on a change project

Consulting on and implementation of technical processes in CRM and email marketing, international project management

• 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

AI Strategy & Enablement for SMEs Management consulting – SMEs (e.g. marketing boutique, IT & office services)

Concept and delivery of structured AI introduction and strategy workshops for small and medium-sized businesses. Result: Practical AI status assessment, prioritized use case list, and management decision template as the basis for the next steps in the company’s AI development.

Activities

• Needs analysis and individual preparation of the consulting formats
• Facilitation of a structured AI status assessment including vision, mission, and target picture
• Identification and prioritization of relevant AI use cases and action fields
• Creation of management decision templates and roadmaps
• Raising awareness for opportunities, risks, and success factors of AI introduction
• Support for first customers with AI-supported automation scenarios
• Supporting people and teams through the change process of AI introduction (CM)

Methods / Tools / Technologies

Methods:

• AI status assessment & use case analysis
• Workshop moderation / facilitation
• Requirement Management
• Change Management (PROSCI)

Tools:

• Generative AI tools (e.g. ChatGPT, Claude)
• Automation/AI coding tools (e.g. n8n, Claude Code, Visual Studio, Antigravity)

Technologies:

• Prompt engineering
• AI workflow automation

• Business development in the Middle East (Abu Dhabi, Dubai, Ras al Khaimah, Oman, Bahrain, Qatar) for PE management consulting and leadership training, training and further education, HR development
• Active participation in delegation trips to Oman, Dubai, Abu Dhabi and Bahrain/Qatar including follow-up support and customer visits on site, preparation of training and consulting offers, negotiations with local and international contacts
• Networking and sales on site (Abu Dhabi and Dubai) in cooperation with a local consulting and business development company

• Project management for the location consolidation of a major telecom provider (client: Telefonica) since 2023
• IT multi-project management for a large leasing company (client: Athlon) from 2021 to 2022
• Migration of applications to the cloud and to another data center
• Extension and optimization of the application landscape through additional projects
• Project management for developing a platform for internet access on airplanes of various airlines (client: m3Connect/Deutsche Telekom) 2021
• Responsible leadership of an IP network consolidation (infrastructure project) at a major telecom provider (client: Cisco/Vodafone) from 2017 to 2020
• Planning and coordination of migrations and rollouts
• Team leadership integrating different teams (network operators, hardware and service suppliers)

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