SUMMARY:

• Senior Oracle EBS Technical Specialist with 20+ years experience in support and customization of the main Oracle Financials modules (GL, AP,AR, CM,PA).
• I have worked in the full SLDC developing forms and reports in multiple Oracle Applications modules, customized package software and created new programs to meet user needs.
• Multiple Oracle EBS upgrades Data Conversion
• Integration with internal and external systems Report development and customization

ORACLE TECHNICAL SPECIALTIES:

Oracle EBS (releases 9,10.7, 11i, R12) - General Ledger, Receivables, Payables, Fixed Assets Oracle Technologies - SQL, SQL*Plus, PLSQL, Oracle Forms/Report Workflow, BI Publisher Troubleshooting, bug fixing and enhancements Integration automation, shell scripting, FTP/sftp, scheduling, encryption

TECHNICAL CAPABILITIES:

Languages / Software: Oracle RDBMS (6,7,8,9,10)

SQL*Forms: (2.3,3.0,4.5,6i)

Oracle Reports: 2.0, 2.5, 4.5, 6i SQL, SQL*Plus, PL/SQL

Oracle Applications: 9.4,10.0,10.5, 10.7SC, 11.0, 11i,r12) AP, GL, CM, PA, PO, INV, WIP, OE Korn shell, bash, unix scripting Oracle Utilities

Operating system: Linux, UNIX (IBM AIX, HP-UX, ICL DRS-NX, Sequent DYNIX), VAX VMS, Windows, Windows NT, Novell, DOS

EMPLOYMENT HISTORY:

Confidential

Senior Oracle EBS Technical Specialist

Responsibilities:

• Troubleshooting and end user support.
• Design and develop new interfaces into and out of EBS.
• Co­ordinate patching and customization installation with hosting provider.
• Customizing reports using Oracle Reports and BI Publisher.
• Use GoAnywhere software to handle dozens of interfaces for Oracle EBS and Oracle Cloud HCM using pgp encryption, ssh authentication ftp, sftp
• Responsible for integrating Coupa Purchasing system with Oracle EBS.
• Supervised an offsite developer to ensure development and testing of multiple interfaces.
• Produced data mapping and design documentation.
• Responsible for testing and migration through multiple rounds of testing.
• Developed enhancements after go live.
• The company split into 2 publicly traded companies.
• We needed to create a free standing instance for the new company and ensure that that all fiscal reporting for the split year reflected the legal split.
• Configured and changed existing interfaces to work with 2 separate instances.

Confidential

Technical lead

Responsibilities:

• We had a number of local and offsite developers and I was responsible for coordinating their work and ensuring the timely completion of deliverables including data conversion, custom reports and interfaces. Integration lead responsible for interfaces between EBS and multiple internal and external systems.
• Worked with banks and other external systems to co-ordinate testing the production cut over.
• Reviewed MD050 and MD070 documentation and also conversion design documents and conversion scripts
• I was responsible for developing a suite of GL fiscal reports to properly handle the changeover stub year and the new fiscal year in an instance that was still configured for a calendar year.
• Troubleshooting application problems.
• Developed custom reports for GL, AP, AR and Confidential modules.
• Responsible for full SDLC for new interfaces between Oracle EBS and internal and external subsystems.
• Interface changes between Oracle EBS and various external system.
• Custom Reports migration, supervised 4 programmers to migrate all custom reports from 10.7 to 11i.

Confidential

Senior Oracle EBS Technical Specialist

Responsibilities:

• Responsible for data conversion and interfaces for a full life cycle Oracle Implementation (11i, GL, AP, AR,PO and CM).
• Designed and built interfaces into Oracle AP and AR from a custom SQL/Server applications using PL/SQL.
• Designed and built interfaces into Oracle CM.
• Designed and built Vendor conversion,customer conversion and payables invoice conversion.
• Built workflow modifications for Confidential .
• Set Up Federal, State and AMT tax books in an 11i installation.
• Converted multiple years' asset information into multiple companies tax books.
• Built Confidential interface program using PL/SQL.
• Developed General Ledger Budgets and Forecasting training materials.
• Worked in "train the trainer" with client staff and supported the training delivery
• Design, development an testing of Fixed Assets conversion from FAS to 11i (Designed and built using PL/SQL and stored procedures)
• Inventory Conversion for a 10.7 to 11i reimplementation pilot feasibility project.
• Designed built and tested conversions for items, quantity on hand and purchase orders using PL/SQL
• Puchasing conversion for a 10.7 to 11i reimplementation.
• Designed built and tested conversions for vendors, and employees using PL/SQL.
• Customised the Item master form to provide extra validation for item segments and categories
• Designed and built using PL/SQL and stored procedures and Oracle Forms
• Customized standard Oracle reports and provided technical and functional support for an Oracle 11i implementation.
• Provided technical and functional support for an Oracle 11i implementation including reports customization.

Confidential

Senior Oracle EBS Technical Specialist

Responsibilities:

• Responsible for data conversion and interfaces for a full life cycle Oracle Implementation (11i, GL, AP and CM).
• Designed and built interfaces into Oracle GL from multiple feeder systems using PL/SQL, ksh and perl.
• Designed and built interfaces into Oracle CM. Designed and built Vendor conversion.
• Coordinated development of Legacy to Oracle interfaces involving client staff, contractors and external developers.

Confidential

Senior Oracle EBS Technical Specialist

Responsibilities:

• Assisted the consolidation of multiple sets of books into a global set of books.
• Analyzed and developed reports to meet statutory foreign and local currency reporting requirements for Hong Kong and Indonesia.

Confidential

Senior Oracle EBS Technical Specialist

Responsibilities:

• Conducted the as is assessment for the analysis phase of an Oracle Financials implementation (GL, AP, Confidential ).
• Interviewed the IT staff of two Japanese subsidiaries and produced an assessment workbook covering system configuration, network topology, legacy systems and legacy master files.
• Analyzed requirements for data conversion and Interfaces between Oracle Financials and legacy systems.

Confidential

Senior Oracle EBS Technical Specialist

Responsibilities:

• Analyzed conversion requirements for an Oracle Applications upgrade (GL, AP, AR and PO) from 10.7 to version 11i.
• Provide technical support to functional teams. Installed Oracle GLDI and ADI.
• Analyzed requirements for and capabilities of Appworx and Kintana software.

Confidential

Senior Oracle EBS Technical Specialist

Responsibilities:

• Developed interfaces from a SQL Server based investment management system into Oracle GL using Informatica.
• The interfaces handled complex venture capital transactions across multiple multi-national subsidiaries.
• The development effort covered analysis through testing.

Confidential

Senior Oracle EBS Technical Specialist

Responsibilities:

• Designed and developed an automation suite of programs for the month end process.
• The suite consisted of multiple programs using SQL and PL/SQL to automate and link multiple PA, AP and GL month end processes.
• Supervised two programmers during the development phase.

Confidential

Senior Oracle EBS Technical Specialist

Responsibilities:

• Developed an account profitability analysis modification for Confidential (OFSA).
• Designed, developed and tested multiple SQL and PL/SQL programs to extract and analyze data by product, account and channel.

Confidential

Senior Oracle EBS Technical Specialist

Responsibilities:

• Worked in multiple technical roles on an Oracle Applications 10.7SC implementation.
• Analysis of requirements for conversion of legacy data.
• Designed and developed conversion programs for Oracle Projects from legacy system.
• Design, development and testing of modifications and interfaces to Oracle Applications.
• Developed new and modified existing reports and forms in Payables (AP), Projects (PA).
• Conducted Quality review and Quality Assurance testing for numerous custom programs.
• Designed and developed an automated month end close scheduler.
• The effort required programming in shell scripting, SQL and PL/SQL and added functionality that was not present in the Oracle concurrent manager.
• This involved programs and interfaces in the AP, PA, GL and AR modules.
• Gave technical advice and support to help desk after offices went live with Financials.

Confidential

Senior Oracle EBS Technical Specialist

Responsibilities:

• Design, development and testing of modifications and enhancements to Oracle Applications (10.5).
• Developed new and modified existing reports, interfaces and forms in Purchasing (PO), Inventory (INV) and Work in Process (WIP).
• Sizing and installation of Oracle databases. Installed and configured Novell based software.
• Analyzed and defined Applications and database security and auditing requirements.
• Defined deployment procedures for LAN and server based software. Defined specification and programming standards for SQL*Forms and Reports 2.0 and 2.5.
• Developed reports for WIP, GL and AP modules using Oracle Reports.
• Provided technical support to Financials and Order Entry functional project teams.
• Installed a test instance of the Oracle Application.
• Conducted technical interviews for new development staff.

Confidential

Responsibilities:

• Support and modification of Oracle Financials (v9.4 & v10) on ICL and Sequent platforms.
• Developed EDI interfaces to import data from mainframe systems using PL/SQL, SQL*Plus and SQL*Loader.
• Developed programs to allow multi-org functionality in AP using views.
• Modified standard package forms and reports.
• Developed forms and reports using SQL*Forms3.0 and SQL*Reportwriter on Oracle6 and Oracle7.
• Produced technical documentation for new developers and redesigned some reporting functions.
• Development and testing of Confidential 's time recording system using and ORACLE7 database on an ICL DRS6000.
• Developed reports and forms using SQL*Forms3.0 and SQL*Reportwriter.