SUMMARY

• 8+ years of strong experience as an Oracle Apps functional consultant on EBS Release12 (R12 R 12.0.2) & Release 11i (R11i - 11.5.5, 11.5.7, 11.5, 10.2) financial modules General ledger, Accounts Payable, Account Receivables, Project Accounting, Procure to Pay, Cash Management and Fixed Asset.
• Strong in Oracle EBS - GL, AP, AR modules with functional experience in analyzing business requirements, procedures & processes, module setup, functional design specifications, user training and post-implementation support.
• Expertise in all new features & functionalities on R12 i.e. Oracle E-Business Tax, Sub ledger Accounting Method, Multi Org Access Control (MOAC) and Advanced Global Intercompany SystemAGIS.
• Experience in all stages of ERP implementation including Requirement Gathering, Solution Design, GAP Analysis, Customization, Configuration, Testing and Project Coordination.
• Extensive experience in understanding and gathering client requirements, translating them in to various process alternatives, mapping into feasible solutions in Oracle Applications, managing functional setups related to Oracle applications.
• Involved in Implementation, Upgrade, Production Support, Migration and Customization of various domains of oracle applications.
• Involved in setup of GL and AP modules on production server, updating the test scripts.
• Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Involved in documentation in accordance with AIM Standards (BP080, BR100 & TE040).
• Successful completion of Implementation, Upgrade and Production support.

TECHNICAL SKILLS

ERP: Oracle Applications R12 (12.0.2), Ver. 11.5.5, 11.5.7, 11.5.10.2

Oracle Apps Modules: General Ledger (GL), Accounts Payables (AP), Account Receivables(AR), Fixed Assets(FA), Cash Management (CM), Purchasing(PO), Inventory (INV), Order Management(OM), iExpenses, iReceivables, iProcurement, iPayments.

Databases: Oracle 9i/ 8i, MS Access

Languages: SQL, PL/SQL, C, C++, Java, JSPetc.

Oracle Tools: SQL*Plus, SQL*Loader, TOAD

Business tools: SPSS, working knowledge on Eviews.

GUI Tools: Oracle Forms and Reports, Oracle BI Publisher,Web ADI, Cognos,Oracle Discoverer and exposure to workflows.Oracle Reporting tools BIEE,Hyperion etc.

Operating Systems: UNIX on Sun Solaris, Windows NT/2000/98/95

Version Control: PVCS, CVS, Microsoft VSS

PROFESSIONAL EXPERIENCE

Confidential, Downtown, CA

Financial Functional Consultant

Responsibilities:

• Involved in Implementation and testing of Oracle FinancialR12 GL, AP,AR and CM modules
• Involved in requirement gathering and analysis and design of the application.
• Worked with the client team to understand the current Business Process.
• Developed test plans and scripts and conducted testing for quality assurance.
• Performed set up for GL, AP, AR modules for R12.
• Worked on General Ledger Multi-org on an R12 implementation through initial Conference room pilot (CRP).
• Performed requirements gathering, gap mapping. Responsible for initial setups using Accounting Setup Manager.
• Assisted/reviewed Payables and Cash Management.
• Determine business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.
• Setup instance for new acquisitions.
• Provide post upgrade support
• Work with the developers to develop conversions, interfaces, reports (MD50’s).Tested the Order to Cash (O2C) and the Procure to Pay (P2P) business flow
• Tested the Service Contracts Module and the Receivables Interface process
• Tested the 2 way, 3 way and 4 way matching in PO
• Tested the AP to GL Transfer program
• Tested the Invoicing and Accounting rules in AR
• Tested the Auto Invoice Interface and Auto Invoice grouping rules in AR
• Designed Auto Invoice Import process and documented the import process in AR.
• Documented custom processes by using AIM Methodologies.
• Wrote functional specification for reporting requirements in AP
• Corrected wrong currency problem in AR Invoice, Debit Memo & Credit Memo.
• Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
• Defined Payment Options, Payment terms, Distribution Set, Payment format, Internal Banks in AP.
• Corrected customer Profile class setup & statement to avoid multilingual statement printing. Wherever required.
• Configured the setups for prepayment to employees and defined employee expense report.
• Developed FSG Reports in GL like (Income statement, Dept. Expenses, Inter Company Summary).
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.
• Created and maintained User Menu objects.
• Created responsibilities assigned to users and set profile option.

Environment: Oracle Application (R12), GL, AP, AR, CM, PO, INV, OM, iProcurement, iExpenses, PA, Reports Manager, Alerts, Applications Developer,SLA,E-Business-Tax

Confidential, Fairfield, IL

Oracle EBS Functional

Responsibilities:

• Implementing Accounts Payables, Receivables, Cash Management and General Ledger for all business units of UCI.
• Identifying standard functionality, and analyze gaps and complete solution for GL, AR, AP and CE depending on Business requirement.
• Business communications for the system updates and meeting deadlines for the implementation.
• Setting up Multi-ORG and Multi Currency.
• Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies.
• Setting up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defining FSG’s, Creating Ad-hoc Reports, and Open and Close Accounting Periods.
• Setting up Consolidation Ledgers, AGIS for intercompany Transactions.
• Setting up AP for PO matching and non-matching supplier invoices, payment profiles for check and wire, sub ledger accounting of payables transactions and transfer to GL.
• Setup Banks, Bank Accounts and documents.
• Setting-up of AR for invoice transactions including auto invoicing from OM and Service Contracts, auto application of receipt application to invoices using auto lockbox functionality, sub ledger accounting.
• Set-up of invoices, debit and credit memos, guarantees, deposit transaction types.
• Set-up receipt class, receipt methods, receivable activities and setting up accounting information for revenue recognition.
• Defined Customers, organizations, locations, control rules and groups.
• Defined payables lookup, payables option, tax codes, set up bank details, invoice payment terms.
• Defined distribution sets, matching tolerances for purchase order matching, payment programs and payment formats.
• Created different types of invoices and payment methods.
• Forms Personalization in iExpense and iProcurement using Oracle Application Framework Personalization.
• Setup financials and payables options including all key configurations in Accounts Payable.
• Auto import and reconciliation of bank statement in CE.
• Conducted CRP 1 & CRP 2, Tested RICE components and UAT.
• Developed FSG Reports in GL like (Income statement, Dept. Expenses, Inter Company Summary
• Prepared BP 40, CV40, BR100 documents and created MD 50 for all RICE components.

Environment: Oracle EBS R12, iProc,OM,AP, PO, AP, GL, AR, Quality Center, TOAD,E-Business-Tax

Confidential, Kalamazoo, MI

Oracle Financials Functional Analyst

Environment: Upgrade from 11.5.10.2 to R12.1.3

Responsibilities:

• Conducting Orientation with client to discuss R12 up gradation.
• Understanding current Chart of Accounts and propose a future design to enhance the way Stryker does Business currently with a new Chart of Accounts in R12.
• Interaction with Business Users to understand better their main points and Key requirements
• Defined and generated FSG’s for Balance Sheets.
• Updating Functional Setups of GL, AP, AR, and CE modules.
• Prepare financial reports for month-end.
• Involved in procure to pay(P2P) business flow.
• Discuss and Suggest a new Chart of Accounts structure to enhance the Performance of the current Business
• Designing and Developing Demo sessions for the Modules with the Respective users for R12 Environment.
• Gathering Business Requirements for Upgrade considerations and documenting them
• Configuring Working session exercises for the key processes performed
• Capture and upgrade all the Custom Processes and Reports
• Develop Unit (TE.020) and System Integration Test Scripts (TE.050)

Confidential, VA

Oracle Financials Functional Analyst

Responsibilities:

• Prepared Impact analysis document for the upgrade of the financial modules from 11.510.2 to R12.0.6.
• Involved in preparation of future business Process document (BP 80). Prepared Application configuration setup BR.100 and MD.50 Application Extensions Functional Design documents according to AIM.
• Responsible for preparing upgrade plan for GL, AP & FA.
• Prepared impact analysis document for the upgrade of financials module.
• Prepared the setup documents and configured system according to business requirements.
• Responsible for setting up delta functional like MOAC, Data Access sets, Payment Process.
• Designed Financial Reports using Financial Statement Generator (FSG) tool.
• Used Accounting Setup Manager for Inter-company Transactions.
• Set up Fixed Assets including defining category, location, and asset key flex fields.
• Defined the prorate convention; prorate calendar, depreciation rate and calendar, fiscal calendar, book controls and system controls.

Confidential, New York City, NY

Functional Consultant (AP, GL)

Responsibilities:

• Understanding the business requirement to enhance the functionality of existing implementation of service contract module to meet the wholesale business requirement.
• Preparation of technical design documents for interfaces, data migration and reports development.
• Development of interfaces following interfaces -
• Inventory Transaction Interface
• AP Vendor
• Auto invoice Interface
• AP Invoice Interface
• Integration of all above mentioned interfaces.
• Customization & Integration of Third party application ECHO to Oracle Applications
• Developing unit test cases for various interfaces and data migration.
• Performance optimization of reports using trace file and tkprof utility.
• Registration of concurrent program, executables, value sets, values etc
• Resolving all technical issues during the unit testing
• Following AIM mythologies in the project documentations.
• Moving programs and registrations from one instance to another instance.

Confidential, Trumbull, CT

Oracle Financials Consultant

Responsibilities:

• Involved in data migration, form’s conversion, and report conversion.
• Created many custom reports, custom forms as the part of the re-engineering project.
• Used standard user exits and Application Object Library routines to write the reports and forms.
• Migrated the data from the Oracle Payables, Oracle General Ledger, includes the information about the vendors, invoices, payments, and the balances from the Oracle General Ledger.
• Added cross validation rules to the new accounting structure.
• Implemented Advance Recovery Project with minimum customizations to OraclePayables with the discountaccounting.
• Incorporated discount accounting as part of the Advance recovery process.
• This project is to collect the advances paid to the vendors depends on the date ranges and the percentages.
• Implemented Inter Company accounting, these balances at multiple segments.
• The standard Intercompany program generates the transactions only to specific accounts (Balance at only one segment). The new process creates the transaction which balances at two segments.
• Implemented interest calculation project for the delayed Claims. This project calculates the interest on the delayed claims based on the Complex business rules including charity.
• Amounts and the percentage of interest depending on the legal entity and the date ranges.

Confidential

Responsibilities:

• Worked as a functional Consultant to implement Oracle Application 11.5.10.2 involving PO, i-Expense, AP, AR, GL and FA Modules Meet with customers to understand their system and service requirements Writing Functional Specification and coordinating with the technical team to develop AP Check Printing, EFT, PO Form and AR Invoice. Assist in the regression testing of Oracle Modules as required.
• Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), PO, AP, i-Expense, AR, GL and FA