PL/SQL Expert

Project – Evaluation and development of databases for a new product line for a measuring equipment manufacturer

• Current-state analysis
• Requirements analysis of the data storage layer
• Writing benchmark tests
• Design of the new database schema
• Database migrations
• Development of audit logging and Part11
• Creation of backup and recovery concepts
• Design of the persistence layer API
• Writing unit tests
• Creating requirements in Azure

Tools: C#, Visual Studio 2022, Azure DevOps, SonarQube, Git, RestSharp, WebServer, PostgreSQL, MS SQL, SQLite, MinIO, Podman, Docker, DataGrip, SQL Management Studio, HeidiDB, pgAdmin

• Optimized the data architecture (Medallion) to better decouple processing steps and improve transparency and reproducibility

• Ensured the technical quality of data processing in Databricks by introducing schema enforcement, data quality checks, and a structured data architecture

• Pipeline orchestration with Azure Data Factory

• Improved and automated the development and deployment process by integrating Git and GitHub Actions

• Technical leadership of the Data Engineering team (3 employees)

• Led workshops to optimize and stabilize the data platform and development process

• Collected and prioritized new requests and maintained the product backlog

• Technologies: Microsoft Azure (Data Lake, Data Factory), Databricks, Apache Spark (PySpark), Python, SQL, Git, Confluence, Power BI, Power Apps, Dataverse, MS Sharepoint, Mural

• ITSM consulting, analysis, and optimization of IT capacity using BMC TSCO / BMC Helix
• Developed the concept for “Governance Guidelines for Operational Capacity Management”

Project overview: The use of “Generative Pretrained Transformer” (GPT) technologies will greatly change the world of work in the coming years. ITZBund is developing a basic service for this purpose, which can be used by its 200 customers. This basic service is offered both on-premises and in the cloud. Launched in 12/23, production systems (based on the MVP) had already been successfully rolled out and operated for several authorities and federal ministries by 05/24.

Project metrics:

• 2024 budget approx. 20 Mio €
• approx. 70 people directly involved in the project
• regular (indirect) contact with approx. 80 people in the wider project environment

My main responsibilities:

• Overall responsibility as external project manager
• Project definition phase/ Project setup and establishment of the project organization
• Strategic and operational project planning, as well as project design and ongoing adjustments
• Ongoing coordination with the project owner and stakeholders at ITZBund
• Ongoing coordination with sub-project managers, agile roles, and other project team members
• Responsibility for project controlling, quality management, risk management, and change management
• Responsibility for providing the basic service in on-premises and cloud environments and its ongoing development
• Planning and leading several hypercare phases
• Collaboration and ongoing coordination with a federal ministry partner project and delivery of an MVP
• Coordination with the agile teams
• Coordination with operations, release, and deployment
• Responsibility for delivering initial customer projects
• Responsibility for developing AI governance
• Ensuring accessibility (BITV)
• Responsibility for setting up a sub-project for marketing activities
• Support in setting up an efficient proposal process
• Stakeholder management

Approach:

• V-Modell XT ITZBund
• Scrum

Tools used:

• Microsoft Office, Skype, MS Project, Confluence, Jira, Sharepoint, Miro

The Base Services of DB InfraGO form a central data hub between the company’s IT systems. Common Data Services are developed that distribute data from source systems to a variety of downstream systems (via JMS) and make them available (via REST API). The existing service landscape based on TIBCO is being migrated to DB InfraGO’s cloud-native platform.

• Architecture design and implementation for performance-optimized bulk data processing of several million datasets at specific times during the day
• Technical specification and documentation of business requirements
• Integration of various subsystems (including SAP and Salesforce) through the reimplementation of more than 40 microservices based on Spring Boot
• Migration of TIBCO Based microservices from the Enterprise Integration Platform to the Cloud Native Platform using Spring-Boot
• Establishment of a deployment pipeline using GitLab CI/CD, Artifactory, and automated deployment to a Kubernetes environment with the help of ArgoCD
• Definition and implementation of automated unit, integration, and regression tests

Team Size: 9

Technologies/Tools: Java, Spring Boot, ActiveMQ(JMS), JUnit, Tibco Business Works, Gitlab (CI/CD), Kubernetes (Amazon AWS), ArgoCD, postgreSQL, Oracle, Postman, Hoppscotch, openAPI, Sonarqube

• Consulting, training and coaching in the financial sector on strategy, organization and IT topics

• MorgenFund: Advising the operator of a fund platform on software selection for a sub-ledger "Cash Accounts" based on virtual IBANs (VIBAN)

• Structuring requirements, market screening, preparing RfIs, communicating with vendors and conducting the selection process

• UniCredit/HypoVereinsbank: Workstream Lead "Booking and Customer Reporting" in the payment transformation project "PULS"

• Business analysis, preparing business requirements and coordinating the solution items as part of the functional specification with the bank's IT service providers

• Business analysis of SEPA CT and SWIFT MX (.camt-, .pain- and .pacs- formats), change management, team leadership for a virtual team of fifteen line experts and stakeholder management

• equensWorldline Germany: Program management for three projects of the SWIFT Service Bureau (CBPR+, ESMIG and Euro1Step1 migration) as part of the SWIFT MX migration

• Managing individual project leads with regard to cross-project goals and requirements; reporting to internal and external committees and stakeholders; coordination with dependent projects and programs

• Project management/PMO: Interim project management, deputizing for project leads, resource planning, budget and cost management, general PMO activities

PMO & Project Organization Blueprint for Restructuring

Renewable Energy / Solar Equipment

Technologies / Methods: PMO setup, KPI tracking, project organization, Jira, Confluence

• Developed measures to improve management control during a restruct...

• Administration and further development of the M365 environment, including Teams, Exchange Online, Intune, and SharePoint Online
• Development of dashboards for performance monitoring with Microsoft Power BI
• Implementation of user requirements and processes with low-code/no-code technologies (Power Apps, Power Automate)
• Use of Jira and Azure DevOps to plan and implement user stories in an agile project context
• Participation in daily stand-ups, sprint planning, sprint reviews, and retrospectives as the technical point of contact
• Planning and implementation of security policies using Azure Conditional Access and multi-factor authentication
• Configuration and deployment of clients and applications via MECM (SCCM) and Baramundi

• Led discovery phase and POC for Shopware to Shopify Plus migration across EMEA markets, evaluating platform suitability, technical architecture, and multi-brand/multi-country capabilities against business requirements.
• Designed reference architecture for Shopify Plus implementation incorporating headless front-end patterns (Vue.js, Nuxt.js), CMS integration (Magnolia), and Azure middleware (APIM, Functions, Logic Apps, Service Bus) for 11 EMEA markets.
• Defined migration strategy analyzing data mapping, cutover approach, and zero-downtime deployment patterns using Varnish caching, GitOps pipelines, and CI/CD orchestration across six vendor teams.
• Architected multi-tenant Shopify Plus governance model with centralized admin, localized storefront customization, and compliance controls (GDPR, data residency).
• Prototyped AI-driven search optimization (LLM.txt, JSON-LD) for product discoverability in Google AI results, demonstrating post-launch performance opportunities.
• Defined EMEA expansion roadmap for 15+ markets through C-level strategic workshops, identifying phased rollout, market-specific configurations, and resource requirements.
• Tech Stack: React, Nuxt.js, Vue.js, Magnolia CMS, Shopware, Shopify Plus, Azure (APIM, Functions, Logic Apps, Service Bus, Front Door), Varnish, SAP, MS Dynamics, Docker, Kubernetes, GitHub Actions, PostgreSQL, Kafka

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

• Ride-sharing and bus platform, live and fully functional. Backend with Spring Boot 4.1 on Java 21, PostgreSQL with Flyway, and Testcontainers integration tests. Hosted in my own AWS account (ECS Fargate, ALB, ECR, IAM Least-Privilege) with CI/CD via GitHub Actions and OIDC federation without static credentials. Development fully AI-supported with Claude Code, including custom skills and project-specific memory. Spring Boot · Java 21 · PostgreSQL · Flyway · Docker · AWS ECS/ALB/ECR · CI/CD · GitHub Actions · Claude Code

• Introduction of a new payment term including its description, as well as a new shipping condition
• Configuration of item category determination (Item Category Determination)
• Implementation of the minimum price calculation (Floor Price) in the pricing procedure
• Setup of the intercompany third-party transaction (direct delivery) and addition of the direct delivery indicator to the invoice
• Prevention of delivery splits (Delivery Split) in sales orders
• Masking of the expiration date and net weight fields
• Transfer of the sales group from the quotation to the sales order
• Analysis and resolution of a pop-up appearing when creating sales orders
• Analysis and resolution of order confirmations that were created and sent with €0.00 per item

Topics:

• Further development of the CRM system NKAM and technical separation of “direct” and “indirect” sales
• Redesign of the discount management area and outsourcing to another system.
• Designing numerous improvements on the wholesale side to reduce manual effort down to the level of user stories.

• Setting architectural standards for Informatica Power Center development teams
• Maintenance-performance-health for DWH (Exadata) environments
• Qlik Sense / BO reports architectural standards
• Implementing best practices in ETL tasks
• Documentation ETL standards on Confluence
• Dynamic Data Masking rules for GDPR/KVKK regulations by using Informatica DDM tool
• DWH Data model Power Designer
• Upgrade Qlik Sense versions
• Merge all Informatica server's repository databases on one Oracle DB