We provide IT Staff Augmentation Services!

Oracle R12 Functional Lead Consultant Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • I am a team - oriented consultant with strong analytical, communications and business development skills. I also have technical depth in finance and accounting. In addition to several years of audit and accounting experience, I have over 16 years experience in requirement definition, evaluation, data conversions, selection and implementation of financial system solutions. My recent focus is on Oracle Financials implementation.

TECHNICAL SKILLS:

Platforms: Windows NT, Unix (Linux), Sun (Solaris), HP (HP/UX)

Oracle Development Tools: Oracle Forms 4.5/6i, Oracle Reports 2.5/6i

Other Applications: Microsoft Office Professional. IBM Lotus Notes

PROFESSIONAL EXPERIENCE:

Confidential

Oracle R12 Functional Lead Consultant

Responsibilities:

  • Gathered and validated requirements for GL, AP, AR, PA and SLA in preparation for the upgrade to R12. Reviewed validated requirements for fit to core Oracle R12 functionality.
  • Participated in the design of the multi GAAP global ledger and operating unit structure. Worked with key finance users to validate structure for a fit to core Oracle R12 functionality.
  • Reviewed existing Record to Report business process and prepared a global process template prior to the upgrade to R12
  • Reviewed current FA Account Generator setups and validated for fit to R12 SLA structure.
  • Reviewed GL and subledger roles and responsibilities in the 11i instance in preparation for the upgrade to R12.
  • Trained finance users on core R12 functionality.

Confidential

Oracle R12 EBS Functional Lead

Responsibilities:

  • Gathered and validated business requirements for the deployment of GL, PA, SLA and FA for GMF locations in the US and Latin America.
  • Configured and validated GL, PA, FA and SLA setups in the test and production instances for the US and Latin America countries.
  • Worked with end users to validate configured SLA entries in the GL. Resolved issues arising from these entries.
  • Develop and deploy a reporting strategy for GMF companies in the US and Latin America.
  • Prepared functional specifications on master and transactional data conversions in the test and production instances. Worked with the technical team to test converted data and resolve functional issues arising from these conversions.
  • Prepared CRP test plans and worked with end users to test module configurations and custom objects in the Oracle EBS R12 instance.
  • Worked with Oracle Support to resolve bugs in the Oracle R12 test and production instances. Raised and follow through on SR’s raised with Oracle Support..

Confidential

Oracle EBS Functional Lead

Responsibilities:

  • Worked with global process owners to develop a global process template for the following modules: GL, CM, SLA, FAH and AGIS. The global Chart of Accounts was also developed as part of this global process template.
  • Configured and tested GL, CM SLA, FAH and AGIS in the CRP instances. Worked with global process owners and end users to resolve issues arising from CRP test results.
  • Developed functional specifications for interfaces and conversions to the GL, FAH and AGIS. Work with the technical team to build and test these interfaces. Put in place a functional test plan to test these custom interfaces and conversions.
  • Worked with subledger leads to test SLA and FAH entries in the GL and resolve issues from subledger postings. Reconcile SLA and FAH entries with the GL and subledgers.
  • Worked with Oracle Support to resolve bugs and issues arising from the configured modules above.

Confidential

Oracle Functional Lead - Financials

Responsibilities:

  • Developed the functional plan for this R12 EBS implementation. Provided weekly status reports to the Project Manager and managed the functional team.
  • Developed a global chart of accounts for the use of LIDESTRI US operations. Configured the GL, PA, SLA, AP, AR, FA, and EB Tax modules in the development, test and production instances.
  • Prepared functional specifications for EDI and Payment interfaces for Bank of America.
  • Worked with the technical team and banks to test custom bank interfaces.
  • Worked with end-users to test these modules and assist with the resolution of issues arising from the tests.
  • Worked with Oracle Support to resolve bugs and issues in the implemented modules.
  • Worked with the technical team for the conversions of GL balances, open items, vendors, customers in the conversion and production instances.

Confidential

Oracle Functional Lead

Responsibilities:

  • As Functional Lead, prepared the conversion plan from the legacy AP system to Oracle Accounts Payable 11i in a shared services environment.
  • Worked with the financial controller to define and map requirements to the standard Oracle Payables functionality. Identified gaps and proposed solutions to the gaps identified.
  • Prepared functional specifications for the interfaces to RBC and conversion of vendors in the test and production instances. Worked with the technical team to test and migrate all RICE components in all configured instances
  • Prepared the master test plan and worked with finance end users to test the Oracle Accounts Payables system and assisted with the resolution of issues.
  • Configured Oracle Accounts Payable in the test and production instances.

Confidential

Oracle Functional Lead - OFSS Project

Responsibilities:

  • As Functional Lead, prepared the upgrade plan from 11.5.10.2 for all government departments involved in the OFSS project.
  • Prepared business requirement documents for the GL, AR, TCA and SLA piece of the implementation.
  • Configured GL and SLA in the test and production instances,
  • Prepared functional specifications for the government interfaces in the GL and AR. Worked with developers to test and validate these interfaces.
  • Worked with Oracle Support to resolve issues in the core functionality of the applications

Confidential

Oracle Functional Lead

Responsibilities:

  • As Functional Lead, prepared the upgrade plan from R 11.5.10.2 to R12.0.6 for the GL, SLA and Report Manager
  • Developed a new multi-org and ledger structure for the use of Irving Oil Limited to meet complex IFRS and CGAAP reporting requirements.
  • Captured functional and technical requirements. Mapped requirements to the standard Oracle R12 functionality and identified the gaps. Provided solutions to the identified gaps.
  • Configured GL, SLA and Report Manager in the test and production instances.
  • Prepared a master test plan and test scripts for UAT and three iterations of CRP. Worked with end users to implement test scripts and resolve issues arising from these tests.
  • Worked with Oracle Support and Oracle On Demand to resolve identified bugs in the R12 application functionality

Confidential

Oracle Financials Lead

Responsibilities:

  • As Functional Lead, developed the functional plan for this R12 implementation. Provided weekly status reports to the Project Manager and managed the functional team.
  • Developed a global chart of accounts for the use of Epic world-wide operations. Configured the GL, AGIS, AP and AR modules in the development, test and production instances
  • Worked with end-users to test these modules and assist with the resolution of issues arising from the tests.
  • Worked with the technical team for the conversions of GL balances, open assets, vendors in the conversion and production instances.
  • Developed EDI templates for AP payments to RBC. Worked with RBC Canada to resolve issues arising from the automatic file transmissions.

Confidential

Oracle EBS Functional Consultant

Responsibilities:

  • Captured functional requirements and developed a global chart of accounts for the use of MDA North America. The COA was designed in line with Oracle R12 functionality.
  • Developed the multi-org structure for use by MDA North America for this R12 implementation. Entities defined include: Business groups, Legal entities, Ledgers, Ledger sets and Operating units
  • Identified, analyzed and documented the gaps between the functional requirements and the standard oracle R12 functionality. Proposed solutions to the gaps identified.
  • Prepared GL E-Business Tax and FA configuration documents for the test and master instances. Configured and tested these modules for the different iterations of the Conference Room Pilot
  • Assisted with the analysis, configuration and testing of PO, AP and CM.
  • Utilized XML Publisher to prepare FSG reports and change the look and feel of standard reports.
  • Worked with the technical team for the conversions of GL balances, open assets, vendors in the conversion and production instances.
  • Tracked issues and worked with Oracle Support to resolve issues.
  • Prepared weekly status reports for the project management office.

Confidential

Senior Functional Consultant

Responsibilities:

  • Captured, documented and validated business requirements.
  • Documented current business processes and mapped same to oracle financials release 11i/12 functionality.
  • Led the chart of account design sessions and developed a new chart of accounts in line with oracle financials release 11i/12 functionality.
  • Developed demo scripts used in the assessment.

Confidential

Senior Functional Consultant

Responsibilities:

  • Worked with technical resources to review customizations and the fit into the 11.5.10.2 environment. Assisted with the migration of custom schemas and objects.
  • Prepared a Master Test Plan and guided end-users in the implementation of the different test cycles. Developed procedures for migrated data validations
  • Worked with end-users to resolve critical issues. Track and expedite oracle TARS and assist with the planning and testing of updates and patches
  • Provided post-production functional/technical support.

Confidential

Senior Functional Consultant

Responsibilities:

  • Identified and analyzed customizations. Mapped customizations to new functionality.
  • Developed detailed decision papers to support recommendations for utilizing new functionality or upgrade existing customizations.
  • Prepared a detailed test strategy and guided super-users in the implementation of the different iterations of the Conference Room Pilot (CRP). Developed procedures for converted data validations.
  • Worked with super-users to resolve critical issues. Track and expedite oracle TARS and assist with the planning and testing of updates and patches.
  • Provided post-production functional/technical support to end users.

Confidential

Senior Functional Consultant

Responsibilities:

  • Developed high level test scenarios for the SIT phase of the project. Assisted with the resolution of functional project issues.
  • Designed and developed the conversion process for historical AR transactions into Receivables during the implementation process.
  • Provided functional/technical support after implementation.
  • Mapped Cartesis (Aviva’s consolidation and reporting tool) data elements to Oracle GL flexfield structure. Identified and resolved mapping related issues.
  • Captured user requirements and prepared functional specifications for the automated interface from Oracle GL to Cartesis. Developed validation procedures for converted data in Cartesis.
  • Provided functional support to end-users for Oracle GL, AP, Fixed Assets and Cash Management.
  • Worked with technical resources for the testing of the automated interface from Oracle GL to Cartesis.

Confidential

Oracle Functional Consultant

Responsibilities:

  • Mapped existing Chart of Values to newly defined Oracle accounting flexfield structure. Identified and resolved mapping related issues.
  • Captured user’s requirements and prepare functional specifications for the report development phase of the FSRP project. Conducted a reporting fit analysis and develop a reporting matrix for end users.
  • Reconciled GL data in Oracle Financials with the data warehouse using a variety of methods (Sql plus, Discoverer, Toad and ADI)
  • Used Oracle Discoverer and Oracle Financial Analyzer to build and test end user reports for the different iterations of the Conference Room Pilot
  • Developed validation procedures for legacy system data converted to Oracle GL. Identified and reconciled differences between legacy systems data and Oracle GL.

Confidential

Business Analyst

Responsibilities:

  • Worked with Oracle Support to apply and test patches for bugs in Oracle Financial modules.
  • Maintained and updated Oracle Financial module configuration workbooks
  • Captured users’ requirements, prepared functional specifications and developed link test scripts to extensions, interfaces and custom report solutions.
  • Proposed and tested configuration choices at user’s request
  • Trained users maintained and updated user procedure documents.

Confidential

Oracle Financial Analyst

Responsibilities:

  • Provided post-production functional support for Oracle AR, AP, PA and FA modules. Worked with Oracle support to apply and test patches for bugs in Oracle Financial modules. Responded to oracle functionality queries. Performed period end closing for Oracle AR and AP modules.
  • AR and AP functional resource for the upgrade of Oracle Financials 10.7 to 11i. Proactively interacted with end users to identify and document business requirements. Performed fit/gap analysis. Worked with end users to identify and document systems integration test scenarios.
  • Identified and documented business requirements for the integration of the WCSS system with Oracle Receivables. Prepared the functional and technical specifications for the integration. Worked with the technical team to identify unit, integration and regression test scenarios.
  • Developed approach and methodology and delivered to end users on basic navigations, transaction processing, basic accounting and business process assessment.

Confidential

Oracle Functional Lead. - PA, AP, PO

Responsibilities:

  • Proactively interacted with users to understand the business process for PA, AP and PO. Identified and documented business requirements.
  • Performed fit/gap analysis, pre-production business testing, conference room pilot support, interface/conversion mapping and related documentation and deliverables.
  • Configured PA, PO and AR modules for the three iterations of the Conference Room Pilot
  • Lead all efforts for interface and integration testing for all custom solutions, resolving migration issues from test to production instances.
  • Worked with the client’s team to prepare the business requirements definition documentation. Mapped the future process requirement into Oracle AP module. Performed the fit/gap analysis. Configured the AP module for multiple oracle instances.
  • Worked with the technical team to migrate data (Open invoices and suppliers) from legacy systems to Oracle AP. Activated descriptive flexfields to capture additional information not provided by Oracle AP. Guided the client’s team to carry out the Accounts Payable period end closing.
  • Involved in business and transaction flow reviews and definition of an effective Chart of Accounts. Oracle GL set-ups performed include: Set of Books, Calendar, Account Segments, Flexfield Security rules, Cross-Validation rules, Roll-up groups, Recurring journals and Mass Allocations.
  • Mapped client’s existing chart of accounts to newly defined Oracle flexfield structure. Developed validation procedures for legacy GL balances converted to Oracle GL
  • Trained end users in basic accounting and module functionality. Prepared documentation and materials.

Confidential

Business Analyst

Responsibilities:

  • Ensured completeness and accuracy in the definition of requirements and in the development of functional specifications and assisted in the development and design of review documents.
  • Prepared test plans, authored test scripts and carried out user acceptance testing. Prepared test reports for audit review.

Confidential

Financial Controller

Responsibilities:

  • Defined roles and responsibilities. Managed departmental budgets. Developed work plans in line with the bank’s strategic plan.
  • Monitored bank wide financial performance. Prepared key indicator reports for top management review. Reviewed financial control procedures and made recommendations for improvement. Liaised with regulatory authorities and prepared statutory returns
  • As an audit and accounting senior, participated in a wide range of audit projects, involving commercial banks, multinationals and the Central Bank of Nigeria.

We'd love your feedback!