SUMMARY

• Twenty years of IT experience providing Oracle Applications solutions including implementation, customization, upgrade, maintenance and support of Oracle Applications.
• Expertise in setting up and using various Oracle Applications versions.
• Release 9.x/ 10.x/ 11.x/12.x., as well as providing technical expertise in creating custom extensions including reports, interfaces, conversions, extensions, forms and workflows.

AREA OF EXPERTISE:

• Oracle General Ledger
• Oracle Receivables
• Oracle Payables
• Oracle Assets
• Oracle Internet Expenses
• Oracle Cash Management
• Oracle Incentive Compensation
• Approval Management Engine (AME)
• Oracle Human Resource (HRIS)
• Oracle iProcurement
• Oracle Purchasing
• Oracle Order Management
• Oracle Service Contacts
• Oracle Cost Management
• Oracle Inventory
• XML Gateway
• System Administration/AOL

TECHNICAL SKILLS

Databases: Oracle 8i, 9i, 10, 11, 12

Languages: PL/SQL, SQL,SQL*Plus, Shell Scripts

Tools: TOAD, Workflow Builder, SQL*Loader, SDLC Methodology

Reporting: BI Publisher, Oracle Reports, Discoverer, Cognos

PROFESSIONAL EXPERIENCE

Confidential

Oracle Applications Functional/Technical Lead Consultant

Responsibilities:

• Senior resource on implementation team that integrated Oracle EBS Financials with a third - party revenue recognition system (RevPro) Key areas supported were Oracle Order Management, Inventory, Service Contracts, Accounts Receivables, General Ledger, and related custom systems.
• Provided production support for Procure to Pay and Order to Cash processes. Used JIRA software to plan, track, and manage software development projects and help desk tickets.
• As a techno-functional resource, took on challenging new development projects and enhancements. Responsible for developing custom RICE components (mainly using PL/SQL and APIs) as well as recommending configuration changes within Oracle
• In Depth knowledge and familiarity in underlying Oracle ERP applications database architecture as well as Oracle development tools.
• Acted as a liaison between business users, local technical team, and offshore technical team. Support defect resolution during all test phases. Partner with project managers and business analysts to review and understand business requirements and recommend solutions.

Confidential

Oracle Applications Functional

Responsibilities:

• Team lead on the enhancement and production support of Oracle applications including: Human Resources, General Ledger Payables, IPM, Receivables, iProcurement, Purchasing, Inventory and Service Contracts.
• Work closely with end users in the identification and documentation of business requirements and potential application solutions. Responsible for Oracle ERP configuration reviews, process improvement and training.
• Responsible for implementing new features and enhancements such as Payables ACH process, Electronic Invoice, on boarding of new Punch-out sites and local catalogs, customizing workflows, setting up AME approvals, custom reporting etc…
• Project Lead responsible for the integration of Oracle Applications from a newly acquired company into the existing Oracle ERP system.
• Excellent technical skills with Oracle Apps and Oracle PL/SQL. Proficiency in PL/SQL, SQL, Workflow 2.x, Forms and Reports 6i
• Acted as Technical Lead responsible for developing custom extensions and enhancements to ensure that system continues to meet business owner’s needs. Optimization and Tuning of existing PL/SQL stored procedures and packages. Solid exposure to oracle’s API’s and Open Interfaces.
• Provided functional application support/training for Oracle Applications using Footprints for tracking help desk tickets.

Confidential

Oracle Applications Functional/Technical Lead Consultant

Responsibilities:

• Key member of the implementation team to enhance the “ Confidential ” business process for a large company that provides consulting for IT infrastructure technology.
• Functionally and technically lead the implementation of several new Oracle modules including Oracle Sales Online, Quoting, Proposals, Purchasing and Inventory. Accountable for the integration of new modules with existing modules including Oracle General Ledger, Receivables and Payables.
• Responsible for working closely with users to determine new business processes, gather requirements, define system configurations and create functional designs and configuration documentations.
• As member of Quality Assurance team, was tasked with creating test scripts and participating in the execution of functional testing in QA and UAT environments. Identified and resolved testing defects, and issues, Performed post go-live production support for the Service Desk.
• As a technical lead designed, documented and developed several custom extensions and enhancements required for the implementation of the new modules using Oracle API’s and PL/SQL packages and procedures.
• Lead the design and development of end-user reporting solutions using BI Publisher, Oracle Reports and Discoverer. Reporting included custom Invoices, Proposals, Pick Slips, Packing Slips, and several other customer specific reports.

Confidential

Oracle Applications Functional/Technical Consultant

Responsibilities:

• Provided functional application support in a production environment during various enhancement projects for a company that certifies manufacturers with product safety compliance.
• Responsible for all aspects of production support for domestic and international operations in a multi-organization, multi-currency environment. Company maintains over 70 sets of books worldwide.
• Supported several applications including GL, AR, AP, PO, OM, FA, CRM, Internet Expenses and Advanced Collections. Used Peregrine Software to track help-desk tickets.
• Lead the implementation of new features such as: AR Customer Credit Limits, AR Dunning Letters and AP Matching Tolerances and a new FA corporate set of books. Implemented new features to accommodate the specific language and country requirements.
• Responsible for the design, testing, and implementation of various other custom extensions including a Treasury Bank Form, an Automated Invoice Adjustment program, company specific AR Aging Reports, GL Translation, Revaluation and Consolidation reports.

Confidential

Oracle Applications Functional Lead Consultant

Responsibilities:

• Acted as a Functional Financial Team Lead in an upgrade of 11.5.10.2 to 12.0.2 for a large candy manufacturer.
• Responsible for requirements gathering, developing business processes, determining gaps and the configuration of Oracle Payables, Oracle Cash Management and Oracle Receivables modules.
• Provided user training on the applications and new features such as Multi-Org Access Control, Sub Ledger Accounting (SLA) and Web ADI.
• Accountable for system testing and the creation of detailed test scripts, identifying application defects and communicating issues to internal business analysts and developers.
• Provided assistance to the technical team and users with the go-live process and post-production support.

Confidential

Oracle Applications Functional/Technical Consultant

Responsibilities:

• Provided production support for a national organization that represents and serves hospitals and health care networks.
• Responsible for reviewing, prioritizing and researching help desk issues as well as implementing the solutions. Business areas include Oracle Financials, Oracle Human Resources, Time and Labor and Benefits Administration.
• Implemented Oracle’s Report Manager, for the Finance Department, to issue Financial Statements (FSG) and standard reports in XML format.
• Designed, developed and implemented two custom PL/SQL interfaces: the Pension Benefits Monthly Interface and the Halogen Monthly Employee Appraisal Information Interface.
• Responsible for creating new Discoverer reports and trouble-shooting existing reports. Additionally, created custom User Security reports using SQL.
• Additionally, participated in special projects, involving the implementation of a new tool or application such as HR Intelligence, Manager Self Service and Web ADI.

Confidential

Oracle Financials Technical Team Lead

Responsibilities:

• Performed as the Technical Team Lead on a projectto consolidate two legal entities into a single entity in Oracle Applications 11.5.9 for a large manufacturing company.
• Worked with management and users on business requirements gathering and the design of system, including the recommendation of new business processes.
• Responsible for defining configuration changes needed for the consolidation of the entities. Applications included were: Oracle General Ledger, Oracle Assets, Oracle Projects, Oracle Payables, Oracle Inventory, Oracle Purchasing and Oracle Cash Management.
• Designed, developed and implemented the conversion of Open purchase orders, open poreceipts, supplier banks, suppliers, AP open invoices and custom cross references using Oracle’s open interfaces, public APIs and PL/SQL. Developed custom reporting via SQL and Discoverer.
• Provided functional and technical support for all issues relating to the Oracle Financials applications.
• Lead the integration and user acceptance testing efforts.

Confidential

Oracle Financials/Manufacturing Team Lead

Responsibilities:

• Project Team Lead for an implementation of a custom Scan-based Trading (SBT) system using 11.5.10.2 of Oracle Applications. Provided an assessment and identified the components for the SBT solution.
• Monitored the implementation of the SBT model and identified and resolved any variances between the initial design and the implementation.
• Designed, developed and implemented custom interfaces for: AR Customer Sites, Inventory Items and Item Categories using Oracle’s Open Interfaces and Public API’s.
• Additionally designed, developed and implemented an on-going Cost Management production interface for updating item costs on a daily basis in the SBT organizations.
• Created custom workflows for Order Management (using Oracle Workflow Builder) to accommodate the new SBT Order Types needed. Developed several custom reports as required by the new process.
• Assisted with the testing phase and provided on-going Production support as needed. Primary focus on Oracle General Ledger, Receivables and Incentive Compensation Modules.

Confidential

Oracle Financials Team Lead

Responsibilities:

• Served as a Team Lead for an Oracle Applications upgrade from 11.5.5 to 11.5.10.2 for a large Greeting Card Manufacturer.
• Provided an assessment of current system components and test strategy, processes and practices. Modules responsible for: Oracle General Ledger, Payables, Receivables, Cash Management, CRM and Oracle Incentive Compensation. Also worked closely with the RPG Data Warehouse and Oracle Discoverer teams.
• Worked with users to assess new features and functionality that would enhance the current business processes. Prepared and executed New Functionality Workshops.
• Created detailed test plans and defined and implemented processes and best practices with regard to component testing. Lead the integration and user acceptance testing efforts for all Financial applications.
• Responsible for issue resolution arising during the testing phase. Work closely with users, developers and Oracle to resolve all issues.

Confidential

Oracle Applications Team Lead

Responsibilities:

• Managed the project of an Oracle Applications re-implementation to 11.5.9 for a large Banking client located in Connecticut.
• Responsible for the functional system setup of AP, FA and Internet Expenses. Worked with the Project Manager, Business Analysts and End-Users to configure the above modules based on business process requirements.
• Technical Team Lead responsible for the conversion of Legacy Suppliers, Sites and Bank Accounts. Also responsible for the conversion of Fixed Asset Categories and Fixed Assets using PL/SQL programs and Oracle’s open interfaces. Modified Fixed Assets workflows in order to meet the reporting requirements of the client.
• Developed System Setup, Unit Test and UAT Testing Documentation per Oracle’s AIM Methodology.

Confidential

Oracle Applications Training Team

Responsibilities:

• Served as a Training Team member that developed customer specific training documentation, using Oracle Tutor, for a large public sector transportation authority.
• Accountable for the design and development of multiple-day, instructor-led, training classes.
• Designed and developed training classes in the Financials, Manufacturing and Human Resource areas.
• Provided Train-The-Trainer courses to prepare instructors to deliver training classes.
• Wrote course designs, training curriculum, course activities and quick reference guides.
• Worked closely with the functional team leads and end-users to define and test business processes.

Confidential

Oracle Applications Team Lead

Responsibilities:

• Served as a Functional Team Lead for an Oracle Applications upgrade from 11.5.3 to 11.5.8 using a 9i database for a large Building Controls Manufacturer.
• Performed unit and integration testing for the Financial and Manufacturing modules in a highly customized environment; Oracle General Ledger, Payables, Assets, Cash Management, Purchasing, Order Management and Inventory.
• Tracked testing issues using PVCS Tracker and developed solutions to address the issues. This included working with developers, end-users as well as Oracle Support.

Confidential

Oracle Applications Functional/Technical Consultant

Responsibilities:

• Identified and assessed post-production issues with Oracle Financials modules for a large Health Products Distributor.
• Reviewed system setups and provided recommendations and direction for Financial Systems, including Oracle Receivables, Payables and General Ledger modules. Responded to issues and assisted in the redesign of processes per client’s specific business requirements.
• Developed procedures for AP and AR period-end balancing and led the training effort needed to train GL users in creating FSG’s (Financial Statement Generator) using the Application Desktop Integrator tool (ADI).
• Designed and developed a custom interface for the AP Check Reconciliation process in Cash Management using PL/SQL and SQL*Loader. Created custom Receipt Registers using SQL*Plus. Provided detailed design documentation to support the above customizations.

Confidentia

Oracle Applications Team Lead

Responsibilities:

• Performed as a Team Lead on an Oracle Applications upgrade from 10.7 Smart Client to Release 11.5.3, for a large Building Controls Manufacturer.
• Worked with the Project Manager, Business Analysts and End-Users to configure the above modules based on business process requirements. Developed solutions to address any “GAP” issues.
• Lead efforts for the design of effective testing strategies including test planning, test script development, test execution, and defect management.
• Retrofitted the 10.7 customizations into the 11.5.3 environment in a highly customized environment.
• Responsible for the design, development and code changes needed, due to the upgrade. Designed and developed new complex month-end balancing reports.
• Focus was Oracle General Ledger, Payables, Assets, Cash Management, Purchasing, Order Management and Inventory modules.
• Provided production support and training to end-users.