SUMMARY:

• Over 11 years of Functional & Business experience in Oracle ERP in a variety of large Projects with Full Life Cycle Implementations, Upgradation and Post Production Support of Oracle Applications.
• Strong Oracle Applications Functional experience in multiple implementations, Upgradation and Post Production Support of Financials Modules in both R12&11i versions of Oracle E - Business Suite.
• Extensive knowledge in providing solutions, designing, customization, implementation, configuration, thorough testing and documentation of Oracle Financials including General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CE), E-Business Tax (E-B Tax),Purchasing (PO) and Sys Admin.
• 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.
• Involved in Multi-Org & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System) and designed and developed Financial Statements (FSG’s) as per Business Requirement.
• Expertise with business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C), Sub-Ledger Accounting (SLA) and Acquire to Retire (A2R).
• Involved in Data Conversions/Migration and designed function specific document of data for Suppliers, Customers, Assets, and GL Balances.
• Experience in maintaining documentation and using the Application Implementations Methodology (AIM),which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration and testing (BP 80,RD20, BR30, BR 100, MD 50, CV 40 &TE 40)
• Create SR’s with Oracle Technical Support, 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.
• Conducted CRP’s and provided wide range of functional training to multiple business user groups and coordinated UAT sessions.
• 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.

TECHNICAL SKILLS:

Oracle ERP: Oracle Financials R12&11i - GL, AP, AR, CE, FA, E-B Tax, PO, I Expense, Sys Admin, SLA, P2P, O2C and A2R.

Other Tools: Web ADI, Data Loader, Discoverer, SQL*Loader, SQL*Plus and MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Oracle ERP Financials Consultant

• Handling Month-end close activities and reconciliation for GL, AP, PO and FA modules.
• Resolving Finance issues that occurred during production and provide Month end support to the above financial modules along with delivering the reports of the close.
• Run Depreciation for the Company Corp books and created the system entries to be approved by Superusers, reviewed and then posted.
• Run the CIP and Standard FA Reports for the different Books. Interacted with the end users and demonstrated the functionality in detail.
• Resolved Problem Tickets (PT) and Service Requests (SR) issued by Business Users for various Finance issues using Remedy System.
• Responded to Users requests to run programs, reports and requests for their daily duties.
• Prepared training materials with screen shots, exercises and presentations for critical end users.
• Supported Oracle Financial modules which involved daily issues and new customizations and enhancements based on the changing requirements.
• Working actively with DBAs to apply Change Control (CRs) in PRD and to migrate solutions.
• Worked with Oracle Support to resolve the critical Production issues.
• Used TOAD to open multiple instances and query tables using SQL and to either run reports, figure out issues or get some data for analysis.
• EDI monitoring for Supply Chain inbound & outbound data which involves resubmission of failed orders, reporting incorrect POs to users, approving POs and identifying any issues with scanned orders.

Confidential, TX

Oracle Financial Functional Analyst

• Supported Post-Implementation phase for all Oracle Financials Modules.
• Production support, interfaces maintenance, change management, month end closing
• Prepared and modified MD50’s for different reports like Product profitability report, PO received but notinvoiced report, etc.
• Created the extensive test scripts TE 40 to verify the reports; tested, verified and deployedto production.
• Researched and resolved PO number in customer credit card statement for refund transactions.
• Resolved the issues related to credit card refund, return, bills only, freight charge return, not invoiceable items,credit card authorization, consolidated invoicing, in order management and receivables.
• Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, and customer statement report.
• Worked on development of new FSG reports and customized various standard FSG reports.
• Worked with technical team regarding RICE components.
• Created work around for unsolved issues.
• Supported Post-Implementation phase for all Oracle Financials Modules.
• Worked with Oracle Support to resolve the critical issues through SR/TAR.
• Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue logregister.
• Involved in supporting Super Users and End users in period end closing.

Confidential,Philadelphia, PA

Oracle Financial Functional Analyst

• Involved in Confidential ’s Oracle EBS Implementations and its Initiatives and customizations for General Ledger, Payables, I-Procurement, Accounts Payable, Receivables, Fixed Assets, PTP, Inventory, I Expense, Project Costing, Billing and Cash Management.
• Performed meeting within Business stack holders, Developers, DBAs, Quality Assurances and End users of Business high level requirements and its updates.
• Used IR Tools and OBIEE for customized reports and Reconciliation Reports and Prepared Data sheets for Reports for updates and to present in Meetings.
• Used other major Oracle’s such as IPM and Other outside applications such as KOFAX, AppLoad, Formscap for Images Management and uploading bunch of data using Excel Sheets into the Oracle Database.
• Defined, Created and Tested Flex field structure, Cross Validation rules, Accounting Calendars, Functional currencies, foreign currencies and budget for QA testing.
• Defined, Created and Tested Primary Ledger, sub ledgers and Operating Units Ledgers.
• Created Journal and its Batches (with STAT), Recurring Journals, Mass allocations, Consolidations, Conversions, Journal line Reconciliation, Generated reversal and scheduled automatic reversal journals for QA Testing.
• FSG Reports, Financial Reports, Account summary reports, Income and Expense Reports and other Oracle standard reports.

Confidential,Jeffersonville, IN

Oracle Financials Functional Analyst

• Assisted in implementation of Oracle Financials (AP, AR and CE) across the organization.
• Managed a team of consultants for the up gradation and configuration of AP, AR and CE modules.
• Created general settings and completed specific configuration related to Company Code, Banktransaction codes, Bank accounts and bank reconciliations.
• Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.
• Conducted CRP1, CRP2 and tested the customized components.
• Configured the Sub Ledger Accounting (SLA) setups.
• Created the BR100, TE40 and BP80.
• Created the MD50 documents for each RICE components.
• Facilitating end-user training and developing the various users training manuals and conducted the UAT.
• Involved in the design and setup of legal entities and the related inventory organizations using the legalentity Configuration.
• Set-up financials options, payables and payables System options in AP.
• Drafted extensive set of requirements, questionnaire and gap analysis.
• Involved with the integration of sub ledger for meeting multi GAAP corporate and physical accountingrequirements.
• Used accounting methods builder in sub ledger accounting for analysis, auditing and reporting of journalentries.
• Defined security and cross validation rules.
• Involved in the setup of tax configuration using the Regime to Rate flow and setup of tax rules.
• Setting up of fiscal calendar in FA that map to the new GL calendar.
• Configure new prorate conventions based on the fiscal calendars.
• Create new corp. books and tax books that are associated with new calendars and prorate conventions.
• Assign asset categories to corresponding new corp. and tax books.
• Reviewed business processes initiated setups, developed and executed test scripts.
• Setting up of PO matching options, invoice tolerance, term holds, and expense report templates.
• Setting up of banks, bank branches and bank accounts.
• Configured the financials and payables options.
• Involved in end user training and user acceptance testing.

Confidential, Emeryville, CA

Oracle Financials Functional Consultant

• Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials General Ledger, Accounts Payables, Purchasing, I Expense and P2P.
• Responsible for the documentation (BR.030 -Business Requirements Mapping, BR.100 -Application Setup and TE.040 -System Test Script).
• General Ledger, Account Payables, andPurchasing Modules setups.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Created Auto Invoicing and Auto lockbox (Source of Auto Invoice was Project Billing) processes.
• Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, CrossValidation Rules, Security Rules, Calendar, Currencies, Assigning Ledger to a
• Setting upResponsibility, Standard Journals, Statistical Journals, Recurring Journals, Suspense Accounts and Mass Allocations.
• Defining Financial Statement Generator, Creating Ad-hoc Reports, and Open and Close Accounting Periods.
• Set-up Oracle Payables including System Options.
• Setups and defined Invoice attributes- Payment Terms, Approve, Hold and Release and DistributionSet, Special Calendar for Recurring Invoice, Payment Terms and Payable Quick Codes, Entering Supplierand Site Information, Payment Attributes- Payment Formats, Bank Account, Payable Documents, TaxCode, Rates,Groups and Withholding Tax, Open/Close of payable Accounting periods, andPayableTransfer to GL.
• Used Accounting Rules to determine the number of periods and percentage of total revenue to berecognized (Revenue Recognition) in each accounting period.
• Perform the related setup tasks in the applications that work together with Internet Expenses to create anintegrated environment for expenses reporting.
• Setup payment terms, invoice distribution, matching of invoices against PO.

Confidential,Burnsville, MN

Oracle Financials Functional Consultant

• Responsible for the documentation (BR.100 -Application Setup and TE.040 -System Test Script) andsetups of the General Ledger, Account Payables and Account Receivables.
• Involved in the design and configuration of chart of accounts, accounting periods and accounting calendarfor each legal entity.
• Designed the primary ledger, secondary ledger, functional currencies and reporting currencies using theaccounting setup manager.
• Involved in the design and setup of legal entities and the related inventory organizations using the legalentity Configuration.
• Set-up of financials options, payables and payables System options in AP.
• Drafted extensive set of requirements, questionnaire and gap analysis.
• Involved with the integration of sub ledger for meeting multi GAAP corporate and physical accountingrequirements.
• Used accounting methods builder in sub ledger accounting for analysis, auditing and reporting of journalentries.
• Defined security and cross validation rules.
• Involved in the setup of tax configuration using the Regime to Rate flow and setup of tax rules.
• Setting up of fiscal calendar in FA that map to the new GL calendar.
• Configure new prorate conventions based on the fiscal calendars.
• Create new corp. books and tax books that are associated with new calendars and prorate conventions.
• Assign asset categories to corresponding new corp. and tax books.
• Reviewed business processes initiated setups, developed and executed test scripts.
• Setting up of PO matching options, invoice tolerance, term holds, and expense report templates.
• Setting up of banks, bank branches and bank accounts.
• Configured the financials and payables options.
• Involved in the setup of auto invoice workflow.
• Involved in end user training and user acceptance testing

Confidential, San Antonio, TX

Oracle Financials Functional Consultant

• Involved in Month-end support for close and reconciliation for AP, AR and PO modules.
• Resolved issues that occurred in the production.
• Interacted with the end users and demonstrated the functionality in detail.
• Involved in unit testing and integration testing on various modules.
• Prepared and did extensive testing of TE 040 test scripts, validations using Win Runner 7.5.
• Assisted in user acceptance testing and conference room pilot go live.
• Prepared training materials with screen shots, exercises and presentations for critical end users.
• Assisted the technical teams on the customization and extension issues of RICE objects.
• Actively involved in the post production support and troubleshooting on various issues.
• Provided with Post production support for various issues after go- live.
• Resolved the application issues interacting with oracle support through SR/TAR.
• Resolved the issues related to credit card payment processing, payment authorization, payment capture.
• Resolved the issues where invoice transactions were related to consolidated invoicing and selected to receipt batch ids and stuck in the workbench and not being able to be applied to the receipts.
• Resolved the issues related to automatic refund of credit card charges stuck in the receivable workbench.
• Resolved the issues related to automatic clearance of receipts, aging 7 bucket report, credit snapshotreport, customer statement report.
• Resolved the issues related to RTP for drop ship, PO receiving, AP invoicing, receiving hold, debit memo.

Confidential, San Diego, CA

Oracle Financials Functional Consultant

• Member of the core team responsible for implementing GL and AP.
• Interacted with the client team to understand the existing business practices and prepared the businessrequirement definition document.
• Responsible for the documentation (BR.030 -Business Requirements Mapping, BR.100Application.
• Setup and TE.040 -System Test Script) and setups of the General Ledger and Account Payables Modules.
• Created BR100 documentation for GL and AP.
• Participated in designing the chart of accounts to meet the client’s business requirements.
• Configured the Ledger Setup, Legal Entity, Operating units and Multi Org (MOAC).
• Created Customized responsibilities, customized menus, customized request groups.
• Configured Payable Setup Options.
• Used Accounting Setup Manager for Inter-company Transactions.
• Worked with Technical team regarding conversion of data.
• Conducted CRP1 and CRP 2.
• Created the MD 50 for each RICE components.
• Provided various custom solutions for client’s specific needs.
• Created user-manuals and trained the end users.
• Trained the users for UAT and conducted UAT.
• Created Test Scripts (TE-40’s) for UAT sessions.

Confidential,San Antonio,TX

Oracle Financials Functional Consultant

• Train the business users on Global Translations, Revaluations and Consolidation of Multiple Ledgers.
• Writing TE.040 Test Scripts for Functional Testing of GL, AP and developing Guided Navigations.
• Developing Training Material for AP module.
• Conducted end user training sessions and User manuals.
• Post implementation support and maintenance - performed successful three-month end and period closeactivities in the newly implemented modules.
• Design and Configure Financial Statements Using FSG.
• Maintain issue tracker using Bugzilla and issue resolution.
• Conduct business meeting whenever required based on issues and new functional requirements.
• Resolved issues that occurred in the production.
• Interacted with the end users and demonstrated the functionality in detail.
• Involved in unit testing and integration testing on various modules.
• Assisted in user acceptance testing and conference room pilot go live.
• Prepared training materials with screen shots, exercises and presentations for critical end users.
• Assisted the technical teams on the customization and extension issues of RICE objects.