SUMMARY:

• 16+ years of Oracle Applications experience
• 8+ years of project leadership and managing functional/technical development teams.
• In - depth understanding of various Oracle 11i, R12, Fusion Cloud E-business suite applications which include Oracle Order Capture, Quoting, Service Contracts, Service, iStore, Marketing Online, Order Management, Receivables, Financials, HRMS, OAB, TCA (Trading Community Architecture), Oracle Lease Management and Advanced Pricing.
• Extensive functional and technical experience in Oracle Ebusiness Suite.
• Thorough attention to detail, schedules, deliverables to attain results.
• Demonstrated ability to handle multiple parallel projects and priorities to achieve desired results.
• Excellent team player with good leadership, analytical, communication and interpersonal skills. Highly motivated, resourceful, enthusiastic and self-starter.

SKILL:

Oracle Application Releases: 11i, 12

Languages:: Java, Javascript, Perl, C, C++, HTML, XML, PL/SQL

H/W platforms:: Solaris, AIX, HPUX, Linux, Unix, Windows NT/2000/XP

Database Server:: Sybase (11.x, 12.x), Oracle (9i,10g,11g)

Oracle Tools:: JDeveloper, Forms, Designer, Oracle Application (OA) Framework, Workflow, XML Publisher (BI Publisher), Reports, BPEL Developer, ADI, WebADI

Tools: ClearCase, RCS, TOAD, SQL*Plus, SQL*Navigator, MS Project, Excel, MS Word, PowerPoint, Make, Gcc, Dbx, Yacc

EXPERIENCE:

Confidential, Sunnyvale, CA

Lead Functional Consultant/Business Analyst

Responsibilities:

• Worked with various stakeholders like internal and external partners, different vendors for requirements and functional design for different order processes.
• Performed Feasibility Analysis and Developed Project plan, Business Requirements, Functional Specs, Test Strategy, Test Plan, and Test Scripts etc.
• Ascertain the functional requirements and derive As-Is (Current Process Documentation), To-Be (Acceptable Design document) and Gap Analysis for all the functions of Fusion Cloud Financials.
• Organizing Daily Status calls, Maintaining Project Plan, Derive Project Status Metrics and report to steering committee.
• Configure the Oracle Cloud Applications to meet client requirements and document application set-ups
• Work with business to ensure requirements are finalized, Perform Prototype review and train them on Functionality.
• Facilitated Workshops for Business Requirement gathering, CRP and UAT.
• Fixing issues related to Setups/ Configuration, Personalizations, Reports and Analytics, Interfaces.
• Communicate with Oracle Support and Success Manager Team to get the issues resolved on priority.
• Developing test scenarios to ensure thorough testing and reviewing all test scripts developed by IT to ensure accuracy.
• Designed and developed solutions for end-to-end processes for Evaluation Orders, Donations Orders, Service Fulfillment, RMA, etc.
• Designed customizations and enhancements for Order Management, Account Receivables and Purchasing to automate numerous manual processes.
• Designed and wrote specifications for numerous reports in Order Management, Procure-to-Pay, and Order to cash processes using XML Publisher.
• Wrote the BP080 (To-be future process) for doing OM, AP, PO, Confidential AR and RMA processes which include entitlement checking, closed-loop RMA process, Install Base checking, etc.
• Wrote Test Scripts and trained users on the process steps.
• Developed the process training manuals for various business groups.
• Developed BR100 (setup) documents for AR, AP, Confidential, Order Management, Customer Master and FA.

Confidential, Milpitas, CA

Lead Functional Consultant/Business Analyst

Responsibilities:

• Worked with various stakeholders like internal and external partners for setting up new Operating Units for different countries.
• Managed and implemented Vertex tax engine for US and Canada
• Gathered requirements and implemented AGIS for automating intercompany transactions.
• Implemented E-business Tax for Germany, Singapore and Australia
• Designed interfaces for integration with Confidential and WorkDay
• Designed and developed enhancements for Purchasing, Payables and Requisitions.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Carrying out Conference Room Pilots (CRP) and User Acceptance Tests (UAT), go-live activities and Post implementation support.
• Designed and implemented iProcurement. Tailored many web pages to accommodate business requirements. Developed new LOVs for the accounting structure.
• Designed and Customized “PO Doc creation workflow”, “PO Approval & Requisition Approval Workflow” for iProcurement.
• Developed expense report templates, expense report processes (AP & OIE), and modified excel templates for iExpense. Configured key profile options and setups to invoke manager (spending) approval workflow process
• Customized ‘PO Output for Communication’ to print in multiple languages ( overriding session base language set up) and also personalized forms to add regenerate PO option to menu to let latest updated PO PDF.

Confidential, Newark, CA

Lead Functional Consultant/Business Analyst

Responsibilities:

• Worked with various stakeholders like internal and external partners, different vendors for requirements and functional design for different stores.
• Designed enhancements for different B2B stores using iStore
• Designed customizations and enhancements for Order Management for discrete manufacturing
• Wrote requirements for different stores and configured new stores for US, EMEA and China.
• Wrote Test Scripts and trained users on the process steps.
• Developed the process training manuals for various business groups.
• Developed BR100 (setup) documents for Depot Repair, Order Management, Customer Master and iStore.

Confidential, Sunnyvale, CA

Lead Functional Consultant/Business Analyst

Responsibilities:

• Worked with various stakeholders like internal and external partners, different vendors for requirements and functional design for different stores.
• Developed the design and integration for a custom pricing solution with Advanced Pricing (QP) for iStore to improve performance and custom functionality.
• Designed enhancements and customizations in Order Management for both discrete and process manufacturing.
• Wrote requirements for different stores and configured new stores in US and other countries.
• Wrote Test Scripts and trained users on the process steps.
• Developed the process training manuals for various business groups.
• Developed BR100 (setup) documents for Order Management, ATP, Customer Master, Advanced Pricing and iStore.

Confidential, Sunnyvale, CA

Lead Functional Consultant/Business Analyst

Responsibilities:

• Worked with various stakeholders like internal and external partners, different vendors for requirements and functional design.
• Designed various business process enhancements for quote-to-order process.
• Wrote Test Scripts and trained users on the process steps.
• Developed the process training manuals for various business groups.
• Developed BR100 (setup) document for Quoting and Order Management for Discrete Manufacturing.

Confidential, Sunnyvale, CA

Lead Finance Functional Consultant/Business Analyst

Responsibilities:

• Gathered business requirements and set up a new operating unit for a recently acquired business.
• Gathered business requirements and designed a business process for VMI (Vendor Managed Inventory) with Amazon and other vendors.
• Wrote Test Scripts and trained users on the process steps.
• Developed the process training manuals for various business groups.
• Developed BR100 (setup) document for finance modules including I-Expenses.

Confidential, Cleveland, OH

Lead Functional Consultant/Business Analyst

Responsibilities:

• Gathered details about current processes and requirements from Business on the current Quoting implementation.
• Conducted a feasibility study to help Confidential determine if they can use Negotiation functionality in order management and documented in a white paper.
• Implemented setups for Negotiation and presented to Business.
• Identified business process improvements for Quoting and Negotiation.
• Investigated pricing issues in Advanced Pricing and fixed pricing setups.
• Performed Gap Analysis between Quoting and Negotiation for different requirements.
• Developed BR100 (setup) document for Negotiation.

Confidential, Sunnyvale, CA

Lead Finance Functional Consultant/Business Analyst

Responsibilities:

• Gathered details about current processes and requirements from Business.
• Defined and Described ERP business processes and mapped existing business process to Oracle
• Designed Chart of Accounts, Multi-org structure (MOAC) and accounting structure.
• Performed Gap Analysis and designed custom solutions for different requirements.
• Developed the BP080 (To-be future process) documents for AP, AR, PO, FA and Confidential .
• Developed conversion strategy and mapping (CV040) for various data objects like open AR invoices, customers, sales orders, etc. from SAP to Oracle
• Designed the party and customer data model using TCA from business requirements.
• Developed MD50 documents for various interfaces and customizations.
• Configured Ebusiness Tax for US, Germany, China and Hong Kong countries.
• Configured Revenue Recognition rules, AGIS, Intercompany Relations and Trade compliance business processes in Oracle.
• Set up approval rules in AME for I-Expenses and I-procurement.
• Wrote Test Scripts and trained users on the process steps.
• Developed the process training manuals for various business groups.
• Developed BR100 (setup) document for finance modules including I-Expenses.

Confidential, Redwood City, CA

Lead Functional Consultant

Responsibilities:

• Gathered details about current processes and requirements from Business.
• Performed Gap Analysis and designed custom solutions for different requirements.
• Wrote the BP080 (To-be future process) for doing RMA processes which include entitlement checking, closed-loop RMA process, Install Base checking, etc.
• Wrote MD50 documents for various interfaces and customizations including Oracle-Remedy and Remedy-Oracle processes using SOA, BPEL and EBS.
• Modified Ebusiness Tax setups for Order Management and service contract billing for US.
• Wrote Test Scripts and trained users on the process steps.
• Developed the process training manuals for various business groups.
• Developed MD50’s for various reports for use in Discoverer, XML Publisher and Oracle Reports.
• Developed BR100 (setup) document for Depot Repair.

Confidential, Sunnyvale, CA

Lead Functional Consultant

Responsibilities:

• Wrote Functional specification, User guide, Test Scripts, Configuration document and detailed design documents for a custom extension in OAF and PL/SQL for merging quotes from one quote into any quote in other organization. The extension will copy any configuration from one quote into any other quote irrespective of the customer and any header details. Coordinated with business users for functional testing and training.
• Designed a custom extension in OAF and PL/SQL to calculate and display support price by using custom tables in Quoting.
• Designed a custom extension in JTT, JSP, Java and PL/SQL to explode all the configuration items using 1-click button.
• Gathered requirements and performed impact analysis and gap analysis to use a custom extension from an acquired company to use DFF to enable custom sequential ordering in quotes and use it in Confidential .
• Developed functional specification for quote print templates in quote printing in XML Publisher and reports.
• Provide production support for any quoting issues.

Confidential, Sunnyvale, CA

Lead TechnoFunctional Consultant

Responsibilities:

• Modified setup rules for deriving territories in Territory Management.
• Set up Geographic and Named Account Territories in Territory Manager.
• Developed PLSQL program to update territories in territory manager.
• Integrated Territory Manager with Order Management and Quoting.
• Analyzed, designed and developed an interface to load Confidential period rates.
• Developed a program to automate creation of users and assignment of responsibilities to users.
• Designed and Developed the CM bank interface for UK banks.
• Troubleshooted issues with tax calculation and Vertex integration.
• Designed and Developed the Cash Positioning interface with US banks.
• Designed the Customer / Supplier architecture by leveraging the Party / Account model within Trading Community Architecture (TCA)
• Developed an interface to update Fixed Assets with new departments and accounts.
• Set up approval rules in AME for I-Expenses and I-procurement.
• Developed BR100 (Setup) documentation.
• Troubleshooted issues with expense reports.
• Developed report for AR Invoices using BI Publisher and word templates.
• Troubleshooting any production issues including performance tuning.

Confidential, Mountain View, CA

Lead TechnoFunctional Consultant

Responsibilities:

• Analyzed, designed and developed an interface to load Confidential segments and values from Hyperion-based MDM system into Oracle.
• Analyzed, designed and developed a report to show status of each Confidential allocation batch for different Confidential allocation sets.
• Developed a script to update transaction numbers for bank statements.
• Developed report for AR Invoices using BI Publisher and word templates.
• Troubleshooting any production issues including performance tuning.

Confidential, San Jose, CA

Snr. Financials Lead Techno Functional Consultant

Responsibilities:

• Gather business requirements and design the functional solution to capture project codes for Requisitions and Expense Reports and transfer to Confidential in the procure-to-pay flows.
• Gather business requirements and analyze impacts in various modules for Confidential change from one business division segment to multiple divisions.
• Developed functional solution analyzing impacts across various modules.
• Gather business requirements and design the functional solution for various extensions in the order-to-cash business flow.
• Analyzed and evaluated R12 features for feasibility of R12 upgrade.
• Troubleshoot production issues in AP, AR, PO, Confidential, FA and other modules.

Confidential, Santa Clara, CA

Technical Lead Consultant

Responsibilities:

• Analyzed, designed and developed a PL/SQL extension to populate the customer name using a pre-determined format when a new customer is created.
• Analyzed, designed and developed a PL/SQL extension to create billing schedule for Service Contracts from a billing profile entered in quote.
• Analyzed, designed and developed a PL/SQL extension to populate DFF and other field information from quote to a service contract.
• Analyzed, designed and developed a concurrent programs, PL/SQL and OA UI extension to create, update service requests and install base for serviceable items whenever a service item is booked in Order Management.

Confidential, Fullerton, CA

Technical Lead Consultant

Responsibilities:

• Manage the technical project plan for all technical activities with various milestones and tasks.
• Analyzed, designed and developed OKL Lease conversion program for importing data from legacy systems into Oracle. The program included creating OKL contract header, lines, payments, allocations, validating contract, creating streams and booking the contracts.
• Analyzed, designed and developed a custom extension including schema, forms for creating and maintaining lease contracts.
• Analyzed, designed and developed the custom extension to prevent creation of fixed assets for certain types of items and financial products.
• Designed and developed the custom extension to derive the Confidential code combinations and customer information based on different invoice sources for Auto invoice programs.
• Analyzed, designed and developed the custom extension to correct fixed asset information in FA after the contract is booked.
• Designed and modified the OKL booking workflow to call custom logic that derives the Confidential accounting codes.
• Designed and developed a custom extension for import AP invoices through EDI and XML sources.
• Developed a custom extension for task assignment alerts and notifications for Service Requests in Oracle Service.
• Customized the Fixed Asset, Inventory, Service request and COGS account generation workflows.
• Designed and developed a custom extension to terminate OKL asset lines.
• Designed and developed a custom extension to create credit memo’s for OKL billing invoices.
• Designed and developed custom extensions and interfaces to update OKC and OKS contracts when OKL contract is updated.
• Set up rules in Oracle Territory Manager and integrated with Quoting and OM.
• Involved in extensive SQL performance Tuning.

Confidential, Orange, CA

Technical Architect

Responsibilities:

• Prepared the technical project plan for all technical activities with various milestones and tasks.
• Managed a team of 3 technical resources for the project.
• Analyzed, designed and developed the AR customer, TCA and invoice interfaces for importing data from legacy systems into Oracle.
• Analyzed, designed and developed the supplier conversion program for importing data from legacy systems into Oracle.
• Analyzed, designed and developed the HRMS conversion program for importing employee detail, address, assignments and salary history from three legacy systems into Oracle.
• Analyzed, designed and developed the advanced benefits conversion program for importing benefit carrier for each employee for health, life insurance and FSA providers.
• Developed OAB Fast Formulas
• Developed reports for PO detail, Invoice and Check printing using XML Publisher and word templates.
• Developed and tested Positive Pay and Bank Reconciliation reports.
• Lead the implementation of different interfaces between Oracle and different benefit providers.
• Involved in extensive unit and system testing activities. The testing involved in-depth functional and performance testing.
• Involved in the product technical documentation.
• Involved in extensive SQL performance Tuning.