SUMMARY:

• Eighteen years experience in Oracle EBS covering implementations, customizations, upgrades, and support.
• Experience in O2C, P2P, Service and Self - Service modules in R12 and 11i releases.
• Experience in requirements gathering, impact assessments, gap analysis, work estimations, system configurations, technical solutions, testing, validations, and project management.
• Experience in delivering solutions through Waterfall and Agile methodologies.
• Experience in stakeholder communications and client relations in global environments.

TECHNICAL SKILLS:

Oracle EBS Versions: R12(12.1.3), 11i (11.5.10.2 and 11.5.7), 11.0.3, 10.7SC

Oracle Modules: O2C, P2P, Project Billing, Install Base, Service Contracts, Core HRMS, SSHR, OTL, iExpense, iProcurement, iSupplier, iReceivables, TCA, Alerts, AME.

Oracle Tools: Workflow 2.6, Discoverer 4i, Forms 6i, Reports 6i, FSG, ADI/WebADI, BI Publisher.

Other Tools: NoetixViews, PVCS, Kintana, Remedy, HP QC, Rally Agile, Visio, PowerPoint

Languages and OS: Pro*C, PL/SQL, Perl, HTML, Core Java, Unix/Linux.

Working Knowledge: ODI 11g, Informatica PowerCenter 8.6, OBIEE 10g, OA Framework.

PROFESSIONAL EXPERIENCE:

Sr. Consultant

Confidential, San Jose, CA

Responsibilities:

• Lead project for migrating Cisco Sales Orders and Customer data across three 11i instances into a single R12 instance. Business entities migrated are US, Canada, EMEA, India and Japan.
• Defined and socialized the RD50s for Sales Order and Customer data migrations with PMO, Cross Functional, business and IT teams to ensure acceptance. Participated in MD50 design reviews.
• Proactively worked with stakeholders to identify and fix problem sales orders to minimize fallouts and ensure successful order fulfillment post go-live.
• Regularly communicate project status to stake holders across business entities.
• Working with QA team, defined and validated the unit test cases for end to end Order fulfillment and Customer data with IT team and Business users.
• Manage the requirements traceability matrix to ensure business and technical requirements are translated accurately into test plans and scripts.
• Performed functional testing, extensive audits, and smoke tests on migrated data during Go-Live.
• Involved in post go-live normalization issues prioritization, resolution and escalation management.
• Working with operations, cross functional business and IT teams, defined new RMA and service cancellation processes in China business entity to comply with China statutory Red VAT letter requirements.
• Created user stories in Rally for functional specs, updated user guides with the new processes flows, and conducted user training sessions.
• Defined unit test cases in HP QC and performed UAT testing on the two new processes.

Technical Lead

Confidential

• Involved in design, development and deployment of Integrated Collections Management System(ICMS) application for disputes management using Pega framework. Responsible for developing Sales Order holds application/release, Customer Balance, Aging Trend, and KPI Dashboard features of the application.
• Leading a six person offshore development team. Interfacing between development team and onsite business analysts. Resolving design and technical issues.
• Worked on PO and iProcurement release 12.1.3 upgrade project for select business units. Tasks include pre and post upgrade data validation, setups validation, and issue resolutions.
• Worked on enhancing and troubleshooting existing AME rules in iProcurement in R12.1.3 environment.
• Worked on integrating Fieldglass tool with iProcurement to manage contingent worker purchase orders.
• Monitor and resolve high priority month-end, period close issues in the O2C and P2P processes.

Environment: R12.1.3, AR, OM, TCA, RICEW, PL/SQL, Remedy, Kintana, HP Quality Center, Rally Agile, BuinessObjects BI, SFDC, Pega.

Confidential, Sunnyvale, CA

Sr. Oracle Applications Consultant

• Designed new data extracts from Oracle Financials (GL, SLA, AR) into Data Warehouse environment (Hyperion/SmartView). The process included defining source to target mapping specifications and developing ELT extracts using ODI interfaces.
• Enhance existing dimension and fact tables and assist in developing new ones to facilitate drill through reporting of GL and AR/OM data.
• Upgrade of Oracle EBS release 12.1.2 to 12.1.3. Performed pre and post upgrade steps for RICEW components.
• Customized several seeded reports in AP, AR and GL using BI Publisher.
• Designed and Developed several ad-hoc FSG reports in GL.

Environment: R12.1.3, Oracle 11g, SQL Reports, BI Publisher.

Sr. Oracle Consultant

Confidential

• Upgrade of Oracle Apps financial modules 11.5.4 and database version 8.1.7.4 to 12.1.3/11.2.0.2 respectively. Responsible for upgrade/porting of RICEW objects. Prepare test cases and participate in UAT testing
• Involved in installation of OBIEE 10g and Informatica PowerCenter 8.1, setting up the connection pools, repository and integration services, RPD development, Dashboard Setup with drill through reports, Source to target extract mappings, Lookup and Router Transformations for a data warehouse pilot project.
• Client: Xactly Corporation. Designed and developed Sales Credit Assignment Engine (CAE) add-on for Xactly Incent product, which is a SaaS based incentive management tool. The CAE module processes incoming sales orders against flexible and comprehensive set of rules and assigns sales credits. Developed several APIs to interface with the CAE. Used advanced PL/SQL techniques, external tables, analytical functions and hierarchical queries.

Environment: R12.1.3, PL/SQL, Discoverer, SQL Reports, BI Publisher, Workflow, OBIEE, Informatica, Linux

Sr. Oracle Applications Analyst

Confidential, Oakland, CA

• Managed an entire project involving separation of parent entity books (GL and Sub ledgers) into three separate legal entities as part of company spin offs. Deliverables included implementation of O2C, P2P, iExpense and iProcurement modules in the new legal entities.
• Customized Requisition and PO approval workflows for streamlined routing and approval processes.
• Implemented iReceivables for internal/external users to manage accounts and pay, print, and dispute invoices.
• Implemented iPayments to accept credit card payments against invoices in Receivables.
• Worked on beta rollout of iSupplier portal for vendor management.
• Developed custom Aging by Salesperson, Aging by Collector, Aging by Transaction Type, and Aging Trend Analysis with DSO reports using Discoverer 4i.
• Wrote BAFF interface to integrate Oracle Payables with Confidential payment services for Confidential.
• Prepared RD50, MD50, and BR100 AIM documents.

Environment: Oracle 11i EBS (11.5.10.2), Oracle 9i, PL/SQL, Workflow 2.6, Discoverer 4i, FSG, BI Publisher, SQL*Loader, Data Loader, ADI/WebADI, Linux.

Oracle Applications Manager

Confidential, Redwood City, CA

• Lead team in implementing Install Base and Service Contract modules. Involved in fit/gap analysis, capturing requirements, mapping legacy data with Oracle Service Contracts schema, setups and configuration, workflow customization, BAT testing, production rollout and post go-live support.
• Upgraded Finance, Project Accounting, Purchasing, OM, Inventory, HRMS, SSHR, OTL, and iExpense modules. Performed pre and post upgrade steps on the standard and customized objects as per the 11i upgrade roadmap.
• Upgraded custom Forms and Reports to v6.0 and Discoverer reports to v3.1.38
• Migrated custom PL/SQL programs, SQL*Plus scripts, Interfaces to suite 11.5.7 architecture.
• Worked on integrating Oracle HRMS with ADP and EquityEdge for payroll processing and employee stock options respectively.
• Assist in month/period end close and reconciliation activities.

Environment: Oracle EBS (11.0.3 & 11.5.7), Oracle 9i, PL/SQL, Forms, Reports, FSG, Discoverer, Toad, Linux.