We provide IT Staff Augmentation Services!

Oracle Functional Consultant Resume

2.00/5 (Submit Your Rating)

Tulsa, OK

SUMMARY

  • Over 10 years of experience implementing packaged and custom software solutions. He has served as an Oracle Functional Consultant gaining significant experience working in multiple projects and in various phases of project life cycle.
  • He has successfully delivered IT, business solutions for enterprise level multi - tier applications, and demonstrated competencies in functional responsibilities - Conducting process workshops, Business requirements gathering, gap analysis, participating in design sessions, configuration, testing, training end users and providing production support.
  • He has hands-on experience in system analysis, interface designs, Use Case modeling, implement process improvements that include developing system specifications and process flow diagrams. She is a team oriented consultant with strong analytical, problem solving and communication skills.

TECHNICAL SKILLS

Operating system: UNIX/Windows 2000/NT/XP

Oracle eBusiness: Suite Modules 11i and R12

Purchasing,Accounts: Payables,CoreContract,iProcurement,iExpense,Inventory, General Ledger, Accounts Receivable, Order Management, Property Manager, Project, System Administration, Fixed Asset, Multi Org setups,SLA,MRC,Web ADI,OBIEE,MarkView 170

Languages: Oracle PL/SQL

Utilities: SQL, SQL*Loader, Oracle Workflow, Oracle Discoverer, Toad, SQL Navigator

Application software: MS-Project/Word/Excel/Power point/Access/ Visio

PROFESSIONAL EXPERIENCE

Confidential, Tulsa, OK

Oracle Functional Consultant

Responsibilities:

  • Led the business requirements definition, gap analysis, configuration related to General ledger, Accounts Payable, Purchasing, Accounts Receivable and Core contract.
  • Prepare functional design documents based on requirements, prepare project estimate, work with development team for developing technical design documents, perform unit and end to end tests and follow the change control process to migrate the changes/enhancements to production environment.
  • Assist in developing and testing functional spec of Rice components for purchase order import from third party system, requisition import from third party system, inventory batch load,
  • Led the Regression tests, Disaster Recovery Tests and CPU Patch tests for Purchasing, Payables, Inventory, iExpense, iProcurement, Core Contracts and Power plant interfaces (project). Prepared test scripts, project estimate and assist other team members/perform the tests.
  • Train technical team in R12 concepts of Ledger, SLA, MOAC and GL, AP and AR modules. Participated in workshop for Analysis of RICE items of GL, AP, AR, and PO for R12 implementation.
  • Work with the audit team to understand Regulatory requirements / in corporate the same and provide data extracts periodically for analysis.
  • Primary point of contact for End User support/Break fix/enhancements for GL, AR, AP, PO, Inventory, Core Contract, iProcurement, iExpense.

Confidential, Atlanta, GA

Oracle Functional Consultant

Responsibilities:

  • Led the business requirements definition, gap analysis, configuration related to General ledger, Accounts Payable and Accounts Receivable.
  • Worked on Multi Org, Multiple Set of Books, Oracles Internet Directory and third Party Human Resources System interfacing Oracle. Third party system AVM is used for maintenance, validation of segment account values and interface has been developed for sending Segment value updates from AVM to Oracle.
  • Assisted in developing and testing functional and technical spec of RICE components for import of General Ledger journals from multiple third party Systems (Billing, Tax.).
  • Assisted in testing PO import from Maximo to Oracle.
  • Assisted in developing and testing of invoices from third party systems Maximo, Leased Labor, Brainware and Xign.
  • Xign Payment Service Network is used for generating electronic invoices and payment to vendors. Paper invoices, including credit memo and prepayments are scanned and imaged using Brainware-third party imaging software. Employee expense related receipts are scanned and imaged using Brainware.
  • Assisted with developing and testing iExpense Amex P-cardholder information (cif) and transactions import to Oracle.
  • Assisted in developing and testing requirements for Forms Personalization to restrict access to Supplier bank information and invoices access.
  • Worked in defining and testing different payment methods check, EDI ACH, Positive Pay and check printing.
  • Led Regression (Break Fix tests for GL, AP, AR, Alert) prior to different phases of Go Live.
  • Training technical team in R12 concepts of Ledger, SLA, MOAC, Payables, Payments Analysis of RICE items of GL, AP for up gradation from 11i to R12
  • Performed role of Primary support analyst providing production support of Oracle GL, AP, AR, PO, iExpense and FA modules covering huge client base.

Confidential, San Diego, CA

Oracle Functional Consultant

Responsibilities:

  • Perform internal analysis and implementation of R12 EBS. Develop Business process flows for AR and AP and identify the gaps.
  • Present the identified gaps and work with business owners/users in the design sessions. Mapped the future state process requirements in GL, AP and AR.
  • Develop project documentation including BR100 and Project Functional Design Documentation (MD.50).
  • Configured GL, AP and AR.Worked extensively in Revenue Recognition functionality considering accounting and audit requirements.
  • Worked with the technical team for developing customer interface, transaction conversion from legacy systems and Auto Lockbox interface.
  • Define system options, Accounting Option, Lookups, Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source, transaction types.
  • Assisted in developing and testing of invoices from third party systems
  • Led the test sessions for GL, AP and AR modules. Performed unit, End to End tests and assisted in UAT sessions.
  • Perform develop and document systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.
  • Performed role of Primary support analyst providing production support of Oracle GL, AP, AR, modules covering huge client base.
  • Worked closely with business users (Automated Fare Collection) and accounting (AR, AP and OM) to understand the business processes and prepare the business requirements definition documents.
  • Mapped the future state process requirements in Oracle modules.
  • Carried out the set up of the Accounts Payable, General Ledger and Projects
  • Used Mercury Test director, created test documents and Performed Unit, Integration and End to End testing.
  • Closely worked with the technology team for developing interface between AFC (Automated Fare Collection) system and Oracle EBS.
  • Good knowledge of Smart card and RFID technology.
  • Developed interface requirements for integrating Web Sales portal with Oracle EBS (GL, OM and AR).
  • Team lead for developing business rules and interface requirements between Marta Partners settlement system and Oracle Accounts Payable.
  • Experience in interfacing with Warehouse Systems
  • Developed interface requirements between Marta Ridestore (Point of Sale system-Automated Fare Collection System) and Oracle GL.

Confidential, San Antonio, TX

Oracle Financials

Responsibilities:

  • Team member of the core functional team responsible for implementation and support of GL, AP and AR.
  • Designed and setup the multi-org structure based on organization structure and client requirement.
  • Designed and setup the set of books after defining calendar, currency and chart of Accounts.
  • Completed setup options to perform mass allocation and recurring journals. Built various reports using FSG. Used ADI to upload journals excel spreadsheet.
  • Prepared design documents for AP Open Invoice Interface.
  • Defined financial options, payables options, creation of suppliers, tax codes, bank information, distribution sets and payment terms.
  • Creation of different types of invoices and payment methods.

Confidential

Business Analyst

Responsibilities:

  • Participated in the configurations, testing and support phases of the project.
  • Defined payables lookup, payables option, tax codes, set up bank details, invoice payment terms invoice payment terms, payment programs and payment formats. Creation of different types of invoices and payment methods.
  • Created Test Plans and Test Labs in Quality Center for test execution.
  • Coordinated regular status calls with clients/business leads/users for integration testing and UAT.
  • Assisted in Integration Testing - Purchase to Pay Process testing. Actively participated in Conference Room Pilots - Unit Testing, Integration Testing and End-to-End Testing.
  • Provided Production Support for Purchasing, Accounts Payable, and Cash Management module.
  • Worked with Oracle support team to resolve application issues, raising service requests and resolve issues and bug fixes.

We'd love your feedback!