Robert Meixner - Air traffic tax German Customs Administration SOAP Webservices Client Requests

Recommended expert

Bonn, Germany

Experience

Nov 2022 - Aug 2025

2 years 10 months

Air traffic tax German Customs Administration SOAP Webservices Client Requests

Team GmbH

In the citizens' and business customer portal of the Customs Administration, airlines submit applications for departures and landings every month
These applications are forwarded to the caseworkers via SOAP web service and, after review and processing, any queries or notifications are returned via SOAP web service
PL/SQL programming of SOAP webservices client requests for HTTP/XML message exchange between the BuG portal and the caseworkers
New creation and change requests for Forms and Reports 12 modules
Forms applications start and read SOAP webservice requests via PL/SQL packages, process them and send Reports 12 documents to the airlines

Jan 2022 - Apr 2023

1 year 4 months

Process control for manufacturing systems with PL/SQL SOAP Webservices client requests

Team GmbH

Support of about 100 Oracle databases for administration and process control across five plants
Processing change requests for legacy systems, affecting PL/SQL packages, procedures, functions, views, scheduler jobs, job queues, tables and triggers
PL/SQL programming of SOAP webservices client requests for HTTP/XML message exchange of a goods ordering system with SAP and Oracle Forms 10

Aug 2021 - Nov 2021

4 months

Data warehouse ETL mappings / process flows with PL/SQL

Venturi UK / PerformanceDNA

Converting ETL mappings and process flows from Oracle Warehouse Builder into standalone PL/SQL sequences and formats
Simplification and optimization of Warehouse Builder generated PL/SQL packages, using modern Oracle SQL commands like PIVOT and UNPIVOT
Creation of PL/SQL ETL mappings with Oracle Warehouse Builder and manual revision of the modules
Development of PL/SQL packages for process flows from the Oracle Warehouse Builder repository

Mar 2019 - Oct 2020

1 year 8 months

Deletion of customer/contract/claims data and DB2 migration

Right People Group

Development of a PL/SQL package for dynamic deletion and anonymization of approx. 50 million records in 350 tables according to GDPR and Code of Conduct
Use of six control tables for configuration instead of hard delete statements
Implementation of the configuration via an Oracle Forms 12 application
Migration of the Oracle database to IBM DB2 in Oracle compatibility mode using Database Conversion Workbench and IBM Data Studio in 4 weeks without major software changes

Jul 2018 - Sep 2018

3 months

ISUS Oracle Forms/Reports application system

Marlin Green

Implementation of PL/SQL package change requests for hazard level calculation based on working with dangerous substances
Extension of the system with recommendations for suitable work gloves
Creation of Oracle tables, constraints, triggers, views and stored procedures
Adjustments of Forms and Reports modules in development and test environments

Sep 2017 - Mar 2018

7 months

DWH Management Information System - India

RGF HR Agent Singapore Pte Ltd

Cloned five process flows with around 150 ETL mappings for India using Oracle Warehouse Builder and PL/SQL modules
Created OLTP staging tables, views, and materialized views to populate DWH fact and dimension tables
Adapted IBM Cognos Framework Manager and Report Studio reports for different business processes in India

May 2017 - Jun 2017

2 months

Oracle Database Permissions

Neusta Consulting GmbH

Analyzed existing database permissions and restricted them to the minimally required rights for users and roles
Created PL/SQL scripts that query the Oracle data dictionary and generate SQL scripts with detailed REVOKE and GRANT statements

Mar 2017 - May 2017

3 months

Forms/Reports application system for managing teacher trainees

MegaPart

Extended the Oracle Forms 10/Reports 10g system for managing teacher trainees and state exams for a ministry of education
Adapted grading to match annual examination regulations
Developed stored procedures and Report RefCursor queries to produce report cards and certificates

Apr 2016 - Nov 2016

8 months

DARRS Forms/Reports Application System

Avabis

Enhanced the Dataserv Asset Recovery Recycling System (DARRS) in seven countries including South Africa, USA, and Singapore after merging with TES-AMM
Implemented about 60 change requests on Forms/Reports modules, stored procedures, views, and triggers within 4 months
Developed innovative Excel reports using the Ora_EXCEL API

Oct 2015 - Feb 2016

5 months

TDB Transaction Database

GFT Financial Services

Analyzed and extended the end-of-day batch processing system TDB to integrate mark-to-market information
Got up to speed on a large PL/SQL system with no documentation, with the requirement not to affect existing functions
Added about 200 lines of code and performed extensive module and integration tests with CA Autosys

Nov 2013 - Feb 2014

4 months

Implementation of a DB-XML/XML-DB interface

Gulp

Development of a PL/SQL interface for bidirectional conversion of database content to XML files and vice versa
Use of Oracle JobQueue for automated data transfer with XML schema validation over MQ to EAI systems

Nov 2011 - Aug 2015

3 years 10 months

Member/Campaign Management IG Metall

Goetzfried AG

Enhancement of the IG Metall master data system with around 2.3 million members using about 400 forms and 80 report modules
Mapping of entities such as persons, businesses, publications, committees, seminars, campaigns, and the SEPA migration
Implementation of stored procedures and Oracle Forms/Reports 10g, 11g on Oracle 11g

Jan 2010 - Sep 2011

1 year 9 months

Oracle Reports/Forms 10g, PL/SQL

Support GDC

Development of PDF and Excel reports for container ships (booking, freight, routes) using PL/SQL RefCursor queries and pipelined functions
Creation of an Oracle Forms application for report development administration

Jan 2009 - Dec 2009

1 year

Data migration SQL Server – Oracle and performance tuning

ASSpro AG

Data modeling and manual ETL of 60 tables from SQL Server to Oracle, considering complex business rules
Creation of loader scripts to load into temporary Oracle tables and generation of PL/SQL migration scripts
Performance tuning of views