SUMMARY

• He has 20 plus years of Oracle Applications Experience, both as a Consultant and Internal Application Support.
• He has completed multiple installs in a senior role with many different versions of Oracle.
• He has worked both in a Senior Role (Project Management) and independently and is comfortable in either environment.
• A majority of Confidential ’s work is as a Functional Consultant but has a very good understanding of the technical aspects of a project.

PROFESSIONAL EXPERIENCE

Senior Consultant

Confidential

Responsibilities:

• Multiple Projects to Support Streamline Initiative for Oracle Cloud
• Main Modules Supported: Payables, Purchasing, Iprocurement, Order Management, Shipping, Inventory, Cost Management, Cash Management, Advanced Collections, Receivables and eBTax
• Revised procedures and trained Planner/Buyer personal in Requisition and Purchase Order creation from the planners workbench(Purchasing/Iprocurement)
• Streamlined Cash Applications for AR
• Addressed Shipping issues from 3rd party system where transactions were getting stuck in the import to Oracle
• Remapped Sales Order interface to Oracle. Additional fields where needed for Oracle
• Worked with Internal Sales on Oracle CRM and Order Management functions that where not be utilized to streamline their processes.
• Retired 3rd party Tax software “Taxware” due to escalating yearly contract rates and replaced with Oracle eBTax for AR and OM
• Created a Custom Tax solution from Oracle eBTax to use with B2B (Website platform)
• Developed a daily plan for new item costing and transfers to multiple Inventory Organization. This was being done manually item by item previously.
• Created a program to use Oracle Return to Supplier Debit Memo’s as to the manual process of processing NCMR’s that was in place
• Setup a Dunning Letter Plan in Advanced Collections
• Lead Testing on change in Credit Card Authorization Partner/Software
• Setup and led testing on new Lockbox Transmissions, manually posting payments from the lockbox previously.
• Rewrote Month - end Closing procedures and Steps to help address reconciliation issues in the costing area.

Senior Consultant

Confidential

Responsibilities:

• Support the re-implementation of Oracle 11i to Oracle R12
• Main Modules Supported: Payables, Receivables, Purchasing,Cash Management and Iexpense
• Test, Design Review for custom interfaces to Payables and Purchasing. 4 Payables Invoice interfaces, 2 Purchasing Purchase Order interfaces, 2 PO receiving Interfaces and a Purchasing Requisition Interface
• Payables and Cash Management transactions in Multiple Currencies with FX transactions in the US operating account

Senior Consultant

Confidential

Responsibilities:

• Follow up work with Cash Management for Bank Reconciliation issues around the different levels of detail coming out of their Retail system to Oracle and the Bank to Oracle.
• Follow up on Costing and COGS issues. Created and changed several SLA Rules in conjunction with setup changes
• Invoice Consolidation for AR
• Follow up on Trade Management (used for Royalty payments) to Payables import and payments
• Follow up on Payables to Fixed Asset processes.
• Resolved Receiving issues both within Oracle and interfaces from 3rd party systems

Senior Consultant

Confidential

Responsibilities:

• Design and Document interfaces with legacy systems for a financials only (GL, AP, PO, Inv-Receipts,WMS) implementation. This implementation is an addition to an existing R12 production environment.
• Interfaces from Legacy to R12
• Purchase Order from Legacy to Oracle
• Receipts Legacy to Oracle
• GL Import from Legacy to Oracle
• Receipt Close from Oracle to Legacy
• Purchase Order Close from Oracle to Legacy
• Payables Invoices imported via EDI from 2 major Suppliers
• Created SLA rule for Expense accounts on Month-end Accruals and Invoices. The accounts were already charged in the legacy system and would be imported via the GL import. We needed to set those accounts to the accounts to the accrual account to zero the effect on the GL
• Payables Invoices are being manually entered into Oracle R12 and have been mapped to be entered via EDI form the two largest suppliers.

North American Finance Lead

Confidential

Responsibilities:

• AGIS Senior Consultant - Setup, tested and trained end users on the AGIS (Advanced Global Intercompany System) for a worldwide implementation. 1000+ Legal Entities transacting with each other and setting them up to flow through AGIS for the appropriate intercompany transactional accounting.
• Designed custom program to settle open Intercompany AR Invoices once the AP intercompany payment run was completed
• North American Finance lead

Independent Contractor

Confidential

Responsibilities:

• Performed Set-up, Testing, Data Gathering and Training on the following Modules in a Rapid Implementation Environment
• Fixed Assets(Performed Conversion with ADI and Set-Up)
• Purchasing
• System Administrator
• Discoverer
• Inventory (Multiple Locations and Companies)
• Set-up of Inventory besides Phone equipment and supplies was generally based on the construction of Cellular towers and Land line phone network build out. Multiple companies drawing from the same inventory, serial controlled, min-max reordering stock controls, locator and lot control. The biggest issue here was the tracking on Cable, how to issue it and what company and what project.
• Aided with the Set-up of the following:
• General Ledger
• Payables

Inventory, Order Entry and Fixed Asset Specialist

Confidential

Responsibilities:

• Provided technical and function direction on Oracle Inventory, Order Entry and Fixed Assets in a Manufacturing environment. Assisted and instructed the client in the application set-up of these modules to meet their business requirements. Provided support and guidance for modules already installed and in production (Purchasing, Accounts Payables and General Ledger). Assisted the client in realizing the enhancements and gaps in their existing project commitment based reporting system and the suite of Oracle Applications being implemented. Developed permanent and temporary (in association to future Oracle Modules to be installed) processes and reporting solutions to cover such obstacles.
• Developed a procedure, logic and cross-reference table to incorporate items from 3 separate Legacy Inventory systems to be loaded into the MTL Systems items table with the appropriate attributes and inventory organization assignments. Logic had to be designed to incorporate the Manufacturing and movement of items across 9 Inventory Organizations.
• Develop the logic for an interface from a Legacy Warehouse system to pass pick confirm and shipment information to Order entry through the MTL Transactions Interface. And devised a timing strategy for the Concurrent Managers to run in conjunction with the production of the Legacy flat file to assure accuracy between both systems.
• Developed a procedure, logic and cross-reference tables to incorporate item categories from 3 separate Legacy Inventory systems to be loaded into the appropriate inventory tables. Logic had to be designed to incorporate items across 9 Inventory Organizations with multiple category assignments within individual organizations.
• Developed and implemented the logic, cross-reference and coding of Legacy Fixed Assets to be pushed through Mass Additions table to assure the proper population of multiple Fixed Assets tables. Modified Flex Builder to accommodate a lower level of depreciation tracking.
• Developed logic, implemented and tested interface between legacy Order-Ship-Build system and Oracle Order Entry to assure proper item shipment movements. Devised a schedule for the concurrent managers to be run to assure timely, efficient item movement between the two systems to assure a reasonable ability to reconcile.
• Developed a process for the end users to properly combine assets coming to FA and legacy capital expenditure system.

System Analyst

Confidential, Sacramento, CA

Responsibilities:

• Responsible for hands-on management of an Oracle Purchasing and Inventory re-engineering and implementation project for the Sacramento market. With responsibilities including project planning, resource scheduling, new process definition and Oracle Applications setup and implementation. Other responsibilities were the management of the design and development of a Sales Compensation System, which was integrated into the Oracle Applications. And also participated in many other internal development and implementation projects at AirTouch including a Point of Sales system, a Capital Tracking System and more.
• Developed the logic, views and temporary tables to enable the Adhoc Capital Tracking System to properly report monthly Capital Expenditures by project. These views and tables spanned Oracle Accounts Payable, Purchasing, Fixed Assets and General Ledger.
• Developed logic to interface third party Point of Sale product to Oracle Purchasing, Payables and General Ledger.