Robert M.

Go to Website

Bonn, Germany

Experience

Nov 2022 - Aug 2025

2 years 10 months

Lorem ipsum dolor sit amet

Team GmbH

In the customs administration's portal for private and business customers, airlines submit monthly applications for takeoffs and landings.
These applications are sent to caseworkers via SOAP web services.
After review and processing, queries or notices are returned via SOAP web services.
PL/SQL development of SOAP web service client requests for HTTP/XML message exchange.
Creation of new Forms and Reports 12 modules and handling change requests.
Forms applications invoke and read SOAP web service requests via PL/SQL packages and send Reports 12 documents.

Jan 2022 - Apr 2023

1 year 4 months

Lorem ipsum dolor sit amet

Team GmbH

Administration and process control of around 100 Oracle databases at Nobilia.
Handling change requests on legacy systems using PL/SQL packages, procedures, functions, views, scheduler jobs, tables, and triggers.
PL/SQL programming of SOAP web service client requests for the HTTP/XML message exchange of a goods ordering system with SAP and Oracle Forms 10.

Aug 2021 - Nov 2021

4 months

Lorem ipsum dolor sit amet

Venturi UK / PerformanceDNA

Migrated data warehouse ETL mappings and process flows from Oracle Warehouse Builder to standalone PL/SQL scripts.
Simplified generated PL/SQL packages and formatted them to improve readability.
Replaced complex SQL pivot solutions with more efficient implementations.
Created PL/SQL ETL mappings and manually revised the modules.
Developed PL/SQL packages for process flows from the Oracle Warehouse Builder repository.

Mar 2019 - Oct 2020

1 year 8 months

Lorem ipsum dolor sit amet

Right People Group

Developed a PL/SQL package to delete and anonymize customer, contract, and claim data in accordance with GDPR using dynamic SQL and control tables.
Configured the system via an Oracle Forms 12 application.
Migrated the Oracle database to IBM DB2 within four weeks using IBM Database Conversion Workbench and IBM Data Studio without major changes.

Jul 2018 - Sep 2018

3 months

Lorem ipsum dolor sit amet

Marlin Green

Extended the ISUS application system for occupational safety and environmental protection at RWE.
Created Oracle tables, constraints, triggers, views, and stored procedures.
Adapted Forms and Reports modules, including development and module testing.
Implemented PL/SQL packages to calculate hazard levels and recommendations for work gloves.

Sep 2017 - Mar 2018

7 months

Lorem ipsum dolor sit amet

RGF HR Agent Singapore Pte Ltd

OWB cloning of about 150 ETL mappings for five process flows to provide software modules for India.
Creation of staging tables, views, materialized views and DWH fact & dimension tables in Oracle 11g.
Extension of MIS reports using IBM Cognos 10.2.1 Framework Manager and Report Studio for various business processes in India.

May 2017 - Jun 2017

2 months

Lorem ipsum dolor sit amet

Neusta Consulting GmbH

Analysis of excessively granted database permissions and definition of minimally required rights.
Creation of PL/SQL scripts to analyze the Oracle data dictionary and generate REVOKE and GRANT SQL scripts.
Application of the scripts on affected databases to implement differentiated permissions.

Mar 2017 - May 2017

3 months

Lorem ipsum dolor sit amet

MegaPart

Further development of an Oracle Forms/Reports application system for managing teacher trainees at the Ministry of Education of Baden-Württemberg.
Implementation of stored procedures and PL/SQL to manage state exams and grading.
Development of certificate documents and attestations with Oracle Reports 10g using RefCursor queries.

Apr 2016 - Nov 2016

8 months

Lorem ipsum dolor sit amet

Avabis

Further development of DARRS (Dataserv Asset Recovery Recycling System) in Oracle 11g Forms/Reports.
Customization of 60 forms and reports modules including stored procedures, views and triggers.
Development of new Excel reports using the Ora_EXCEL API.

Oct 2015 - Feb 2016

5 months

Lorem ipsum dolor sit amet

GFT Financial Services

Analysis and modification of the 'End of Day' batch processing system TDB (Transaction Database) at Barclays Investment Bank.
Implementation of mark-to-market information by adding about 200 lines of code to existing PL/SQL packages.
Execution of extensive module and integration tests with the CA Autosys Job Control System.

Dec 2013 - Aug 2015

1 year 9 months

Lorem ipsum dolor sit amet

Goetzfried AG

Further development of the IG Metall master data system (approx. 400 forms, 80 reports) for managing 2.3 million members.
Implementation of Oracle 11g SQL, PL/SQL, stored procedures, as well as Forms/Reports 10g and 11g.

Nov 2013 - Feb 2014

4 months

Lorem ipsum dolor sit amet

Gulp

Development of a PL/SQL interface for bidirectional conversion of database content and XML files.
Use of Oracle JobQueue for data transfer using XML protocol with schema validation.

Nov 2011 - Aug 2012

10 months

Lorem ipsum dolor sit amet

Goetzfried AG

Further development of the IG Metall master data system (see above) in an earlier project phase.

Jan 2010 - Sep 2011

1 year 9 months

Lorem ipsum dolor sit amet

Support GDC

Development of reports for the Hamburg Süd shipping company in Oracle 10g Forms/Reports.
Implementation of PDF and Excel JSP reports with PL/SQL RefCursor queries and pipelined functions.
Creation of an Oracle Forms application to administer report development.

Jan 2009 - Dec 2009

1 year

Lorem ipsum dolor sit amet

ASSpro AG

Manual ETL migration of approx. 60 tables from SQL Server to Oracle, considering complex business rules.
Data modeling, creation of loader scripts, and PL/SQL migration scripts.
Performance tuning of views for a C#/.NET planning and production system.