PL/SQL Experts in Munich

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

• 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

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

Task

• Further development of a new ERP system with Blazor
• Creation of e-invoices in the XRechnung and ZUGFeRD formats
• 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

• Design, development, and maintenance of end-to-end ETL pipelines for scalable and reliable data integration
• Support in data quality checks, testing, and migrations
• Development and maintenance of dbt models for structured, modular, and reusable data transformations
• Use of AI-driven development to improve ETL job creation and code quality.
• Development of CI/CD for automated deployment.

• 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

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

• Business and technical consulting for master data provisioning and process management
• Support for transition management
• Process optimization
• Interface definition

I have worked across multiple international client projects, holding senior roles including Software Architect, Senior Software Developer, Technical Lead, and Lead Backend & DevOps Engineer. My experience spans complex enterprise environments in banking, financial services, telecommunications, engineering, and automotive domains, supporting organisations such as UniCredit Bank, Telefónica O2, and BMW.

At UniCredit Bank, within the Securities Domain Transformation program, I led the modernisation of legacy monolithic systems into cloud-native Spring Boot microservices and an Angular frontend deployed on Google Cloud Platform. Beyond implementation, I was responsible for defining the target architecture, producing system architecture diagrams and sequence diagrams, and preparing API contract documentation for clients. I designed RESTful APIs and integrated Apigee for secure and reusable cross-project service consumption of APIs. I architected Kubernetes-based deployments using Helm. CI/CD pipelines were built with Jenkins, automating code analysis using Sonar, as well as testing and deployment stages. Defining clean coding principles for the project, conducting regular code reviews, and mentoring junior developers were also among my tasks at UniCredit.

At Telefónica O2, I led the transformation of a legacy call centre desktop application into a cloud-native microservices and micro-frontend solution. I actively contributed to the platform architecture, creating system architecture diagrams, component diagrams, architecture documentation, and ADRs for future references. I improved the performance and scalability of the services. I optimised AWS infrastructure costs, particularly by minimising the use of DynamoDB and reusing test environments effectively. Observability was implemented using Prometheus, Grafana, CloudWatch, and Splunk dashboards. CI/CD pipelines were delivered using GitLab, Docker, Kubernetes, and AWS. Conducted techinical sessions for teams.

• Create a product and service portfolio delivering a 360 degree approach to digital corporate sustainability covering KPI management, CSRD reporting and sustainable strategy
• Create vision and business case
• Onboard and align business partners, negotiate contracts
• Set up partner network as self-organized agile team
• Co-develop product and service portfolio
• Coordinate sales and marketing, go-to-market strategy and roadmap