Management Project
Resume:
Santosh Deshpande
****************.*******@*****.***
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