Resume

Sign in

Service Oracle

Location:
Fremont, California, 94538, United States
Posted:
May 25, 2010

Contact this candidate
Sponsored by:
TalentDesk
Post Jobs to
Multiple Job Boards &
Get more Candidates
Try it Free!
Start your 30-day
Free Trial

SUMMARY:

> * years of total IT experience, which includes extensive experience

in technical and functional aspects of Oracle Applications 11i (CRM

Foundation, Service Contracts, Install Base, Field Services, Depot

Repair, Mobile Field Services, OM, INV,AP, AR, GL, PO, AOL and System

Administration).

> Involved in business requirement gatherings from Business Stake

Holders on different components.

> Very strong in Functional and Technical aspects of Service Contracts

and Install Base modules.

> Very good at Financial and Manufacturing Modules and its integration

with CRM modules.

> Good understanding in using Service Contracts Counters( Usage Based ).

> Extensively used Oracle standard APIs in Oracle Service Contracts and

Install Base.

> Good experience in doing data conversions from legacy systems to

Oracle ERP.

> Expertise in functional and technical design of interfaces.

> Extensively supported Service Contracts, Install base, Order

Management (OM) and AR as part of Production Support.

> Customized the Workflow for Service Contracts, Order Header and Order

Lines

> Involved in Service Contracts and Install Base Conversions in multiple

implementations.

> Involved in Oracle based business application design and development,

implementation, customization, maintenance, conversions, interfaces,

and user training.

> Good knowledge in Oracle Applications Architecture.

> Good understanding of TCA Architecture and using its APIs.

> Experience In usage of AIM methodology to implement Oracle

Applications.

> Involved in developing the custom database which interacts with Oracle

Applications @ Symantec

> Written Interface / Conversion programs for importing data from feeder

system to Oracle using PL/SQL, SQL*Loader and UTL_FILE.

> Having extensive experience in Customization of Oracle application

modules, which involved developing the Reports and Forms customization

using CUSTOM.pll.

> Ability to utilize project methodologies and standards.

> Experience Includes Application System Administration activities like

application user setup, defining responsibilities, value sets, flex

fields, registering forms, reports, concurrent programs and providing

support to the application users for technical and function issues.

> Have Strong analytical, problem solving and Communication skills,

extremely goal-oriented and driven by strong work ethic.

> As a process followed the SOX compliance in implementing the process.

> Undergone training in BPEL Process, Stream Serve Engine and XML

Publisher

TECHNICAL SKILLS:

Oracle CRM Modules : CRM Application Foundation, Service Contracts,

Field Services, Depot Repair and Install Base.

Financial Modules : General Ledger, Account Receivables, and

Account Payables

Distribution Modules : Order Management, Purchase Order, and

Inventory

Others : System Administrator, and Application Object

Library (AOL)

Databases : Oracle 8.x/8i/9i

Developer Tools : Oracle Forms 6i, Oracle Reports 6i,

Oracle Workflow, XML

Publisher

Database Tools : SQL*Plus, SQL Loader, TOAD, Data Load

Languages : SQL, PL/SQL and Java

Operating Systems : UNIX, Windows 9x/NT

PROFESSIONAL EXPERIENCE:

Google Inc., CA

Feb 09 -Till Date

Oracle Apps Techno Functional Analyst (Consultant)

Modules: Order Management, Service Contracts, Install Base, INV, AR, AP,

GL

Environment: Oracle E-Business Suite R11i (11.5.10.2), Oracle 10g,

Developer 6i ( Reports, Forms),Salesforce.com, PERL

Responsibilities -

> Responsible for resolving Production Issues in Service Contracts,

Install Base, Order Management (OM) and AR modules.

> Fixed many bugs in above modules

> Extensively supported Month End and Quarter End

> Involved in writing Test Case Documents, SDLC documents for various

enhancements.

> Provided various options/solutions to the business for process

improvements

> Extensively interacted with Business users in getting the business

requirements and doing the required testing.

> Developed interfaces using TCA API's for Customer updates

> Performed Data Conversions using Service Contracts API's and Install

Base API's

Advent Software, SFO, CA

May 07-Jan 09

Oracle Apps Techno Functional Analyst

Modules: Service Contracts, Install Base, Order Management, Advanced

Pricing, INV,AR, AP, GL

Environment: Oracle E-Business Suite R11i (11.5.9, 11.5.10.2), Oracle 10g,

Developer 6i ( Reports, Forms).

Responsibilities -

Production Support

> Responsible for resolving Production Issues and I am part of the P1

issues resolution team for Service Contracts, Install Base, Order

Management (OM) and AR modules.

> Completed many enhancement requests from Users on these modules (OKS,

OM and IB).

> Interacting with Users and Business owners in designing the solution

for production enhancements.

> Written number of Functional designs, Technical designs and Test

Scripts.

> Involved in customization of Service Contracts and Order Management

Workflows.

> Developed number of scripts to fix the Production Issues

> Involved in Service Contracts Conversion using Oracle APIs

> Resolved Critical (P1) issues in Service Contracts, Install Base, OM

and AR modules.

> Interacted with Oracle Support for problem resolutions

> Completed many process improvements in the Renewal business.

Projects

> Part of the upgrade project from 11.5.9 to 11.5.10.2

> Customized the Workflows in Service Contracts and OM

> Worked on many small projects involved in enhancing existing

functionality in Service Contracts, Install Base ( IB), OM and AR

modules

> As part of SalesForce.com implementation

o Worked on data Conversions

o Worked on Interfaces between Oracle Apps and SalesForce.com

Symantec Corporation, Mountain View, CA

Dec 05 - Apr 07

Employer: Symantec Corporation,

Project: CATALYST

Oracle Apps Techno-Functional

Modules: Service Contracts, Install Base, AR,INV and OM

Responsibilities -

> Involved in Requirement gatherings with business stake holders to

design interfaces and custom processes between CATALYST system

(External Portal) and ERP.

> Worked with cross track teams like Finance, Manufacturing, EDI, EAI

and others to gather and fulfill the requirements.

> Involved in presenting proof of concept to Business stake holders in

this project.

> Followed the SOX compliance while drafting the requirements.

> Involved in requirement gatherings for OM - OKS integration for

CATALYST (Software as Service) contracts.

> Involved in designing the new custom schema for this project.

> Responsible for design and development of Counter Capture Interface

between CATALYST( web based portal) and OKS using Service Contract

APIs

> Responsible for designing CDM (Common Data Model) for all interfaces

like Change of Service, Termination of Service, Billing PO and

Counter/Usage capture. These CDMs are used to integrate different

systems using EDI and EAI.

> Involved in requirement gatherings for Billing PO. This requires

customization of 'Service Contracts Main Billing Program'

> Responsible for development of 'Change of Service Interface Program'

between CATALYST, Partner net and OKS using Service Contracts APIs and

Install Base APIs

Project: OAISIS

Oracle Applications Techno-Functional

Modules: Service Contracts, Install Base, OM, AR and Inventory

Responsibilities -- Implementation

> In this project I was involved in all stages of project

implementation.

> Responsible for technical design and development of custom Service

Contracts approval

Workflow process

> Responsible for Autogen( Renewals ) engine technical design and

development. This engine is responsible to create contracts based on

critical business rules.

> Designed and Developed Quote Documents report using Oracle Reports

and Stream Serve

> Developed new forms using Oracle Forms

> Involved in Customization of new forms ( Quoting Tool )

> Developed various custom APIs in Service Contracts module which are

used as utilities.

> Involved in Service Contracts Conversion

> Involved in data conversion of Install Base data and Partners data.

> Worked with business users to gather requirements for Autogen Engine

and Workflow customizations.

> Followed the SOX compliances while implementing this project.

Production Support

> Involved in requirement gatherings for enhancements from business.

> Working with Business users on day to day production issue

> Involving in Quarter End/ Month End Support

> Writing complex Queries for Business users for analysis

Coherent Inc., Santa Clara, CA

Mar 05 - Nov 05

Oracle Apps Technical Consultant

Modules: CRM Foundation, Service Contracts, Install Base, Service Request,

Depot Repair, Order

Management, Inventory, WIP, BOM, GL, AR, AP

Environment: Oracle E-Business Suite R11i (11.5.10), Oracle RDBMS 9i,

Developer 6i.

Project Description: This Project is Implementation of Oracle Applications,

which includes Oracle CRM Service modules, Oracle Financials and

Manufacturing modules. This includes migration of data from legacy systems,

customizations and Report development.

Responsibilities:

> Responsible for setting up Service Contracts Module

> Involved in Design, Analysis and Development of Warranty and Service

Contracts Conversion using Oracle standard APIs.

> Involved in development of Install Base Conversion.

> Involved in Service Request Conversion along with Task and notes.

> Developed custom procedure to capture costing for Debrief Labor

Transactions using Debrief and WIP Bucket Jobs.

> Used Oracle user hooks to handle Debrief Material Transactions.

> Developed Service Contract Quote report.

> Involved in various developments related tasks.

> Written functional and technical specifications for Conversions and

other development items.

GE Power Systems, Atlanta Oct 04 - Feb 05

Employer : Rapidigm ( India ) Pvt. Ltd

Oracle CRM Consultant

Modules: CRM Foundation, Field Services, Depot Repair, Install Base, and

Inventory.

Environment: Oracle E-Business Suite [R11i (11.5.8, 11.5.9)]; Oracle RDBMS

8i, PL/SQL, SQL*PLUS,

Developer 6i(Forms and Reports)

Project Description: This Project is Integration of FRMT (Oracle Apps

11.5.8) and PARAGON (Oracle apps 11.5.9) Systems. This integration enables

the PARAGON resources to login FRMT system to do various operations like

Task update, Debrief etc.

Responsibilities:

> The project involved the development, customization and implementation

of custom Programs, Interfaces, Reports, Value sets in Oracle

Application as per the business needs.

> Involved in development of Setup document.

> Developed Conversion/Interface documents.

> Involved in Analysis, Design and Development of Install Base

Conversion (Instances and Relations ) using Oracle standard APIs and

Interface tables.

> Involved in Analysis, Design and Development of Service Request (SR)

Interface including Tasks and Notes using Oracle standard APIs

> Involved in Analysis, Design and Development of Resource Conversion

using Oracle standard APIs

> Involved in Analysis, Design and Development of Resource Skills

Conversion using Oracle standard APIs .

> Involved in Analysis, Design and Development of Skills Assignments to

Resources Conversion using Oracle standard APIs .

> Developed Pl/SQL Procedure to add Profile Values using Oracle Standard

APIs

> Used UTL_FILE Package to read the data from legacy system for

Conversions.

> Developed Reports using Reports 6i.

> Modified CUSTOM.pll to disable few field on 'View Service Request Form

'

> Prepared Conversion and Interface Technical Documents.

> Registered all the pl/SQL scripts as Concurrent programs to enable

users to schedule and run programs from Standard Report submission.

> Used TOAD as one of my major development tools to create, test the SQL

& PL/SQL codes.

> Worked on all phase of the project life-cycle

GE Wind Energy, Atlanta Dec 03 - Sep 04

Employer : Rapidigm ( India ) Pvt. Ltd

Oracle CRM Consultant (Executed at Offshore - India)

Modules: CRM Foundation, Field Services, Core Contracts, Service Contracts,

Install Base,

Mobile Field Service, Account Receivables, and Inventory.

Environment: Oracle E-Business Suite [R11i (11.5.9)], Oracle RDBMS 9i,

PL/SQL, SQL*PLUS,

Developer 6i (Forms and Reports)

Project Description: This project is Implementation of Oracle CRM for GE

Wind Energy business. Involved in technical implementation and

customization of Oracle CRM (CRM Foundation, Service Contracts, Field

Services and Install base) modules.

Responsibilities:

> The project involved the development, customization and implementation

of custom Programs, Interfaces, Custom Forms, Reports, Value sets in

Oracle Application Release 11.5.9 as per the business needs.

> Developed unique Error Reporting mechanism for all Interfaces and

Conversions.

> Developed SQL*Loader program for custom format to import the Service

Contracts, Employees, Resources and Problem codes data .

> Extensively used Service Contracts tables and Oracle standard APIs for

Conversions and Report development.

> Involved in Analysis, Design and Development of Service Contracts

Conversion including Billing schedules using Oracle Standard APIs

> Involved in Analysis, Design and Development of Employee Interface

using Oracle Standard APIs

> Involved in Analysis, Design and Development of Resources Conversion

using Oracle Standard APIs

> Developed 'Service Contracts Billing Report' using Developer6i and

integrated to Oracle Applications using AOL

> Developed 'Service Contracts Details Report' using Developer6i and

integrated to Oracle Applications using AOL

> Developed 'Install base Data Accuracy Report' using Developer6i and

integrated to Oracle Applications using AOL

> Modified CUSTOM.pll to disable few fields 'View Service Request' form

and 'Resources' form.

> Done the customization for Oracle Standard API - OKS_CONTRACTS_PUB

> Developed PL/SQL Procedure for Conversion of Problem Codes (lookups)

using Oracle Standard API.

> Registered all the PL/SQL scripts as Concurrent programs to enable

users to schedule and run programs from Standard Report submission.

> Used TOAD as one of my major development tools to create, test the SQL

& PL/SQL codes.

ECHOSTAR (Dish Network Company) Communications.

Sep03 - Nov 03

Employer : Rapidigm ( India ) Pvt. Ltd

Oracle Apps Technical Consultant (Executed at Offshore - India)

Modules: General Ledger, Account Receivables, Account Payables, Order

Management, and Inventory

Environment: Oracle E-Business Suite [R11i (11.0.3, 11.5.9)], Oracle RDBMS

8.1.7, PL/SQL, SQL*PLUS,

Developer 6i (Forms and Reports) .

Project Description: This project is up gradation of Oracle Application

11.0.3 to Oracle Applications

11.5.9.

Responsibilities:

> Migrated various reports from 11.0.3 to 11.5.9 in GL, AP, AR and OM

modules by finding out new mappings in the new version, compiling and

debugging the reports in report 6i.

> Developed few new reports in AR Module

> Customized some of the standard reports Purchase order and AR modules

> Involved in preparation of detail level design documents and unit test

plans

> Used TOAD as one of my major development tools to create, test the SQL

& PL/SQL codes.

BPL Engineering Limited, India. Jul 02 - Aug

03

Employer : Solix Technologies, India

Oracle Apps Technical Consultant

Modules: General Ledger, Account Receivables, Account Payables, Order

Management, Purchase

Order, and Inventory

Environment: Oracle E-Business Suite [R11i (11.5.8)], Oracle RDBMS 8.1.7,

PL/SQL, SQL*PLUS,

Developer 6i (Forms and Reports).

Project Description: This project is Implementation of Oracle Financial

(GL, AR, AP) and Distribution

Modules (INV, OM).

Responsibilities:

> The project involved the development, customization and implementation

of custom Programs, Interfaces, Custom Forms, Reports, Value sets in

Oracle Application Release 11.5.8 as per the business needs.

> Developed SQL*Loader program for custom format to import Journals,

Suppliers and Customers.

> Developed PL/SQL Package for Journals Conversion.

> Developed PL/SQL Package for Suppliers Conversion.

> Developed PL/SQL Package for Customers Conversion.

> Developed new reports using Reports6i ('Customer Invoice Details

Report', 'Payments Cheque Report', 'Transaction by Periods Report').

> Involved in end user training.

> Involved in Post Implementation support.

> Involved in preparation of detail level design documents and unit test

plans

> Used TOAD as one of my major development tools to create, test the SQL

& PL/SQL codes.

Rahul Auto Ltd, India. Nov 01- Jun 02

Employer : Solix Technologies, India

Oracle Developer

Environment :Oracle RDBMS 8.1.7, PL/SQL, SQL*PLUS, Developer 6i (Forms and

Reports).

Project Description: This Project 'Sales Tracking System' is developed for

Automobile showrooms where selling and servicing takes place. This system

will take care of all the divisions in the showrooms such as Inventory,

Sales, and Purchase etc.

Responsibilities:

> One of the team members of two, responsible for Implementation of

'Sales Tracking System'.

> Sales Tracking System was developed for Automobile Showrooms where

selling, buying and servicing of vehicles takes place. This Product

had modules such as Finance, Sales, Purchases, Inventory, Master file,

Vehicle Sales, Workshop Job Orders, Company Reports.

> Involved in development of Finance, Purchase and Inventory modules.

> Involved in Requirement gathering

> Involved in development of Various Forms using Forms 6i

> Involved in Development of Reports using Reports6i

> Created the Test scripts to check the functionality of the product

> Involved in end user training.

Trainee Oracle Applications ( Employer : Solix Technologies, India )

Jul 01 - Sep01

Employer : Solix Technologies, India

Undergone in-house training on Oracle tools (SQL, PL/SQL, TOAD, SQL*Loader,

Developer6i, Discoverer) and Oracle Applications Functional and Technical

aspects (Financial modules, Distribution Modules, System administration and

AOL).

References available upon request.



Contact this candidate