Oracle SQL Developer Expert

• Focus: System architecture, cloud-native platforms, microservices, API design
• Product: Pflege-Pfad is a digital placement platform that directly connects relatives of people in need of care with verified care services and caregivers – without an agency and without ongoing fees.
• Business analysis & process design:
• Analysis of the German care market and identification of the key pain points of both target groups.
• Modeling of core business processes: registration, verification, care request, application, placement, and rating.
• Definition of the business model as a freemium/premium model with optional contact unlocking.
• Creation of user stories and requirements documentation for relatives, care services, and administrators.
• Design of trust and quality assurance mechanisms with document upload, admin review process, and rating system.
• Coordination with stakeholders and validation of product decisions with potential users.
• Technical implementation:
• Design and implementation of the entire platform architecture as the sole developer.
• Design and implementation of a REST API with Spring Boot and Kotlin, including JWT-based authentication.
• Development of the frontend as a single-page application with Angular 17.
• Implementation of the AWS infrastructure with EC2, RDS PostgreSQL, S3, CloudFront, and IAM.
• Document upload with AWS S3 using presigned URLs to verify care services.
• Email notifications via Resend API.
• AI-supported care service search via OpenAI API.
• Implementation of complete user flows such as registration, login, password reset, and the placement process.
• Development of an admin panel for user and care service management as well as analytics.
• CI/CD with GitHub Actions and containerized deployments with Docker.
• End-to-end tests with Playwright.

Technologies: Kotlin, Spring Boot 3, Spring Security, JWT, JPA/Hibernate, PostgreSQL, Angular 17, TypeScript, RxJS, AWS (EC2, ECS, S3, CloudFront CDN, RDS PostgreSQL, IAM), nginx, GitHub Actions, Playwright, Maven, Git, OpenAI API, Resend API, Docker, Scrum, i18n (DE/EN/TR), Kiro, feature flag architecture.

• Supporting the International Web Presence of the BA (IntWeb) project in the area of quality management, with the aim of taking responsibility for the quality of processes and project results while considering BA standards. The main objectives of the project are to give professionals abroad a quick overview of their opportunities for moving to Germany and to enable them to take the necessary steps consistently and with digital support by providing access to services.

• Defining the general guidelines in the QA handbook

• Summarising test results in QA reports for PLA

• Analysing project results for improvement opportunities

• Quality management of requirements analysis (particularly processes, methods, and tools)

• Ensuring compliance with SERA requirements

• Creating a cross-project test concept

• Agreeing on sprint completion reports

• Formal review of work results in accordance with requirements and/or the project plan

• Contact person for internal audit, external audits by auditors, or BRH (Federal Court of Audit)

• Technologies: JIRA, Confluence, MS Office, GitLab, Kubernetes

• Designed a migration strategy for WLS applications to BKA Cloud and Stack IT

• Created a hybrid cloud for internal testing and development with Kubernetes

• Transformed the IT landscape from an outdated monolithic architecture to a cloud-based architecture

• Integrated new CI/CD processes using Azure Pipelines

• Quadrupled the processing throughput for personnel security checks

• Migrated personnel security screening applications to Docker-based applications

• Implemented CI/deployment pipelines using Azure DevOps

• Environment: Java Springboot, Kubernetes, Oracle Weblogic, OpenID, Camunda, JUnit, TOGAF

Methodology: Agile project management

Goal: Digitization and implementation of CCD2 requirements within the Consumer Finance systems.

Analysis, identification, and assessment of business requirements, as well as their transfer into technical implementation requirements. Coordination and status reporting of the various requirements. Documentation and process management using UML and BMPN. Cross-functional stakeholder management, UAT testing, data management, API architecture management.

Tools: Jira, Confluence, Visual Code, Sql Developer, Enterprise Architect, MsOffice, Bruno, ALM, Camunda, Figma

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

• Support for one of the largest logistics service providers in handling ServiceNow tickets in the areas of SAP MDG, Business Partner (BP), customer and supplier master data
• Technical analysis and resolution of tickets through in-depth review of various database tables
• Creation and maintenance of accounting clerks in the system
• Deactivation of company codes using transports
• Carrying out mass changes with LSMW (Legacy System Migration Workbench)

• Restructuring of the network architecture/topology followed by installation, setup and testing of the network at a small business.
• Resolution of server (permissions and roles) and connection problems (WAN, (V)LAN, WLAN).
• Infrastructure support and maintenance.
• Creation of documents such as manuals, architecture and design documents.
• Revision of manuals and technical documents as well as creation of VBA macros.
• Use of AI and basic prompting as well as formulation of AI requests.
• Adaptation of workflows based on legal requirements and optimization of existing workflows.
• Delivery of training and workshops for adaptations, new features and changed workflows.
• Modeling basis: BPMN.
• System environment: MS Office 2019/365, Win10/11, Teams, Netgear (Switch), QNAP, Synology (NAS), Linux (Ubuntu).

• Creation of automated tests.
• Extension of the functionality of the enterprise BI data warehouse.
• Design and development in SQL and PL/SQL.
• Data modeling as well as performance measurement and tuning.
• Creation of and contribution to user stories and concepts.
• Technical environment: Windows, Linux.
• Database: Oracle 19c incl. DWH, CDB, PDB.
• Tools: Confluence, CVS, Eclipse, Git, GitLab, Jira, N4, PL/SQL, SQL Developer, utPLSQL.

• Fixing issues in the program logic

• Covering the changes with unit tests

• Analyzing and documenting the data structure of the various applications

• Analyzing and documenting the parameters for configuring the applications

• Analyzing and documenting the measures required to ensure the operation of the applications

• Analyzing and designing the separation of the individual database structures

• Analyzing and estimating the effort for planned extensions

• Analyzing, maintaining and documenting a heterogeneous legacy system landscape for a print media service provider

• Technology: C#, VB.NET, C, Python, Microsoft SQL Server, Visual Studio 2010, JetBrains Rider, Visual Studio Code, arc42, Draw.io, Jira, GitLab

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

• Lead programmer, architect and deputy product owner
• Completed transition from zPDV to STEP
• Ensured quality of C++ and Perl sources through automated and manual checks
• Supported resolution of incidents and errors in testing
• Implemented batch for supplementary assignment of payment run numbers
• Implemented batch for distribution of SGB 2 information to the central payment unit
• Supported replacement of Solaris with Linux
• Upgraded gcc from 7.4 to 9.3
• Programmatically generated Makefiles from Borland projects for builds
• Extended funding data with new attribute “Kennzeichen Fahrtkosten Praktikum”
• Programmatically generated XSD and WSDL files from IDL definitions
• Represented the product owner when needed
• Implemented batch for one-time payment processing
• Developed generator for Liquibase files
• Implemented and maintained regular anonymization of production data
• Supported migration from SLES 12 to SLES 15
• Supported introduction of mutual TLS
• Implemented batch for sending deletion impulses to EDA BE
• Organized script directory structure
• Investigated potential introduction of String-Latin and implemented minimal solution
• Remediated security findings identified by CheckMarx
• Supported PAP recalculations and general change notices
• Converted ERP interfaces from SOAP to REST
• Planned technical and business topics such as register modernization, cash register security, training costs, four-eyes principle

• Analysis and audit of the current situation on-site and at customer locations
• Planning of IT infrastructures and advice on new hardware purchases as well as migration planning
• Planning and management of the IT budget
• Configuration and support of IT hardware under Windows 7, 8.x, 10 and Mac OS
• Review and update of documentation with regard to GDPR
• Analysis and expansion of technical and organizational measures in accordance with GDPR and BDSG
• Training of employees
• Training in AI-Assistant Consulting and Cybersecurity with AI
• Recording the current state and planning the target state
• 2nd/3rd level support (C/S/N)
• Technical environment: Exchange Administration, Active Directory, MS Server 2016 R2, MS Server 2022, MS SQL Developer, MS SQL, Visual Studio 2013+, Tivoli Monitoring, Tivoli Remote, TeamViewer, weclapp CRM Solution, RA-Micro, IT Compliance, Citrix, UltraEdit, SCCM, Windows XP–11, Office 2010–M365, VPN Solutions, Lexware Solutions, OKI Management Solutions, LogMyTime, SAGE Systems

PHP and React redesign of a web-based ERP system.

• Development of the header and parts of the navigation
• Development of various modules in React, such as a calendar, chat and various tables

• Establishing the Microsoft Fabric platform with the company as the central data warehouse and reporting system.
• The company migrated several operational systems including D365 to new version. The new data warehouse is based on a Fabric/Power BI architecture with Azure cloud Entra Authentication.

Tasks Performed:

• Full administrative responsibility for the Fabric platform F64 and F32 capacities, as well as two F8 capacities for development and prototyping.
• Integration of Fabric with Microsoft Entra.
• Data modeling for the data warehouse bronze, silver and gold layers using data modeling tools.
• Star Schema as well as entity relationship modeling.
• Data modeling for data marts and for dimensional modeling and Power BI (semantic model).
• Design of data models for Microsoft SSAS multidimensional and tabular OLAP cubes using DAX and MDX.
• Definition of design patterns for the ETL team for loading OLAP cubes (Tabular and MD), star schemas and data vault structures.
• Planning and managing team of 4 ETL and reporting developers.
• Performance Tuning of Power BI reports, particularly the semantic layer, as well as the Fabric notebooks
• SQL Performance Tuning.
• DB Design for Azure SQL.
• Reporting directly to project senior management.

Label: Power BI, Fabric, Analysis Services (multidimensional and tabular), D365, SSIS, Tabular Editor, SQL Server and Azure SQL, TOAD Data Modeler, DBSchema, Visual Studio Code, DAX Studio, SSMS, Visual Studio, Jira and Confluence.