Santosh Deshpande

+1-832-***-****

aco40r@r.postjobfree.com

Status: US Permanent Resident (GC)

SUMMARY

• Senior IT Solution functional Consultant

• Over 17 years of software engineering experience and 12+ years of experience in the

development and implementation of Oracle Applications 11i and R12 E-Business suite modules

including Solution Architect, Business Requirement Gathering, System Architecture, Technical

Design and Development, Seeded as well as Custom Interface development, Data conversion,

Documentation, Testing, Performance enhancements and User Training

• Functional experience in Oracle Supply Chain Management, Manufacturing and Shop Floor

Modules.

• Worked on Conversion, upgrade, support and implementation projects.

• Project/Program Management of multiple projects across the globe.

• Solution Architect in discrete manufacturing services.

• Business Analyst - Business requirements gathering, process mapping, GAP Analysis.

• Experience in the design and development of custom as well as seeded interfaces, extensions

using Oracle API’s, SQL, PL/SQL Procedures and SQL Loader utilities.

• Experience in design and develop customizations.

• Extensive experience in the design and development of complex business forms and reports using

Oracle Forms and Reports.

• Well versed with the AIM Methodology to prepare the Project documentations (MD-50/70, BR-

100, TE-70/120)

• Excellent read/write communication and work management and organization skills; ability to

work on multi regional projects on different time zones.

EDUCATION: Bachelor of Engineering in Mechanical Discipline – 1997 – Dr. B.A.M. University

Aurangabad, India.

Technical Expertise

Oracle Applications 11.5.10.2/ 11.5.9

Application

Inventory (INV), Oracle Bill Of Materials (BOM), Work In

Modules

Progress (WIP), Shop Floor Management (SFM), Purchasing(PO),

Payables(AP) Order Management(OM), Receivable (AR)

Application Object Library(AOL), Alerts (ALR) & Workflow.

SQL, PL/SQL, C++

Languages

Oracle Database 10g/9i

RDBMS

Oracle Forms 6i/9i, Oracle Reports 6i/9i, Oracle Discoverer, Toad,

Tools

SQL * Loader, Data Loader, Microsoft Office.

Operating System Unix-Solaris, Windows 9x, Windows NT/ 2000/XP.

Projects

GE Power & Water Distributed Power (Houston USA) June 2012 – till now

Program Manager – Implementations of SCM, Manufacturing and Shop Floor Modules.

Scope: GE P&W Distributed Power is leading manufacturer of gas turbines. The manufacturing

units are spread across the USA, Europe and Brazil. GE DP recently acquired four new

companies GE Aero Brazil, Waukesha Gas Engine USA, Jenbacher Gas Engine Austria and Avio

Aero Italy. Company is also planning to upgrade EBS suite from 11i to R12 and merge all above

companies into one EBS instance.

Responsibilities:

SCM/Manufacturing Functional Consultant

• Primarily responsible for implementation of multiple projects in SCM, Manufacturing

and Shop Floor GE Distributed Power Services sector. Under this role following projects

are completing / completed.

Implemented wing to wing solution for serviceable used material from buyback

o

engines.

Implemented Shop Floor Management tool at Brazil and Italy Service Center.

o

Preparing for the Malaysia rollout.

Implemented new warehouse in Brazil location and connect it to multiple

o

business instances in USA and Austria.

Implemented a complete solution to control the over ordering of high value parts

o

and ad-hoc changes in the Part Ordering cycle.

Implemented a typical Procure to Pay cycle to handle serviceable parts for

o

specific customers.

Implemented a Part tracking system in Shop Floor Centers across the globe.

o

Improved labor vouchering approval system.

o

Developed custom interfaces for part forecasting of GE Waukesha and GE

o

Jenbacher, Austria

Implementation of end to end MRP process into Brazil Service Centre

o

Project/Solution Architect /Change Management

Involved into change management team for re-engineering the Oracle EBS

o

solution for GE DP’s service Centers.

Preparing Proof of concept to replace customized Shop Floor Management

o

application by Oracle CMRO

Preparing the design of Part Configuration and Bill of Material system to support

o

EBS R12 implementation

Process mapping CEMLI components to Oracle R12.

o

Defined the IT scope and Fit/Gap analysis for GE Avio Aero, Italy to implement

o

service centers of two new gas engines

Organizing the workouts and CRPs to identify the improvements opportunities

o

into GE DP service centers

Program Management

• Point of Contact for implementation and support projects of Client: GE Distributed

Power Services.

• Resource Optimization/Management by resource training/sharing.

• Involved in the costing and negotiations of the projects to provide the optimum cost and

business benefits.

• Working as a final quality gate to make sure the completeness of the documentations

(MD Documents) in all the above projects.

GE Power & Water Distributed Power (Houston USA) July 2010 – June 2012

Project Manager - Production support of Oracle Work in Process (WIP) and Shop Floor

Management

Scope: GE P&W Distributed Power is leading manufacturer of gas turbines. The manufacturing

units are spread across the USA, Europe and Brazil. The scope of this project is to provide

production support to all service centers based at US, Netherland and Norway.

Responsibilities:

• Provided L1 to L3 levels production support (24X7) of Oracle Work in Process and Shop

Floor Management to all GE DP service centers across the globe

• Provided Configuration Management and Root Cause Analysis of Shop Floor

Management applications.

• Implemented short term fix and long term solutions on service center issues across the

globe.

• Application and database monitoring using existing GE tools

• Design and implemented major and minor enhancements

• Coordinating daily, weekly and monthly status reporting at various business stake

holders.

GE Energy Infrastructure (Hyderabad India) Jun 2009 – July 2010

Project Manager, offshore development team

Scope: GE Infrastructures has acquired Kelman Ltd. The company is a leading provider of

advanced monitoring and diagnostics technologies for transformers. Kelman Ltd was working on

customized ERP system. After merger GE implemented Oracle Applications 11i to replace the

legacy system.

Responsibilities:

• Primarily worked as Technical Team Lead to convert the Kelman Legacy data into Oracle

Application seeded tables. Converts the data for Inventory, BOM, Engineering and Work

Orders, PO and OM data.

• Responsible for the design and development of APIs and open interfaces.

• Involved in the data mapping from Legacy to Oracle Apps.

• Loaded data into staging interfaces by creating loader scripts, creating utl files to transfer

the data to other servers.

• Created custom interfaces by using PL/SQL procedures to validate the data to send it to

Oracle apps seeded tables through open interfaces.

• Involved in the SIT and UAT to demonstrate new system to the end users.

• Converted/Created 61 Reports into Oracle Reports.

• Prepared Design documentations (AIM: CV and MD Documentations)

• Involved in Quality documentations.

• Involved in Resource and Risk management.

CISCO System INC (Raleigh USA) Aug 2008- Jun 2009

Production Support Lead

Scope: worked as Sr. technical Lead to support the BSOS (Business Support & Operational

System) the project activities involved the production support for Oracle Applications Order

Fulfillment and receivables. The BSOS team does the bug fixings and enhancements in

production systems.

Responsibilities:

• Primarily responsible for the production support to fixing the bugs and monthly release

activities for order management, shipping and receivable modules.

• Responsible for trouble shooting of the production issues and create the short term fixes.

• Analyzed the long term solutions. Onsite coordination with offshore team and functional

consultants to develop the long term solutions.

• Created of test cases and validates the code delivered by offshore team.

• Santosh was involved into performance tuning of the custom interfaces.

• Prepared the audit report to track the sox compliances (Management reports).

• Created a matrix based tracker to identify and control the production issues.

• Preparation of technical Documentation like MD70, TE250.

• Weekly and monthly meetings with customers as well as inter project leads.

• Co-ordination between the support and development teams for monthly release activities.

Dresser-Rand (Houston USA) Jan 2007- Aug 2008

Oracle Techno Functional Consultant

Scope: Dresser-Rand is a global supplier of rotating equipment solutions to the oil, gas,

petrochemical, power, and process industries. The scope of the project was to designing of the

objects related to Oracle Order Management, Invoicing (AR) and Project Accounting using AIM

Methodologies.

Responsibilities:

• On-site co-ordination between offshore team and functional team and end client.

• Created an in bond interfaces using the pricing API’s to fulfill the complex part pricing.

• Created customized form to send the accounting transactions to sub ledgers and GL.

• Developed custom reports in Project Accounting to track the accounting information to

finance.

• Understanding of business process and convert it into the technical requirements.

• Development of complex forecasting reports in Discoverer 10g environment.

• Created custom interfaces to connect the project accounting to the global accounting

processes.

• Develop MD50 and MD70 documents using AIM methodology.

• Testing of the developed and delivered objects by off-shore team.

Logitech Inc (Fremont USA, Pune India) Jan 2006- Dec 2006

Technical Consultant

Scope: Logitech Inc. is world leader in computer accessories. Logitech’s manufacturing units and

offices are located across the world in the different continents. The scope of this project was

included the implementation of Data Warehousing and Business Intelligence modules. Discoverer

9i used as primary reporting tool. The multi-region project was developed for different continents

with one database.

Responsibilities:

• The Project includes Creation of Interfaces/Views in Oracle Financial Applications for

DW/BI system.

• Set ups of Discoverer Administrations and creation of End User Layer and Business Areas.

Provide security by using Grants and Privileges through Discoverer administrations.

• Preparation of set up documents & user training documents for self-creation of the reports

and create the parameters as per their requirements.

• Creation of Reports in Discoverer Environment.

• Requirement analysis: Analysis of current Oracle Application system. Requirement gathering

from Super users and End User. Suggesting the best possible solutions to minimize the time

through the developed reports.

• Documentations: Preparation of various Analysis Reports, Tracking report, Daily status report

• User Training: To make the user independent to create/update the reports by themselves.

Logitech Inc ( Suzhou China) Sep 2005- Dec 2005

Technical Conversion Expert

Scope: Logitech Inc. is world leader in computer accessories. Logitech’s manufacturing units and

offices are located across the world in the different continents. Company is having manufacturing

unit of computer accessories in china and Taiwan. The project activities involved the data

conversion of Oracle Applications Manufacturing and Order Fulfillment.

Responsibilities:

• Primarily responsible for Development of Interface for data conversion of Oracle Inventory

and Work in Progress module.

• Developed auto debugger program for the troubleshooting of the complete project.

• Development of custom Interface for conversion of data of Oracle Work in Progress

Assembly lines using API and Oracle PL/SQL.

• Created test cases to verify the job flow in other plug ins.

• Creation of Technical Design and Code Migration Documentations.

• End user coordination for requirement analysis.

• Preparation of testing scenario and Unit Testing with End user.

Electronic Arts Inc. (Pune, India) Oct 2004- Sep 2005

Technical Team Lead

Responsibilities:

• Primarily responsible to lead the team of 18 resources, working from offshore for

development and support for US and APAC region. Worked with senior management to build

the On-site Offshore model and got the success within estimated time.

• As a developer he involved in development of critical custom objects for Oracle Order

Management and Financial Modules using Oracle SQL/PL-SQL, Forms and Reports.

• Responsible to provide the production support.

• Troubleshooting of support issues within the decided time lines.

• Daily/Weekly work allocation and time estimation for each development object.

• Responsible for design and development of custom changes in the Order fulfillment forms

and financial reports.

• Creation and maintenance of a tracker sheet Report.

• Creation of Technical Design Documentations using AIM (MD50, MD70) Along with

technical documentation, Santosh developed induction manuals for entire ODC.

• Representing weekly and monthly quality reviews.

GE Power System (Gurgaon, Hyderabad India) Jul 2002- Sep 2004

Technical Developer

Scope: GE Power System is the global leader in Power generations using gas and steam turbines.

The Project was to create a Global GL module integrated with sub ledgers of multiple GE Power

and water companies. Global GL is a customized GL module using Oracle financial frame work

and Data structure.

Responsibilities:

• Primarily responsible to develop the customized general ledger module using pl/sql

procedures form GE Global Services.

• Responsible for creating Interfaces to transfer the data from 50+ sub-ledgers.

• Created of Back bridge Application using UTL files and shell scripts.

• Data migration using SQL Loader and Export-Import utilities.

• Developed the four core procedures to map, validate, clean and purge the data into GL seeded

tables.

• During the project, developed five forms and seven reports using oracle developer 6i.

• Worked in the post Implementation support as a team leader to support the same project.

• Creation of Testing & Design Documents. MD-50, MD-70 and UTD.

Forbs Marshall (Pune India) Jan 2000- Jul 2002

Technical Developer –

Scope: Forbs Marshall is a well-known name in steam engineering and control instruments. The

scope of the project was conversion of IT processes from oracle base legacy system to Oracle

Application 11.0.3.

Responsibilities:

• Responsible for conversion of traditional Oracle Application Modules included INV, BOM,

OM, PO, AP, AR, FA and GL. (Financials, Manufacturing, Distributions and Supply Chain

Modules).

• Primary responsibility was Migration of data from legacy system to Oracle Applications

11.0.3.

• Created custom and API Interfaces to load the data into Oracle Applications using SQL,

PL/SQL and Data loader.

• Developed Validation scripts to import the data into the seeded tables in the oracle

applications

• Development of Oracle Application Reports and Forms using Reports 4.5 and Forms 4.5

Benninger India Ltd. (Pune India) Jul 1996- May 1999

Design Engineer,

Responsibilities:

• Worked as design engineer, Created part nomenclature, exploding the bill of material for

large textile machineries

• Worked as erection and commissioning engineer of large turnkey projects in Textile

engineering.

• Worked as site engineer with large conveyer industry.

Contact Details and Status

• Status: US Permanent Resident.

• Address: 23600 FM 1093, 106

Richmond, TX -77406

• (C) 832-***-****, (H) 832-***-****

Contact this candidate