Oracle Project

Sudhesh Srivastava, CPIM, PMP

**** ******* **. *** *****, MI-48103

Phone: 734-***-****

E-mail: *******.**********@*****.***

Career Summary

. An experienced Information Systems professional with a solid

background in business and management. Extensive software development

experience.

. Oracle Demantra - implementation of Demand Management/Sales and

Operations Planning system.

. Oracle Applications 11i (11.5.10) - full cycle implementation in multi

currency and multi country. Lead of data conversion and design,

development of RICE elements.

. ASP.NET Web Application development using C# and SQL server as

database.

. Possess excellent project management, organizational, interpersonal,

and communications skills.

Skills Summary

. Project Management - Managed oracle implementation at France

manufacturing facility. PM Team meetings, Negotiated resource

availability. Prepared cut-over plan for go-live.

. Business Analyst - Mapping business process to user requirements.

Preparing presentation for customized solutions. Preparation and

participation of test plan/ system testing.

. Software development. Oracle 11i - RICE elements Oracle development

environment/tools - Oracle 9i, PL/SQL, TOAD, PVCS, Oracle Reports,

Oracle Discoverer, Oracle Workflow, System/User Administration, EDI

implementation (Oracle's e-Commerce Gateway, Sterling's GIS).

. Demantra implementation - Configuration of data model, hierarchies,

workflow and Integration interfaces.

. Software development. ASP.NET using C# code behind and SQL server as

database. Design development of Collaborative-Commerce web application

using C#, SQL Server, SourceSafe and XML web services.

Project lead and supervisory- Project Management - planning,

execution, monitoring and control - work with On-site as well as off-

site teams, to achieve on-time delivery of assigned tasks.

. Enterprise business processes. My experience concentrates around MPS,

MRP, Shop floor, Purchasing/Receiving, Inventory control, Oracle

engineering and Customer order processing, however I have touched all

aspects of supply chain management.

Education

. 1990, Cambridge University, Cambridge, England, Diploma in Computer

Science. (Post Graduate course)

. 1986, G.B. Pant University, Pantnagar (Nainital)-India, Master of

Science (Physics)

. 1983, Kumaon University, Nainital- India, Bachelor of Science

(Mathematics, Physics, Chemistry)

Professional Education, Training and Certifications

. CPIM - Certified in Production and Inventory Management from APICS.

. PMP - Project Management Professional from PMI

. Oracle 11i Manufacturing Functional foundation course from Oracle

education.

. Oracle 11i Oracle Engineering from Oracle education.

. Oracle 9i Database Management I from Oracle education.

. Oracle Advanced SQL programming from Oracle education.

Professional Background

Tecumseh Products Company, Ann Arbor - MI (August 2004 - Present)

Manager, Global Project Management (August 2008 - Present)

Analyst - Global Enterprise System (August 2004 - July 2008)

Oracle Demantra 7.3 (Demand ManagementSystem) Implementation

. Workshop on business requirement. Managed business expectations of

Executives and SOP Managers.

. Negotiated resources from various business functions.

. Configuration of Business model, hierarchy, workflow and integration

interfaces.

. Managed customization (development of Custom Hooks to supplement

standard data collection process).

. Coordinated knowledge transfer and training of support personals.

. Environment - Oracle EBS, APS (ASCP) and Demantra (Demand Management

System).

Oracle rollout Project at France Business operations

. Managed year long project of rolling out Global Reference Model (GRM)

to France business operations.

. Project Budget preparation

. Project team meeting to track and resolve project issues and reporting

to steering committee.

. Guidance to local team leads on managing critical paths and problem

solving.

. SOX related documentation and controls.

Shop-Floor (Barcode) System

. Presented new system design/solution, proposing replacement of legacy

shopfloor system. Implementation of this system saved $250K in

maintaining legacy system.

. Designed and developed an enterprise system for shop floor - Bar-

coding, Packing and Production reporting activities.

. Managed rollout of this application to other business location (India

operations).

. Environment - ASP.NET, SQL Server 2005, Loftware Client interfacing to

Oracle Apps.

Ongoing Operational Support

. Global Technical lead for - Data migration and Interfaces.

. Manage SR (Service Request) System for after go-live issues and

development of RICE elements.

. Analysis, Documentation of business requirements, Develop reports.

. SOX Compliance - IT Development/Data Conversion.

. Environment - Oracle 11i, PL/SQL, TOAD, Oracle Reports, XML Publisher.

Oracle e-Commerce Gateway implementation

. Managed implementation of Sterling Commerce's BaseEDI Package along

with Oracle eCommerce Gateway.

. Supervised documentation and setup of e-Commerce Gateway, Oracle AR.

. Trained and mentored (EDI Administrator) to support future EDI

operations.

. Worked with on-site consultant and off-site team at Hyderabad India,

which was involved mapping and testing of EDI transactions with the

Trading Partners.

. Environment: Oracle e-Commerce Gateway, Oracle AR, Oracle Order

Management, Gentran Integration Suite from Sterling Commerce, Sterling

VAN.

Implementation of Oracle 11i and after go-live support

. Technology Team Lead - Data Conversion, RICE.

. Implementation of Oracle Application 11i globally, as a single

instance for Tecumseh Products Company with Deloitte as consulting

partners.

. Planning - Put together a plan and guidelines for data-conversion

process.

. Conversions were done in Inventory, BOM, Routings including Flow,

Purchasing, Order Management, Accounts Receivables, Advanced pricing,

General Ledger, Human Resources.

. Execution - Managed a Technology Team of 4 off-site (Other locations

of company) developers to document and develop data Extraction from

Legacy System.

. Execution - Managed a team of on-site (10-12) developers to accomplish

data conversion.

. Monitor and Control -Coordinated of the effort with the site Project

Lead to achieve the goals of cutover plan and successfully switch over

to Oracle (go-live).

. Environment - Oracle 11i, PL/SQL, TOAD, Oracle Reports, XML Publisher.

Computer Discoveries Inc. Chicago IL March 997 to July 2004

Consultant

June 2003 - July 2004

Client: Tecumseh Products Company, Tecumseh - MI

New product line (Packaged Refrigeration Solution)

. This project involved making changes and developing new functions to

support sales and manufacturing of the new product line.

. Project management and execution of certain tasks.

. Interviewing end users, preparing requirement specifications.

. Develop functional specifications and detailed program specifications.

. Environment: I-Series, RPGIV, CA-PRMS 9.1, Intermec 5250 RF scanners

devices

July 2002 - June 2003

Client: Epic Global Tech, Lombard - IL

C-Commerce Web Application (EPIC GLOBAL) on .NET

. C-Commerce web application - Connecting Manufacturers, Retailers and

Brokers

. Electronic publication of Item, Price, and Promotion information

between the Key Account Manager of the Local Sales Agent and the Buyer

for the Direct and Indirect Buying Retailer, as well as managing

wholesaler surveys and Indirect Retailer funding which is normally

paid at the local store level.

. Responsible for Development database model and XML Web Services

. Design and programming for hierarchical data display on TreeView, Data

Grids and other web controls.

. Hardware / Software environment: Microsoft Windows 2000 server, .NET,

Microsoft Visual Studio, Visual SourceSafe, Microsoft SQL Server 2000,

C# programming language, Infragistics web controls, XML.

March 1997 - June 2002

Client: Tecumseh Products Company, Tecumseh, MI

Supporting On-going operation and other Software Development Projects

. I was contracted to work at Tecumseh Products Company to upgrade its

AS/400 based ERP system (PRMS 8.4) as part of Y2K.

. During this tenor I got opportunity to work on all aspects of

Manufacturing and Distribution system and understand the business

process thoroughly.

. Also, I developed various add-on modules to PRMS system in order to

support the business. Some of them are listed below.

. Automated Shipping process

. Sales Operation and Planning

. Supplier Consignment

. Auto Production Reporting

. Scrap Reporting and Continues Improvement

. Supplier Rating System

. Capacity check / Blocker for Order Entry

. Shop Floor Scheduling

. Simulated Allocation of Inventory to customer orders

. Physical Inventory and Cycle count

Enpro India Ltd. New Delhi Jan 1996 to Jan 1997

Associate Consultant

Client: Clothstime Inc. - Anaheim, CA

. Worked at Enpro India Ltd (a software consulting and outsourcing

company based at New Delhi, India) Enpro was setting up software

development shop and I initially helped in that area.

. Later, I was assigned to a client (Clothstime Inc. a retail clothing

chain based in California US). During this period I assisted them on

developing Merchandise Planning module.

Databorough India Ltd. New Delhi Feb

1993 to Dec 1996

Programmer/Analyst

. As one of the first employees of Databorough India, worked on all

aspects of setting up a software development shop in India..

. During this period I installed AS/400 system. Setup a LAN network and

. worked on development on various modules/components of X-Analysis

reverse engineering CASE tool

Databorough Ltd. UK July 1992 to

Jan 1993

Programmer/Analyst

. Worked at the Databorough headquarters in Surrey UK. During this

period I worked on development of interfacing X-Analysis reverse

engineering CASE tool to various 3rd party PC based CASE tools like

ADW, Excelerator.

Status in US: Permanent Resident

References: Available on Request

Contact this candidate