Management Oracle

CHAKRADHAR PILLALA

973-***-**** *******************@*****.***

Summary

V 7 plus years experience in production planning, materials management,

procurement, IT, Systems Integration and Project Management with

Oracle 11i functional experience implementing ERP Systems covering

entire implementation life cycle of the project - analysis, design,

configuration, development, post implementation and support.

V Good understanding of the Oracle Version 12 E-Business suite and sound

knowledge of version upgrade projects. Completed the internal training

for Version 12.

V 11i Applications modules included Inventory, BOM, MRP / ASCP, WIP,

Purchasing, Order Management, Pricing, Shipping Execution, MSCA,

Engineering, and Costing.

V Experience with all phases of testing life cycle like Unit Testing,

Integration Testing, System Testing, and User Acceptance Testing.

V Excellent understanding of Software Development Life Cycle and Testing

Methodologies from project definition to post-deployment

documentation.

V Excellent functional experience and understanding of the Production

and Supply Chain Management areas.

V Strong implementation experience in the Manufacturing modules.

Summary of Experience:

Dialogic Oracle Senior Techno-Functional Supply Chain

Analyst

Working as the primary contact for supporting

and implementing the INV, OM, PO, BOM, WIP,

MRP, OKS & Install Base modules.

Enrich IT Project Lead

GE T&D, Worked as implementation lead in the INV, OM,

Somersworth, NH and ASCP/MRP modules.

GE Wind, Worked as implementation lead in the INV, OM,

Schenectady, NY PO and Spares Management modules.

GE Solar Worked on the proposed solution design for the

Energy, Solar RFP

Schenectady, NY

Cummins, UK Worked as a trainer in the Advanced Pricing

module.

GE Wind, Worked as Subject Matter Expert in the INV, OM,

Schenectady, NY ASCP and PO modules.

Core Labs & Worked as senior consultant in defining INV,

PetroServices BOM and WIP modules.

Hosuton, TX

GE Wind, Worked as project lead to implement the Order

Schenectady, NY Management, Advanced Supply Chain Planning,

Shipping Execution and MSCA modules.

Hitachi Consulting Senior Consultant II

Aspen Worked as Subject Matter Expert for Inventory,

Technologies, Bills of Material and Advanced Pricing modules.

Cambridge, MA

AM Castle, Worked as functional consultant to implement

Franklin Park, IL Order Management, Shipping Execution and

Advanced Pricing modules.

Teradyne, Assisted client in developing test scripts for

North Reading, MA the OM, Advanced Pricing and Inventory modules.

RJT CompuQuest Principal Consultant

Cymer Inc Supported the client in all the 11.5.8

San Diego, CA manufacturing and distribution modules.

GE Security Worked on several projects ranging from

Hickory, NC support, upgrade and implementation of 11.5.10

manufacturing and distribution modules.

Danka, Worked on 11.5.9 implementation of

Charlotte, NC Manufacturing modules

Technical Skills

ERP Oracle Version 12 Manufacturing and Supply Chain

modules, Oracle 11i ERP Applications: Inventory, BOM,

MRP, Order Management, AR, WIP, Shipping Execution,

Pricing, Purchasing, iProcurement, AP, WMS and

Costing modules. Oracle APS Suite: Advanced Supply

Chain Planning.

Languages PL/SQL, SQL*Plus

Tools Forms 6i, Reports 6i, SQL*Loader, TOAD, Discoverer

4i, Oracle BI Publisher, MS Project, MS Visio, MS

Office

RDBMS Oracle 8i, Oracle 9i

Operating SUN OS2.6, UNIX, Windows 95/NT/2000/XP

Systems

Academics

V M.S. in Industrial Engineering, West Virginia University, US.

V B.E. in Mechanical Engineering, Osmania University, India.

V Certified in Production and Inventory Management (CPIM) From American

Production and Inventory Control Society (APICS).

V Certified Supply Chain Professional (CSCP) From American Production

and Inventory Control Society (APICS).

Membership

V Member of the American Production and Inventory Control Society

(APICS) Northern New Jersey Chapter.

V Member of the Association for the Advancement of Cost Engineering

(AACE).

Work Experience

. Senior Oracle Techno-Functional Business Analyst, Dialogic,

Parsippany, NJ

Sep '10 - Till Date

Dialogic Inc. is one of the strongest players in the VOIP market with

manufacturing and distribution facilities in North America, Europe and

Israel.

V Leading the Operations modules implementation for another legacy

business to come on to the existing Oracle instance.

V Gathering requirements from the users and designing the solutions to

meet the requirements.

V Setting up the INV, OM, PO, BOM, WIP and MRP modules as per the

requirements.

V Supporting the existing Oracle 11.5.10.2 instance for the INV, OM,

BOM, WIP, MRP, PO, AR, Service Contracts and Install Base modules.

V Interact with users on a daily basis, understand their issues logged

in via a ticketing system and resolve them timely.

V Modify the existing reports and/or develop new ones as per the

requirements.

V Prepare student guides with standard operating procedures for the user

group to follow.

V Involved with period end and year end activities on an on-going basis.

V Involved in identifying and resolving the physical counting issues.

. Tools Used: Oracle 11i MRP, Inventory, Order Management, Shipping,

Purchasing, BOM, WIP, Accounts Receivables, Service Contracts, Install

Base, Toad, SQLPlus and AIM documentation.

. Functional SME, GE T&D, Somersworth, NH

Mar '10 - Sep '10

GE Transmission and Distribution, a division of the GE Energy

Renewables is one of the largest manufacturers and service providers

in the power distribution industry.

V Supporting the implementation now across the US pole.

V Leading the team in designing the planning solution for the Meters and

Transformers product lines. Working closely with the business to

understand the legacy system and capture the requirements to design in

Oracle.

V Setting up the inventory module to store the parts data, perform cycle

counts and order management modules to process the order fulfillment

requests.

V Coordinating with the Configuration team to integrate with the order

entry system depending upon the customer requirements.

V Setting up the BOM and WIP modules for all the work orders generated

from the customer orders.

V Coordinating with the Purchasing team to create internal requisitions

and drop ship purchase orders.

V Working closely with the warehousing team to implement MSCA for

receiving, picking and shipping functions.

V Preparing end user training documents and was involved in training the

super users.

. Tools Used: Oracle 11i ASCP/MRP, Inventory, Order Management,

Shipping, Purchasing, Toad, SQLPlus and AIM documentation.

. Implementation Lead, GE Wind Energy, Schenectady, NY

Dec '09 - Mar '10

GE Wind Energy, a division of the GE Energy Renewables is the largest

manufacturer and service provider for the Wind Turbines with

operations in US, Canada and Europe.

V Supporting the implementation now across the US, CA and European

poles.

V Led the team that implemented Oracle Field Services with the main

focus on the integrations between Oracle Field Services, Spares

Management and the existing ERP modules like Inventory, Purchasing and

Order Management and Pricing.

V Set up the inventory and order management modules to integrate with

the data coming from Spares and Field Services as per the business

requirements gathered.

V Designed and set up the Spares Management module to create an Internal

Requisition every time there is a material requirement on the Service

Requests in the Field Services.

V Worked closely with the mobile field services implementation for

multiple GE wind parks as part of the go-live.

V Worked with the wind park technicians and helped them to access mobile

field services from the Motorola MC75 handheld devices.

V Prepared end user training documents and was involved in training the

super users.

Tools Used: Oracle 11i Inventory, Order Management, Shipping, Purchasing,

Field Services, Spares Management, Toad, SQLPlus and AIM documentation.

. Functional SME, GE Solar Energy, Schenectady, NY

Dec '09 - Dec '09

V Was involved in weeklong preparation of an Oracle ERP solution to a

RFP floated by GE Solar Energy for their business process.

V Led a team of 5 people to develop a Visio flow chart highlighting the

Oracle modules that match the business processes depicted in the RFP.

V Will be presenting the proposed solution to the GE Solar team on the

5th of Feb.

Tools Used: Oracle 11i Inventory, Order Management, Shipping, Project

Manufacturing, MS Visio and MS PowerPoint.

. Advanced Pricing Trainer, Cummins, UK

Nov '09 - Nov '09

V Was involved in weeklong hands on training with the end users in

Cummins, UK during the UK morning hours.

V Trained them on the basics in Advanced Pricing, creating Price Lists,

Qualifiers, Modifiers, Manual discounts, Attributes, Attribute

Mapping, etc.

V Created sales orders in Order Management to see how the pricing

entities setup affected the price on the orders.

V Created Freight modifiers and showed the user group how they get

applied on the sales orders at the time of shipping.

V Prepared training guide for the users to follow during the training

sessions.

Tools Used: Oracle 11i Inventory, Order Management, Shipping, Advanced

Pricing, Toad and SQLPlus.

. Functional SME, GE Wind Energy, Schenectady, NY

Dec '08 - Nov '09

GE Wind Energy, a division of the GE Energy Renewables is the largest

manufacturer and service provider for the Wind Turbines with

operations in US, Canada and Europe.

V Phase 1 for this assignment involves the Legal Entity change as

mandated by the GE legal and tax requirements to realize potential tax

benefits.

V Created a new DFF at the organization parameters level to bypass the

standard valuation accounts

V Issuing out all the on-hand inventory using API's, changing the

accounting and bringing the material back in using API's.

V Modifying the PO and Requisition account generator workflow to pull

the charge, accrual and variance accounts on the PO from the newly

created DFF instead of off the standard valuation accounts.

V Updating all the accounting to handle the new LE in the receiving,

purchasing, shipping networks, cycle counting, suppliers, payables

setups.

V Modifying the accounting on the requisitions created via requisition

import program from ASCP by deploying a DB trigger.

V Phase 2 for this assignment involves defining intercompany relations

among all the existing operating units (Germany, Spain, US and CA) two

ways (both buy and sell).

V Gathered the business requirements and the CTQ's for this project

after brainstorming sessions with the business.

V Created a new operating unit, which will process sales orders for two

customer facing Legal Entities, that do not hold any inventory. (Drop

shipping from another legal entity that carries inventory)

V Defined the intercompany flows between all the OU's for drop shipping

and physical shipping scenarios.

V Created the internal customers as required to start the intercompany

transactions with the creation of an Internal Requisition and Internal

Sales Order.

V Set up the intercompany price lists, order types, modifiers and built

a custom program to maintain the price lists.

V Set up the customers, customer sites, transaction types, tax codes,

autoinvoice and autoaccounting rules in AR to generate the

intercompany AR invoices.

V Set up the suppliers, supplier sites, payment terms and tax codes to

generate the intercompany AP invoices.

V Customized the AR autoinvoice interface and AP expense report

interface to create the invoice with the correct customer/supplier in

the case of one OU sharing two customer facing legal entities to

create sales orders.

V Integrated the Oracle system to IBS (Internal Billing System) for

automatic settlement of the Intercompany Due From and Due To invoices.

Involved in building 5 interfaces (3 outbound and 2 inbound) between

IBS and Oracle.

V Setting up the ASCP instance to create internal requisitions for

replenishing the Canadian warehouse from US warehouse.

V Involved with the user training and prepared the test scripts for

major testing milestones.

V Participated in testing the intercompany design from end to end.

Prepared the training manuals for the end users to assist in

performing intercompany transactions.

Tools Used: Oracle 11i Inventory, Order Management, Shipping Execution,

ASCP, Pricing, Purchasing, Accounts Payables, Accounts Receivables, Toad,

SQLPlus and AIM documentation.

. Senior Consultant, Core Labs, Houston, TX

Sep '08 - Dec '08

Core Laboratories is a leading provider of proprietary and

patented reservoir description, production enhancement and reservoir

management services. They are implementing Oracle 11.5.10.2

manufacturing modules for one of their divisions.

V Worked as senior consultant for implementing the INV, BOM and WIP

modules in a discrete manufacturing environment.

V Designed the Inventory organization as per the requirements gathered.

V Involved in setting up the BOM and WIP modules as per the

requirements.

V Completed the OSP setup for WIP and Purchasing in a job-based

hierarchy.

V In charge of loading the items, bills, prices and routings for this

new organization.

V Set up freight carriers, order types and pick release rules. Created a

couple of custom defaulting rules as per the business requirements.

V Set up the RMA workflow for both the Credit and Repair / Replace

scenarios.

V Performed the end-to-end testing for the manufacturing and

distribution modules. And preparing the training manuals for the end

users.

Tools Used: Oracle 11i Inventory, BOM, WIP, OM, Shipping, AR, Purchasing,

Toad, sqlldr, SQLPlus and AIM documentation.

. Project Lead, GE Wind Energy, Schenectady, NY

Aug '07 - Sep '08

GE Wind Energy, a division of the GE Energy Renewables is the largest

manufacturer and service provider for the Wind Turbines with

operations in US, Canada and Europe. They are implementing Oracle

11.5.10.2 for their spare parts and sales business, and are

integrating the already implemented Field Service module.

V Worked as Project Lead for implementing the Order Management, ASCP,

Pricing, Shipping, and MSCA modules for GE Wind Americas in the

Discrete Manufacturing environment. Went live in May '08. Currently

supporting the implementation.

V Implemented the MSCA handheld enabled label printing procedure for

receiving and picking business processes.

V Involved in the requirements gathering, business process designs and

conference room pilot discussions. Worked on the fit-gap analysis.

V Created the Legal Entities and the multi-org operating structure

depending upon the business needs.

V Worked with the technical team to develop the custom interface for

integrating the Oracle Field Sales (CRM) application and the Order

Management implementation.

V Involved in the items, customers and price list conversions.

V Worked on the entire business requirement, technical design documents

as per AIM specifications.

V Worked on the Consigned Inventory setup.

V Involved with the user training and prepared the test scripts for

major testing milestones.

V Prepared the training manuals for the end users

V Supported the business users and resolved issues pertaining to all the

SCM and Distribution modules.

Tools Used: Oracle 11i Inventory, Order Management, Shipping Execution,

Pricing, MSCA, Accounts Receivables, Oracle APS ASCP, Toad, sqlldr,

SQLPlus, Oracle BI Publisher and AIM documentation (BR100, MD, TE, etc.).

. Senior Consultant, Hitachi Consulting, Edison, NJ

Mar '07 - Aug '07

Hitachi Consulting is an Oracle certified partner and a consulting

company, which offers implementation, and support services to the

clients. Was involved in the Oracle practice working on the

Manufacturing, Distribution, Procurement and Supply Chain modules.

V Worked with Order Management, Pricing modules and assisted in

developing the test scripts for a client, which is in the semi-

conductors manufacturing business during the CRP2 phase.

V Worked with the implementation team on the Order Management and

Shipping Execution modules for a metals company. Was involved in the

requirements gathering sessions and developing the As-Is and the To-Be

process flows.

V Worked on the Advanced Pricing implementation for a software solutions

provider company with a highly complex pricing and item structures.

This pricing solution involved capturing the pricing attributes in the

Configurator as there were a lot of different variables per item.

V Was involved with Demantra software, a product used for Demand

Planning, in a week long training. Worked on developing test models in

Demantra and prepared end user training documentation.

Tools Used: Oracle 11i Inventory, Order Management, Acoounts Receivables,

Shipping Execution, Advanced Pricing, Configurator, Demantra, SQLPlus,

Toad and AIM documentation (BR100, MD, TE, etc.).

. Oracle Functional Consultant, Cymer Inc, San Diego, CA

Jan '07 - Feb '07

Cymer Inc is the world's leading supplier of light sources for

semiconductor industry. Was involved with providing support for the

11.5.8 version of Manufacturing and Distribution Oracle applications.

V Worked as the contact point for supporting the Production instances

for the OM, Pricing, Inventory and Shipping Execution modules in the

Discrete Manufacturing environment.

V Developed and tested Logical Apps rules to restrict the user access to

certain Inventory module forms as demanded by the business.

V Was part of the upgrade team working on upgrading the 11.5.8 version

to 11.5.10.

V Prepared the end user training documentation for the OM module.

Tools Used: Oracle 11i Inventory, Order Management, Shipping Execution,

Advanced Pricing, Logical Apps, Toad and AIM documentation (BR100, MD,

TE, etc.).

. Oracle Functional Consultant, GE Security, Hickory, NC.

Feb '05 - Jan '07

GE Security is the world's biggest manufacturer of security devices,

which are categorized into Commercial, Enterprise, Residential and

Homeland security. Was involved in Database upgrade, Application

upgrade Testing and Ongoing Production support of 11.5.9 version of

Oracle Applications as part of the project.

V WMS:

o Led the Oracle WMS implementation effort, worked on the proof of

concept and feasibility.

o This project involves consolidating the 5 inventory

organizations that ship today a net volume of around $5 billion

into 2 Distribution Centers, which will be WMS organizations.

o Gathered the requirements and demonstrated the out-of-the-box

Oracle setups for a WMS Org to the business, including, but not

limited to LPN, Put Away, Pick Confirm, Ship Confirm and barcode

label printing using the MSCA scanners.

V Picking Process:

o Worked on getting the Pick confirmation transactions to be done

via the MSCA handheld scanners.

o Introduced the barcode fields on to the custom Pick Slip report

to facilitate the usage of the MSCA handheld scanners by

scanning the delivery number off of the pick slip and pick the

product.

o The major benefit with this was the reduction in picking errors.

The number of errors came down from around 15 errors on average

per day to 7 per day, thus resulting in increased inventory

control and picking efficiency.

o Rolled this MSCA implementation out to 3 GE Security

distribution centers in the US pole.

V Inventory Item Reservations:

o Implemented the inventory item reservations in a multi-org

environment during the pick release process for Orders in Oracle

11i.

o Rolled this project over to multiple business locations.

o This project's major benefit was that the picking process

improved drastically by reducing the items that get picked even

though there is no stock to be allocated. This resulted in a lot

less paper and improved the efficiency in the warehouses

tremendously.

o Worked with the 3rd party bolt-on's (Clippership) which

communicate with Oracle for shipping purposes.

V PO workflow customization:

o Customized the standard PO approval workflow for all the OU's by

capturing the business requirements, which involved bypassing

the double approvals involved.

o This process reduced the number of steps and times a PO needed

to be approved, thus cutting the cycle time involved by 25%.

V Inventory migration:

o Successfully migrated all the inventory items and on-hand

quantities from a manufacturing inventory organization to a

distribution center within the same OU.

o The net worth involved in this operation was around $10 million.

o Developed the Item Upload tool used to mass load new items

and/or updates to the existing items using the Item Import.

o Reconciled the dollars after the inventory move was complete via

certain valuation reports.

V Auto-Replenishment setup:

o Set the auto replenishment up for the purchased raw material

parts to be replenished by the supplier based on the min max

levels in the inventory.

o Set up the ASL and a blanket purchase order to receive the

product in.

o Created a custom request set, which ran the min-max process,

requisition import and showed the open shipments.

o This completely upstaged the manual process involved with

replenishment till then and automated the entire process for the

buyers. Also, developed a report on the same lines as the

Requisition import exceptions report to show the items that

failed the Requisition import process.

V Internal Order setup:

o Set the Internal Orders process between the Distribution center

and the various manufacturing sites based on the min max levels

of the inventory in the DC.

o The min max run for the DC was setup to run based on the planner

codes, which would take care of all the items in that planner

code and create an internal requisition with the respective

manufacturing plant.

o This process obviated the placing of sales orders with the

plants; instead, this setup would do that automatically based on

the DC inventory levels.

V Worked on several reports and enhancements from the functional

perspective involving requirements gathering, user testing & training

and seeing them migrate through to the Production environment.

V Support for the SCM modules:

o Worked as a business analyst in the SCM area of the RTS group,

which was involved in the production support for all of GE

Security.

o In charge of the planning area, involved in running the MRP's

for all the organizations in the multi-org environment.

o Implemented the Planning Calendar format change from 4/4/5 to

5/4/4 format.

o Worked with the custom developed Forecast Upload tool to load

forecasts using the Open Forecast Interface to mass load the

weekly or monthly forecasts.

o Involved in the Physical Inventory for the years 2005 and 2006

to assist the business in printing the physical inventory tags

and record the counts.

o Involved in one of the most successful Hardware moves, moved the

Oracle applications server from Ft. Wayne, IN to Cincinnati, OH.

o Performed the post cloning operations from the functional

perspective after the instance was copied from Production.

o Involved in the monthly integration cycle testing.

o Involved in setting up the Organizations for cost rollups,

worked during the month end closing and quarter closing

extensively.

o Involved with loading the item costs and doing the standard cost

updates. Also worked to renew the costs at the end of the year

via custom sql scripts.

o Worked on the uploading of data into the Oracle database from

excel templates using the DataLoad tool.

o Worked on the Consigned Inventory implementation.

Tools Used: Oracle 11i Inventory, BOM, Purchasing, Engineering, Order

Management, Shipping Execution, MSCA, Advanced Pricing, MRP,

Configurator, Costing for Discrete Manufacturing, Accounts

Receivables, Accounts Payables, iProcurement modules, Clippership,

SQLPlus, sqlldr, Toad and AIM documentation (BR100, MD, TE, etc.).

. Oracle Functional Associate Consultant

Oct '04 - Feb '05

V Implementing Operations modules:

o Responsible for the implementation of the Inventory, BOM and WIP

modules.

o Studied the company's business process and conducted the fit -

gap analysis with respect to the Oracle 11i modules.

o Setting up the required flexfields according to the business

requirements.

o Validated the set ups and conducted the Conference Room Pilot's

with the client.

o Coordinated with Oracle support to resolve application issues.

o Educated the user on the application.

o The deliverable here was to get Danka on Oracle 11i and train

the user community.

Tools Used: Oracle 11i Inventory, BOM, WIP modules in Discrete

Manufacturing and AIM documentation.

Contact this candidate