Supply Chain Oracle

Professional Summary:

. Enriched experience as a Business Analyst pertaining to Manufacturing and

Supply Chain Domain

. Worked in various manufacturing environment such as Make to Stock, Make

to Order, Engineer to Order and Assemble to Order

. Lead several business process re-engineering sessions involving the core

business team in making critical decisions that provided financial

benefits and operational visibility for continuous process improvement

. Good understanding on Financial Accounting with the ability to interpret

the financial statements

. Lead several projects pertaining to onsite-offshore project team

models for Demand to Build and Order to Cash Processes

. Helped design consignment inventory solutions, VMI (Vendor Managed

Inventory solutions), Internal Sales Order Cycle and Drop ship

solution.

. Designed solutions that helped customer to increase inventory turns

thus reducing the inventory day's outstanding

. Extensive exposure as an Application Specialist in ERP implementation

using Oracle Applications 11i comprising functional areas in Inventory,

Bills of Material, Work in Process, Cost Management, Quality,

Engineering, Purchasing and Order Management.

. Good experience in full life cycle implementation including Business

Process Re-Engineering, Solution Designing/GAP Analysis, Test Plan

Preparation, Unit Testing, CRP, Training Key Users, UAT, Go-Live

preparation and Production Support

. Configuring the application based on solution design, performed gap

analysis and designed workaround solutions.

. Lead the Technical Team during the Conversion and Report Development

Phase

. Documented the Business Processes, Application Set-ups, Customizations

using Oracle AIM Methodology (BP80, BR100, MD50 etc

. Trained several business process leads pertaining to SCM/MFG functions in

Oracle and have prepared several training documents, view-let cam demo',

etc...

Project Experience:

Client : Phones4U, Newcastle-under-Lyme, UK

About Client : Phones 4u is the UK's fastest growing independent

mobile phone retailer. Since opening the doors to customers in 1996 they

have expanded across the UK and Northern Ireland resulting in a network of

more than 450 stores.

Duration : Sep 09' - till date (Currently back in US supporting on

call/email)

Role : Solution Architect Oracle Supply Chain/ Manufacturing

Environment :Oracle Applications 11.5.10 (OM, INV, i-Supplier, PO, WMS,

BOM, WIP,Costing and ASCP), Oracle Store Inventory Management

Responsibilities:

. Completed the CRP and obtained sign-offs on the Solution Design

pertaining to Track 1

. Prepared and Executed the SIT plan for Track 1 Warehouse Move Project

. Designed high level solution to replace JD Edwards/ Store Retail with

Oracle Supply Chain/Oracle Retail Store Inventory Management -- Track

2

. Prepared the project plan for Track 2

. Drafted the CEMLI Plan for allocating work to the resources - Track 2

. Managing a 30 member team (10 Onsite and 20 Off-shore)

. Assisting the business for Track 1 UAT readiness

Client : Masco Contractor Services (MCS), Daytona Beach, FL

About Client : MCS is a group of independent companies, which are

subsidiaries of Masco Corporation. Masco, a Fortune 500 company, is one of

the world's leading manufacturers of home improvement and building products

and a leading provider of services that include insulation and other

building products. They operate in almost all locations in North America

and have about 150 divisions.

Duration : Dec 08' - Aug 09'

Role : PM/ Oracle Analyst - Oracle Supply Chain Deployment

Environment :Oracle Applications 11.5.10 (OM, INV, i-Proc, PO, BOM and

WIP), Custom Module Scheduling and Dispatch (S&D) and Workbrain

Responsibilities:

. Responsible for deploying Oracle successfully in 5 locations in a span

of 7 months

. Handled the overall co-ordination of deployment tasks with the home

office, site expectations, mitigation of risks and status reporting

. Coordinated with the off-site on various deployment related activities

like Warehouse Readiness, Infrastructure Preparation, System Access,

Configuration Issues etc..

. Involved in the various stages of the project that includes Training,

cut-over, go-live and post go-live

. Participated actively during Cut-Over and provided guidance to the

business on various activities that included: Warehouse Readiness,

Closing their existing legacy system, Entering Quotes in Oracle,

Performing Physical Count and Inventory Load

. Focused on dispatching jobs to the trucks that were critical for Day1

and Day 2 of go-live

. Assisted the users in their day to day process related issues

. Provided post-go live support as an Oracle Analyst in identifying the

issues and channeling it to the right person

. Resolved several day to day transactional issues pertaining to

Entering Quotes, Converting Quotes to Orders, Order Booking, Releasing

Credit holds, Order Scheduling, Reservation Issues and Ship Confirm

Issues

. Guided several divisions in performing Inventory Cycle Counts

. Analyzed several inventory transaction related issues prior to closing

Inventory period in Oracle

. Resolved I-procurement issues, Invoicing Issues and Labor Pay Issues

Client : Hyclone Laboratories', Logan, UT

About Client : World leader in serving science, enabling customers to

make the world healthier, cleaner and safer. With annual revenues of $10

billion, they serve over 350,000 customers within pharmaceutical and

biotech companies, hospitals and clinical diagnostic labs, universities,

research institutions and government agencies, as well as environmental and

industrial process control settings

Duration : Mar 07' - Sep 08'

Role : Lead Business Analyst/Application Specialist - O2C, D2B

Environment : Oracle Applications 11i (INV, BOM, WIP, Quality, Cost

Management, Engineering, MRP, OM, PO and Advanced Pricing)

Role: Lead Business Analyst

. Organized multiple BPR sessions involving the key business experts

across the globe pertaining to supply chain and manufacturing function

. Lead several process re-engineering discussions involving about 30

business users on a daily basis that lasted for a month and made

critical business decisions with a focus on establishing standard

business processes across the globe

. Involved in several cross-functional discussions during the solution

design phase

. Developed the future business process flow in less than one month and

obtained major process signoff' across the globe in a span of two

weeks (CRP')

. Continued to play the analyst role during various stages of the

project life cycle supporting and providing clarity to the other

business functions

. Designed consignment inventory solutions for all distributor and also

for vendors ( with long lead times) and also helped customer to reduce

both inventory carrying cost and order fulfillment cost by deploying

Drop ship process

. Designed Supply - Demand Equilibrium solutions to increase inventory

turns.

. Documented the various business benefits such as:

> Improved customer satisfaction by scheduling the order based on

the product availability (Cumulative Total Lead Time) - ATP

> Reduced the Quote to Order processing time significantly by 60%

> Process time reduction in application of price adjustments to a

sales order - Application of automatic modifiers with associated

qualifiers for surcharges, promotions, and discounts

> Reduction in scheduling process time by automatically scheduling

sales order lines

> Automatic email/fax of SO Acknowledgement to the customer thus

eliminating the manual process

> Shipping Process time reduction by using Auto Ship Confirm based

on Schedule Ship Date

> Reduced the delivery lead time by introducing Drop Ship Process

of shipping goods directly from supplier to customer

> Maintaining Routings: Lead-time Visibility, Capacity Planning in

identifying the resource bottlenecks, Product Costing and Shop-

Floor scheduling

> Creating Engineering Prototypes that facilitates the Quote to

Order Process

> Establishing Quality Standards for products and processes

flowing through and across the organization

> Monitoring Quality performances by collecting product

information, tracking product defects, causes and dispositions

through various flow of the product at different stages

> Triggering Quality collection plans at different stages of the

product (Raw Material, WIP and FG) to input the test results and

take actions if necessary based on the entered results

> Maintaining a repository of Quality Results that can be shared

across the enterprise

> Visibility of Product sent outside the manufacturing plant for

service

> Improved shop-floor efficiency by minimizing the transactions

> Redefined the structure of the existing Bills of Material that

resulted in fewer manufacturing errors, fewer customer

complaints and improved product costing

> Provided visibility of the material and resource variances by

maintaining standard product cost for operational analysis

> Standardizing the Part numbers across locations - facilitating

better Planning, Inventory Management and Strategic Sourcing

Role: Application Specialist

. Prepared implementation Documents BR100 for discrete manufacturing and

supply chain modules

. Lead 30 member off-shore team during the development/data loading

phase of the project

. Minimized the changes made to the application using the "Vanilla

Implementation" methodology

. Established a step by step process for configuring the system that

minimized the configuration time significantly by atleast a week

. Lead 7 member on-site team during the Application Configuration Phase

(CRP', UAT and Prod)

. Conducted Conference Room Pilot that lasted for 2 weeks and

demonstrated the system functionality to obtain sign-off on the

established business processes

. Prepared Key-User Training Manuals/ Viewlet Cam Demos for Mfg and

Supply Chain Processes

. Trained the Key-Users with clear focus on providing the right system

knowledge that helped them in understanding the system to train other

users

. Developed test scripts for UAT

. Assisted in several cut-over activities like Inventory Reconciliation

etc

Role: Post Go-Live Support

. Classified the issues into various categories such as: Training,

Configuration and Process Non-Conformance

. Established a process that clearly identified the priorities for the

IT Technicians and this provided clear visibility on the top issues

that required attention

. Closed the top 5 business related supply-chain issues in 7 business

days

. Worked with Oracle in resolving period closure P1 Issues and provided

inputs to the technical team in updating BOM/Routing revisions for the

ECO' that were implemented incorrectly

. Worked closely with the off-shore team in resolving major report

issues

. Resolved the day to day business/system issues such as:

> Additional training to the users and making sure they conform to

the process

> Inventory/WIP/OSP related transactional issues

> Cycle Count Issues like Cycle Count adjustments not getting

processed

> ATP / Order Scheduling issues, Supply/Demand Analysis and Lead

Time issues

> Pricing issues like currency not defaulting when a price list is

being chosen

> Modifiers not getting applied based on specific item category

> Planning issues related to Forecasting, Shrinkage Factor and

Component Yield

> Transactional Trigger related issues pertaining to Quality

> Internal Sales Order/ Drop Ship Process Issues

> Standard Costing Issues (Lot Sizes/ Bills and Routings)

> Documented the "Cost Import from Price List" function for

Intercompany purchases

> Assisting the Business in reviewing the standard oracle reports

for analyzing the Product Cost (Standard Cost Lot Size, Bills,

Routings) and Job Close Variances

> Testing the Customized Reports functionally for sign-off from

the business

> Inventory Period Closure Process/ Intercompany Related Issues

(Identifying and fixing those distributions held up in the Sub-

Ledgers)

Client : American Leather, Dallas, TX

About Client : American Leather is an exclusive producer of leather

upholstered furniture with a complex configuration of products to fulfill

the customer order

Duration : Dec '05 - Jan '07

Role : Sr. Consultant

Environment : Oracle Applications 11i PO, OM, Configurator, Advanced

Pricing, INV, BOM, Quality, WIP and Costing

Responsibilities:

. Captured the Business Requirements and Prepared the AS-IS Process.

. Involved in analyzing the business system complexity and developed

high-level application models

. Prepared implementation Documents (RD20 & BR100)

. Lead the offshore team during the Development phase of the project and

assisted the technical team during the data conversion phase for

Inventory and BOM from the functional stand point

. Involved in performing set-ups of Inventory Organizations, Sub

inventories, Item Sub inventory relation ships etc. for the Inventory

Module

. Assisted in the Data Load Process for setting up Collection

Elements/Specifications, Parent-Child Relationships and several

transactional trigger pertaining to Oracle Quality

. Assisted in performing the setups for Departments, Resources, Standard

Operations, and Routings in BOM module

. Performed various OM set-ups like OM System Parameters, Price Lists,

Modifiers, Qualifiers, and Shipping Parameters

. Worked on Drop Shipments, Backorder, Delivery Lines, Pick Release,

Pick Confirm

. Created shipment Monitors which shows the orders Stuck in Receivables

interface .

. Created Multi Level, Multi Currency based price lists and established

and enforced limits on promotional discounts

. Defined freight and special charges modifiers, defined formula' to

calculate cost to charge Markup

. Created various configuration rules, generated user interfaces and

published the models

. Developed test scripts, Integration testing, and UAT

. Involved in preparing job aids and training manuals such as

navigational paths and other useful information on application and

business process flows

. Solved day-to-day transaction issues (Assembly Pull and Push Supply

Types) on WIP Standard Jobs

. Solved day-to-day costing issues and maintained the standard cost of

items

. Created new shipping networks (on need basis)

. Resolved various issues pertaining to Order Management

. Trained the logistics team in creating Purchase Requisition and Auto-

Creating Purchase Orders

. Trained the team on how to use Oracle drop shipment process, ASN from

a supplier

Client : Hugh Symons, UK

About Client : HSCS sell assembled computers. Customer has the freedom

of choosing the configuration of the computer they desire to buy

Duration : Nov '04 - Nov '05

Role : Sr. Consultant

Environment : Oracle Applications 11i PO, OM, Custom Configurator, Advanced

Pricing, INV, BOM, Quality, WIP and Costing

Responsibilities:

. Captured the Business Requirements and Prepared the AS-IS Process.

. Involved in performing set-ups of Inventory Organizations, Sub

inventories, Item Sub inventory relation ships etc. for the Inventory

Module

. Assisted in performing the setups for Departments, Resources, Standard

Operations, and Routings in BOM module

. Performed the entire WIP/ Costing setup like WIP Parameters, Cost

Types, WIP Accounting Classes etc...

. Performed the entire OM / Pricing / Shipping setups

. Developed design documents (MD50) for a custom configurator module for

capturing configuration rules, valid configurations

. Delivered a custom configurator product that integrated with Oracle

Advanced Pricing

. Defined freight and special charges modifiers, defined formula' to

calculate cost to charge Markup

. Developed test scripts, Integration testing, and UAT

. Involved in preparing job aids and training manuals such as

navigational paths and other useful information on application and

business process flows

. Solved day-to-day transaction issues

. Solved day-to-day costing issues and maintained the standard cost of

items

Client : Diodes Incorporated, CA

About Client : Diodes Incorporated is a leading global manufacturer and

supplier of high-quality, application-specific standard products within the

broad discrete and analog semiconductor markets, serving the consumer

electronics, computing, communications, industrial and automotive markets

Duration : Mar '04 - Aug '04

Role : Sr. Consultant

Environment : Oracle Applications 11i ( OM, Advanced Pricing, INV, BOM,

WIP, Costing)

Responsibilities:

. Prepared implementation documents for the setups BR100'

. Configured the system for CRP', UAT and Prod

. Involved in following Configuration/ Setups of the PROD Instance:

> Multi-Organization Setup and performed various OM set-ups like

OM System Parameters, Price Lists, Modifiers, Qualifiers, and

Shipping Parameters

> Inventory Organizations, Sub inventories, Item Sub inventory

relationships, Shipping Networks, ATP Rules, Inventory related

KFF' (Stock Locators etc Item Templates, Attribute Control,

Picking Rules (Based on Lot Expiration) etc...

> BOM Parameters, Departments, Resources, Standard Operations,

Alternates and Routings in BOM module.

> WIP Parameters, Accounting Classes pertaining to WIP Module

> Cost Types, Overheads etc... pertaining to Cost Management

Engineering Types, Approval List etc... pertaining to

Engineering

> Sourcing Rules/ ASL pertaining to Purchasing

Client : UTPA, TX

About Client : The University of Texas-Pan American (UTPA) serves the

higher education needs of a rapidly growing, international, multicultural

population in the South Texas Region. The University preserves, transmits

and creates knowledge to serve the cultural, civic, and economic

advancement of the region and the state

Duration : Sep '03 - Feb '04

Role : Functional Consultant

Environment : Oracle Applications 11i, PO and TR

Responsibilities:

. Involved in gathering the Business Requirements by constantly

interacting with the SME'

. Studied the AS-IS process, identified the gap between their existing

systems and suggested changes wherever necessary to meet business

demands

. Assisted in preparing functional design documents

. Mapped the Business Needs of the client to identify the areas that

required customization and the set-ups for implementing Oracle

Purchasing

. Communicated the functional processes with the technical team

. Carried out several conference room pilot (CRP) with implementation

team members and end users

. Created a custom responsibility called Travel Requisition that enabled

users to access certain functionalities offered by Purchasing. This

streamlined the traditional travel process by reducing the process

time considerably

. Involved in setting up the Approval Process Hierarchy, UOM and

Creation of Purchase Requisitions, Auto-creation of PO's and RFQ's for

Purchasing

. Documented Training Manuals for the end-users as per the client needs

. Trained a group of end-users "Train the Trainers"

Client : Tata BP Solar, Bangalore

About Client : Tata BP Solar has a fully integrated Solar Manufacturing

Plant, including Cell Manufacture, Module Assembly and Balance of Systems

(BOS), all at one site.

Duration : Sep '02 - Jun '03

Role : Technical Consultant

Environment : Oracle Applications 11i, INV, BOM, OM, Purchasing, Reports

6i

Responsibilities:

. Created PL/SQL packages to validate and load data through sql loader

using shell script into the shipping interface API

. Customizations of Oracle Standard Reports related to Oracle

Receivables, Order Management, Oracle Shipping, and Oracle Purchasing

. Responsible for Data Loading of - Item Master, BOM, Item Category and

Customer

. Developed and interfaced Transaction Interface Form - It is useful to

do the bulk transactions at a time and later bar coding can be

incorporated. Transactions like moving material from one inventory to

another inventory, one organization to another, the Shop Floor

transactions and Warehouse Transactions and so on can be done through

this Interface.

. Involved in developing Manufacturing Variance Analysis System

. Worked on interfaces like Ship Confirm and Pick Release

. Perform Testing & prepare relevant documentation

Education:

. Master of Science in Industrial and Manufacturing Systems, University

of Texas, 2005

. Trained in Oracle Forms and Reports, Computech, India, 2002

. Diploma in Computer and Business Application, SSI, India, 2002

. Bachelor of Engineering in Mechanical and Manufacturing Systems,

India 2002

Contact this candidate