Microsoft Excel Expert in Cologne

Transformation assignment: IT Operating Model and Governance

• Management of the operationalization of a new IT operating model for a service- and customer-oriented organization in the managed services and Microsoft 365 environment.
• Translation of the target organizational model into concrete roles, responsibilities, organizational elements, decision-making paths and collaboration principles.
• Design and operationalization of a layered model with autonomous delivery teams, supporting units and clearly defined governance functions.
• Design of governance for Service Delivery Management, People Leads, Global Service Owners (GSO), operational teams, clusters and management committees.
• Structuring of the transformation rollout into ramp-up, implementation, hardening and operations, as well as development of kick-off, communication and feedback formats.
• Further development of PMO and office structures as well as portfolio and workforce management to create transparency around resources, risks, dependencies and decision requirements.
• Facilitation of cross-functional workshops and decision-making meetings, and translation of different stakeholder interests into actionable principles, rules and measures.

Interim assignment: IT Service and Operations Management

• Assumption of operational responsibility for Citrix and AD/Access, including incident, escalation, transition and quality management in day-to-day operations.
• Clarification of operational interfaces and clear separation of responsibilities between internal units, Service Delivery Management and external service providers.
• Conduct of structured GAP analyses of existing service descriptions, preparation of make-or-buy decisions and clarification of roles with KPI integration.
• Management of conflicting objectives, dependencies and escalations in complex customer, operations and transformation situations.

Selected results

• The transformation target model was translated into directly applicable roles, governance rules, organizational elements and rollout formats.
• Decision-making paths, responsibilities and interfaces between operational delivery, supporting functions and management were described transparently and bindingly.
• The foundations for self-organized teams, standardized service descriptions and reliable portfolio, resource and management transparency were established.

Methods: Operating Model Design, Governance Design, RACI, GAP Analysis, Stakeholder Analysis, Workshop Facilitation, Change Communication, Risk and Escalation Management, KPI and Service 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

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

Successful delivery of projects on behalf of customers:

• -> 2023 – present: Project management for the consolidation of sites/data centers for a large telecommunications provider (infrastructure project, customer: Telefonica)

• Opening and preparing new sites

• Application migrations

• Decommissioning and handover of old sites

• -> 2021 – 2022: IT multi-project management for a large car leasing company (customer: Athlon)

• Migration of applications to the cloud and to another data center

• Additional projects to expand and optimize the application landscape

• -> 2021: Project management for the development of a platform providing internet access on aircraft operated by various airlines (customer: m3Connect/German Telekom)

• -> 2017-2020: Responsible management of an IP network consolidation (infrastructure project, customer: Cisco/Vodafone) at a large telecommunications provider

• Planning and coordination of migrations and their rollout

• Team leadership and integration of different teams (network operators, hardware and service providers)

• 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

• Backend WordPress web development.

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

• Project manager for transition and migration of IPC Trader Telephony to 3CX-based dispatcher and Cloud9-based trader telephony
• Planned and managed company-wide replacement of IPC Trader Telephony with 3CX and Cloud9 solutions
• Continuous improvement of implementation processes and development and execution of optimization measures
• Planned, coordinated and tracked delivery of IT equipment and service provision at all sites
• Led a team of IT site managers to ensure IT services were delivered on time, within budget and with required quality
• Defined project scope in coordination with all business resources
• Planned and executed software and hardware rollouts, including user support during implementation
• Communicated with key customers and service organizations and collaborated with traders, telephony architects, app owners, testers and technical IPC teams
• Conducted stakeholder analysis for creation and maintenance of change management processes
• Managed full change process: prepared change requests, defended them in change board, communicated at company and user level, and supported change implementation

• 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