Oracle SQL Developer Expert

• Focus: system architecture, cloud-native platforms, microservices, API design
• Product: Pflege-Pfad is a digital matchmaking platform that connects relatives of people in need of care directly 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 the 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 a solo 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 via presigned URLs for verification of 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 placement process.
• Building 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.

• The goal of BIENE is to provide a uniform program for tax collection for all states.

• In tax collection, the aim is to collect the assessed taxes. This includes handling due dates, documenting incoming and outgoing payments, triggering reminders or refunds. Statute of limitations and payment reminders also play an important role. All payment transactions with banks and accounting are mapped in BIENE.

• Setting up the architecture and coordinating the provisioning of development and test environments at the Hanover location

• Installing and configuring environments on Linux servers (Apache Kafka, PostgreSQL)

• Interface tasks: coordinating and aligning the integration of software products from other departments and their test data

• Upgrading application server, JDK, Maven project structure

• Environment coordination and build management

• Implementing external interfaces

• Implementing business requirements

• Designing and implementing RESTful APIs and OpenAPI specifications

• Designing and implementing microservice architecture

• Setting up and maintaining CI/CD pipelines

• Deploying applications on OpenShift

• Creating technical documentation and diagrams

• Working with SQL databases (Oracle and PostgreSQL)

• Setting up authentication and authorization for the application and users

• Containerizing the application (automated deployment via CI/CD pipeline)

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)

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

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

• 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

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

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, e.g. calendar, chat, and various tables

• 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

• Migrating the existing Delphi 2010 version to Delphi 10.4.
• All software products must be made Terminal Server capable.
• Support and further development of the in-house forwarding software until it is replaced by a newly purchased version.
• Technologies: Delphi 2010, Delphi 10.4, Advantage Database, DevExpress, GIT, Devart, OOP.

• Design, planning and execution of complex acceptance tests for a document exchange platform for the German justice authorities.
• Validation of decrypted and certificate-based message exchange via web platform, mobile app, and Java API.
• Documentation of test cases, execution steps, and test results.
• Technologies: Windows 11/10, Ubuntu, iOS, Android, Bash for Windows, Java 17, IntelliJ, Git, Jira, Confluence, Citrix Server, xJustiz standard implementation, specific justice software.

• Project leadership and management
• Implementing reporting solutions in banks
• Enhancing and optimizing reporting processes in bank finance and risk departments
• Consulting through all phases of regulatory requirement implementation, including requirements analysis, defining business requirements, testing, tool development, and audit-compliant documentation
• Supporting regulatory implementation projects
• Analyzing business requirements and implementing reports
• Acting as a liaison between business and IT
• Publishing on regulatory changes
• Training internal colleagues on regulatory topics

• Creation of test concepts
• Requirements management
• Release planning and support
• DDS management
• Reporting (test report, AFO TestMatrix)
• UAT/BAT coordination
• Onboarding of new team members
• Team planning / capacity planning
• Support with documentation
• Methods/tools/technologies: black box, white box, exploratory testing, E2E testing, regression testing, L&P testing, acceptance testing and interface testing, integration and system testing, networking, JIRA with Zephyrscale plug-in, Confluence, RISE Portal, Ethernet, IPv4, IPv6, Linux, VM, Postman, SQL, SQL-Developer, Bruno, Wireshark, cloud, Burp Suite, Notepad++