SUMMARY

• Over 7+ years of experience as an Oracle Apps Financial Functional which includes Implementation, up gradation, Testing and Production support on Oracle Apps 11i, R12.
• Implementation and Support of various financial modules including General Ledger, Payables, Receivables, Cash Management, Fixed Assets, E - Business Tax, Purchasing, Inventory, TCA, iSupplier and iExpense.
• Experienced in Supply chain, implementing and supporting Order Management, shipping, Pricing, Purchasing and Inventory 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.
• 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, RICE customizations.
• 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
• Prepared Test cases TE-020,030,040 for various Financials modules.
• 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.

• Oracle R12 Financials and SCM
• Expert in AOL and AME
• AIM Methodology and documentation
• 11i Support and Upgrade Experience
• Consolidation, Reconciliation and Financial Statements Expert.
• Implementing FAH
• Implementing EB-TAX and VERTEX
• MRC (Multi Reporting Currency)
• TCA (Trading Community Architecture)

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, FAH, CM, FA, PO, iProcurement, iSupplier, Sourcing, OM, INV, Advanced Pricing, Shipping, iExpenses, AOL, AGIS and AME.

PROGRAMMING LANGUAGES: SQL, PLSQL

TOOLS: TOAD, SQL Developer

DEVELOPMENT COMPONENTS: RICEW components designing, testing and debugging

DATABASES: Oracle Database 9i/10g

OPERATING SYSTEMS: Windows NT/XP/2007, LINUX, UNIX

CHANGE MANAGEMENT: PVCS, Rational Clear Case

TICKETING SYSTEMS: SYSAID, HP Quality Center, HP Service Center

PROFESSIONAL EXPERIENCE

Confidential, CHICAGO IL

ORACLE FUNCTIONAL ANALYST

RESPONSIBILITIES:

• End to end Implementation of Oracle Payables, Payments, Receivables, Order Management, Advanced Pricing and Ecommerce gateway.
• 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.
• 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.
• Documented current state, designed future state to automate treasury functions including cash position, daily investing, cash forecasting, cash general ledger entries and debt facility accruals.
• 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.
• Designed and authored functional specifications for many OM reports like Pick Slip, Packing Slip, and Mailing Label for Shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports.
• 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.
• Configured Pricelists, Modifiers and Qualifiers in Advanced Pricing for complex pricing system of the client.
• 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.

ENVIRONMENT: Oracle Applications 11.5.10.2/R12 (Accounts Payables, Cash Management, Accounts Recievables, Order Management, Advanced Pricing, Purchasing, iExpenses, eCommerce Gateway), Workflow, Reports, XML Publisher, Forms Personalization.

ORACLE FUNCTIONAL ANALYST

RESPONSIBILITIES:

• Worked with R12 implementation team, gathering requirements 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.
• Worked on setting up of accounting method builder (AMB) for Financial accounting hub for various pass through Journal applications.
• 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.
• Liasoned between the technical staff and the users (staff and management). Was also responsible for interdepartmental coordination between the various teams involved.
• During the Support phase, Applied various Recommended patch Collections (RPCs), for AP, Suppliers, Workflows and Cash management.
• Analyzed and applied various GDFs in payables and applied RCA patches to fix the issues permanently.
• Designed, tested and delivered various custom reports as per the Client specific requirement, including Invoice Register, Payment register Summary and Detail reports, Allocation of labor, Timeliness of Payments, Rejected Invoices register, etc.,
• Participated in user testing and helped in migration to production for BAU activities.
• Provided exptensive production support of Oracle financials, including following up SR’s with Oracle Meta link.

ENVIRONMENT: Oracle Applications R12.1.3 (GL, AP, AR, FA, CM, Purchasing, iProcurement, iExpenses, iSupplier, FAH, EBTAX), SQL Developer, Reports, EIS Reporting, Forms, Workflow.

Confidential, BILLERICA, MA

ORACLE FUNCTIONAL ANALYST

RESPONSIBILITIES:

• Involved in the Up-gradation of the Application for all financial modules like GL, AP, AR, FA, CM, Purchasing and the Self-Service Modules Like iExpenses, iSupplier.
• Prepared and updated CV40, BR100 documents and created MD 50 Functional Design documents according to AIM.
• Designed and created new CHART OF ACCOUNTS and set of books.
• Configured, Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies.
• Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
• Implemented EB-tax integration for Procure to Pay and Order to Cash cycles with One-Source Indirect Tax product line.
• Extensively worked on Oracle Sub Ledger accounting to analyze and gather information from Payables into GL and reverting back from GL Journal Entries to grab Payables Invoice and Payment Details through XLA.
• Designed various Quarter and Year end reports for Higher Management review in like Top Ten vendor payments, Overall Payments history, Employee and Tax Payments etc.,
• Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
• Created users and modified the privileges for users, rollup group and summary accounts.
• Created suspense accounts for automatic balancing journal entries from particular sources and categories.
• Set-up supplier and supplier sites for suppliers in payables.
• Set up banks, receipts, transactions, plus training for invoicing, receipts, adjustments, and period close.
• Involved in setting up Project resources and roles to the project, Jobs and organizations for project Organizations, creating and maintaining Project budgets and worked on PA costing Import Process as part of project costing and billing.
• Conducted orientation training, CRP, UAT and Rollouts strategies for System up gradation.
• Provided production support for day to day business issues and worked on SRs with Oracle.

ENVIRONMENT: Oracle Applications 11.5.9(GL, AP, AR, FA, CM, PA, Purchasing, EB Tax, OM, Inventory), Oracle 10g, (SQL, PL/SQL), TOAD.

Confidential

ORACLE APPLICATIONS FUNCTIONAL CONSULTANT

RESPONSIBILITIES:

• Resolved all the functional and technical issues for AR, AP, CM, FA, GL, PO Modules.
• Preparation and modification of documents like MD050, BR100 as part of project Deliverables for the change requests for functional and technical configuration changes.
• Post production support and maintenance of the Application and resolved user queries.
• Created Accounting Flex Field Structure; Chart of Accounts; Set of Books, Mass Allocations and Summary Template. Tested features Translation, Revaluations, and consolidation.
• Prepared end user training material with specific business cases and conducted end-user training.
• Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions, executing and monitoring of cut over activities.
• Involved in Data Conversions, Developing, customizing reports and interfaces in GL Module i.e. Journals importing from mainframe legacy system using SQL Loader.
• Involved in the month end closure and reconciliation activities to close the periods on respective financial modules.
• Provided production support for day to day business issues and worked on SRs with Oracle.
• Provided daily user support for Fianancial modules and applied patches as and when required to resolve the Application issues.
• Log, view, access, monitor, follow up and close Service Requests (SRs) online through Oracle Metal ink and Oracle Applications Patch Management.

ENVIRONMENT: Oracle Applications R12 - (GL, SLA, AP, AR, CM, FA, Purchasing), Oracle 10g, TOAD, Reports.

Confidential

ORACLE FUNCTIONAL SUPPORT CONSULTANT

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

ENVIRONMENT: Oracle Applications (11.5.10.2) (Accounts Receivable, Accounts Payable, General Ledger, Purchase Order, OM), SQL, PLSQL, Reports, Forms, Discoverer.

Confidential

ORACLE APPLICATIONS FUNCTIONAL CONSULTANT

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.
• Financial reporting: Developed various reports using Financial Statement Generator (FSG), including Account Analysis reports, Trial balance reports, Consolidation reports, Exception reports, Journals Entry reports, Consolidation rules report, Summary Trial balance etc.,
• Extensively worked on Month end and Year end reconciliations for closure of subledger 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.

ENVIRONMENT: Oracle Applications 11.5.3 - (GL, AP, OM, AR, CM, FA) Oracle 10g, (SQL, PL/SQL), TOAD.