SUMMARY

• Above 7 years experience of Functional experience in oracle GL, AR, AP, FA, CM implementation and a hands on experience as an oracle Business Analyst on SLA/FAH implementation and support project.
• Experience on Oracle E - Business Suite R12 (General Ledger, Account Receivable, Account Payables, Fixed Assets, Cash Management, Sub-Ledger Accounting, Financial Accounting Hub).
• Experience in Requirement gathering and Documents preparation with AIM Methodology.
• Expertise in SDLC methodologies like AGILE, Waterfall as used in IT Finance projects.
• Experience in Oracle Application Implementation Methodology (AIM).
• Prepared AIM Documents based on Client requirements.
• Involved in Multi-Org Structure setup for multiple clients.
• Handled user issues directly and guide them on various modules of the system.
• Done Set-ups configuration in the new environments
• Exposure requirement gathering and find out the Gap analysis.
• Exposure in preparing documents like MD 50, BR 100, TE040
• Exposure in preparing business structures for client business and design the multi org structure based on client requirement.
• Interacted effectively with other members of the Business Engineering, Quality Assurance, Users and other teams involved with the System Development Life cycle
• Sound knowledge on Financial Accounting, Procure to Pay and Order to Cash Cycles.
• Worked on Implementation as well as Supporting Projects at client locations(onsite)
• Provided application requirements gathering, designing, development, functional and technical documentation, and debugging. Performing business process mapping, Gap analysis and user training.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

ORACLE Apps Financial Functional Consultant

Responsibilities:

• Configured Payables System Options, Payable and Financial options
• Defined Payment Terms, Payment Set ups and Distribution Sets
• Setup Suppliers, Supplier Sites, Banks, Bank Accounts and documents
• Setup book controls, corporate book and tax book.
• Provide custom solution and test tracking the depreciation by project through to FA and GL.
• Implementation of standard Procure to Pay (P2P) Functionality.
• Setup purchasing for standard functionalities like converting purchase requisitions into standard purchase orders and blanket releases.
• Involved in documentation of Future business (BP-80), present business requirements (RD-20), conversion (CV-40), and Function extension design document (MD-50), Test scripts (TE-40) and System Set up Document (BR-100) as per AIM Methodology.
• Training Super users & power users before start of CRP
• Conducted Training to User and super User for AP, and FA
• Conducted CRP’s and trained end users for, AP and FA
• Extensive unit and integrated testing done before CRP & UAT
• Trained users on functionality and processes for reconciling, revaluating the foreign currency balances, translating them into USD and consolidating them to consolidated ledger.
• Hands on experience on generating FSG’s
• Conducted rigorous Unit and integration testing on CRP2 instance which had the customizations extensions) installed with the seeded functionality configured as per signed off documentation.
• Based on the BR 100 setup document for Payables, configured the Payables setup options (Financial, payables system and payables options).
• Logged in as sys admin and configured the cash management for the user to create banks, branches and bank accounts.
• Trained users as how to create suppliers and supplier sites and configure suppliers for using them to create payment invoices.
• Configured the Procure to Pay process to send purchase orders to suppliers, receive the material, match the PO in Payables and using payment manager, pay the invoices to suppliers.
• Reconciled and verified if Data correctly got updated during post implementation.
• Month end process - Create Accounting entries, print month end reports, Transfer accounting to General Ledger.
• Resolved Post implementation issues and issues raised during testing either by analysis and provided steps to correct them if they are user errors, otherwise created service request ticket if it was an issue with seeded functionality.

Confidential, Hartford, CT

ORACLE Apps Financial Functional Consultant

Responsibilities:

• Requirement gathering with the business owner
• Understanding the existing functionality
• Developing new interface and coordinating with technical people
• Explaining functionality to the technical team
• Understanding the integration involved in this project and working on it
• Prepared BR100, DS030, MD50 and TE40 and FSD for Reports and Error Handling.
• Mapping with Legacy to Oracle FAH.
• Done E2E setup in Gold, UAT, QA, Configuration and Development Instance. (Manual and Automated)
• Done code review for the customized packages to ensure the requirement is correctly addressed through the prepared executables.
• Prepared Oracle Template for Mapping
• Tested on legacy data with oracle data.
• Tested all functionalities in financial modules.
• Tested on Period end and Financial Closure
• Troubleshooting Journal sub ledger transfer and journal import issues
• Troubleshooting data issue fail during validation and Processing stage (Event Creation and Accounting) with in FAH.

Confidential, Houston, TX

ORACLE Apps Financial Functional Consultant

Responsibilities:

• Prepared Business Requirement and setup document (BR 100) based on the workshops conducted with business users.
• Gathered business requirements and configured the modules based on the defined future business process.
• Assisted in GL setup by defining Chart of Account, Flex Field Qualifier, Segment Security rule, Independent - Depend Rule and None value sets.
• Defined Security and Cross-Validation rules to restrict access and prevent invalid account codes combinations.
• Defined Calendar, Currencies and used them for creating Ledger.
• Defined mass allocation, recurring journals, cross validation rules, security rules, calendar, key flex fields and descriptive flex fields in GL
• Designed and developed specific FSG reports Based on Client requirement.
• Performed System Administration tasks in Oracle Financial Application by defining Responsibilities, Users, and Menus, Concurrent programs, Request sets and Request Groups.
• Iinvolved in Purchasing and Cash Management setupsI.
• Thorough understanding of Multi organization access control allowing the users to submit requests, enter, view and access data of different operating units without having to switch between responsibilities.
• Experienced in Business Process Re-Engineering study for GL, AP and AR.
• Defined AP important setups like Financial Options and Payable options to carry out all types of Invoices which are relating to payments.
• Defined the Payables and Financials Options.
• Setting up PO matching option, invoice tolerances, distribution options, terms, holds etc. Setting up Payment methods, Banks, payment format etc.
• Configured mandatory setups in Payables like Suppliers, supplier’s banks and its bank accounts to run payments.
• Defined Expense report setups to prepare expense reports on travelling or other business expenses.
• Defined AR Setups like Transaction Types and sources, System Options, Receipt Classes and sources
• Defining Lock Boxes and Transmission formats.
• Good working knowledge and hands on experience on all the aspects AR.
• Defining all 3 flex fields in Assets.

Confidential, New York, NY

ORACLE Apps Financial Functional Consultant

Responsibilities:

• Was part of a financial team leading AP and AR modules.
• Went through the current processes to understand the modules implemented in 11.5.10 implementation.
• Spent time on going through the existing BR 100 and MD 050 documents.
• Configured the Vision instance for providing demo on release 12.
• Provided demo on E Business Tax, AGIS, Report Manager and Payment manager which were new in Release 12.
• Conducted workshops to gather requirements for new modules to be implemented in release 12. The client wanted to know more details about I procurement.
• After discussing internally with technical team, figured out the delta for 12i upgrade and explained the same to business users during workshops.
• Provided the demo to users on the new dev system, once the delta was taken care by technical team.
• Once the Test environment was ready, conducted test cycles with users to test the transactions and processes in release 12.
• Good working knowledge on Procure to Pay and Order to Cash cycles.
• Worked extensively in Sub Inventory Configuration and Warehouse management.
• Thorough understanding of Multi organization access control allowing the users to submit requests, enter, view and access data of different operating units without having to switch between responsibilities.
• Very good understanding of Profile options.
• Configured the set ups for PO and AP ( Purchasing options, Financial options, Payables options
• Good understanding on 2 way, 3 way and 4 way matching, receipt routing .
• Helped client with Month end closing process - Create Accounting entries, print month end reports, Transfer accounting to General Ledger.
• Helped users in the consolidation process by revaluating the foreign currency transactions, translating them to USD currency and creating consolidation sets and transferring the balances to consolidation ledger.
• Configured all the Receivable options in AR.

Confidential, Vienna, VA

ORACLE Apps Financial Functional Consultant

Responsibilities:

• Identified Business needs, Gaps and Requirements Analysis
• Defined GL Responsibilities, Value Sets, Key Flexfield Segments, Period Types, Accounting Calendar, Currencies and created Set of Books
• Defined Recurring and Allocations Formulas
• Performed Complete Setups related to manual and automatic receipts
• Defined Profile Options to specify certain implementation parameters, Processing Options and System Options
• Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources
• Involved in defining Tax features such as Codes, Rates, Exceptions and Exemptions
• Involved in Defining Organization, auto cash rule set, auto invoice tuning
• Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defining distribution sets
• Defined receipt class, specifying creation method, Payment method, clearing method, defining collectors, defining aging buckets
• Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes
• Trouble-shooting in GL & AR
• Involved in CRP 1, CRP 2
• Involved in UAT user acceptance test

Confidential

ORACLE Apps Financial Functional Consultant

Responsibilities:

• Assisted and supported in setting up General Ledger
• Defined Journal Sources, Journal categories, Document Sequence, Chart of Accounts maintenance
• Created Standard Formula templates for recurring journals.
• Created Mass allocation journals
• Defined and enabled Multi-currency
• Created standard FSG reports and formatted the report according to the client needs
• Assisted in setting up AP
• Created and tested invoices, suppliers and supplier sites
• Involved in creation of payment terms
• Involved in Creation of debit memo, credit memo invoices
• Assisted in creation of payment holds
• Tested functionality of GL and AP
• Involved in preparing BR 100