SUMMARY

• Oracle Applications Senior Analyst offering a wide array of cross - functional experience in IT, Finance and Manufacturing. Participated in 14 financial and manufacturing Oracle conversions in 10 countries as a lead analyst, while managing and training individuals globally.

AREAS OF EXPERTISE

• Oracle R11, R12 and Fusion ERP
• Oracle Conversions
• Writing Functional Specifications
• Set Up of Financial, Manufacturing and Distribution Systems
• End-User Training
• Post-Production Support

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA

Oracle Applications Senior Analyst

Responsibilities:

• Enhanced, and supported several Oracle financial and manufacturing modules for multiple companies and operating units located across North America.
• Maintained a solid understanding of several modules, both financial and manufacturing including GL, AP, AR, FA, OM, CM, PO, EBTAX, ASCP, DP, MRP, INV, BOM, ENG, CST and WIP.
• Worked closely with business to both understand existing process and provide enhancements / improvements when warranted.
• Worked closely with the programming staff, providing detailed programming specifications to support data conversions and end-user customization requests.
• Maintained a solid understanding of interfaces with external systems, both developing / enhancing as needed.
• Maintained a good understanding of SQL to help resolve end-user database and applications issues.
• Wrote functional specifications detailing technical requirements for both data conversions and customizations.
• Maintained a solid understanding of process flows throughout the entire suite of Oracle applications at both the functional and database levels.
• Setup and conducted end-user training across all functional areas.
• Developed and executed audit testing programs for IT systems.
• Streamlined current business practices with respect to Oracle applications

Confidential, Las Vegas, NV

Senior Oracle Financials Independent Consultant

Responsibilities:

• Led efforts to integrate Canadian financials from legacy system onto Oracle R12 including the setup and maintenance of all core modules.
• Worked with management along with key business partners in conjunction with developing detailed project plan.
• Helped analyze and define business requirements based upon legacy system / operations.
• Helped assess GAP/FIT analysis and provided recommendations and solutions wherever there was a departure from standard functionality.
• Led efforts to port legacy entities (AR Aging, GL Balances etc.) over onto Oracle.
• Helped construct detailed test scripts.

Confidential, San Diego, CA

Senior Oracle Analyst

Responsibilities:

• Implemented, enhanced, and supported several Oracle financial and manufacturing module for multiple companies and operating units located across North America and Europe.
• Maintained a solid understanding of several modules, both financial and manufacturing.
• Met with corporate executives monthly to ensure that all initiatives, both strategic and tactical, were adequately vetted, scoped, resourced and assessed for overall fit, both financially and architecturally.
• Worked closely with the programming staff, providing detailed programming specifications to support data conversions and end-user customization requests.
• Maintained a good understanding of SQL to help resolve end-user database and applications issues.
• Wrote functional specifications detailing technical requirements for both data conversions and customizations.
• Designed and implemented corporate foreign currency translation and consolidation program.
• Developed and launched a corporate inter-organizational sales process for US and foreign subsidiaries that fulfilled the needs of planning, order management, procurement and payables.
• Maintained a solid understanding of process flows throughout the entire suite of Oracle applications at both the functional and database levels.
• Setup and conducted end-user training across all functional areas.

Confidential, San Diego, CA

Senior Oracle Analyst

Responsibilities:

• Implemented, enhanced and supported several Oracle financial and manufacturing modules for multiple companies and operating units located across North America.
• Led efforts to re-architect existing software systems to accommodate rapid growth, both organic and through acquisition.
• Led cross-functional team in conjunction with incorporating legacy systems onto existing corporate architecture.
• Implemented MRP as part of corporate efforts to increase inventory turns.
• Initiated efforts to implement several systems-based process improvements to help facilitate daily processing and address regulatory concerns.
• Defined and created various reports extracted directly from the database for both the manufacturing and financial functional organizations.
• Implemented Assemble to Order (ATO) process for a key subsidiary.
• Designed and programmed all FSG’s.

Confidential - Orange, CA

International Director of Accounting

Responsibilities:

• Served on corporate post-acquisition team to ensure that newly-acquired entities were integrated into existing Oracle infrastructure.
• Participated in 12+ Oracle conversions in 10 countries.
• Incorporated three acquisitions into the existing corporate infrastructure, resulting in $200 million of new revenue with no additions to the accounting staff.
• Wrote functional specifications and set up financial, manufacturing and distribution systems. Led extensive end-user training sessions worldwide and offered post production support in all areas of accounting, costing, procurement, order management, planning and manufacturing.
• Reallocated headcount within both AR and AP by streamlining existing processes and eliminating non-value-added tasks.
• Managed month-end closings, including financial statement preparation, review and analysis and reduced past due balances by 75% and drove down DSO from 50 to 39 days.
• Implemented an Interactive Voice Response (IVR) system to automate customer payments and reduce outbound collection calls.
• Reduced headcount within payables by implementing pay upon receipt functionality.
• Participated in several Oracle upgrades worldwide.
• Identified $1.5 million in inventory discrepancies, and several thousand dollars worth of improperly invoiced trade products.
• Uncovered a $1 million WIP discrepancy caused by improper valuation and accounting control.
• Directed significant improvements to the unvouchered receipts reconciliatory program, currency revaluation procedures and month-end closing processes.
• Worked extensively with end users in conjunction with developing process improvements.
• Setup and conducted end-user training across all functional areas.
• Supervised a staff of 25 individuals worldwide.