Service Oracle
Resume:
*********@*****.*** RAJEEV KAINTH
SUMMARY
Have around 8 years of global experience in Oracle e-Business Suite (release R12 and 11i) and Oracle
technologies - designing, developing, implementing, testing and rolling-out solutions for Oracle Corporation,
Sun Microsystems, Diebold and Motorola.
With a very good understanding of quote-to-cash flow and CRM modules, I have an excellent operational,
functional and technical knowledge of Advanced Pricing, Quoting, Order Management, Configurator,
Install Base, Oracle Service, Service Contracts, Inventory, BOM, Advanced Product Catalog, TCA, and
AR.
SKILLS
• Oracle Advanced Pricing, Quoting, Order Management, Installed Base, Oracle Service, Tele Service,
Service Contracts, AR, TCA, Inventory, BOM, Advanced Product Catalog
• Prepare BRD (Business Requirements Document), FDD (Functional Design Document), and TDD
(Technical Design Document)
• System Integration, Conversion, Change Management, Process Improvement
• Post-production support, Issue identification, tracking and resolution
• Onsite-offsite coordination
• Requirement mapping to Oracle Application modules, identify customization details, Oracle Application
setups
• System test planning & execution, User Acceptance Testing (UAT)
• Languages (PL/SQL, SQL, Oracle Forms, Reports, C)
• Database (Oracle 10g, 9i)
• Tools (Microsoft Office, Project and Visio, MS Access, Oracle Developer 6i)
• Have strong conceptual, business and analytical skills.
• Project planning & management, SCRUM Approach
WORK AUTHORIZATION: US Citizen.
Professional Experience
CSC Dec06 -- Present
Oracle Applications Analyst in Sun Microsystems
Sun Microsystems is a Hardware and Software company providing integrated technology solutions all over
the world. And worked Initial Implementing of GCIS and then for D1, D2, D3 and D4 Project to add more
functionality and perform Business Analyst and to add more Modules and support the Production System.
Environment: Application (ERP), Oracle Applications 11i (Advanced Pricing, INV, AR, Order Management,
Service Contracts, Installed Base, CRM, Customer Support, Field Service, Tele Service )
Advanced Pricing Projects: Implement Advance Pricing and create BR100, TE-40 and later for more
requirements create MD50s for different extensions to Advance Pricing.
• Prepare Oracle Applications Setup Documents (i.e. BR100), system test plans (TE40s).
• Write MD50 for custom extensions.
• Setup Pricing Agreement, Qualifiers, Modifiers, Pricing Formulas based upon Business
Requirements.
• Setup Pricing Attributes and map them by using the custom package designed for source code for
pricing engine.
• Setup the different Price list based upon the business requirements.
• Made all the necessary setups so that OM, Quoting Service Contract, Service Delivery can
interface properly.
• Made a lot of enhancements in Price calculation based upon Business Requirements like Warranty
Discount, Localized Uplifts, Item Category Discounts, Customer Category Discounts, Special Partner
Agreement (SPA).
• Supporting various test cycles for entire life cycle implementation, like System Testing, UATs and
production cut-over & go-live.
Service Contract Projects: Implement Service Contract Module as per Business Requirements and Create
MD50s and BR100s.
• Prepare Oracle Applications Setup Documents (i.e. BR100), system test plans (TE40s).
• Write MD50 for custom extensions.
• Define Coverage Templates for different levels of Service Coverage.
• Define Custom Process Definition.
• Design a process to convert Covered Item to Covered Product once the Booked H/W Order Shipped
and Installed.
• Update Billing Schedule of the Service Contract once the H/W is installed based upon installation
date.
• Custom Quality Assurance for better Customer Satisfaction and Improve Business like Overlap
Coverage, EOSL, Payment Method required, Installation Service Check and implement new Change
in control check when Oracle acquired Sun.
• Service Contract Versioning.
• Update Service Contract from Order Management.
• Supporting various test cycles for entire life cycle implementation, like System Testing, UATs and
production cut-over & go-live.
Service Delivery Projects: For Service Delivery to function Properly we Implement Field Service,
Universal Work Queue, CRM Modules and create MD50s and BR100s for them.
• Define New Business Processes for Coverage Templates.
• Define New Service Request Types, Statuses, Priorities and Service Request Groups and Transitions.
• Define New Task Type, Priorities, Statuses, Transitions of statuses, mapped task types.
• Define New Problem Codes, Resolution Codes and mapped them to Service Request Types.
• Define new Notes and mapped them for Service Request, Task, Debrief.
• Personalize and change the look and fields for Contact Center, Service Request form as per business
requirements.
• Define new resources and groups in CRM and assign them to Business User per business
requirements.
• Setup Territory Manager, Qualifiers and map the resources so that Assignment manager works.
• Install Base Update and trigger Service Request Creation Process custom work flow.
• Auto Create Service Request for Installation Service from Service Contract.
• Supporting various test cycles for entire life cycle implementation, like System Testing, CRP, UATs
and production cut-over & go-live.
Escalation Project: Because Sun use its own application WebEsc for Escalation/Notification for Field
Service. So create MD50 and MD70 for this Project.
• Design/Develop a mechanism so that Service Request and Task data will flow from Oracle 11i to
WebEsc.
Quote Import to OM: Sun has its own application for quoting which is linked with Oracle W5C
Configurator, so once quote is configured then automated the process to import in Oracle OM quoting.
Worked on designing to import the external quote to OM with its configuration.
•
Setting up BOM and Configurator so that proper configuration will be imported to OM.
•
Advanced Product Catalog: Set up Advanced Product Catalog (APC) Module as per business
requirements and create BR100. And load attached these catalogs to Items in Inventory module.
Support for Production System:
• As there is Live Production system with Oracle application, So always supports the
critical issues in Production which impact either Users or Revenue.
• Train the users for new process and/or new modules when we implements those.
• Resolved a lot of issues with Invoices, Credit Memos which effects Quarterly revenue. .
• Settling up Advance Pricing issues at Client side that was impacting couple of millions in
a quarter
• Support the Users with Contact Center, UWQ, Order Entry Issue, Creating SRs,
Assigning tasks, changing ownership of SRs, Item Instance, using Installed Base to find Item
instance details.
• Worked on set up user in CRM Administration and assigning Role, Groups.
• Quoting, Booking and Shipping the orders in Order management.
• Load the Pricing-using Mercury Load Runner from excel sheet to database.
• Worked with Users to resolve the issue with Install base, Service Contract, Service
Request and Order Management.
• Got a lot of recognition and awards while fixing the issues in Oracle Applications which
impacts million dollars revenue.
Diebold, Canton, OH Jan05 -- Sep06
Oracle Developer
Diebold is a services company providing integrated technology solutions that enable customers to maximize
their self-service capabilities.
Environment: Application (ERP), Oracle Applications 11i (INV, Order Management, Pricing)
• Customized reports Orders by item report, Cancelled Orders report, Item Order/Invoice Summary report
etc in Order Management.
• Worked on OM drop ship process. Extracting drop ship orders and sending them to fulfillment partners
and ship confirming those orders when ship confirmation is received from fulfillment partners.
• In Order Management (OM) developed PL/SQL procedure to validate the data in temporary tables and
send the data to the interface tables for batch order entry. Used Order Import to import data from interface
tables to OM tables.
• Design and Development of Custom Reports for Oracle Advanced Pricing using Oracle Reports Builder.
• Customize reports like Sales Order Acknowledgement, Pick Slip, Commercial Invoice, Packing Slip and
Invoice in OM.
• Created users defined custom responsibilities and assigned responsibilities to users.
Motorola, Chicago, IL Aug 02 -Dec 04
Oracle Developer
Motorola is a Fortune 100 global communications leader that provides seamless mobility products and
solutions across broadband, embedded system and wireless Networks.
• Involved in Customization of Standard Oracle Reports as per client requirement.
• Developed Interface Program for loading Items information from legacy system to Inventory (INV)
interface tables using SQL*Loader and PL/SQL and subsequently ran Item Import to populate the
Inventory Base tables.
• Used Order Management API to populate the data into various base tables.
• Registered concurrent programs, request groups for reports and concurrent requests.
Environment: Oracle Applications 11.5.5 Oracle Manufacturing (INV, OM,), PL/SQL, Oracle 9i, Forms
6i, Reports 6i, SQL *Loader.
Reference Available upon request
Contact this candidate