Project Oracle

SAndeep Kethireddy

functional summary

Sandeep is a Senior Principal Consultant with 10 years

of IT Industry experience including over 7 years

Oracle Applications. Sandeep has completed 6 full life

cycle implementations of Oracle 11i. He is highly

motivated, enthusiastic professional with a high

degree of commitment to succeed. He has been

recognized by management at different occasions for

dedication and devotion at work in various projects.

He possesses outstanding managerial skills and

superior verbal and written communication skills.

relevant ProjecT experience

US Steel Corporation United States Steel Corporation(USS), headquartered in

June 2009 - Present Pittsburgh, PA, is an integrated steel producer with

major production operations in the United States,

Canada and Central Europe and an annual raw

steelmaking capability of 31.7 million net tons. USS

is live with Oracle in Canada and planning to roll out

Oracle in several facilities in the US.

Responsible for conducting workshops during "Analyze"

phase in Sourcing, RFQ/Bid, iSupplier, iExpenses,

iProcurement, Payables and other Purchasing

functionalities with Users to identify gaps and

capture business requirements.

Update and report project status to PMO. Prepare and

keep setup/changes documentation up to date.

Discuss RICEW object requirements with site users and

prepare functional design documentation for the

development team. Conduct Unit testing and Integration

testing of the RICEW objects after Build phase.

Responsible for conversion of Suppliers, Expense

Employees, Fixed Assets, Open POs/RFQ/Requisitions,

Sourcing and other Attachment data from legacy.

Solution several business gaps eg. Org level

Attachments, PO Approval customization, Account

generator requirement, Expense Reports, OBIEE

dashboards, Punchouts, iSupplier

Personalization/Extensions, XML Pub Printed PO layout.

Responsible for preparing test cases using HP Quality

center and conduct integration and UAT testing for

Phase 2 Canada OU rollout. Post Go-Live and operations

support.

Applications:

Oracle eBusiness Suite release 12

Specific modules included: Financials, Discrete and

Process Manufacturing, Purchasing, Receiving,

iSupplier, iProcurement, Quality, Advanced Supply

Chain Planning, Order Management, Shipping, WIP,

Engineering, BOM, Inventory.

Tools:

TOAD, XML Publisher, OBIEE

Project Responsibilities:

Functional Design Lead for Purchasing, Sourcing,

iSupplier, iProcurement, Procurement Contracts, XML

Gateway for the implementation. Analyze business

requirements and design RICEW objects. Data validation

from legacy. Setup and configuration of test and PROD

environments.

Method:

Following a global foot print(Canada rollout) and

based on sites requirement configure pilot environment

for conducting Workshops. Identify gaps and propose

simple but effective solutions. Prepare RICEW design

documentation to hand over to Development Team. Work

closely with development teams for unit testing data

conversions and RICE objects. Perform Integration and

User acceptance testing with Quality center scripts

that involved daily business cases.

Assisted Users after Go-Live and supported daily

operations.

Pacific Scientific PacSci is a technology driven company with 40 years

Jan 2010 - June 2010 experience in the motor and drive industry serving

industries ranging from semiconductors, medical,

robotics, fitness, mail handling and other specialty

automation equipment. Pacsci decided to convert their

3 ERPs used in different sectors of their business

into Oracle.

Responsible for identifying gaps and discuss RICEW

requirements with site users and getting them created.

Responsible for converting Suppliers, ASLs, MPNs, Item

categories, Open Pos, Invoices, Sourcing and Quality

data from legacy.

Configure and Setup Purchasing, Order Management,

Quality, Shipping, Advanced Pricing, Receiving modules

for test and PROD environments.

Setup Order Management module to demo RMA Process

using a customized line workflow based on business

requirement. Responsible for designing and developing

Custom RMA line workflow.

Designed and developed a Time and Attendance system

using Oracle Apex to replace their legacy system.

Responsible for preparing Day-in-Life scenarios and

conduct integration and UAT testing with users which

included training and issue resolution. Post Go-Live

and operations support.

Applications:

Oracle eBusiness Suite release 12

Specific modules included: Financials, Discrete and

Flow Manufacturing, Purchasing, Receiving, Quality,

Advanced Supply Chain Planning, Order Management,

Shipping, WIP, Engineering, BOM, Inventory.

Tools:

TOAD, Discoverer, Oracle Apex

Project Responsibilities:

Purchasing, Receiving, Payables Fixed Assets and

Quality lead for the implementation. Design and test

Time and Attendance solution with Users. Data

validation from legacy. Setup and configuration of

test and PROD environments.

Method:

Following a global foot print and based on sites

requirement configure pilot environment for CRP.

Worked closely with development teams for data

conversion and integration testing. Perform

Integration and User acceptance testing with

Day-in-Life scenarios which included handouts,

training and home work assignments.

Assisted Users after Go-Live and supported their daily

operations.

Continuum Health Continuum Health Partners is a nonprofit hospital

Partners system in New York City that comprises five

July 2009 - Jan 2010 historically distinguished hospitals. CHP has about

17000 employees and uses Oracle for SCM, HR, Payroll

and Finance modules to serve their patients and

employees. CHP also uses several 3rd Party systems for

replenishment of their "Just In Time" inventory and

data gets passed through Oracle for sourcing/ordering.

Managed a team of 4 and held PMO meetings to report

issues and progress.

Responsible for resolving user raised tickets in AP,

GL, FA, PO, iProc, iExpenses and EDI issues.

Responsible for integrating and maintaining XML

Gateway Maps for Outbound Purchase Orders and inbound

Invoices.

Created and rolled out several Discoverer reports for

EDI and critical job Monitoring.

Responsible for fixing several bugs in the custom

ordering process as receiving these materials in a

timely manner is very critical for performing health

procedures/surgeries.

Designed and developed "Check Request Intranet portal"

for AP Clerks and integrated it with AP Invoice

Interface using Oracle Apex.

Responsible for co-coordinating weekly EDI supplier

calls to discuss EDI issues, unpaid Invoices and

problem resolutions.

Resolved several bugs in the EDI Invoicing process

like UOM errors, pay site mismatch, PO/Release/line

number errors and others.

Applications:

Oracle eBusiness Suite release 11.5.10 CU2 (and

upgrade to 12)

Modules included Purchasing, Inventory, iProcurement,

Payables, General Ledger and Fixed Assets, eCommerce

Gateway, AME, HR, Payroll, Labor Distribution.

Tools:

TOAD, Discoverer, BI Publisher

Project Responsibilities:

Lead for Purchasing, Receiving, eCommerce Gateway and

iProcurement. Support for Fixed Assets, GL, AP,

iExpenses. Tech lead for the P2P modules and Oracle

Apex. Upgrade testing and issue resolution.

Method:

Used Remedy Helpdesk ticketing system to resolve daily

user issues. Support and monitor SCM critical

concurrent jobs.

Designed a solution for EDI issues. Manage a team of 4

to develop a validation program and conducted detailed

testing of each scenario followed by UAT signoff and

PROD migration.

Danaher Motion Danaher Corporation combined over 30 industry-leading

May 2008 To July 2009 brands such as Kollmorgen, Thomson, Dover, Pacific

Scientific and Portescap to establish a

customer-focused motion control manufacturing company

called Danaher Motion. Onemotion project was started

in 2003 to bring all their partner companies using

different legacy systems onto Oracle Platform.

Responsible for following Danaher's global oracle

footprint and identify gaps and discuss RICEW

requirements with site users and getting them created.

Responsible for converting Suppliers, Open Pos and

Invoices, Sourcing, Quality data from legacy.

Configure and Setup Purchasing, Order Management,

Quality, Shipping, Advanced Pricing, Receiving modules

for test and PROD environments.

Responsible for training Users in Payables,

Purchasing, Asset and Quality modules.

Responsible for preparing Day-in-Life scenarios and

conduct integration and UAT testing with users which

included training and issue resolution. Post Go-Live

and operations support.

Involved in upgrade testing of all Oracle and custom

Danaher functional scenarios. Issue resolution via

metalink patches. Created detailed delta documents and

presentations for site super users in 11.5.10.2

version and conducted training for N.America, Europe

and Asia/Pacific Users.

Applications:

Oracle eBusiness Suite release 11.5.9, Upgrade to

11.5.10 CU2

Specific modules included: Financials, Discrete and

Flow Manufacturing, Purchasing, Receiving, Quality,

Advanced Supply Chain Planning, Order Management,

Shipping, WIP, Engineering, BOM, Inventory.

Tools:

TOAD, Data loader

Project Responsibilities:

Purchasing, Receiving, Assets, Payables and Quality

lead for the implementation. Upgrade testing and issue

resolution. Completed the setup and configuration of

the pilot environment.

Method:

Following a global foot print and based on sites

requirement configure pilot environment for CRP.

Worked closely with development teams for data

conversion and integration testing. Perform

Integration and User acceptance testing with

Day-in-Life scenarios which included handouts,

training and home work assignments.

Assisted Users after Go-Live and supported their daily

operations.

Concur Technologies Concur is the world's leading provider of on-demand

Apr 2008 to Apr 2008 Employee Spend Management services, enabling

organizations to globally control costs by automating

the processes they use to manage employee spending.

Concur managed its client base with Oracle.

Responsible for making the client aware of all the

functionalities of Oracle Advanced Pricing and educate

their new users in Order Management module.

Responsible for providing solution for Order

Management issues.

Applications:

Oracle 11i eBusiness Suite release 11.5.10.2

Tools:

Microsoft Office Suite for training documents.

Project Responsibilities:

Functional Instructor for a short-term class room lead

training assignment in Order Management, Shipping,

Advanced Pricing, Install Base and Inventory.

Method:

Designed a training plan and handouts for the class.

Completed application setup and configuration. Lead a

class of 20 with different Advanced Pricing and Order

Management scenarios. Used a quiz based approach for

better involvement of users. Used Order Management

constraints to provide a solution for the issues.

New York Institute of New York Institute of Technology (NYIT), offers

Technology undergraduate, graduate, and professional degrees in

Mar 2008 to Apr2008 more than 90 fields of study. A non-profit,

independent, private institution of higher education,

NYIT has more than 15,000 students attending campuses

in Long Island and Manhattan, online, and throughout

the world.

Responsible for developing a custom process using

Oracle Workflows to manage recruiting of new

Teaching/Research assistants and Student Interns.

Applications:

Oracle 11i eBusiness Suite release 11.5.10.2

Tools:

TOAD, Oracle Forms, Oracle Reports, Workflow Developer

Project Responsibilities:

Played a Techno-Functional role to gather requirements

and develop a custom process to input data and route

it through different stages of approval.

Method:

Designed client solution, completed application setup

and development. A custom form was put in place to

enter information regarding the new hire, Dept., funds

available, etc. Workflows pass this information to the

approver followed by HR and finally the IT(to make

sure new hire's computer and desk are available). All

approval information gets stored for future audit.

Zions First National Zions First National Bank is a subsidiary of Zions

Bank Bancorporation which operates through over 500 offices

Oct 2007 to Apr 2008 and 600 ATMs in 10 Western states. Zions decided to

add Self Service Modules to streamline and automate

the requisitioning process by adding iProcurement to

their existing stack of PO, Shared HR, GL, FA and AP.

Responsible for preparing the project Timeline and

rollout schedule keeping in mind the project budget

and forthcoming Oracle upgrade from 11.5.9 to 11.5.10

Responsible for developing a custom interface that

brings user's Locations, Job/Position hierarchy and

other information from ADP to Oracle HR on a daily

basis.

Responsible for installation and testing of XML

Gateway modules and perform a cXML transmission proof

of concept.

Satisfied bank's strict Network firewall/security

department by preparing the security risk analysis of

punchouts and XML data transmission over the internet.

Configured Approvals Management Engine to satisfy the

banks complex approval routing structure.

Applications:

Oracle 11i eBusiness Suite release 11.5.9, Upgrade to

11.5.10.2

Specific modules included: General Ledger, Payables,

Assets, Purchasing, Sourcing, iProcurement, HR, Time

and Labor, Projects

Tools:

TOAD, Workflow Developer, XML Gateway Message Desginer

Project Responsibilities:

Lead/Subject Matter Expert/PM for the iProcurement

project. Prepare project timeline and schedule within

project budget. Data conversion from ADP to Oracle HR.

Co-ordinate with suppliers regarding XML PO

transmissions.

Method:

Requirements gather, designed client solution,

completed application setup and configuration in pilot

environment.

Prepared training documentation and conducted training

over conference calls. UAT signoff and initial

iProcurement rollout to 300 admin users followed by

rest of the 2000 users.

Equinux, Inc. Equinix's offers unique ecosystems that foster

Sep 2007 to Oct 2007 interconnection, open or private data exchange and

commerce between networks, online businesses, digital

media companies, enterprises, financial institutions,

and content providers within their neutral centers.

Responsible for configuring Oracle Business Event

system to trigger instant approval process and

implementing custom Payables Approval workflow

solution to include invoice and expense attachments in

the notifications to approver.

Applications:

Oracle 11i (Rel. 11.5.10.2) eBusiness Suite

Tools:

TOAD, Workflow Developer.

Project Responsibilities:

Subject Matter Expert for the Payables, iExpenses,

Purchasing which included development of custom

workflow process for Invoice and Expense attachment

routing to approvers.

Method:

Designed client solution, managed application setup

and testing activities. Wrote custom procedures to

pick up attachment files and route it through

workflow.

Beckman Coulter, Inc. Beckman Coulter, Inc. is a leading manufacturer of

Jan 2007 to Sep 2007 biomedical testing instrument systems, tests and

supplies that simplify and automate laboratory

processes. Beckman uses Oracle for SCM, Finance,

Manufacturing and Payroll.

Responsible for implementing Purchasing, iSupplier,

iProcurement, punchouts, XML Gateway and Procure-Pay

automation.

Designed an automated solution for ordering and

delivery of IT supplies.

Responsible for identifying installation patches and

configuring XML Gateway and Ecommerce Gateway modules

for Proof of Concept. Design and implement supplier

specific cXML and EDI outbound PO and inbound Invoice

formats.

Setup and configure Procurement Contracts for some of

their critical commodities. Tweaked approval workflows

and contract clauses for the same.

Involved in analyzing and designing Order Management

and Shipping data synchronization with FEDEX systems

using TIBCO.

Test iProcurement, Purchasing and Payables modules in

CU2 patch instance.

Applications:

Oracle 11i (Rel. 11.5.10) eBusiness Suite, CU2 Patch.

Specific modules included: Financials, Discrete and

Flow Manufacturing, Configurator, Purchasing,

Receiving, Quality, Contracts, Advanced Supply Chain

Planning, Order Management, Shipping, WIP,

Engineering, BOM, Inventory.

Tools:

TOAD, TIBCO, Workflow Developer, XML Spy, XML Gateway

Message Designer.

Project Responsibilities:

Lead/Subject Matter Expert for the iProcurement

project which included PO to Pay automation..

Co-ordinate with suppliers regarding XML PO

transmissions. Order Management and Shipping sync with

FEDEX systems

Method:

Initially gathered As-Is and To-Be business process

for signoff. Designed client solution, managed

application setup and testing activities. Coordinate

testing schedule of XML documents with suppliers.

Prepared training documentation and rollout schedule

for US orgs followed by global rollout. Post Go-Live

and operations support.

Cablevision Cablevision Corporation is a leading

Corporation telecommunications, media and entertainment company

Oct 2006 to Jan 2007 serving its customers with a variety of advanced

digital television, voice and high-speed Internet

services, publishing and interactive media services.

Responsible for rolling out iProcurement Punchouts,

XML Gateway and iSupplier modules within specified

timeline.

Provided a custom Move Order solution to integrate

with their Clear Orbit handheld systems.

Applications:

Oracle 11i eBusiness Suite release 11.5.9

Specific modules included: Financials, Inventory,

Purchasing, Sourcing, iProcurement, iSupplier, XML

Gateway, Service.

Tools:

TOAD, Oracle Reports, Oracle Forms

Project Responsibilities:

Lead/Subject Matter Expert role for this project which

included PO to Pay automation. Co-ordinate with

suppliers regarding XML PO transmissions.

Method:

Designed client solution, managed application setup

and testing activities. Prepared Proof of concept and

scope for initial signoff. Developed custom XML

transmission formats and prepared testing schedule

with Suppliers.

Performed training and global rollout of iProcurement

and iSupplier modules. Post Go-Live and operations

support.

Acuity Brands, Inc. Acuity Brands is the leading provider of innovative,

Aug 2006 to Oct 2006 technologically advanced, sustainable lighting

products and lighting-related solutions. Acuity had

Oracle Applications suite in use that included

iProcurement, Oracle Purchasing, Inventory, Financials

and Manufacturing modules.

I was responsible for streamlining and simplifying the

10,000 Purchasing Item Categories that were

implemented previously. This confusing list was not

used by Requisitioners and did not serve internal

reporting requirements.

Responsible for enhancing user experience in

iProcurement module with Stores, Catalogs and shopping

list functionality so that it can be rolled out to

additional sites and users.

Applications:

Oracle 11i eBusiness Suite

Tools:

TOAD, Dataloader, AIM

Project Responsibilities:

Design a solution to disable existing categories and

create new categories, develop, and deploy Oracle

Discover reports to client's specifications.

Method:

Analyzed existing categories and prepared a simplified

list. Setup application and demo in pilot environment

for signoff. UAT testing with users and migrate to

PROD. Documented the setup, and usage instructions for

creating new categories.

Used OAF Personalizations, Base Descriptors,

Stores/Catalogs, Realms, Bulk upload functionalities

to enhance iProcurement.

Carlson Companies, Ranked among the largest privately held corporations

Inc. in the United States, Carlson Companies is based in

Aug 2005 to Aug 2006 Minneapolis, Minnesota, USA. Carlson-related brands

and services employ about 171,000 people in more than

145 countries. The Carlson Companies selected Oracle

Applications as a part of Procure to Pay and HRMS

implementation.

As a lead for Inventory, Purchasing, Receiving,

iProcurement, iExpenses and iSupplier, I was

responsible for preparing fit and gap analysis,

setting up the pilot for users and training.

Responsible for converting Item Master, Suppliers,

Sourcing, open Pos data from several legacy systems

like Cross wend, MXD, Crunch time. Work closely with

Users and technical teams to conduct integration

testing and resolving issues.

Followed AIM methodology throughout and kept setup

documentation up to-date.

Applications:

Oracle Release 11.5.10.2

Tools:

TOAD and Oracle Application Implementation Method

(AIM)

Project Responsibilities:

Lead for Purchasing, iProcurement, iSupplier,

iExpenses and Inventory. Design, develop, and deploy

custom reports based on user requirements. Report

issues on a weekly basis to PMO.

Method:

Configure application in pilot environment and testing

activities. Perform Fit Gap Analysis with users.

Analyze Client's business requirements and provided

workarounds. Gather requirements for RICEW

requirements and prepare MD50 and MD70s. Designed

report definitions, created custom report design

documents, and developed and tested reports.

Prepared test scripts for SIT and UAT for each

business scenario and detailed documentation of all

application setups using BR100s. Followed timeline and

schedule for global rollout and delivery. Weekly

status update, report issues and research their

resolutions. Post Go-Live and operations support.

work experience

Senior Principal Consultant Empowered Solutions, 2007 - Present

Inc.

Project Manager / Sr. Principal IT Convergence 2005 - 2007

Consultant / SME

Sr. Principal Consultant Nettlinx, Inc. 2003 - 2005

Senior Consultant/ Business Analyst MA General 2002 - 2003

Application & Tool(s) Release(s)

Oracle E-Business Applications releases 10.5 through 12.0.4;

Database versions 7 through 10g; Oracle Discoverer,

Oracle Forms Builder, Oracle Reports Builder, Oracle

Workflow Builder, XML Gateway Designer, jDeveloper,

OAF, BPEL, Oracle SQL*Plus, APEX and BI Publisher

Microsoft Microsoft Office Suite

Quest TOAD, SQL Navigator

Reporting software Crystal Reports, Access, Hyperion

Others Linux, Apache, MySQL, PHP, Ariba, B2B Application

Design, Catalog Mgmt.

Oracle Functional & Toolset Expertise

Oracle Corporate Business

Performance Management Intelligence

Solution

Oracle Financials General Leger Payables Assets

Internet Expenses

Oracle Supply Chain Procurement Advanced Enterprise Asset

Management Procurement Management

iProcurement iSupplier Sourcing

Material AME Procurement

Requirements Contracts

Planning (MRP)

Inventory Bills of Material Work in Process

Cost Management Quality Engineering

Order Management Shipping Advanced Pricing

Execution

Oracle Technology E-Commerce XML Gateway Workflow/BES

Stack Gateway Oracle Reports

Oracle Forms

Technical Expertise

Languages SQL, PL/SQL, Java/Jsp, PHP, Shell Scripting.

Operating Systems Microsoft Windows 7, Vista, XP, 2000, NT

Unix

Linux (Redhat 3 Certified, Solaris 8 Certified,

Ubuntu, Suse)

Education

Higher Diploma in Software Engineering (HDSE)

Bachelor of Engineering in Electronics &

Communications, St. Josephs College of Engineering

Bachelor of Engineering in Electronics &

Communications, St. Josephs College of Engineering

Bachelor of Engg. (Electronics and Communications, St.

Josephs College of Engg)

Master of Engineering in Electrical Engg. (University

of Hatrford).

Higher Diploma in Software Engg. (Ahana Infotech)

Solaris 8 Certification, (Ahana Infotech)

Redhat ES 3 RHCE certification, (Syscad Technologies)

[pic]

Contact this candidate