SUMMARY:

Senior Functional Consultant with 20+ years’ experience implementing, supporting and developing/delivering training for Oracle Confidential, with an emphasis on core financials and procure to pay modules.

TECHNICAL SKILLS:

Application Software: 12.1.3 Oracle PO, INV, OM, Sys Admin

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Senior Business Analyst

Responsibilities:

• Functional lead for Procurement on three separate implementation projects over a period of 28 months.
• Informally trained Canadian project team members on basic Navigation, Inventory, Purchasing and Order Management functionality.
• Created and documented functional setups for Purchasing and Order Management for two international operating units.
• Led the system administration activities for two projects; defined custom responsibilities, menus and request groups; defined profile options to support multi - org responsibilities while maintaining cross OU security.
• Trained client resource in system administrator job functions, including custom menus, responsibilities and request groups.
• Defined new and updated existing supply chain sourcing schemas to support cross OU purchasing; created data loaders for assignment sets and sourcing rules.
• Trained end-users on the use of data loaders to convert master data including sourcing rules, sourcing assignments, contract purchase agreements.
• Designed and documented (using MD050s) custom reports, interfaces, forms and programs.
• Trained international procurement team in Oracle Procurement including navigation, creating, modifying and approving POs, querying items/viewing attributes for items at the Master and Organization Attributes level, utilizing sourcing rules and assignments, and viewing receipt and invoice transactions against existing POs.

Lead Functional Consultant

Confidential, Charlotte, NC

Responsibilities:

• Created and documented (using MD050s) functional designs for interfacing suppliers, supplier bank accounts, customers, customer (AR) invoices, and vendor (AP) invoices from various transportation management systems into Oracle Confidential
• Created and documented (using MD050s) functional designs for interfaces from Oracle for cash receipts and supplier payments
• Configured, tested, and documented General Ledger Automatic Intercompany Eliminations functionality for revenue and cost of sales
• Configured, tested, and documented AR/AP netting functionality
• Created and delivered application demonstrations on AR/AP netting and Automatic Intercompany Eliminations to key finance stakeholders

Functional Consultant

Confidential, Monroe, NC

Responsibilities:

• Provided pre-cutover, cutover and post-production support for Payables, General Ledger, Cash Management modules for multi-billion dollar metals manufacturer.
• Modified seeded Subledger Accounting to support payables accrual process.
• Developed test scripts and performed testing of application patches and configuration modifications/updates.
• Created functional specifications for new CEMLIs; change requests for existing CEMLIs.
• Developed and delivered end-user training for Oracle Report Manager, RXi Reports, and Web ADI.
• Performed reporting gap analysis for financial modules (AR, GL, FA) and provided recommendations for report solutions (RXi, BI, standard Confidential, Report Manager).
• Provided support for FA/AP/AR functional lead on business processes including wire transfer payments, lockbox processing.
• Supported the testing process of the month-end reconciliation for Accounts Receivable.
• Validated designs for and tested customizations for Accounts Receivable module.
• Gathered functional requirements for OBIA (financial) modifications and enhancements.
• Wrote functional specifications to configure the accounting flexfield in OBIA, validated/tested configuration in all seeded reports for financial subject areas.
• Analyzed and developed OBIA dashboards based on the requirements of custom Financial Analytics.

Functional Consultant

Confidential, Davidson, NC

Responsibilities:

• Gathered and documented business requirements for automated bank statement reconciliation using Oracle Cash Management.
• Documented exiting business procedures and developed future process models and flows.
• Trained end-users in Oracle bank statement reconciliation functionality.
• Created and documented functional setups for CE based on business requirements; created test scripts for CRPs.
• Assisted super-users in executing CRP tests.
• Provided production support.

Functional Consultant

Confidential, Charlotte, NC

Responsibilities:

• Defined requirements for, develop and train on solution for implementing blanket purchase agreements.
• Troubleshoot connectivity problems to Oracle applications and ADI.
• Interface with Corporate Applications support as on-site contact to verify user issues and resolve same.
• Develop and deliver tailored training materials for Oracle Navigation, FSG’s, ADI, Purchasing, standard Oracle reports for ledger and sub-ledgers, custom folders, utilizing themes in ADI, exporting data, etc.
• Identified key areas for business process improvement, including receipt accruals, budget updates, and additions of assets.
• Modified existing FSG’s to comply with best practices; wrote FSG’s.
• Identified technical problems with budget uploads through ADI; resolved problems and trained users.
• Documented current sales and use tax processes in AR and AP modules; researched and presented options to achieve regulatory compliance.
• Developed and documented process for utilizing standard Oracle GL functionality to update forecasts with actuals.
• Developed and tested content sets to achieve management reporting objectives.

Functional Consultant

Confidential, D allas, TX

Responsibilities:

• Gathered and document business requirements for Payables and Treasury departments.
• Documented current business procedures.
• Developed future process models and flows compliant with SOX requirements.
• Wrote Functional Specifications for seven AP interfaces.
• Wrote Functional Specifications for four AP custom reports
• Trained managers and end-users in AP and CE functionality.
• Created and documented functional setups for AP and CE.
• Created test scripts for AP and CE.
• Defined requirements for customize in-house check printing.
• Assisted super-users in executing CRP tests.

Lead Functional Consultant

Confidential, New orleans, LA

Responsibilities:

• Developed and delivered overview training classes for Navigation, GL, FA, AP, and System Administration
• Gathered and documented business requirements for Payables and Treasury departments.
• Gathered and documented requirements for purchasing and inventory modules.
• Documented current business procedures.
• Developed future process models and flows compliant with SOX requirements.
• Trained managers and end-users in AP and CE functionality.
• Created and documented functional setups for AP and CE.
• Created and documented test scripts for AP and CE.
• Implemented customized check printing for in-house and outsourced payables payments
• Assisted super-users in executing CRP tests.
• Provided post-implementation support.

Applications Trainer

Confidential, Little rock, AR

Responsibilities:

• Identified gaps in knowledge and skills in Oracle applications 11.5.5.
• Developed tailored training materials to help users gain necessary skills.
• Delivered eight hands-on training sessions to various levels of users, including managers and clerks, over a period of three months.

Functional Consultant

Confidential, Mason, OH

Responsibilities:

• Trained distribution center management and staff in Oracle Order Management, Inventory and Purchasing functionality.
• Planned for and implemented open sales order conversion.
• Planned for and implemented open purchase order conversion.
• Configured OM, PO, INV modules to meet client requirements.
• Loaded all items in inventory organizations to be included in for physical inventory.
• Assisted users in performing initial physical inventory.
• Performed post-production support.

Functional Consultant

Confidential, Raleigh, NC

Responsibilities:

• Participated in conference room pilot testing for interfaces to Oracle.
• Developed interface testing scripts.
• Provided end-user training on functionality of Oracle purchasing and inventory applications.
• Provided technical expertise to third party software company on Oracle database tables used for interfacing data into Oracle applications.

Functional Consultant

Confidential, Charlotte, NC

Responsibilities:

• Determined scope, requirements, objectives and risks of implementation.
• Deliverables included Detailed Project Plan for Phase I, Statement of Work and Implementation Recommendations.
• Used Oracle AIM for all project deliverables.

Functional Consultant

Confidential, Raleigh, NC

Responsibilities:

• Implemented P-Card functionality with customizations to meet encumbrance accounting requirements.
• Identified knowledge and skills gaps in end-user community; developed and delivered training materials to address gaps.
• Developed and implemented plan for first physical inventory; trained end-users and supported process.

Functional Consultant

Confidential, M iami, FL

Responsibilities:

• Determined business requirements.
• Demonstrated application functionality for implementation team and senior management.
• Assessed fit between business requirements and application functionality.
• Provided recommendations regarding prospective iProcurement implementation.

Trainer

Confidential, Austin, TX

Responsibilities:

• Identified appropriate Oracle Tutor 11.03 training materials.
• Performed heavy customization to suit client configuration and ported training materials to version 11.5.9 for modules GL, AP, PO, FA, INV, and OM.
• Delivered multiple sessions of super-user training for GL, AP, PO, FA, INV, OM.
• Provided one-on-one training to end-users as needed.

Oracle Functional Lead

Confidential, Schaumberg, IL

Responsibilities:

• Gathered and documented global business requirements for payables and purchasing departments.
• Documented current business procedures.
• Trained super-users in AP and PO functionality.
• Created and documented multi-organizational functional setups for AP and PO.
• Created and documented test scripts for AP and PO.
• Assisted super-users in executing CRP test scripts.
• Provide post-production support.

Functional Consultant

Confidential, Greensboro, NC

Responsibilities:

• Modified AP setups to support business requirements.
• Conducted end-user training on system navigation, purchase order/invoice matching, blanket purchase agreement setup and use
• Performed system administration tasks, including setting up new users, defining custom responsibilities, creating custom menus, setting up printers.
• Created custom reports using SQL*Plus.
• Resolved problem transactions and trained users in problem solving procedures.
• Validated system data.
• Developed and documented new business processes.
• Review/critiqued technical specifications for system customizations.

Oracle Trainer

Confidential, Charlotte, NC

Responsibilities:

• Developed two day training session for Oracle AP.
• Delivered AP training to two groups of end-users and managers.
• Developed three day training session for Oracle PO and AP/PO Integration.
• Delivered three day training session for end-users and managers.