We provide IT Staff Augmentation Services!

Oracle Apps Functional Consultant Resume

3.00 Rating

SeattlE

SUMMARY

  • Over 8 Years of IT experience of which majority is in Oracle Financial Applications, Oracle Financial Functional consultant with expertise in Oracle EBS 11i and R12.
  • Involved in multiple implementations, upgrades, Support and Enhancement Projects on Financials Modules.
  • Three full life cycle Implementations, Two Upgrades and couple of support/enhancement projects in Oracle EBS R12 and 11i.
  • Multiple project life cycles experience with Planning, Business Analysis, Requirements Gathering, Functional Design Development, Integration & User Acceptance Testing, Training, Go - live and Post-Implementation Support.
  • Developed Functional specification Documents (MD50), Business Requirement Documents (BRDs), GAP Analysis, Solutions for the GAPs, Dealing with Business Users on Training and Testing of the application.
  • Strong experience in financial suite including General Ledger (GL), Account Receivables (AR), Account Payables (AP), Cash Management (CM), Fixed Assets (FA), e-Business Tax, Sub Ledger Accounting(SLA) and Purchase Order(PO) .
  • Good experience in creating Concurrent programs, forms, functions, Menus, Custom Responsibilities, Profile Options, Request Groups, Maintaining Users and customizing Key & Descriptive Flex fields.
  • Strong understanding and working knowledge on Order to Cash and Procure to Pay Cycles.
  • Utilized AIM methodology for Business Flows in different phases of the project including Requirement Gathering, As-Is, To-Be, Solution Design, Conference Room Pilot (CRP), Build, Test, User Training, Data Migration, Production and Post-Production Support.
  • Worked as a Functional Tester and conducted CRP sessions to test complete end to end functionalities of several modules following the upgrade from Oracle 11i to R12.
  • Gained expertise in using the Oracle User Productivity Kit (UPK) to record the test scripts and used these scripts to train the end users on R12 functionality.
  • Helped the automation testing team with functionalities of modules GL, AP, AR, CM, FA to automate the test scripts using Quick test Professional (QTP) & Unified Functional Testing (UFT) tools.
  • Excellent verbal and written communication skills, exhibited a consistent performance and ability to work as a team member or as an individual.
  • A team player with exceptionally good organizational, analytical, training, troubleshooting, functional and interpersonal communication skill, a key team player.

TECHNICAL SKILLS

Databases: Oracle Database Version 10g, Microsoft SQL Server

Languages: SQL, PL / SQL

Internet Technologies: Web Protocols

Oracle Applications: E - Business Suite- R12.x/11.x

Oracle Apps Modules: Oracle Financials (GL, AP, AR, FA, PO, GIS, CM, P2P & O2C, Order Management (OM), Inventory

Oracle Tools: SQL*Loader, Toad, (Forms 6i/4.5, 8.0, Application Object Library).

Operating Systems: Windows 10/8.1/8/7

Other Tools: MS Word, MS Office, MS Excel, MS Power Point, MS Project.

PROFESSIONAL EXPERIENCE

Confidential, Seattle

Oracle Apps Functional Consultant

Responsibilities:

  • Implemented AWS Training and Professional Services - P2P foot prints for 5 countries including Italy, Austria, Singapore Brazil and China.
  • These projects involves implementing end to end functionality including new Ledgers, Operating Units, Legal Entities, eBusiness Tax, AR, AP, GL, iProc, Custom Reporting, iExpenses, Inventory modules.
  • Architecting in integrating the eBusiness Suite with the external Amazon systems from Kindle, AWS, and VPS platforms and so on.
  • Conduct requirement gathering sessions with the business and users.
  • Document and map the requirements to the Oracle standard functionality.
  • Develop solution and design for the requirements where there are gaps with the mapping.
  • Share the MD050s developed with development team and track the progress of the customizations. configured iProcurement work flow process and tested how to create requisition after iProcurement module has been implemented.
  • I created the roles grants and setups configurations for catalog and non catalog items, created punch-out’s and requisition workflow approval process.
  • Work with all the stake holders in getting sign-off on the requirements, use cases and business processes.
  • Create BR100 for the functional configurations and push them to different instances.
  • Perform the functional and integration testing to make sure the design is coded as expected.
  • Implemented VAT and Service Tax using India Localization in R12.
  • Implemented Withholding Tax and Reporting using out of the box functionality using India Localization.
  • Custom program for Sabrix integration with AP invoice validation program.
  • Custom program for applying custom holds and removal in AP invoice Validation Program Custom GL mapping program.
  • Customized customer rules and rates inSabrix.
  • Lead testing using theSabrixworkbench.
  • Work with the users to get the sign-off from the Business Users and get approval for pushing the necessary configurations to Production.
  • Setup new AR Transaction Types for Invoices, Credit Memos, Adjustment and Write-off activities, Transaction sources and Receipt Classes.
  • Setting up the Brazilian localizations using the Integrated Receiving module and testing the integration with Accounts Payables.
  • Configuring the accounting and tax requirements in Integrated Receiving to make sure the transactions generate correct accounting for all the taxes.
  • Setup new Inventory Organizations, Legal Entities and Operating Units as per the requirements.
  • Design new PO Templates and changes to the Purchasing approval workflow to meet the different purchasing requirements in Italy and Singapore.
  • Design new interfaces for Invoices, AR/AP inward and outward Remittances and implement integration for Cash Management for new banks integration.
  • Configure iExpenses, Purchasing and Financial module for the AWS implementation in Austria.
  • Work closely with Oracle Support to address the Oracle standard issues that are encountered during the implementation.

Environment: Oracle Apps Release 12.1.3. e-Business suite (GL, AP, AR,FA, Inventory, Cash Management, iProcurement, iExpense, Oracle Payments, AME), Workflow Administration, Reports, Forms Personalization.

Confidential, LA

Oracle Apps Functional Consultant

Responsibilities:

  • Involved in business process study and creating business process maps using Visio for Oracle E-Business Suite GL, AP and AR modules during implementation.
  • Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions while executing and monitoring of cut over activities.
  • Reviewed Oracle General Ledger business requirements and mapped them to standard Oracle functionality. Identified Gaps, documented and provided workarounds by defining custom Business Processes.
  • Configured various setups of General Ledger, including but not limited to Accounting Flex Field definition, Chart of Accounts, Calendars, primary and secondary ledgers, cross validation rules, security rules, consolidation, translation, revaluation, etc.
  • Created intercompany Transaction, Consolidation, Elimination entries setups and configurations.
  • Created Master/Detail Budgets, Mass Allocations and Summary Templates. Designed FSG Report for Budget Balance, Actual Balance and Funds Available.
  • Extensively worked on design and coordinating with technical team on developing the third party billing system to bring invoices into oracle receivables.
  • Developed several BR100s on required reports to fulfill the business need.
  • Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
  • Worked on the setups of AP Module - setting up financial options, payable Options, system options, pay groups, discount terms, AME rules, etc.,
  • Configured payments module including Payment formats, custom payment methods, payment documents, Payment Instruction Formats, Payment Process Profiles, PPR Templates, etc.,
  • Conducted Conference Room Pilots (CRP) sessions showcasing the proposed solutions and validating the business requirements.
  • Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules. Extensively worked on HP Quality Center for creating test scripts and tracking test results.
  • Fixing small code changes as of when raised during UAT and during post production support.
  • Performed effort estimation for design and development for data fixes, code fixes and change requests.
  • Support Production issues on a day to day basis including month end closure priority issues.
  • Performed both validation and technical IT General controls testing for SOX & GAP to make the test documentation meet Client’s compliance regulatory norms.
  • Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
  • Provided with useful training to the users in GL, AP, AR, CM, PO, FA, iProcurement, SLA, e-BTAX, Modules.

Environment: Oracle Apps Release 12.2.4 e-Business suite (AP, AR, GL, FA, PO, Cash Management, Inventory, iProcurements, e-Business Tax, Sub Ledger Accounting, Oracle Payments, AME, AOL), TOAD, Workflow Administration, Reports, Forms Personalization.

Confidential, Arlington Virginia

Oracle Apps functional consultant

Responsibilities:

  • Worked as an Oracle Financial Functional Analyst onsite, offshore team. Involved in configuration and testing of AP, AR, GL, CM, FA, E-Business Tax, SLA, and PO.
  • Provided support for GL, AP, AR, Invtory and CM modules.
  • Gained expertise in using the Oracle user training tool called User Productivity Kit (UPK). Used this tool to record the end to end functionalities of the above mentioned modules.
  • Experienced in writing and documenting the test scripts, test scenarios and test cases for all the core financial modules including Project Accounting, bank interfaces.
  • Support oracle projects implementation/Management and resolve the issues during the re-implementation.
  • Implemented Location based tax for Accounts Payables & Accounts Receivables through E-Business Tax.
  • Configured Vertex Tax Software & applied monthly vertex updates during month end process.
  • Implementing Oracle Project Accounting and ProjectCosting in Oracle EBS 11i.
  • Demonstrated/Trained the users on R12 functionalities.
  • Worked closely with the client BA’s of respective functional areas to understand the client business process, setups, working process and their timelines.
  • Tested, documented and recorded (using UPK) the customization of client’s Order Management Interface with several third party vendors.
  • Tested, documented and recorded the Finance Bank Interfaces of several Operating Units across the globe, with their respective Banks.
  • In AGIS, defined Intercompany Order Management system and performed intercompany shipping and billing. Tested and documented the client’s intercompany orders, shipping and invoicing.
  • Tested FSG Reports, using multi-currency features including foreign currencies for multi org structures.
  • Performed the testing of Sub-ledger Accounting Reports like Sub-ledger Period-Close Report, Journal Entries report, Third Party Balances Report etc.
  • Used Agile Software Development Life Cycle Methodology tool to manage projects, document different processes, promote development, collaborate with the customer throughout the life-cycle of the project.

Environment: Oracle EBS 11i/R12 (GL, AP, AR, INV, Cash Management, iExpense, iProcurement, ISupplier, Sourcing, AOL). Configuration and Testing in R12

Confidential

Oracle Functional Consultant

Responsibilities:

  • Implemented the following modules: AR, AP, GL, FA, Cash Management, i-Expense, e-Business Tax, Sub Ledger Accounting, Oracle Payments
  • Worked on the Functional mapping of data Conversions & Enhancements AR, AP, GL, i-Expense, SLA modules
  • Analysis of client's requirements & designing the solution.
  • Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
  • Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
  • Pre upgrade testing and Post upgrade production live support.
  • Involved in testing and validating the logic of Customizations, Form Personalization & Reports.
  • Performed end to end testing and validation of the reports in CRP and UAT instance.
  • Performed effort estimation for design and development for data fixes, code fixes and change requests.
  • Involved in complete end to end business solutions designing BF045, RD 20 for their legacy for the rollout project.
  • Performed effort estimation for design and development for custom reports and GAP's.
  • Conducted CRP and given hands on system trainings to business users.
  • Involved in designing the financial reports and budgeting reporting.
  • Managed technical team and testing team for delivering the custom components and various budget reports.
  • Involved in migrating open transaction and supplier conversion process.
  • Worked on setting up GL module - defining the Ledgers (primary and secondary), Ledger sets, data access sets translation, revaluation, consolidation options, etc.
  • Worked on the AP Module setups - defining the Payment manager options, payment process profiles, payment process requests, payment formats, etc.
  • Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
  • Successfully provided Technical and Functional support to the users, testers and Business System Analysts.

Environment: Oracle Apps Release 11.5.10/12.1.3 e-Business suite (AP, AR, GL, FA, Cash Management, e-Business Tax, Oracle Distributions, Oracle Payments)

Confidential

Oracle Functional Consultant

Responsibilities:

  • Worked on the project by using AIM methodology.
  • Involved in End to End implementation Life Cycle of Oracle Financial modules.
  • Analyzed client's current business events and process based on client discussions.
  • Setup of Security rules, Cross validation rules and values for Value sets.
  • Configured Financial Options and Payable Options.
  • Defining Payment terms, Distribution set Internal Bank account and Supplier Bank Account.
  • Defined Corporate books, fixed assets categories, assets keys etc.
  • Document the main setup steps, definitions and implementation issues.
  • Configured the Test Instance as per the setup document.
  • Prepared the Functional Document required for the business - Future Process module and Mapping design.
  • Setup the Access control for the users based on the responsibility.
  • Involved in CRP and UAT. Given training to End Users
  • Setup Financial Modules in TEST, DEV Instances
  • Testing of Setups done in the above instances
  • Prepared BR100, TE040 and MD050 Documents as per the requirement
  • Providing the User with relevant Test Scripts to test the instances and helping them on Functional issues.
  • Setup of Financial Modules in PRE PROD and PROD instances and handing over of PROD instance to Users.
  • Upload supplier & Customer Details from the legacy to the application.
  • Done System Integration testing with the sub-ledgers to the General ledger.

Environment: Oracle Application 11.5.8/11.5.10.2 (GL, AP, AR, CM & FA), AME, AIM Documentation, Windows XP, TOAD.

We'd love your feedback!