Oracle SQL Developer Experts in Munich

• 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

• Replacement of a Java application and the Oracle DB for loading the internal WerWasWo system using SSIS.
• Development of SSIS packages to load text files into the database (SQL Server)
• Development of a database project for deployment on various servers
• Creation of queries to monitor the loading runs
• Development of a PowerShell script to automate the deployment of the SSDT projects.
• Oracle, SQL Developer, Microsoft SQL Server 2022 on-premises, SQL Server Management Studio v21, Visual Studio 2022, SSIS, SSDT, PowerShell.

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

• 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

• 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

• Overall process definition, planning, training, tools, effective execution, and progress and quality measurement of test activities at the release level
• Defining and improving the test process
• Scheduling of releases
• Coordinating alignment with release management for test setup and data provisioning
• Coordinating migration test planning for Westnetz, Mitnetz, and EON Grid
• Monitoring test progress, audit-proof documentation, progress tracking via defects, OSS reports, and incidents
• Designing and coordinating potential test automation

IT environment: Jira Zephyr, Confluence, SIGMA, PowerBI

• Coordination of implementing IT projects, subprojects, and enhancements within DevOps
• Management of IT service providers and responsibility for the quality of IT systems while meeting strategic guidelines
• Assisting in the creation of security-relevant IT documents, including security profiles, Data@Cloud, SCA, and penetration tests
• Full project management responsibility: monitoring and ensuring adherence to resources (scope, schedule, cost, and quality)
• Defining requirement profiles for external service providers and reviewing and evaluating proposals
• Supporting the setup and management of Windows and Linux servers in collaboration with Infosys, including configuring and enabling network ports

• Transformation project to S/4HANA
• Test management and coordination of functional tests for SAP
• Preparation and support of tests (SIT 1+2, MOCK 1+2, UAT) as part of the SAP S/4HANA rollout (SD, MM, FI/CO, MD)
• Creation of test strategies, test plans, and test cases to ensure system quality
• Monitoring and compliance with service level agreements (SLAs) as well as ensuring the timely delivery of agreed performance indicators
• Coordination of the approach with test managers from other regions (US, JP)
• Planning of European test activities in the SAP implementation project in cooperation with test managers from the supplier
• Coordination of interdisciplinary business and technical test teams in Europe
• Business collaboration with global implementation partners
• Use of Tricentis qTest and ValGenesis as test management tools (for validation-relevant processes)
• Training functional consultants in testing and test tools
• Creation and evaluation of change requests, including effort estimation, prioritization, and tracking
• Reporting on test progress

• SBAM (Sendungsbasiert Auftragsmanagement System) is the core component responsible for splitting customer deliveries into individual letters based on contractual agreements (OLA/SLA).
• Transformation from proprietary host-based AS/400 applications to a modern stack using Java, PostgreSQL, Apache Kafka, MinIO S3, Red Hat OpenShift, Keycloak SSO, Salesforce and Angular Material GUI.
• Application design, solution architecture, use case specification and OLA/SLA concept for end customers.
• Conduct solution architecture/design and requirements engineering (elicitation, documentation, validation, negotiation and ongoing management) in Confluence, including UML/BPMN process models.
• Development and analysis according to Scrum using Jira and Confluence.
• Design user journeys and UI experience; wireframing with Balsamiq and Figma.
• Document requirements as user stories and epics in Jira; create stakeholder and technical design documents.
• Participate in end-to-end solution design, architecture and event-driven messaging design.
• Perform process modelling (UML/BPMN with Draw.io), application internal architecture design and ERM/SERM data modelling.
• Lead sprint planning, story refinement, estimation, retrospective and review meetings; deliver C-level management presentations on OLA/SLA and order management.

• Maintenance of a company-wide Oracle database that consolidates information from various internal databases, Active Directory, and other systems

• Data transfer via Oracle jobs between the monitoring database and other systems

• Data visualization and processing using APEX and Oracle Forms (with Forms being replaced by APEX)

• Gathering requirements from business units

• Designing the implementation

• Implementation at the database level and in APEX

• System maintenance

• Troubleshooting

Technologies: Oracle 12, Oracle 19, Oracle PL/SQL, Oracle APEX, SQL Developer

• Further development of the vergleich.de website

• Development of new and improvement of existing backend services as microservices

• Deployment via TeamCity and GitHub Actions

• Development of monitoring tools

• Development of REST APIs

• Database migration from Oracle to PostgreSQL

• Java and Kotlin (including Spring, Spring Boot, JPA, Hibernate)

• Angular (TypeScript) and JavaScript

• IntelliJ IDEA and WebStorm

• Apache Maven

• Oracle DB (and SQL Developer), MongoDB, PostgreSQL DB

• Git (GitLab, GitHub, BitBucket)

• TeamCity

• Jira

• Docker

• JUnit, Mockito, jasmin

• Migration of a mainframe application (PL/1, zOS) to the cloud (Azure)
• Data transfer from z/OS (USS) to Azure storage (blob containers, file shares)
• Implementation of the mainframe job control in Java
• Mapping of job network dependencies in Control-M
• Performance analysis and optimization measures
• DB2 (z/OS) migration to Postgres (Azure)
• Technologies: Azure (storage, VM, VMSS, Postgres), z/OS (USS), DB2, Postgres, Packer, Terraform, Docker, Jenkins, GitHub Actions, Control-M
• Tools: Eclipse, Visual Studio Code, IntelliJ

• IT infrastructure services
• IT services, networks, Exchange, Office 365 & 2016
• IT documentation
• Collaboration with external partner & managed provider
• Stakeholder management

• Architecture, design and further development of a hybrid solution consisting of a Java backend with REST API and C# / WPF frontend
• Development of secure, distributed functions for classified message processing, categorization and encryption
• Integration of backend services with document management systems (DMS) for structured file storage
• Planning, setup and continuous optimization of Azure DevOps pipelines for automated deployment and quality assurance of distributed applications in a security-critical environment
• Technical coordination with Bundeswehr project managers and third-party providers of relevant software and interfaces, and documentation of the developed solutions