SUMMARY

• Around 7 years of Oracle Supply Chain Functional experience of which revolves around Oracle ERP and CRM Applications - Implementation, Support and Upgrade.
• Well conversant with Oracle Distribution Modules - Order Management and Purchasing, i-Procurement, i-Expense, i-Supplier, and Oracle Financials modules - Oracle AR, AP, GL and
• Very good on both the “Order to Cash” process as well as the “Procure to Report” process.
• Worked with Configuring Oracle Application modules as well as understands the underlying schema, which gives him a better insight into converting user requirements into functional and technical specifications. He has expert level experience in Building and deploying Financial Statement Generators (FSG) in General Ledger.
• Worked on 2 full life cycle implementation on Release 12 and has very good understanding of the new features of R12 like Multi Org Access Control (MOAC), Sub Ledger Accounting (SLA), Payment Module, Legal Entity Configurator, etc.
• Responsible for testing of the functionality of Oracle ERP Application
• Excellent experience with the AIM methodology
• Involved in scoping and mapping of business requirements of clients for Oracle Financials/Distribution solutions. He is actively involved Conference Room Pilots and User Acceptance Testing. Responsibilities also include building, testing & development as per Business Requirements.
• Expertise in implementation, development, customization, conversion, and upgrade of various modules including Trading Community Architecture (TCA).

TECHNICAL SKILLS

• Oracle Applications Oracle Applications
• Release 12/11i Business Suite
• Oracle Financials (Oracle General Ledger
• Oracle Receivables
• Oracle Payables
• Oracle Cash Management
• Applications Desktop Integrator)
• Oracle Distribution & SCM (Oracle Order Management
• Oracle Inventory/ Oracle Purchasing/ Shipping)

PROFESSIONAL SUMMARY

Confidential, CA

Functional Business Analyst

Responsibilities

• As a Distribution Functional Consultant implemented financial modules: OM, PO, i-Procurement, i-Expense, i-Supplier, and INV modules of Release 12.1.3 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 the integration of I-Procurement with PO and also worked on the functional specifications for customizations to I-Procurement module.
• Worked on all of the Order Management module including setting up of Transaction Types, Defaulting Rules, Processing Constraints, Shipping Rules, Modifiers and Qualifiers in Advance Pricing, etc.
• Worked on all of the Test Cycles SIT, CRP and UAT.
• Worked on the Inventory module setting up the Item Master, Templates, Inventory Orgs, defining sub inventories, locators, serial number controls, Min Max and Reorder Point planning, Cycle Counting and ABC Analysis, etc.
• Preparing BR30, 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
• Created New FSG Reports, using multi currency features including foreign currencies for multi org structures.
• Defined the AS-IS and TO-BE processes.
• Implemented TCA - for AR customer master conversions.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks BOA & RBC.
• Developed and executed test cases in Mercury Quality Center.
• Used Load runner to test interfaces.

Environment: Oracle Applications R12.1.3 OM, INV, i-Procurement, PO, i-Supplier

Confidential, LA

Distribution Functional Consultant

Responsibilities -

• Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type
• Established a Item Category and Item Cataloging for their products.
• Defined a ABC Analysis and Cycle Count
• Established Customer Item and Customer Item Cross Reference
• Established a process for smooth month end closing procedure in Inventory
• Lead the solutioning team for the Procure-To-Pay business flow.
• Liaise between the users and the business owners throughout the entire project.
• Performed Gap analysis hence identified issues and suggested workaround solutions.
• Coordinated in closing periods and generated trail balance reports for different Operating Units of the company.
• Worked on the setups of i-Expense module setting up the expense report template, expense categories, expense policies, expense approvals, etc.
• Implemented Enter Advanced Shipment Notices (ASN) in i-Supplier to acknowledge the delivery status and Shipping schedules.
• Integrated key purchasing functionality including Vendor Punch-out, XML Purchase Orders, Procurement Cards (P-Card), Emergency PO requisitions, Hosted Vendor Catalogs, and Automated PO Creation
• Prepared BR 100 Documents, Functional and Technical specifications for reports.
• Trained the business users for purchasing the Click to Requisition, PO to invoice, Return Material Authorization (RMA’s), Invoice to payment flows.
• Worked on new and customizing standard forms like AP/PO Taxability Inquiry, Purchase Order, Purchase Order Summary, AP Invoice Workbench and Supplier Form.
• Integrate Service modules with ERP for Inventory depletion and successfully complete test cycles of process flow from each module and finally recognize revenue in AR.
• Involved in support of Production and worked tickets raised in Oracle financial modules.
• Worked on the Test Cycle setup environment for SIT, CRP and UAT testing
• Prepared training guides and presentations to train users and admins with new features and changes in the system (P2P).
• Prepared and executed a detailed training strategy for the end users of different regions for the i-Procurement module
• Prepared Standard Operating Procedures for the end users reference.

Confidential, TX

Distribution Functional Consultant

Responsibilities -

• Gathered requirements from the power users concerning the customization of the reports and forms.
• Collected business process information, requirements and developed models for each business process.
• Carried out mapping, gapping and produced the initial version of documentation using AIM templates
• Conducted end-user meetings to review current business processes and requirement gathering
• Performed on-site requirement analysis and developed functional specifications for the modules
• Set up AP bank accounts, bank documents, bank codes, reporting entity and expense report templates
• Setup Vendors with mergers to create Invoices. Defined recurring payments
• Interacted with Oracle Support to resolve application issues, Bugs and TAR/SR management
• Performed Integration testing, user accepting testing
• Created user-manuals for programs and user procedures
• Conducted CRP Training of AP Team including senior Management
• Developed month end financial statement formats, project revenue and expense reports targeted to the needs of each departmental organizations
• Responsible for end-to-end testing of set ups, importation of supplier invoices
• Testing and documenting modules under AIM standards for different application functionality.
• Implemented Quote Management system through OM which reduced the ‘Quote to Order’ process time
• Setup Advanced Pricing system to simplify the Pricing process using automatic modifiers, Discounts and Promotions
• Simplified the Freight Charge application process by setting up formula to convert Freight Cost to Charge and modifiers along with associated qualifiers
• Available to Promise(ATP) and Auto-Scheduling functionality configuration reduced the Scheduling process time and enhanced customer service level
• Drop ship Functionality was setup to enable the OM team to ship the goods directly to Customers from Supplier warehouse.
• Internal Sales Order/Internal Requisition process was configured to establish a simplified Inter company sales across operating Units
• RMA and Approval Management functionality setup reduced the process time in Customer Returns management
• Established Purchase Requisition process and Approval hierarchy to manage non-production (Indirect) Items purchases in the Organization
• Developed solution to manage Stock Items and recurring non-stock purchases using Blanket Purchase Agreement (BPA) and Blanket Releases
• Configured Auto-Sourcing rules, Approved Supplier List(ASL) and BPA to enable Buyers to release purchase orders automatically from Planners Workbench
• Developed solution to manage Inventory using ‘Inspection’ as receipt routing for Items routed through Quality department and established ‘Return to Vendor’ process

Confidential, San Jose, CA

Functional Consultant

Responsibilities:

• Implementation of INV, OM, PO, Advance Pricing, i-Supplier, Shipping, AR modules
• AP- Defined invoicing information including payment terms, invoicing and accounting rules, territories and invoice sources
• Defined accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set
• AR - Defined receivable activities for misc. receipts, finance charges, bank charges, defining distribution sets
• Defined receipt class, specifying creation method, payment method, clearing method, defining collectors and aging buckets
• Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes
• Set up transaction types, invoices, guarantee, deposit, and credit memos, debit memos
• Assigned receivable account, revenue account, unbilled account, freight account, clearing account, and unearned account to transaction types
• Created, applied and reversal of Manual Receipts in AR
• Worked on all of the setups and configurations of OM, INV, Advance Pricing, PO modules.
• Analyzed user requirements and functional specifications to create test plans, test cases and test procedures for testing.
• Performed Black Box testing based on the functional requirements and product specifications of the application

Confidential, Austin TX

Distribution Functional Consultant

Responsibilities:

• Member of Global GL/GIS team responsible for OM, INV, PO, i-Procurement
• Core member of CRP2
• Worked on Mercury Quality Center as a Test Director.
• Functional design for OM, INV, PO, i-Procurement
• Responsible for communication with overseas IT resources for different global GL components
• Worked closely wit IT team for different issues.
• Developed and maintained functional specifications for custom reports
• Created test scripts for validating the OM, INV, PO, i-Procurement configurations
• Met with Dell leads and users to generate and review the current and future reporting requirements of the client.

Environment: Oracle Applications 11.0.3, 11.5.8 (OM, AR, AP, PO, GL, Discoverer 4i), ADI

Confidential, Marlton, NJ

Oracle Distribution Functional Consultant

Responsibilities -

• Firming up the Requirements Definition, Presentation of the process flows to the client team and obtaining concurrence on the final process flows for OM, INV, PO, Advance Pricing
• Designing of To-Be process and Identification of Gaps.
• Preparation of Gap disposition documents identifying workarounds & customizations.
• Developing Test scenario to perform Unit and Integration Testing.
• Performing out the Production Setups.
• Provided Functional Support for the Form and Report development to meet the Client requirement.
• End User Training.

Environment: Oracle Applications v.11.5.3 OM, INV, PO, Advance Pricing