SUMMARY

• Over 8 years of experience as an Oracle Apps Financial Functional which includes Implementation, upgrades, testing and Production support on Oracle Apps 11i, R12.
• Implementation and Support of various financial modules including General Ledger, Payables, Receivables, Purchasing, Cash Management, Fixed Assets, E - Business Tax,Inventory, Projects, Cost Accounting Grants, TCA, i-Supplier and i-Expense.
• Having good knowledge in Supply chain modules implementing and supporting Purchasing, Inventory and Order Management modules.
• Excellent configuration experience on Procure to Pay, Order to Cash, and Assets to GL Cycle’s Using Multi-Org.
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support.
• Conducted requirements gathering workshops, prepared AS-IS(BP-040),TO-BE(BP080), GAP analysis, Application setups (BR-100), Functional design (MD050) documents and Conducted CRP,SIT, UAT sessions and user training sessions.
• Trained the client’s super users and users on the application and conducting Pilot testing, integrated testing, design validations and setups of the Distributed ERP applications.
• Special expertise in implementation of self-service modules including, Internet Expenses, i-Supplier, i-Receivables and i-Procurement.
• Implemented Financial Analysis Reporting by defining FSG Reports and Oracle Discoverer Business Areas and Workbooks.
• Proficient working with Oracle Support, creating and following up on SRs. Coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports
• Experience testing Conversions, Interfaces, Data Migration and various custom RICE components.
• Good Team player and leading key business scenarios meetings with coordinating and getting signoff from business for the proposed business scenarios.
• Worked in Onsite and Offshore model projects, coordinating and leading offshore team
• Maintained configuration documents and compared against Business Requirement and made recommendations as necessary.
• Worked extensively with development team members in resolving issues by creating SR(s) and resolving issues while using METALINK (Oracle Support).
• Extensively used AIM methodology for designing standard documents (MD50, BR100, and CV10 & CV40).
• Thoroughly involved in creating Test Scripts TE040 and end to end testing TE060 cross modules.
• Good understanding of various Oracle developer tools including Oracle Forms, Reports, Workflow, Conversions, SQL, PLSQL, TOAD etc.
• Extensive Knowledge on Version Control, Migration and Ticketing Software.
• Proficient is documenting Specifications following AIM Methodology. Authored MD50, MD120, BR100, CV40 documents.
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.
• Experience interacting and driving internal product teams, the user community, IT Operations and Executives; Experience with Functional Teams with a Strong focus on Group dynamics
• Experience with round-trip business methods using Function-point and Use Case estimation methods using well-defined workflow (Project and Initiatives proposal presentation techniques)

TECHNICAL SKILLS

ERP Applications: Oracle Applications R12 (12.1.3/12.0.6 ), 11i (11.5.10.2/11.5.8/11.0.3 ) GL, AP, AR, CM, FA, PO, i-Procurement, i-Supplier, EB Tax, OM, INV, Advanced Pricing, projects, Cost Accounting, Shipping, i-Expenses, AOL

Tax Software: Taxware, Vertex.

Tools: TOAD, SQL Developer

Development Components: RICEW components designing, testing and debugging

Databases: Oracle Database 9i/10g/11g

Operating Systems: Windows /XP/2007, LINUX, UNIX

Change Management: PVCS, Rational Clear Case

Ticketing Systems: SYSAID, HP Quality Center, HP Service Center

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Oracle Applications Financial Functional Analyst

Environment: Oracle EBS R12.1.1/R12.1.3 (Accounts Payables, Cash Management, Accounts Receivables, Order Management, Purchasing, i-Expenses, EB-TAX, SLA, Forms Personalization).

Responsibilities:

• End to end Implementation of Oracle Payables, Receivables, Order Management, Purchasing, Cash Management.
• Involved in the Supplier list, sourcing rules and defining the supplier conversion functional document preparation in purchasing module.
• Carrying out requirement gathering, requirement analysis, high level and granular level mapping, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP’s related to the split scenario and post production data cleansing.
• Configured Security and Cross validation rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
• Prepared BR100 Application setup for Payables, Receivables, Order Management, Payments and Ecommerce Gateway.
• Worked with customers to gather requirements and setup Customer workbenches, transaction types, Transaction Sources, Auto accounting, SLA, Revenue Recognition policy, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
• Testing the business process of the RTS(Return To Supplier) Process and Debit memo creation in the procurement to pay cycle.
• Created accounting flex field segment values, creating new / updating the existing cross validation rules and security rule
• Involved in requirement gathering and authored MD 50 documents for the various reports and Interfaces which includes AR Invoice and AP invoice Interface.
• Designed, documented and implemented Interface programs to import ITEMS from a legacy system into Oracle Inventory.
• Prepared CV040 for Suppliers and supplier banks conversion from Macola toOracle Account Payables.
• Implemented the 810 inbound invoices and the 820 outbound payments for supplier payments and all employees including expense reimbursement. Extensive experience setting transactions and troubleshooting issues in Ecommerce gateway and end to end process of implementing 820 and 810 EDI transactions.
• Configured the Cash management module for GL Accounts Mapping, setting up transaction codes, BAI2 file upload, Customization of out file as per Bank of America requirements, automatic transmission and import of bank files.
• Configured banks, bank accounts and documents for different needs like AP processing.
• Coordinating with Offshore development and Functional Team to resolve Issues.
• Worked on AP/AR Netting, ERS Transactions Setups and related Issues.
• Designed and implemented Back to Back Sales Order Process, integrating with Purchasing and customizing various forms and interface process as per business requirement.
• Designed and configured Custom extension using Order Management processing constraints to restrict cancellation or updates of a Sales Order once the PO is created for a Back to Back process.
• Involved in configuration of CRP2, SIT1, SIT2 and test instance.
• Prepared TE040 Documents, which are used to test various aspects of application functionality.
• Involved in defect fixing of custom workflows like OM export compliance, Return Merchandise notification and credit management.
• Involved in the Bridge Calls during Cut-over/ Go-live phase.

Confidential, Tx

Oracle Applications Financial Functional Consultant

Environment: Oracle EBS R12.0.6 (AP, GL, PO, AR, FA, Cash Management, i-Expense, i-Procurement, i-Supplier, Sourcing, AOL). Configuration and Testing in R12

Responsibilities:

• Analyze design, customize, configure and test implement detailed Oracle applications and modules including GL, AP, AR, CM, FA, PO, P2P & O2C.
• Participated in the Conference Room Pilot sessions to interact with users to analyze the business process and identify the gaps.
• Defined the Functional specifications for setups and reports and transformed the specifications to the Technical Team.
• Worked with the business architect and other planners to assess current capabilities and identify high-level requirements.
• Account Receivables (AR): Setups for TCA Architecture, Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules, Auto accounting Rules, Auto invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Aging Buckets. Defined Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Customer & Sites, Remit to Address, System profiles.
• Helped the technical team in the customer conversion, Open AR invoices and receipts conversion.
• Have setup the system to allow the business to create the Automatic Receipts and send the Ach files to the bank.
• Have setup the system to create manual receipts which are not applied to the invoices and send the ACH file for these receipts to the bank using a custom program.
• Defined the Funds Capture Setup to process the ACH payments.
• Helped the business in the month end closing process, closing and opening of new periods.
• Setup Taxes using E-Business Tax module.
• Helped the technical team in the supplier conversion, Open AP invoices and payments conversion.
• Helped the business in the month end closing process, close and open the new periods.
• Used E-Business Tax module to setup taxes for Payables.
• Setup Currencies, Exchange Rates, Organization's, Set of Books, Bank Accounts.
• Setup all the banks, bank branches and bank account for all the countries.
• Set up bank transaction codes for the bank accounts for BAI and NSF files and assign GL Accounts to the bank accounts.
• Set up cash management for automatic loading and auto reconciliation of all the bank statements.
• Implementation of Fixed Assets, involved in requirements gathering sessions with the client.
• Convert the requirements in to AIM Documents: BR100, BR110 and BR30.
• Led the Conference Room Pilots for the site implementation.
• Preparation of Functional Test Scenarios & Test cases for Fixed Assets.
• Assistance to SIT, UAT, Training and Production Support to End User.

Confidential, San Joes, CA

Oracle Applications Financial Functional Consultant

Environment: Oracle Applications 11.5.9/ R12.0.6 (Order to Cash Business flows including OM, AR, AP, GL, e-Business Tax, INV and Pricing), Oracle 10g, (SQL, PL/SQL), TOAD.

Responsibilities:

• Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating.
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Worked on the entire Order to Cash Flow.
• Performed all the setups for As a Functional Consultant implemented the Order to Cash Business flows including OM, AR, AP, GL, e-Business Tax, INV and Pricing
• Performed Requirement and Gap analysis.
• Configurations and Setups for AR, e-Business Tax, GL and AP modules
• Worked on the setup of Revenue Recognition in AR module.
• Setup of Accounting and Invoicing rules in AR module
• Defined the Auto Lock Box process in AR module
• Defined the Auto invoice process in AR module
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• 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.
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of Accounts Receivables and Account Payable Module
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.
• Worked on the Revenue Recognition Process in Oracle AR module.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Worked on the entire upgrade strategy to upgrade the application footprint from11.5.9/ R12.0.6
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification.
• Flow Testing for SCM Modules (AR, AP, GL, OM, Cash Management, INV, PO) to make sure flow is working without any issues.
• Conducting Pre Project Review & Post Project Review.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Confidential, NC

Oracle Applications Financial Functional Consultant

Environment: R12 (AR, AP, GL, FA, Cash Management, i-Expense, e-Business Tax, Sub Ledger Accounting, Oracle Payments), AIM Documentation, Toad, SQL, Interfaces, XML Publisher, Reports.

Responsibilities:

• Implementation of Oracle Payables including setup of payment options, payment terms, distribution set, payment format, banks, expense report templates, matching options, tax codes, etc.,
• Worked with R12 implementation/Up gradation team, and authoring business requirement documents and functional specifications.
• Implementation of Oracle Fixed Assets module using AIM methodology, which included Asset categories, asset locations, book controls, depriciation methods, security profile, asset calender, fiscal year, quick codes and system controls.
• Designed and developed multiple FSG reports on Budget and Actual balances, crossing over fiscal periods as per Business requirement.
• Extensively registered various AOL objects such as Value Sets, Value Set values, Custom Responsibilities, Lookup Values, Request Sets, and Request Set Links.
• Designed and Developed customized solution for Oracle Fixed Assets to resolve depreciation issues.
• Supported Procure to pay and FA issues during month end performing additional configurations.
• Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies.
• Involved in the analysis and design phases of various iProcurement initiatives. Configured external punch outs and OSN.
• Configured iSupplier for supplier centralization and online invoice processing.
• Defined and Customized iProcurement and Purchasing related Responsibilities, Functions, Menus and Sub-Menus as per BRD documents.
• Responsible for setup, design and testing the purchasing Position Hierarchy for routing PO Approvals as required for the business.
• Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies.
• Prepared setup documents for Accounts Payable, Purchasing and iSupplier modules.
• Liasoned between the technical staff and the users (staff and management). Was also responsible for interdepartmental coordination between the various teams involved.
• Designed, tested and delivered various custom reports as per the Client specific requirement, including Invoice Register, Payment register Summary and Detail reports, Rejected Invoices register, etc.,
• Provided extensive production support of Oracle financials, including following up SR’s with Oracle Meta link.

Confidential

Oracle Applications Financial Functional Consultant

Environment: Oracle Applications R12.0.6 (Accounts Receivable, Accounts Payable, General Ledger, Purchase Order, OM) PLSQL, Reports, Forms, Discoverer.

Responsibilities:

• Worked as member of Support Team for modules GL, AP, AR and CM
• Reviewed daily support SR’s, co-coordinated with users and resolved issues
• Identified SR’s as GAP’s that needed customization and reviewed with management with GAP analysis document
• Developed functional documents for technical customizations in OM, INV, PO and AR modules.
• Implemented and delivered new Oracle functionalities with user interaction, performing systems and unit testing.
• Trained users and Created test scripts for new functionalities
• Provided User training on one to one basis and also in group mode
• Updated Value sets’ values for COA. Defined cross validation rules & security rules
• Designed Financial Reports using Financial Statement Generator (FSG) tool
• Set up of Parent & Child relations, Rollup Groups and summary templates
• Workflow Purchasing integrates with Oracle Workflow technology to create standard purchase orders or blanket releases automatically from Approved requisition lines.
• PO matching options, invoice tolerances, distribution options, terms, holds, etc.
• PO setup and matching options with invoices.
• Defined the Aliases, Set up of Recurring Journals, Stat Journals & Mass Allocation Journals.
• Helped in Inventory management module for costing problem. Inventory valuation report was not tying with General Ledger Inventory account. Cost group was the problem and physical inventory was not updating the quantity in the right

Confidential

Oracle Applications Financial Functional Financial

Environment: Oracle Applications (GL, AP, OM, AR, CM, FA)

Responsibilities:

• Played significant role in the Upgrade Patch set analysis in identifying the impacted components.
• Interacted with Oracle to get the issues addresses by logging SRs.
• Developed Training Material for OM and AR modules and prepared impact analysis for critical issues.
• Tested the revised Customer Interface that takes the new Customer Type into account by enabling to load customer data for both Organizations and Individuals.
• Responsible for preparation of test scripts and monitoring UAT.
• Extensively worked on Month end and Year end reconciliations for closure of sub ledger modules - AR and AP.
• Worked on HP Quality Center to create Test Scripts, Test Cases and testing various Functional activities.
• Responsible for Retrofitting and re-building custom components post execution of standard features testing.
• Involved in the Bridge Calls during Cut-over/ Go-live phase.