PL/SQL Experts in Munich

• Building, implementing and selling automated Data Science solutions such as Scorecard Factory and Forecast Factory
• Implementation of automated end-to-end cloud processes
• Development of LLM and NLP models
• Creation of interactive reports
• Support for national and international large corporations as well as medium-sized companies in implementing ML projects

Large Insurance Company – Consultant Wiesbaden: Consulting support for the introduction of an integrated planning and performance management framework (operational, financial, customer) to enhance customer-centric transparency, decision-making quality, and steering capabilities across all lines of business within an insurance organization:

• Analysis of existing processes, reports, KPIs, and KPI calculation methodologies
• Design and introduction of new, standardized customer KPIs (gross/net), as well as key steering metrics with consistent linkage across all lines of business
• Recalculation, validation, and plausibility checks of KPIs based on existing and newly integrated data sources
• Conceptual support for the development of an integrated reporting and performance management setup
• Execution of customer insights analyses to identify patterns and anomalies within customer data clusters

Large retail company – Consultant in Karlsruhe: Advisory services for the setup and step-by-step implementation of an internationally deployable RELEX solution in the supply chain management environment:

• Advising overall and sub-project management on methodology, project setup and steering (e.g. agile approach, Jira configuration, RELEX phases, Jira Structure PPM)
• Strategic-operational consulting for the introduction of RELEX including best practices
• Support in defining overarching goals and requirements (2-year target picture)
• Guidance in scoping a relevant supply chain network segment for the project
• Development of a roadmap for iterative, incremental RELEX setup and rollout
• Assessment of project dependencies (interfaces, configurations, etc.)
• Advice on prioritized implementation of business requirements and data interfaces
• Support in test planning (data validation, system testing, UAT)
• Consulting on internationalization, change management, training, and knowledge transfer
• Stakeholder advisory and alignment activities between the client, implementation partner, and RELEX

Insurance company – Management Consultant in Munich: Analysis, consulting and support for the optimization of a large-scale business and IT transformation. Focus on strategically important programs and modernization projects in the area of Managed Services Operations and processes:

• Review of project plans and deliverables; analysis of programs and projects (e.g. cloud approach, process standardization, system integration, roadmaps)
• Identification of technical, functional and personnel risks and challenges; development of content-related measures and alternative solutions
• Proposal of quality improvements for program and modernization efforts
• Sparring partner and professional, technical, structural and organizational consulting for project and program management

Large retail group – Management Consultant & Stream Lead in Cologne: Consulting, process, project and product management for the introduction and implementation of a large strategic program in the field of advanced analytics, assortment and space management:

• Setup, test and rollout of a new space planning, automation and optimization product based on the existing cluster-based merchandising approach
• Definition and setup of new processes and transformation and change management measures for the new store-specific merchandising approach
• Collaboration with Advanced Analytics and IT (internal and external) for software implementations, automations, extensions and interfaces
• MVP approach and piloting in phases with gradual rollout (pilot with 80 stores, region with 500 stores, national level with 4000 stores)

Large retail company – Agile Coach & Change Agent in Cologne: Agile coach, OKR master and facilitator for the introduction of the OKR approach in a large strategic digitization program for retail stores:

• Coaching of the core team with topic managers and team leads
• Introduction to the OKR topic and setup of the OKR cycle
• Establishment of the OKR approach in teams and on a cross-team level

Delivery and logistics company – Management Consultant in United Kingdom: Consulting and coaching in the restructuring of the Data Analytics department:

• Analysis of current challenges
• Definition of overarching goals
• Development of a proposal for a new team structure
• Identification of required competencies, skills and responsibilities
• Advisory and alignment on communication and change management strategy

• Data Engineering: Design and implementation of scalable data pipelines
• Legacy migrations to Microsoft Fabric (Lakehouse, Dataflows Gen2, Pipelines)
• BO Universe migrations to MS Fabric / Semantic Models / Power BI
• Taskforce for data-driven transformation projects involving Azure Fabric / Oracle / MSSQL

• Installation, maintenance and regular upgrade of the DB systems with 19x
• Use of OPatch and RU 19.27 on RHEL 8x, SLES 15.x and Windows
• DBA for DACH and European customers in production and last test environments (e.g. Konrad Adenauer) as well as others in CDB
• Processes via Confluence
• Support in operations for customers SR via Metalink

• Operations and extensions of Azure DevOps pipelines

• Operations and extensions of AWS services

• Citrix (Windows 10, Bitwarden)

• AWS: ECR, EKS, CloudFront CDN, Route 53, VPC peering and CNI upgrade, Atlas MongoDB, S3 buckets, static website hosting

• Azure: build and deploy with DevOps pipelines

Task

• Further development of a new ERP system with Blazor
• Creation of e-invoices with the XRechnung and ZUGFeRD format
• UI/UX design Client-server system
• Windows 11 Technology
• Microsoft .NET 9, Git, Azure DevOps, ASP.NET, MSSQL, Blazor Programming languages
• C#, MVVM Development tools
• Microsoft Visual Studio .NET 2022 Database
• MSSQL Industry
• Other

DWH for customer and financial data

• Extension of the DWH with new data sources
• Report development
• Data quality management

Methodology: Scrum

Tools: Atlassian Confluence & Jira

Databases: Microsoft SQL Server

Programming languages: SQL, T-SQL

ETL: Microsoft SQL Server Integration Services (SSIS)

Frontend platform: PowerBI, Microsoft Reporting Services

• Support and further development of a complex process for creating XML documents for electronic invoices / E-Invoicing (XRechnung, ZUGFeRD)
• Automation of operational processes, process development and optimization
• Development of frontend applications with MS Power Apps
• Porting SQL Server 2016 to SQL Server 2022
• SQL Server database administration

Project content: The use of “Generative Pretrained Transformer” technologies (GPT) will massively change the world of work in the coming years. ITZBund is developing a base service for this, which can be used by its 200 customers. This base service is offered as an on-prem and a cloud variant. Started in 12/23, from 05/24 productive systems (based on MVP) could already be rolled out and operated successfully for several agencies and federal ministries.

Project metrics:

• Budget in 2024 approx. €20M
• approx. 70 people in the core project context
• regular (indirect) contact with approx. 80 people in the wider project environment

My main tasks:

• Overall responsible external project manager
• Project definition phase/project setup and establishment of the project organization
• Strategic and operational project planning, as well as shaping and ongoing adjustments of the project
• Ongoing coordination with project owners and stakeholders in ITZBund
• Ongoing coordination with subproject managers, agile roles and other project staff
• Responsibility for project controlling, quality management, risk management and change management
• Responsibility for providing the base service on on-prem and cloud environments and its continuous development
• Planning and leading several hypercare phases
• Collaboration and ongoing coordination with a partner project of a federal ministry and provision of an MVP
• Coordination with agile teams
• Coordination with operations, release and deployment
• Responsibility for the implementation of the first customer projects
• Responsibility for creating an AI governance
• Ensuring accessibility (BITV)
• Responsibility for setting up a subproject for marketing activities
• Support in building an efficient proposal process
• Stakeholder management

Methodology:

• V-Model XT ITZBund
• Scrum

Tools used:

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

• Conducted a comprehensive due diligence review for a potential acquisition of a Swiss manufacturing company as part of a pre-merger analysis
• Assessed production capacities and technical infrastructure
• Evaluated integration possibilities into existing business processes
• Performed risk assessment and developed recommendations for action
• Documented the findings and presented them to management

• Implementation of a GitLab CI/CD pipeline based on SAP Commerce Cloud 2211
• Development of a new B2C shop with Vue, Node and TypeScript to ensure scalability, extensibility and performance optimization
• Integration of Microsoft Azure Event Grid with SAP Hybris
• Implementation of BDD with Cucumber using Gherkin syntax to promote collaboration between development and business teams
• Support and customization of a Spartacus shop
• Technologies/Languages: Java, REST, OData, Behavior Driven Development (BDD), Cucumber, Node, Vue, TypeScript, Spartacus, GitLab CI/CD, Gradle, Maven, Ant, SonarQube

• Designed and built from scratch the automation framework using Playwright, Typescript, JavaScript, Gherkin, Cucumber, BDD, Maven, IntelliJ IDEA
• Defined, developed and maintained test plans, test scripts, reports and other QA documentation in Confluence
• Created and maintained test data with SQL Server Management Studio, Toad and Faker.js
• Performed web services and API testing using Swagger Open API, SoapUI, JSON, HTML and XML
• Executed functional, smoke, regression, black box, GUI, cross-browser, UAT and E2E testing using CrossBrowserTesting and Safari Web Inspector
• Integrated and maintained automated scripts within sprints following Kanban, CI/CD, GitHub, Docker, Azure Pipelines, Agile, Scrum, Kafka and Kibana
• Raised and managed defects in Azure DevOps
• Conducted mobile testing with Robot Framework and Appium

• Concept creation and implementing AI Agents in AWS Cloud
• Continuously alignment with stakeholders
• Collaborate with DevOps
• Technologies: Git, CI/CD (GitHub Actions), Python/ML, Streamlit, Deno/typescript, AWS SAM, AWS Bedrock, AWS Lambda, AWS Dynamo DB, AWS S3, AWS Event Bridge etc.

• Backend development of B2B e-commerce solution using SAP Commerce Cloud, leveraging Java and Spring Framework with creation of REST APIs for effective communication.
• Resolved software defects, developed automated cron jobs and triggers, and authored unit tests with JUnit to uphold code stability and quality standards.
• Utilized Git-based version control systems (Bitbucket/GitHub) for source code management and used Jenkins to support continuous integration and development (CI/CD).
• Executed and closed multiple user stories and tickets across iterative bi-weekly sprints under Agile (SCRUM) methodology.
• Led incident resolution in the production environment and minimized downtime through real-time monitoring (Solr, SAP CCv2, OpenSearch Dashboards) and sustaining SLA targets above 99%.