SUMMARY:

• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut - Over and Project Coordination activities.
• Experience with Oracle Business Accelerators for e-Business Suite Release 12.
• Experienced in working with Oracle Applications Release 12
• Possess strong knowledge of Supply Chain Management modules of Oracle applications, with concentration on Quoting, OM, Advance Pricing (QP), PO, INV, WIP, COSTING, AP, AR, combined with a unique combination of their integration with other modules like Advanced Pricing, Shipping and Oracle Discoverer.
• Experience with the return process in Order Management, Reverse Logistics flow and integration to Depot Repair.
• Extensive experience in CRM Modules of Service Contracts and Install Base.
• Extensive experience with the Order to Cash and Procure to Report business flows.
• Formulated solution design and implementation strategy based on client requirements.
• Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Trained the clients’ super users on the application and conducted pilot testing, integrated testing.
• Design validation & Setups of OM, INV, AR, Advanced Pricing PO, AP, and Shipping modules.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Experience in preparing Requirement Analysis Documentation, scripts, Functional Documentation, User Documents and Customization Documents.
• Specialization in Procure to Pay and Order to Cash business flows -
• Oracle Purchasing, Order Management, Inventory
• Oracle General Ledger (GL)
• Oracle Receivables (AR), Payables (AP)
• Cash Management (CE)

TECHNICAL SKILLS:

ERPE: Business SuiteOracle Applications Release 12/11.5.8/10.7/9.4 (PO, INV, WIP, AP, SYS ADMIN, AOL, OM)

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Financials Functional Consultant

Responsibilities:

• As a Finance Functional Lead implemented financial modules: AR, AP, GL, e-Business Tax, FA and CE
• Performed Requirement and Gap analysis. Configurations and Setups AR, AP, GL, e-Business Tax, FA and CE
• Configured Taxation for US Sales Tax, Canadian GST and VAT Tax in EMEA in e-Business Tax module. Involved in the configuration of Tax Content Service, Tax Determination Services, Tax Users, Look Up Codes, TCA Geography Hierarchy, TCA Classifications for Tax, Tax Classification Codes, Tax Accounts and Tax Accounting Information.
• Worked on the data conversion from 11i to Release 12 for all financial modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• 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 Cash Management and Account Payable Module
• Functional Support for SOX and PWC Audit
• Integration and Implementation of Foreign exposure through Fire Apps external software with Oracle GL
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Environment: - Oracle Applications Release 12.1.1 Upgrade from Release 11.5.10.2 Rollout for US, Canada, EMEA and Middle East AR, AP, GL, FA, CE, Sub Ledger Accounting, Financial Accounting Hub, e-Business Tax

Confidential, Chicago, IL

Oracle Financials Functional Analyst

Responsibilities:

• As a Functional Consultant Supported all financial modules: GL, AP, AR & FA Release 11.5.10.2
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured Oracle GL, AP, AR, CM and FA from scratch and simultaneously created BR100 documentation for the setups.
• Created new Assets (from new acquisitions) using ADI.
• Involved in troubleshooting issues on Fixed Assets Mass Additions.
• Loaded Journalsfor new Acquisitions using ADI.
• Worked on the process of retiring Asset process in Fixed Assets.
• Setup the calculations for Gains and Losses in Retirements in Fixed Assets.
• Set up the Account Generator workflow in Oracle Fixed Assets
• Set up security by book in Fixed Assets
• Defined the depreciation book in Fixed Assets
• Defined formula based depreciation methods in Fixed Assets
• Setup Oracle Assets Function security
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for WVI (World Vision International) by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Conducted Multi-Org Revert Testing to create an effective Revert Plan for WVI, as and when required.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful to the users in GL, AP, CM, FA.
• Created FSG Financial Reports critical to company’s business process.
• Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential, Boston, MA

Oracle Apps Functional consultant

Responsibilities:

• As a Functional Consultant in the Procure to pay business flows, implemented financial modules: i-Expense, GL, AP, Advance Collections, and AR, i-Receivables & FA of Oracle e-Business Suite.
• Implemented 2 SOB’s (2 Operating Units) using multi org structure, multi currency along with 1 Consolidation SOB.
• Worked on a deferred revenue customization using the Revenue Recognition process in AR.
• Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system.
• I-Expense - Configured i-Expense module including setting up of Payables Lookup Types for i-Expense, Setting up Credit Card expense types, Expense check reimbursement address, Expense reporting template for Connected and Disconnected expense reporting, Defining the expense clearing account, establishing the multi currency setup, setting up itemization in iExpense, Setting of i-Expense P-Card functionality, mapping of credit card expense types, entering employees as suppliers in order to facilitate iExpense access, assigning signing Limits, etc.
• Advance Collections - Setup the Scoring Engine, Strategies, Work Items, Universes, Filters, Defined the delinquency status range in Advance Collections.
• Created the Collections Administrator, Collections Manager, Collections User profiles in Advance Collections.
• Implemented internal control features using Form Personalization’s for modules GL, FA, AP, and AR.
• I-Receivables - Performed all the setups for i-Receivables module, tested it and performed the rollout and on i-Receivables module.
• Implemented TCA - for AR customer master conversions.
• Designed and developed the customer interface to load customers into the TCA Module from an external customer database.
• Implemented Auto Lock box Functionality in AR for Bank of America & Royal Bank of Canada.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks BOA & RBC.
• Implemented VERTEX Quantum tax software and D&B integration with oracle.
• Customization done on CFD’s like AR Customer Invoice for pre-printed stationery and using XML feature, inter Company Customer Invoice, AP -Remittance Advice.
• Designing and executing ‘Data migration’ strategy for Master and Transactional data. Migrated GL Balances, Budgets, Suppliers, AP open Invoices, Customers, AR open Invoices, Fixed Assets by using ADI tools and loader scripts.
• Creating Purchase Orders for Capital Projects, Charging Supplier Invoice Lines to Projects, Charging Expense Reports to Capital Projects, Charging Labor, Usages, and Miscellaneous Transactions to Capital Projects, Placing CIP Assets in Service, Creating Fixed Assets from Capital Projects, Defining and Processing Assets
• Developed different reports as per the client’s requirement.
• Developed custom interface between Order Management and Projects.
• Customized the PO account generator and the Payables workflow.
• Prepared documentation to supplement the implementation Project Costing.
• Trained business owners and business end-users on Capital Projects Costing as part of User Strategy.
• Conducted pilot testing, integration with other financial modules testing.