SUMMARY:

• Over 12+ years of experience in User Requirement Study, Analysis, Design, Development, Implementation, Integration, Testing, Training, Support, Conversion and Maintenance of Oracle ERP/CRM systems.
• Hands on experiences in Oracle Applications 11i (11.5.4, 11.5.5, 11.5.9, 11.5.10) and R12 (12.0.3, 12.0.6) with all phases of SDLC from project initiation to post go - live support.
• Performed the role of Solution Architect for Oracle Application Projects.
• Expertise in the areas of Oracle Finance, Distribution & Manufacturing, covering wide array of consulting and client management responsibilities.
• Experience in Project Lead, Solution Architecture using Oracle Application Implementation Methodology (AIM) and SDLC methodology.
• Strong interpersonal and communication skills for effective customer interactions.
• Strong Analytical, Technical and Problem solving skills.
• Designing custom modules and integrations with ERP applications.
• Creating Business Requirements and Functional Design documents.
• Leading development, testing activities and coordinating UAT sessions.
• Ensuring quality, change management control processes and SOX compliance.
• Demonstrated experience of working collaboratively with all levels of project organization to ensure smooth and successful implementation of projects.

SPECIALTIES:

Oracle E-Business Suite (EBS, ERP) R11i, R12, Finance (GL, AP, AR, FA), Distributions, Supply Chain (SCM),Inventory (INV), BOM, Order Management (OM/OE), Advance Pricing, Quoting, Purchasing (PO), Sourcing, iSupplier, Oracle Demantra, EDI Interface.

SKILLS SUMMARY:

• Order Management (OM/OE)
• Quoting
• Advanced Pricing
• Inventory (INV)
• Bills of Material (BOM)
• Purchasing (PO)
• EB Tax, Vertex Tax Integration
• ASCP
• Advance Product Catalog
• Oracle Approval Management (AME)
• Oracle Customer Data hub (CDH)
• D&B data integration.
• General Ledger (GL)
• Receivables (AR)
• Payables (AP)
• Fixed Asset
• Oracle Projects iSupplier
• Sourcing iProcurment
• Trading Community Architecture
• EDI Interface
• Service Contract
• Install Base
• Application Implementation
• Case Methodology
• Fit/Gap Analysis
• Testing
• End User Training
• Configuration
• Functional Setup
• Data Conversion
• Code Combination Migration
• Team Management
• Oracle SQL & PL/SQL
• Oracle Work Flow
• Oracle Forms
• Oracle Reports
• BI Publisher
• Unix Shell scripting
• Oracle Web EDI
• Java, C++
• JDeveloper
• Toad
• OA Framework

PROFESSIONAL EXPERIENCE:

Confidential, CA

Oracle Techno-Functional Consultant

Responsibilities:

• Perform initial analysis on Clients Business Operations, gathering the requirements, preparation of scope document, perform GAP Analysis and solution for each objects.
• Involve in Integration testing for middle layer upgrade project.
• Develop custom pricing call program using API qp preq pub.price request.
• Design and develop the pricing formula to calculate the price of the “service renewal” using the get custom API.
• Design the drop-ship program to pack and ship in a single set.
• Design the new OU Canada and UK for quote edge system.
• Design the new OU Canada and UK for SNL system.
• Enabled pricing call to the Canada OU
• Modified the Service Price calculation for Canada OU
• Design & developed ECO interface.
• Design & developed BOM interface.
• Design & developed Price List interface.
• Design & developed FDS interface.

Confidential, Milpitas, CA

Oracle IT Architect

Responsibilities:

• Design the solution to copy transaction from BV to CG1 using SLA API.
• Data Loading into common accounting repository to support in FAH.
• Developed different ad-oc report to analyze the data for different legacy system from accounting repository (FAH).
• Design document for master data used in Financial Data Hub.
• Design Auto lockbox for Italy OU to bring the receipts.
• Design the RRR Revenue extract program
• Design the Invoice Orchestration program
• Design Libro Journal Report for Audit Process
• Involve in the Analysis of SJ Prod decommission process
• Design the Invoice print report in BI Publisher
• Design the EB-Tax integration program

Confidential, CA

Oracle IT Analysts

Responsibilities:

• Design and develop the Multi-tier service for Distributor, Reseller and the end customer model.
• Design and develop the “Net Price Solver” service to provide additional discounts to the distributor’s model.
• Design and develop the pricing formula to calculate the price of the serviceable product using the get custom API.
• Customizing and personalizing approvals using Oracle Approval Management (AME).
• Customize the Price Book Publication as per the business requirements.
• Design the attribute mapping to use in the attribute sourcing in Advance Pricing.
• Developed the custom pricing engine program to price the products using the price request API.
• Design the Price list Conversion using Bulk loader API
• Develop custom procedure to calculate the price break.
• Develop custom pricing call program using API qp preq pub.price request.
• Developed the update quote program using standard Quote API and simulate the pricing call.
• Design and develop the pricing formula to calculate the price of the “Trade In” product using the get custom API.
• Working on post-production support and resolving the production tickets.
• Worked on the Performance issues for pricing modules.
• Developed custom form using OAF.
• Customize oracle standard form using OAF personalization.

Confidential, CA

Oracle Support Financial Lead

Responsibilities:

• Responsible for the Set up for AR & GL Modules.
• Monitor the O2C Cycle.
• Developed Receipt write off program.
• Design and develop interface program to populate Vertex Tax result
• Worked on EDI inbound interface (Outbound Purchase Order).
• Worked on EDI inbound interface (Inbound Purchase Order).
• TCA: Worked on a project to create the customer the Oracle 11i TCA
• Design and develop the revenue recognition program to recognize short term and long term revenue for reporting purposes.
• Worked on technical design and developed a customization that prints the shipping documents after ship confirmation and re-pricing are done.
• Prepare Custom Revenue Recognition Process for GAN implementation.
• Implement and support of iReceivable module.
• Design & developed custom rule form using OAF.
• Develop month-end monitor scripts to proactively check issues.
• Responsible for running and reconcile different interface program.
• Responsible for any set up change or new set ups.
• Responsible for running different month end interface process in AR.
• Monitor the different lockbox interface.
• Worked on the upgrade testing in O2C module.
• Developed approval rules based on invoice amount for the following transaction type Payables Invoice Approval using Oracle Approval Management (AME) and configured action types and actions and set up the profile option to work for Payables only and also the required setup through Payables Options form.

Confidential

Oracle Support Lead Analyst

Responsibilities:

• Monitor the following interface programs from external system. Resolve the interface errors.
• GL Journal Interface
• AR Auto invoice
• OM Interface
• Responsible for production issues in O2C modules. Mainly on OM, AR and GL modules.
• Prepare Interface programs to CDH application using TCA model.
• Party & Account
• Location
• Party Site
• Account Site
• Bill-to and Ship-to Site
• Contact Points & Contact Preferences
• Classification
• Relationships
• Development of Advance price list Interface program to import the price list to Oracle application.
• Support business testing of data migration at various phases of the project.
• Customize the Invoice form to automate the invoice entries.
• Worked on the revenue reconciliation processes.
• Worked on the development of different revenue recognition rules and implement the same in AR and GL to recognize the revenue on a timely manner.
• Developed different financial revenue reports based on sales channel, business channel and different products.
• Responsible for month end and quarter end closing process.
• Production support for all Financial Modules.
• Developed custom reports for financial data & revenue analysis.

Confidential, Santa Clara, CA

Oracle Analyst

Responsibilities:

• Designed and developed custom program to update the category set in ASCP.
• Designed and developed custom program to update the planner code based on business requirement in ASCP.
• Designed and developed custom program to update the plan based on business requirement in ASCP.
• Prepare Interface programs to CDH application using TCA model.
• Post Processing Update after Plan Run
• Realignment of Supply
• MRP Forecast Interface - Designed and developed interface program to bring forecast data from Oracle Demantra to Oracle ASCP.
• AR Invoice - Developed interface program to convert invoice data from R10.7 using Auto Invoice
• GL Journal Interface - Developed interface program to convert journals data from R10.7 using GL Open Interface.GL Daily Rate Interface
• Design and developed custom forms and also customize standard form using custom.pll.
• Requisition Import Pre-validation to avoid release after requisition.
• Pick Up date calculation for PO Line
• Design and Developed inbound interface to Create Quote in 11i using API.
• Set up cross-validation rules.
• Defined Release process for various RICE components using Kintana tool.

Confidential, Santa Clara, CA

Oracle Applications Developer

Responsibilities:

• Gap analysis of Business requirements and changes.
• Developed and design the GL Journal Interface Program.
• Developed and design the GL Daily Rate Interface Program.
• Prepare Functional / Technical specifications Order Conversion.
• Developed Interface Program for Order Import from Legacy to Oracle.
• Designed, Developed & implemented XML Publisher, replacing formscape server.
• Designed testing documents.
• Implemented Bill Presentment Architecture in AR.
• XML(BI) Reports ( AR Invoice Reports for all OUs, PO Print Report, AR Dunning Letter, AP Invoice Report for all OUs, MVSN Active Employees List Head Count Report)
• Discoverer Reports ( PO Requisition Details Report, PO Cost Savings Report, Open PO Report by Buyer, Expense Report, Employee headcount Report, Open Receipts, PO Un-sourced Requisitions Report)

Confidential, Scotts Valley, CA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Responsible for Data conversion for US and Europe sites.
• Actively involved in various stages of implementation like capturing business requirements, gap analysis, to-be business processes, configuration, training, documentation and post implementation support activities.
• Worked on Test Plan Preparation, Unit testing, System Integration Testing, Conference Room Piloting and User Acceptance Testing.
• Resolving day to day production support issues (SupplyChain-O2C, P2P, BOM, WIP, ASCP & Finance modules).
• Responsible for AR, AP and GL closing for Month, quarter and year end Closing.
• Converted the AR Aging Report to Global Aging Report to display the consolidated data.
• Designed and developed Oracle Alerts for different Business requirements.
• Developed Interface Program for Order Import from KNet (Legacy) to Oracle.
• Designed and developed wrapper APIs to build custom business logic for TCA using PL/SQL.
• Developed Oracle Alert for different business requirements.
• Responsible for End to end patch testing.
• Developed Reports using Oracle Discoverer & XML Publisher.
• Developed interface program for Quote.
• Designed & developed XML Publisher bursting functionality to send email.
• Enabled Pasta Printer set up for XML Publisher Report.
• Responsible for developing the following XML(BI) Reports: (Aviza Pegging Report, AR Invoice Reports, PO Print Report, AP Invoice Report, PO Check Print Report, Commercial Invoice Report, RMA returned Report)
• Responsible for developing the following Discoverer Reports: (Active Responsibility List, Inventory Item Transaction report, PO Requisition Details Report)

Confidential

Project Leader

Responsibilities:

• Requirement analysis, gap analysis.
• Developed the XML Template using BI Publisher desktop tools.
• Modified the RDF as per the change in the report.
• Developed custom mail program to send the report output through email.

Confidential

Project Leader

Responsibilities:

• Responsible for complete R12 Migration Analysis.
• Responsible for R12 Finance Setups.
• Responsible for setup for Revenue Recognition.
• Data Mapping of Supplier data with TCA in R12.
• Customize Revenue Recognition Process.
• Gap Analysis of custom objects moving to R12 instance.
• Responsible for data conversion of different modules (AP Invoice, PO Vendor, AR Invoice).
• Integration with Point Of Sales.
• Production support for FA, GL, O2C, P2P, BOM, WIP & ASCP.
• Interaction with the user community to understand and analyze the business requirements
• Creation of Responsibilities and Users. Defining Functions, Menus and assigning in to Responsibilities.
• Responsible for patch testing for different cycles.
• Developed scripts to use in Reconciliations.
• Developed the following XML Publisher Reports:
• Developed the program “Wyse: RMA Approval Stored” to store the approval details.
• Modified the current RMA process.

Confidential

Project Leader

Responsibilities:

• As a Technical Consultant, I was responsible for
• Involved in implementation of World first ever R12 implementation.*
• Analyzing the requirement/enhancement.
• Creating new packages, procedures, functions in PLSQL
• Interacting with user/functional for clarification/feedback on the objects
• Design and Development of conversion program for Suppliers called Affiliates.
• Developed conversion program to bring data from ResOnline system into Roamfree 12i instance for suppliers.
• Developed xml outbound interfaces in AP module using PL/SQL procedures.
• Responsible for design, coding, development, testing and deliverable objects.
• Designing of Technical Document and Unit Testing Document.

Confidential

Project Leader

Responsibilities:

• Requirement analysis, data mapping, gap analysis. Writing Technical specifications for inbound and outbound interfaces, reports and forms, data conversion, coding standards and decision documents.
• Prepared the set up for the GL Chart of Account, GL Intercompany.
• Prepared the set up for the Auto Invoices.
• Designing and coding Oracle packages, procedures, functions, triggers, synonyms, sequences, views. Designing test plan and test cases.
• Setting up Oracle Applications with designing responsibilities, menus, request groups, concurrent programs, request sets, profile options.
• Designed, customized, tested and implemented forms and reports using forms and reports developer 6i.
• Responsible for extensive data validations, feeding of live data and user acceptance.
• Responsible for the data conversion (Supplier & Sites Conversion, Open PO Conversion, AR Invoices Conversion, Bank Conversion for the Supplier Sites)
• Responsible for the outbound Employee Interface - outbound for People Soft.
• Responsible for Customization of PO Print Report for India.
• Developed new reports (AP Payment Voucher Report, China AP Invoice Voucher Report, China AP Payment Voucher Report, China GL Accounting Voucher Report)
• Responsible for Customization of AR Consolidated Billing Invoices Report & AR Statement Generations Report
• Developed Custom Form to create custom lookup data & display common error messages.