Profileimage by Philip Triebwasser Oracle E-Business Suite Developer: SQL, PL/SQL, Forms and Reports, BI Publisher and Unix from London

Philip Triebwasser


Last update: 12.02.2023

Oracle E-Business Suite Developer: SQL,PL/SQL, Forms and Reports, BI Publisher and Unix

Company: Chapter Software Limited
Graduation: B.Sc. (Hons) Computing and Informatics: University of Plymouth
Hourly-/Daily rates: show
Languages: German (Full Professional) | English (Native or Bilingual)


Oracle Databases Unix Shell Oracle Ebusiness Unix Oracle Applications Bi Publisher Bug Management Cloud Computing Shell Script Solaris (Operating System) + 75 more keywords




UAT, APIs, ADP, BI Publisher, Oracle BI Publisher, C, C++, cloud-based, Cloud, configuration management, cursors, DATEV, dBase IV, data files, data migration, data extract, dataflow, data transformation, Database design, database, Delphi, E-Business, encoded, Entity Relationship, Ethernet, Excel macros, XML, ETL, file transfer, HPUX, healthcare information system, AIX, Lotus, Informatics, Computer Science, Jira, Java, JavaScript, Jenkins, Korn shell, legacy systems, Linux, Linux server, Makefiles, SQL Server, SourceSafe, Production database, Oracle, Oracle Apps, Oracle Applications, OBIEE, 12c, Oracle 9i, Oracle 11g, Oracle 10g, 9i, Oracle 8i, Oracle8, Oracle 7, Oracle E-Business Suite, R12, Oracle EBS, Oracle Forms, Oracle Fusion, Oracle Financials, Oracle Reports, Oracle Developer, PL/SQL, PeopleSoft, performance tuning, PostgreSQL, Pro*C, development tools, regular expressions, reverse engineering, SAP, SQL, stored procedures, stored procedure, SQL*Plus, Sparc, Application Server, SOA, Shell scripting, shell scripts, Siebel, application software, Bug fixes, bug fixing, Solaris, Sun Solaris, code analysis, Subversion, SAP Success Factors, Systems Analysis, test scripts, Toad, Unix, Unix environment, Unix Shell, Unix Shell Scripting, shell, Unix shell scripts, user administration,, Webforms, XQuery, Yourdon

Project history

03/2021 - 06/2021
Oracle E-Business Suite Developer
Summary E-Business Suite R12, Payables, Receivables, Purchasing, iGateway
Oracle 12c
Bug fixes and Change Requests for IT consultancy based in Scandinavia/Baltic states. (Work carried
out 100% remote)
EBS R12: Modules: Payables, Receivables, Purchasing, iGateway
Tools: BI Publisher, webADI, Oracle Forms
Oracle 12c: PL/SQL: XML functions, XQuery syntax, Oracle regular expressions
Operating System: Unix
Jira was used for a Fault tracking and reporting
Jenkins for automated code deployment
Subversion/Tortoise for code repository.
Microsoft Teams for contact with colleagues.

04/2017 - 04/2017
Oracle Fusion Reporting Consultant
West Midlands Police
Summary E-Business Suite 11i, Oracle Fusion Cloud 11i, OTBI, OBIEE
Details Project writing HCM reports using OTBI/ OBIEE running on Oracle Fusion Cloud 11i. Required detailed
understanding of HR schema and ability to pick up OTBI/ OBIEE in a very short timeframe.

12/2016 - 12/2016
Oracle E-Business Suite HR Consultant
Telefónica Germany GmbH
Summary E-Business Suite 11.5.10, HR, PL/SQL, German language
Production of data extracts using PL/SQL for HR migration to SAP Success Factors Employee Central.
Translation of business requirements into technical design, coding and testing. This was a German
speaking role.

01/2016 - 08/2016
Oracle E-Business Suite Data Migration Developer
Summary E-Business Suite 12.1.2, Data Migration, GL, FA HR, PL/SQL, Shell scripting, BI Publisher
Data migration to on-board US acquisition to UBM single instance. Development of data extract,
transformation and loading procedures and design of staging table for General Ledger and Fixed
Assets modules. Also assisted in setup of secure shell for file transfer. Development of BI
Publisher reports and re-engineering of HR/payroll interface to external system ADP. Also assisted
in implementation of self-service HR.

08/2014 - 12/2015
Oracle E-Business Suite Developer
Deloitte/MoD; DBS Finance
Summary E-Business Suite 12.2.4, PL/SQL, Shell, BI Publisher, XML
Upgrade of core financials from 11.5.10 to 12.1.2. Modification of custom code including packages,
shell scripts, BI Publisher and Oracle Reports, to use R12 tables and new chart of accounts. All
core financial modules involved, but particular experience in Payments and Collections. From Jul on
CP&F project using EBS 12.2.4 using Purchasing and Contracts.

07/2014 - 08/2014
Oracle E-Business Suite Developer
Summary E-Business Suite 12.1.2, OTL, PL/SQL, Shell, XML
Implementation of Oracle Time and Labor (OTL) for Oracle's client the MoD. Design and implement
custom tables to hold projects and tasks and write interfaces to populate tables using MoD interface

09/2013 - 12/2013
Oracle E-Business Suite Developer
Ann Summers; Gold Group House
Summary E-Business Suite 11.5.8, Forms 6i, Reports 6i, PL/SQL, Shell, XML, SOA
Development of major EBS customisation to communicate with SOA service using XML documents to
generate and print address labels sent by UKMail in base64 encoded strings using Oracle 9i/11g,
Forms and PL/SQL. EBS Modules: AR, OM, INV.

04/2012 - 08/2013
Oracle E-Business Suite Developer
Summary E-Business Suite 11.5.10, BI Publisher, PL/SQL, Oracle Alerts
Development and support of full Oracle E-Business Suite system in busy central government
department. Developing HR reports and letters using Oracle BI Publisher, PL/SQL, SQL*Plus, Oracle
Reports and Oracle Alerts. Also Unix Shell scripting in AIX environment. General bug fixing and
support, but also involved in on-boarding new customer. All core modules used, but specifically HR,
AR, AP, GL and PO. Also involved with writing interfaces using Open Interface Tables.

01/2012 - 03/2012
Oracle E-Business Suite Developer
Scania AB
Summary E-Business Suite R12, Oracle Forms/Reports 10g, PL/SQL
Migration of E-Business Suite from 11.5.10 to 12.1.3. using Oracle Forms and Reports 10g, PL/SQL and
Shell scripts. Upgrading of customisations to use R12 features such as the Trading Community
Architecture and Sub-ledger accounting. Modules migrated: FA, GL, AR, AP, PA and OM. Analysis of
CEMLI list to identify use of deprecated objects, replace with R12 equivalents and test.

10/2011 - 11/2011
Unix/C Developer
Swiss Life; Swiss Life AG
Summary Shell scripts, C, Makefiles, German language
Details Short assignment at Swiss insurance company to assist with porting C programs and shell scripts from
AIX to Linux. The working language in the office and in all documentation was German.

11/2010 - 02/2011
Oracle Developer
Allianz Worldwide Care
Summary Forms 10g, Oracle 11g, PL/SQL, Shell scripts, GIOS
Working on insurance application GIOS to implement policy refund procedure. Design of front-end
forms and back-end processing to handle cheque payment, international bank transfer and credit card
payments to policyholders. Working from a 150 page functional spec and to tight deadlines, I
succeeded in delivering a working solution to UAT in the 3 months agreed.

10/2010 - 11/2010
Oracle Developer
Oasis Medical Solutions (previously known as Capula Healthcare)
Oasis Medical Solutions (previously known as Capula Healthcare)
Address Battersea Studios, 80 Silverthorne Road, London SW8 3HE
Role Oracle Developer.
Dates Oct 2010 - Nov 2010
Summary Forms 6i, 10g, Oracle 11g, PL/SQL
Details Short-term contract to perform a number of urgent bug fixes to Medical information management system
using Forms 10g and PL/SQL

03/2010 - 09/2010
Oracle Apps Developer
Bord Gáis
Summary Oracle EBS 11.5.10, Oracle 10g, PL/SQL, Major Utility
Core finance system of Ireland's primary gas and electricity utility. Development and documentation
using AIM methodology of various interfaces to GL and PA from AR e.g. Intercompany trading. PL/SQL,
Reports 6i, Linux Unix shell scripts, Concurrent Manager

12/2009 - 02/2010
Oracle Developer
Summary Forms 10g, Oracle 11g, PL/SQL, Linux, Systems Analysis.
Critical bug fixing for 24hour legal services call-centre system using forms 10g and PL/SQL packages
and stored procedures running on 11g database on a Linux server. Also perform Systems
Analysis, documentation and design for proposed re-write of legal advice call centre system.

06/2008 - 03/2009
Oracle EBS Data Migration consultant
Summary Oracle E-Business Suite, Data migration, ETL, Data Design, PL/SQL, Unix shell scripts
Data migration and ETL project involving the Oracle EBS core modules and Oracle Manufacturing in
defence electronics environment. Legacy data in flat files and existing Oracle system needed to be
extracted, loaded, transformed and output to flat files for loading into Oracle EBS by existing
APIs. Design and creation of tables then creation of PL/SQL stored packages and AIX Unix shell
scripts to create a fully automated and repeatable data transformation and extract process. Security
Clearance to 'SC' was required for this project and obtained by Thales on my behalf.

12/2007 - 03/2008
Lead Oracle Developer
Summary Forms 9i, Oracle 9, PL/SQL, tuning, team lead
Lead developer for Bug fixing, enhancement and performance tuning of 24hour call-centre system
running forms 9i and Oracle 9 database built using Headstart utility. Use of PL/SQL packages and
stored procedures and Forms 9i Developer. Resolution of performance issues in a time-critical legal
services application with a poorly documented system that involved extensive code analysis and
reverse engineering to determine current functionality.

05/2007 - 11/2007
Contract Oracle Consultant
Capula Healthcare
Summary Oracle 10g, OAS Application Server, Webforms, Data Migration, ETL, PL/SQL
Data Migration, ETL and Webforms development for healthcare information system running in a 10g
environment. Data provided hospital in flat files needed to be normalised and loaded. Complete
responsibility design of tables and loading scripts using PL/SQL packages and stored procedures.
Forms designed and constructed to access data maintaining look and feel of existing system. Very
large legacy data files involved all in/outpatient data for entire hospital over many years. Sole
responsibility for all design and development tasks also liaison with end user.

04/2006 - 01/2007
Contract Oracle Apps Consultant
Hochtief (Oracle Germany)
Summary Oracle Apps: HR and GL, PL/SQL, Forms6, German language.
HR Development of customised forms and interfaces into external payroll system and to general ledger
in a German-speaking project using PL/SQL packages and stored procedures and Forms Developer 6. Very
large project to replace existing SAP system with Oracle EBS required extensive customisation and
creation of interfaces with legacy systems. Design and build of inbound and outbound interfaces
using APIs. New forms designed and created as part of HR customisation requirement. AIM Systems
Methodology was used on this project and the documentation was in English and German.

02/2006 - 03/2006
Contract Oracle Apps Consultant
Peterborough City Council
Summary Oracle Apps: AP, AR, GL and PO: re-engineering into 11.5.10, PL/SQL
Details Bug fixing and testing of re-engineering of AP, AR, GL and PO modules from 11.5.7 to 11.5.10. This
small project was to fill an urgent short-term consultation requirement.

08/2005 - 12/2005
Oracle Applications consultant
Summary Oracle PA 11.5.9, PL/SQL, Forms6
Development of interfaces of Projects, Agreements, Budgets and Events from Siebel into Oracle PA
using PL/SQL packages and stored procedures and AMG. Creation of custom forms for the processing of
invoice accruals. Part of interface team responsible for design, creation, testing and documentation
of interfaces into Oracle EBS Project Accounting. Included travel to Frankfurt to support UAT.

05/2005 - 08/2005
Oracle Applications consultant
Dalkia PLC
Summary Oracle Applications PA, PL/SQL, Shell scripts
Development of interfaces between Oracle PA and external helpdesk system. One data extract of
projects and employees using PL/SQL packages and stored procedure and AIX Shell Scripts and the
other project and budget creation using Oracle AMG APIs.

11/2004 - 04/2005
Oracle Applications consultant
Porterbrook Leasing
Summary Oracle Applications PA, PO and AP. Reports and Forms 6i, PL/SQL
Development of Oracle Applications customisations using Reports, Forms 6i and PL/SQL packages and
stored procedures for a railway leasing company. Bug fixing and enhancements to complex financial
reports primarily in the PA but also in the PO, AP and GL modules.

05/2004 - 11/2004
Summary Oracle 9i, PL/SQL, PeopleSoft
Oracle 9i based bespoke customer administration system, with interfaces to PeopleSoft, system being
ported to Responsible for Re-engineering of existing PL/SQL code utilising ref cursors,
nested tables and other new features. Also performance tuning and configuration management using

04/2003 - 02/2004
BT (Xansa)
Summary Oracle 9i, Reports/Forms 9i, Workflow 2.6.3, Oracle Applications 11.5.8
Working on Delphi Project. Objective to deliver a single, global Oracle Financials solution,
supporting a single BT Chart of Accounts and enabling standardised business processes and reporting.
Using Oracle Applications 11.5.8: PA, FA, GL, Oracle 9i PL/SQL, AMG Budget Load, Toad 7.5.2, Korn
shell on HPUX, Oracle Apps self-service Framework personalisations, Customised and bespoke reports
for PA using Oracle Reports 6i/9i, Custom Forms for PA using Forms 6i/9i, Oracle Workflow 2.6.3:
Customise Budget approval and Project Status Workflows. Set-up and use of Applimation for the
comparison of Oracle Apps. Data across multiple environments.

12/2002 - 01/2003
Metropolitan Housing Trust
Summary Oracle 8i, PL/SQL, Korn shell, Apps 11I: AP
Details Creation of interfaces between First Housing and Oracle Financials 11i Payables using Korn Shell and
PL/SQL on an Oracle 8i database. This was a short term role to meet a go-live deadline.

07/2000 - 12/2002
Sun Microsystems Ltd.
Summary Oracle 7/8, PL/SQL, Reports25, Forms45, Korn shell, Apps 10.7 & 11.03: PA, AP, HR & GL
Design, build and maintain bespoke add-ons to Oracle Projects 11 to interface with GL, AR and HR
modules and other non-Oracle systems. Implemented using Unix shell scripts, PL/SQL, Forms 4.5 and
Reports 2.5 in an Oracle8/Solaris environment. 3 months as team leader for U.S. reports development
managing 5 developers. Responsible for timescales, quality, standards and liaison with functional
team. 1 month spent in U.S. in analysis and development role. 3 months data migration for European
rollout using Oracle AMG and Open Interface Tables.

11/1997 - 06/2000
WS Atkins plc
Summary Oracle 7, PL/SQL, Reports25, Forms45, Korn shell, C, ProC, Tuning
Creation of management accounting reports, batch accounting programs and bespoke add-ons for project
accounting system. Interface with SunAccounts package. Oracle7 database using Developer2000 (Reports
2.5), PL/SQL and Korn shell scripts. Sun Solaris Unix environment. Duties include liaison with
Accountants and configuration management (SCCS). Basic DBA activities and performance tuning. Small
amounts of C and Pro*C.

* Details for contracts 1993-1997 available upon request.

08/1992 - 08/1993
System Engineer
Tom Pedersen International
Name Tom Pedersen International
Address Hasserisvej 106, DK-9000, Aalborg, Denmark
Business International Oracle consultancy
Role System Engineer
Dates August 1992 - August 1993
Analysis, design, implementation and maintenance of Oracle-based systems and application software.
Undertook project to develop generic on-line documentation creation/viewing tool using SQL*Forms 3.0
and Menu 5.0, also conversion on Forms 2.3 to 3.0 for large accounting system running under Ultrix
at motor factors company: Kapp AG, CH-8112 Otelfingen, Switzerland. Also performed evaluation of
Oracle7 and PL/SQL 2.0

Skills Use of design methodologies, Entity Relationship and dataflow diagrams. Database design and
administration. Unix Shell scripts
Software Oracle development tools including SQL* Forms (2.3 and 3.0), SQL*Plus, SQL*Menu, ReportWriter.
Op. Sys DOS, OS2, Unix. Languages: SQL, PL/SQL (1.0 and 2.0), Oracle7, C, Shell Scripts, Unix Utilities
Hardware IBM PC (compatible), DEC (Ultrix)

08/1989 - 07/1992
Software Engineer
Name BT
Address 23 - 31 St. Matthews Street, Ipswich IP1 3BT
Business Research and Development Division of Telecommunications Provider
Job Title Software Engineer
Dates August 1989 - July 1992
To develop screen-based applications using in-house tools with SQL and some C for large workforce
management project. Also development of internal fault recording and change control tools in

Skills Use of Yourdon design methodology, Entity Relationship and dataflow diagrams
Software SQL*Forms (2.3 and 3.0), SQL*Menu. Operating Systems: Unix (SunOs), Dynix). Languages: SQL, PL/SQL,
C, C++, Shell scripts, Unix utilities
Hardware Sun (Sparc Workstation), Sequent, DEC

07/1987 - 09/1988
Student Trainee
Name ICL
Address Avis House, Bracknell, Berks.
Business Personal Computers Division of computer manufacturer
Job Title Student Trainee (part of sandwich course)
Dates July 1987 - Sept 1988
Duties Test and validation of software and hardware for ICL PC
Skills Creation and use of test scripts, test harnesses
Software DOS, OS2, dBase IV, Supercalc4, Lotus 1-2-3, LAN/ Comms software
Hardware ICL (IBM Compatible) PC, asynchronous Hayes modem, Ethernet

Local Availability

Only available for remote work
Profileimage by Philip Triebwasser Oracle E-Business Suite Developer: SQL, PL/SQL, Forms and Reports, BI Publisher and Unix from London Oracle E-Business Suite Developer: SQL,PL/SQL, Forms and Reports, BI Publisher and Unix