Oracle Customer Service

[pic]

Rahul

Summary

V Around ** years of experience in oracle eBusiness suite application

development with significant experience in techno-functional aspects of

O2C, OM-OKS, P2P and CRM business processes.

V Significant exposure to Order Management (OM), Pricing (QP), Inventory

(MTL), Shipping (WSH), Installed Base (CSI), Service Contracts (OKS/OKC),

Accounts Receivable (AR), Accounts Payable (AP), Purchase Orders (PO),

iExpenses (OIE), General Ledger (GL), iPayments (IBY), Service Requests

(CS), iSupport (IBU), Email Center (IEM), Oracle Alerts (ALR) and Trading

Community Architecture (TCA) modules and APIs.

V Expertise in building FRICEW/CEMLI components.

V Significant experience in application development using SQL, Advanced

PL/SQL, JAVA/J2EE, Workflow, Shell Scripting, and Performance tuning.

V Strong exposure to AOL, OAF, APEX, Forms, CUSTOM.pll, HTML, CSS, XML,

PERL and Reports.

V Highly Skilled in using tools such as jDeveloper, Workflow Builder, Form

Builder, SQLLDR, FNDLOAD, XML Gateway, TOAD, SQL Developer and TKProf.

V Significant exposure to end-to-end implementations and support activities

in both 11i and R12 oracle e-Business suite.

V Significant experience in formulating MD050, MD060, CV040, MD070, CV060

and MD120 documents by interacting with the client/Business System

Analyst (BSA) where required.

V Expert level skill in developing High Level Technical Design Documents

(TDD), and supporting component design/UI documents.

V A self-starter and self-learner. Possess excellent communication skills

and demonstrated them during interaction with business users while

gathering requirements, presenting resolution details and

discussing/ironing out various issues with business processes in a

support environment.

V Excellent team player with a constructive problem-solving attitude. Have

made many key contributions to various projects and received awards from

management and team-members.

Educational Qualifications

Master of Science

Bachelor of Engineering

Certifications

Sun Certified Programmer for the Java 2 Platform 1.4

Oracle Certified Associate

Trainings

OAF, PLSQL (from focusthread.com)

Technical Skill-Set

Applications R12, 11i

Databases Oracle 9i, 10g, 11g

Oracle FRICEW, CEMLI

Components

Modules Order Management (OM), Pricing (QP), Inventory (MTL),

Shipping (WSH), Installed Base (CSI), Service Contracts

(OKS/OKC), Accounts Receivable (AR), Accounts Payable (AP),

Purchase Orders (PO), iExpenses (OIE), General Ledger (GL),

iPayments (IBY), Service Requests (CS), iSupport (IBU), Email

Center (IEM), Oracle Alerts (ALR) and Trading Community

Architecture (TCA)

Technologies SQL, Advanced PL/SQL, JAVA/J2EE, OAF, Oracle Workflow, Oracle

Forms, CUSTOM.PLL, Shell Scripting, PERL, HTML, CSS, XML,

Oracle Reports

Tools jDeveloper, Workflow Builder, Form Builder, SQLLDR, FNDLOAD,

XML Gateway, TOAD, SQL Developer and TKProf, SQLPLUS, Report

Builder, IBM Rational Rose

IT Service Remedy, RT, IBM Rational Clearquest, Rally

Management

Version GIT, Subversion, IBM Rational Clearcase, PPM

Control

Operating UNIX/LINUX, Windows NT/XP

Systems

Methodologies Agile, AIM

Professional Experience

ADESA (www.adesa.com), Carmel, IN Jul

2013 - Till Date

Lead Oracle Apps Technical Consultant

ADESA is North America's premier vehicle auction operator. ADESA offers a

full range of auction, reconditioning, logistical and other vehicle-related

services to meet the remarketing needs of both its institutional and dealer

customers.

Responsibilities:

UPA Implementation (R12 EBS Integration with SFDC):

o This project aims to:

. Shorten the time it takes for dealers to obtain a line of credit

with AFC/KAR by optimizing the credit and contracting

processes/workflows.

. Create a mechanism to allow an automobile dealer to choose

alerts and deliver chosen alerts to the dealer in a timely

manner.

. Transfer parts of functionality from the Oracle EBS forms based

system to salesforce.com.

. Build interfaces between salesforce.com and oracle EBS which

incorporate validations based on business rules.

o Contribution in Design, Development, Testing, Performance

Optimization, Deployment and post-production activities.

o Analyzed and understood existing business model/rules, data model, and

technical architecture/framework and built interfaces/customizations

accordingly.

o Development and Customizations in SQL, PLSQL (XMLDOM), Oracle Forms

and Oracle Alerts Technologies.

R12 Oracle Applications Enhancements:

o Development/deployment related to ADESA's O2C, P2P and TCA business

flows.

o Support and enhancements to ADESA's Order Import, auto-invoice and

Auto lockbox interfaces and OM Workflows.

o Contributed in support activities related to Nightly Builds, Alert

notifications and AP Invoice generation.

o Development of enhancements using Forms, Workflow, Alerts, CUSTOM.pll,

OAF and PLSQL/SQL.

Web-Service Security Implementation:

o This project involves setting up an architecture which secures the way

applications access

web-services.

o Contribution in Design, Development, Testing, Deployment and Post-

Production activities.

o Development in SQL, PLSQL and Java Technologies.

Red Hat (www.redhat.com), Raleigh, NC Jan

2010 - Jul 2013

Lead Oracle Apps Technical Consultant

Red Hat is the world's leading provider of open source solutions, using a

community-powered approach to provide reliable and high-performing cloud,

virtualization, storage, Linux , and middleware technologies.

Responsibilities:

R12 Re-Implementation:

o Migration of FRICEW objects from 11i to R12 and also implementation of

new enhancements in the SCM area.

o Contribution in Pre-assessment, Design, Development, Cutover,

Deployment and Post-production support phases of the implementation.

o Development/performance optimization related to custom OM shipping

interfaces, O2C and OM-OKS business flows.

11i/R12 Support and Enhancements:

o Development/deployment related to Red Hat's O2C, OM-OKS and P2P

business flows.

o Development of enhancements using Forms, Workflow, CUSTOM.pll, OAF and

PLSQL/SQL.

o Support and enhancements to Red Hat's OM inbound and outbound shipping

interfaces, auto-invoice interface in AR from OM and Auto lockbox

interface.

Supportable Re-architecture:

o Re-designing this application from scratch to improve existing

functionality, add new functionality and make the application

compatible with R12 oracle e-business suite.

o Technology evaluation and prototyping application in OAF and APEX.

o Development using APEX components such as pages, reports, interactive

reports, application items, tab layouts, page level processes,

conditional processes & display and collections.

o Development using advanced PLSQL related to O2C and OM-OKS business

flows.

o Integration of the APEX application with oracle eBusiness suite.

Global Credit Card Transaction Processing:

o Responsible for building code to implement data transfer logic between

Red Hat's Oracle eBusiness Suite and external credit card

authentication vendor.

o Development in the OM, iPayment and AR areas using JAVA/PLSQL/SQL

technologies.

B2B Implementation:

o Performing XML gateway transactions such as transactions & trading

partner setup, devising a map to process and load XML data into custom

database tables and OM interface tables.

o Code data validation logic in SQL/PLSQL before calling the order

import program to create orders.

o Development using xmldom and advanced PLSQL incorporating TCA APIs.

Common Tasks:

o Performance optimization and code review.

o Requirement gathering, testing, training and documentation.

Equinix (www.equinix.com), India

Feb 2008 - Dec 2009

Senior Oracle Apps Technical Consultant

Equinix, Inc. (Nasdaq: EQIX) operates International Business Exchange

(IBX ) data centers in 31 markets across 15 countries in the Americas,

EMEA, and Asia-Pacific.

Responsibilities:

Develop interfaces/extensions/customizations/data migrations in the O2C, OM-

OKS and P2P areas using Forms, Workflow, JAVA/J2EE, CUSTOM.pll, OAF and

PLSQL/SQL.

o Performed OM workflow customizations.

o Built concurrent programs and data-fixes to update teleservices, OM

and install base data based on business requirements.

o Extracted data from various modules such as Pricing, OM, Service

Requests, Installed Base, Service Contracts and TCA.

Enhancements/Personalizations/Customizations in the Oracle Teleservices

(CS, IEM, IBU) area.

o UI and functionality changes in iSupport and Tele-services.

o Build APIs to end-date users, responsibility assignments,

responsibilities as a part of CRM maintenance activities.

Performance tuning and code review.

Requirement gathering, testing, training and documentation.

IDC (www.interactivedata.com), India

Sep 2006 - Jan 2008

Senior Oracle Apps Technical Consultant

Interactive Data is a trusted leader in financial information and delivers

a comprehensive set of products and services designed to meet the needs of

the front, middle and back offices at some of the largest and most well-

known institutions around the world.

Responsibilities:

Enhancements/Personalizations/Customizations in the Oracle Teleservices

(CS, IEM, IBU) area.

o UI and functionality changes in iSupport, Tele-services and Email

Center modules.

o Development of enhancements using Workflow, JAVA/J2EE, OAF and

PLSQL/SQL.

Performance tuning and code review.

Requirement gathering, testing, training and documentation.

Nuance Communications (www.nuance.com), India

Jun 2004 - Aug 2006

Oracle Apps Technical Consultant

Nuance Communications, Inc. is a provider of voice and language solutions

for businesses and consumers globally. The Company's solutions are used in

healthcare, mobile, consumer, enterprise customer service, and imaging

markets.

Responsibilities:

Performed Bill of Materials and Project Events Data Conversions.

Design and development of a JAVA/J2EE web portal that displays customer and

item data.

Develop enhancements to Oracle Quoting, O2C, OM-OKS, P2P and CRM business

flows using Forms, Workflow, CUSTOM.pll, JAVA/J2EE, OAF and PLSQL/SQL.

Enhancements/Personalizations/Customizations in the Oracle Teleservices

(CS, IBU) area.

Enhancements and optimizations for the JAVA/JSP based web portal.

Responsible for development of enhancements and optimizations for the

Oracle Goal Setting and Sales Appraisals Module.

Requirement gathering, testing, training and documentation.

References: Available on request.

Contact this candidate