Paul - Consultant technique ORACLE APPLICATIONS

Predominantly interface development around the many daily business interfaces between Oracle ERP and internal and external systems (Oracle Financials, Oracle Process Manufacturing, Oracle Discrete Manufacturing and Supply Chain). Designed interface standards and built interface utilities for developing R12 interfaces with the middleware.

• Created API wrappers for multiple R12 APIs for use in data migration

• Analysis and prototyping of Oracle Fusion Middleware (Enterprise Service Bus and BPEL) using JDeveloper10g

• Multiple R12 developments – technical design and build (e.g. personalisations, custom forms, workflow, reports etc.). e.g:
o designed and built exception monitor for all bespoke exceptions (using Oracle Forms & Workflow)
o AP: vendor interface
o AR: customers (TCA) and customer item interfaces
o GL exchange rates interface
o INV: item interface (including OPM regulatory), Intrastat reporting
o OPM: MES interfaces, formula/recipe bespokes
o PO: PO interface
o WMS: task load, task drop, LPN packing/unpacking, LPN merge, subinventory transfer interfaces
Oracle UK Contract (end client: Sainsburys) (December 2006 – January 2007)
11.5.7

• AP: short-term AP contract to build some reports for a reverse factoring (or supply chain financing) series of enhancements to AP. Includes bespoking AP trial balance.

• OA Framework - underlying technology for self-service applications
• XML Publisher

• PA: Developed phase 2 of a Oracle PA transaction interface program (for accruing invoices in Oracle PA)
• PA: Built some bespoke Oracle PA reports and forms
• PO/AP: Maintained and supported PO and AP invoice interface code
• Bespoked a Belgian VAT Report
• Developed an intercompany charging program which read journal lines across multiple instances and populated the AR and AP invoice interface tables (could not use standard intercompany processes because of limitations of one instance being on 11.5.3)

Design / Management
• Development lead for O2C project to design and build an information interchange “hub” for data transfer with all EA’s third parties
• Gathered all requirements, performed architecture design and then managed overall design with my team of 3 other designers
• Managed build with team of 15 developers
• Used many of the 11.5.9 interfaces and APIs available for PO, AR, INV, OM & WSH
• Go-live performance exceeded users expectations

Financials (design and development of following programs)
• AP:
o payment formats
o VAT reports
o payment reports

• AR:
o transaction interface
o major rework of invoice programs for many European territories including integration with many different type of printers and collation and sorting machines
o consolidated invoice reworking across many territories
o new consolidated invoice form
o dunning letters
o VAT reports
o retrospective discount programs (to interface as AR transactions)
o customer extracts
o migrations: Customer Interface and Autoinvoice: from R10.7 to R11 and 11.0.3 to 11.5.9

• GL: various reports for financial reporting and reconciliation across systems

• PO:
o PO change API PO outbound
o PO print
o EPO (Electronic PO) reports

Supply Chain / Manufacturing (design and development of following programs)
• INV:
o inventory reservations API , receiving transactions interface
o SKU extracts, SKU creation, Quick receipt bespoke

• OM: designed and developed:
o backlog reports, cancel order programs
o extended price list functionality
o sales order, price list extracts
o sales order API

• WSH:
o developed large-scale forms-based shipping bespoke reading from Pick Release data and feeding back into Pick/Ship Confirm interface – was used in all European warehouses shipping 10 million pick slips over a 5 year period
o bespoke forms used real-time in warehouse with barcode guns
o pick ticket and shipping label printing, interfaces to carrier systems
o pick confirm API

Tuning: lots of RBO and CBO tuning across GL, AR, OM, INV, WSH, PO

10.5 & 10.7
• PO: developed and maintained Java applets (front-end) and Forms / Reports 2.0, 2.5 / C / PL/SQL programs (back-end) for a customisation of the 10.7 Purchasing requisition and purchase order functionality.
• During a business trip to Tokyo, developed a kanji double-byte implementation of this product

• part of the Oracle Financials Globalization Group developing modules for French localization and the Global Accounting Engine (AX) product (GL, AP, AR & INV)
• designed and implemented various parts of the AX. Wrote most of the R10SC Oracle Forms 4.5 forms for the product
• French localizations, design and implementation: DAS2, French AP, AR and GL legal reports.
• member of the Oracle Financials globalization effort for Release 10.6, spent 3 months in Oracle HQ in San Francisco developing an Intrastat solution based on Oracle Inventory.
• heavily involved with French customer support for the AX and French localization products.

employed by Oracle UK in the Oracle HR development team in Chertsey and Bracknell developing programs for the Oracle Personnel and Oracle Payroll applications
• developed some of the principal Oracle Forms 4.0 forms for the Oracle HR Release 10SC product (R10SC), led a small team and advised other developers.
• part of the team which studied client/server network performance issues in order to optimize the interaction of the Oracle Forms 4.0 client and the Oracle 7 server.
• designed and implemented one of the very first Oracle Forms 4.0 prototypes (in 1992/3). This prototype was used both as an Oracle HR and Oracle Forms demonstration at the EOUG conference in Vienna.