Freelancer profile translated to English.

Description

With my many years of experience with Oracle PL/SQL and Oracle Apex, I support companies in the development and further development of complex database applications and in the areas of data modeling and migration.

Languages

German
Native or bilingual

Workplace preferences

Can work on-site

Forchheim / Bayern (up to 50km)

Industrie und Handel
Oracle Apex Developer / Oracle Developer
RETAIL (LARGE RETAILERS)
March 2025 - August 2025 (5 months)
Further development and maintenance of an existing resource management system

Scope:
Support in further development
Tasks:

• Testing current functionality and code cleanup
• Migration of existing data into a new data model
• Bug fixing and enhancement of various Oracle Apex applications
• Development of an Oracle Apex plugin for validating complex data in an Interactive Grid
• Extension of test automation within an existing CI/CD environment (Shell Scripting, SQL)
Team size: 2 people
Environment: Oracle19c / Oracle 23ai
Oracle Apex Oracle SQL Oracle PL/SQL Oracle REST Data Service Oracle SQL Data Modeler
Finanzdienstleister
Oracle Apex Developer / Oracle DWH Developer
BANKING AND INSURANCE
January 2022 - October 2024 (2 years and 9 months)
New and further development of customer portals based on Oracle Apex. Provision of data in various formats for analysis and evaluation

Scope:
Consolidation of existing apps into one portal. Development of various apps for easy loading and
provisioning of business data in different formats

Tasks:
Phase 1)
• Adaptation and extension of existing data models (relational and JSON) for storing user-related results
• Prototype development on SODA (PL/SQL) for data provision to external applications and systems
• Development of a cross-application API for connecting different systems and clients (DWH,
Python, Jupyter Notebook, etc.)
• Extension of existing tenant control (VPD) considering existing roles and rights
• Provision of an API (REST) for connecting external data analysis tools
• Consolidation of different dimension and fact tables
• Building various dashboards in Oracle Apex

Phase 2)
• Mapping of different business processes based on Oracle Apex Workflow
• Provision of a customer-specific API (PL/SQL) for easier integration and customization of the workflow and individual tasks
• Creation of RAG indexes via Oracle Apex Workflow
• Connecting local LLM
• Further development and adaptation of various Oracle Apex plugins
• Oracle Apex Migration (to 23.2 / 24.1 / 24.2)

Phase 3)
• Cloud migration
• Extension and automation of deployment (CI/CD)
Oracle REST Data Service utPLSQL Oracle Apex Oracle PL/SQL Oracle SQL
DB Cargo
Oracle Apex Developer / Oracle DWH Developer
LOGISTICS AND SUPPLY CHAIN
September 2018 - December 2021 (3 years and 3 months)
Mainz, Germany
Development of a planning and control tool for the management and simulation of sales objects

Scope:
• Simple and clear recording of sales objects with their planning data in a web frontend
• Bidirectional connection to an existing data warehouse
• Provision of various REST interfaces to enable seamless integration into the existing IT landscape
• Calculation and simulation of sales objects and quantities to optimize logistics flows

Goal:
Increase efficiency and responsiveness in planning and controlling technical and sales requirements

Tasks:
• Development and design of a hybrid data model (3NF and Document Store)
• Development of extensive PL/SQL modules for controlling and simulating sales processes
• Application development with Oracle Apex to support the entire planning and management process
including their simulation
• Splitting the application into several modules (applications)
• Development of custom Oracle Apex plugins
• Provision of a dashboard for checking and monitoring all process steps and sales objects
• Development of workflow-supported inputs and approval processes
• Multilingualism (German, English)
• Implementation of a custom authorization concept within the application
• Provision of various REST interfaces
• Generation of PDF documents
• Development of various unit tests
• Performance tuning
• Support for DBAs
Oracle REST Data Service SQL-Developer SQL-Developer Data Modeler Oracle Apex Oracle PL/SQL