Sumit Mishra

Seeking a position to utilize my skills and abilities and achieve professional growth while being resourceful, innovative, and flexible. To add valuable assets to your esteemed organization as an active member. I’m an Oracle EBS SCM professional working in EBS R12 Implementation/support/upgrade/Rollout Projects. I also have a business analyst experience towards EBS platform for my clients. With having more than a total of 18 years of experience in IT and manufacturing I have extensively worked in all phases of the system implementation life cycle utilizing most of the Oracle tools. Experience of implementation of EBS modules like PO,INV,WMS,OM,WIP,BOM,Supplier Scheduling, Ecommerce Gateway. Currently working as Senior IT Analyst Certified Oracle Procurement Cloud Implementation specialist, OCI Associate and OCI Architect Extensive experience on working on Business requirements analysis, review, definition, and documentation. Worked extensively in Oracle E-Business Suite in the various stages of Development and Implementation cycles including Requirements Gathering, Functional Mapping, Solution Design, functional flow Development, Review and testing of Deliverable. Worked on large IT transformation projects including complete migration from one legacy system to Oracle. Expertise in imparting training on Oracle Apps to end-users. Having Good knowledge on Sql- Pl/sql

• Oracle Cloud Certifications in Procurement
• Oracle Cloud Infrastructure Associate
• Oracle Cloud Infrastructure Architect

Project :   Projects for Honeywell Intelligrated

Client:  Honeywell Intelligrated

Role:  Implementations/ Rollouts/Enhancements/Business Analyst /Implementation Specialist/SME

Description: Have implemented various projects like Implementing WMS in Mexico region, Vendor Managed Inventory, Oracle ECC Dashboards, WMS implementation in Distribution Center. I’ve led these projects from Requirement gathering, Solution Design and Developments, Testing, Training and Implementations/ Rollouts across various Honeywell sites.

Contribution:

· Working for modules like WMS, Purchasing, Inventory, Order Management, Shipping in all SCM modules typically in warehouse structure of business.

· Interact with Business Users to identify pain areas faced by business and design and develop solutions accordingly.

· Involvement from Discovery phase till go-live /infant care including all major milestones of the project.

· Worked in enhancements

· Worked in interfaces

· Worked in critical production issues as a SME

Project :   Cummins Oracle Applications -JEP Implementation

Client:    Jamestown Engine Plant, Cummins Inc. USA

Role:   Implementations/ Rollouts/Business Analyst

Description: Jamestown Engine Plant running in Mainframe systems since long time. As a part of Mainframe retirement program, we’re bringing the plant to EBS( Oracle plant) with various new processes to be introduced that must include customizations , Integrations, Conversions and in EBS R12.2.7 version

Different Modules Involved in the Project:

Contribution:

· Working for modules like WMS, Purchasing, Inventory, MRP, Supplier Scheduling, WIP, Order Management, RLM, Ecommerce gateway in all SCM modules typically in warehouse structure of business.

As a Functional consultant, responsible for the following:

· Interact with Business Users & Business IT to identify pain areas faced by business and design and develop solutions accordingly

· Involvement from Discovery phase till go-live /infant care including all major milestones of the project

· Identify gaps in current Oracle Apps processes and build solutions to bridge them

· Working on Problem Requests and Change Requests while analyzing the issues reported by business users. Study the System Design Documents (SDR) and implementing the changes in the current software, involves analysis & modifications in current software and design document (SDR).

· Modifications to existing functions initiated by Problem Report/Change Request (PRCR) and maintaining product compatibility.

· Document the work performed via PRCR system evaluations and necessary technical reports.

· Working as the offshore coordinator and have an active involvement of Onsite and Offshore team meetings and status meetings.

· Provide necessary trainings to business users to enhance their capabilities to use the Oracle ERP more effectively.

· Leading integration testing and coordination with edge apps that are going to be connected with the ERP system

· Coordinating various project milestones CRP, SIT, UAT, Mock, Cutover-Go-live) and preparing test cases for execution

Project :  Cummins Oracle Applications

Client:  Columbus Engine Plant, Cummins Inc. USA

Role : Implementations/ Rollouts/Business Analyst

Description: Being the most oldest over 100 years  , the Columbus Engine plant was running on oracle 11i to assembly Engine for it’s OEM since a long time.  As a part of system upgrade and various new processes we reimplemented R12.1.3 and later upgraded to OCI with R12.2.7 for all supply chain modules with over 50 integrations and more than 200 customizations

Different Modules Involved in the Project:

Worked for modules like WMS,Purchasing, Inventory, MRP, Supplier Scheduling, WIP,BOM, Order Management, RLM, Ecommerce gateway in all SCM modules typically in warehouse structure of business.

Processes and Tools used by Cummins:

· In depth knowledge of Oracle Application GIEA (Global Integrated Enterprise Application) by Cummins Inc.

· Complete understanding of Cummins working on GIEA, EDI, and other third-party tools

· Knowledge of Cummins ticket tracking tool i.e Remedy.

· Good knowledge of Zebra Printers and Zebra/Motorola Scanners.

· Knowledge of Cummins SRM support and enhancement process

· Knowledge on Label design and prints for logistic operation

Contribution: As a Business Analyst/Functional consultant, responsible for the following:

· Interact with Business Users & Business IT to identify pain areas faced by business and design and develop solutions accordingly

· Identify gaps in current Oracle Apps processes and build solutions to bridge them

· Working on Problem Requests and Change Requests while analyzing the issues reported by business users. Study the System Design Documents (SDR) and implementing the changes in the current software, involves analysis & modifications in current software and design document (SDR).

· Modifications to existing functions initiated by Problem Report/Change Request (PRCR) and maintaining product compatibility.

· Document the work performed via PRCR system evaluations and necessary technical reports.

· Working as the offshore coordinator and have an active involvement of Onsite and Offshore team meetings and status meetings.

· Provide necessary trainings to business users to enhance their capabilities to use the Oracle ERP more effectively.

· Worked as a transition lead while upgrading from 11i to R12 for the CEP(LDD& HDM ) plant .

· Implemented project like

· Engine custom order management(ECOM)

· Regional Warehouse (RWH)

· BOLT ( Oracle financials)

· Supplier Integration( SIM)

· HDM WMS

· Oracle Server movement from Columbus to Chicago( Solaris to Exa)

Environment Oracle applications R12 on Unix platform

Project : Cummins Oracle Applications Global Production Support

Client: Cummins Inc. USA

Description: Cummins Inc., a global power leader, is a corporation of complementary business units that design, manufacture, distribute and service engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions and electrical power generation systems. Headquartered in Columbus, Indiana (USA), Cummins serves customers in approximately 190 countries.

Different Modules Involved in the Project:

• Worked for modules like Purchasing, Inventory, MRP, Supplier Scheduling, WIP, Order Management, RLM, Ecommerce gateway in all SCM modules typically in warehouse structure of business.

Processes and Tools used by Cummins:

· In depth knowledge of Oracle Application GIEA by Cummins Inc.

· Complete understanding of Cummins working on GIEA, EDI, and other third-party tools

· Knowledge of Cummins ticket tracking tool i.e Remedy.

· Good understanding of Cummins Common Components and well-established coordination with their team.

· Knowledge of Cummins SRM support and enhancement process

Contribution: As a Functional consultant, responsible for the following:

· Interact with Business Users & Business IT to identify pain areas faced by business and design solutions accordingly

· Identify gaps in current Oracle Apps processes and build solutions to bridge them

· Working on Problem Requests and Change Requests while analyzing the issues reported by business users. Study the System Design Documents (SDR) and implementing the changes in the current software, involves analysis & modifications in current software and design document (SDR).

· Modifications to existing functions initiated by Problem Report/Change Request (PRCR) and maintaining product compatibility.

· Document the work performed via PRCR system evaluations and necessary technical reports.

· Working as the offshore coordinator and have an active involvement of Onsite and Offshore team meetings and status meetings.

· Provide necessary trainings to business users to enhance their capabilities to use the Oracle ERP more effectively.

· Worked as a transition lead while upgrading from 11i to R12 for the CEP(LDD& HDM ) plant .

Environment Oracle applications R12 on Unix platform

Project : Cummins Oracle Applications Global Production Support

Client: Cummins Inc. USA

Description: Cummins Inc., a global power leader, is a corporation of complementary business units that design, manufacture, distribute and service engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions and electrical power generation systems. Headquartered in Columbus, Indiana (USA), Cummins serves customers in approximately 190 countries.

Different Modules Involved in the Project:

• Worked for modules like Purchasing, Inventory, MRP, Supplier Scheduling

Processes and Tools used by Cummins:
In depth knowledge of Oracle Application GIEA by Cummins Inc.

· Complete understanding of Cummins working on GIEA, EDI and other third-party tools

· Knowledge of Cummins ticket tracking tool i.e Remedy.

· Good understanding of Cummins Common Components and well-established coordination with their team.

Contribution: As a Functional consultant, responsible for the following:

· Production support to the users.

· Technical/Functional discussion with another team member.

· Identified and resolved significant showstopper issues related to rtp process to help client meet deadlines support.

· Worked on critical issues and played key roles for resolving those.

· Received several appreciations from client for proactively resolving priority handled issues.

· Worked with Oracle support for functionalities identified as a Bug.

· Worked for the month end /year end closure issues.

Environment Oracle applications 11i/R12 on Unix platform

Project : Cummins Oracle Applications Global Production Support

Client: At KPIT Cummins Infosystems Ltd for Cummins Inc. USA

Description:  As a Team Member to a global production support to GIEA, I was responsible the following processes:

· Was working for support activities includes issues raised by client in particularly for Purchasing module

Contribution:

· Has handled issues of Business for the cycle of RTP.

· Coordinated with other teams for flow of data from legacy systems to Oracle GIEA system.

· Has worked with Core team for interfacing of data with Oracle.

· Got Client appreciations for resolving high prioritized issues.

· Has worked for various issues mostly related to Purchas Orders, Requisitions, Approved Supplier lists, Sourcing rules, MRP created Releases, EDI with supplier, receiving, 3PL, VMI and other processes.

Environment: Oracle applications 11i/R12 on Unix platform

Project : Upgrade 11.5.10 and production support

Client Afro construction

Description The project was an Oracle application upgrade from version 11i9 to 11i10.

Contribution

· As a consultant successfully completed the up gradation of oracle 11i9 to 11i10 meeting the timely delivery and process dead lines.

· Responsible for validating production data, end- to-end business solution testing for oracle purchasing, inventory and order management modules.

· Identify the changes in the seeded functionality in 11i10 and worked with technical team for custom code changes. Resolved several transaction issues failing due to customer interactions.

· Worked with oracle product development team to resolve the standard bugs identified during the upgrade.

· Developed new unit test scripts, integrated test scripts, training materials and delivered trainings to the end users through net meetings.

· Responsible for delay status meeting and coordinating the bridge between business, technical team and oracle product support to discuss the gaps and resolutions.

· Distributed the workload among the team and monitor those to meet the on time completion. Involved in the two weeks live post upgrade production support along with the business users and signed-off for one of the most successful upgrade of oracle 11.5.10.2

Environment Oracle applications 11.5.9 through 11.5.10 on unix

Project : Production support

Client  Afro construction

Description  As a functional consultant supported for purchasing inventory module.

Contribution

· Performed post implementation support for oracle 11.5.9 in purchasing, inventory modules.

· Provided application support and training to end users.

· Identified and resolved significant show stopper issues related to rtp process to help client meet deadlines.

· Analyzed the business process gap by directly interacting with the end user to collect test cases and validated the requirements with oracle product support team.

· Executed the test cases as per the schedule. performed unit test and integration test. being a single point of contact i was responsible for user acceptance uat, maintaining knowledge repository, operation issue logs on behalf of the team.

· Prepare msr and represent it to the client on a monthly basis to improve the support activities.

· Suggest the optimal operating practices during user training sessions and received several appreciations from the customers.

Environment Oracle applications 11.5.9 on Unix

Project : Implementation

Client   Storax interiors

Description  As a team member was involved in the implementation project for the purchasing and inventory module on oracle application version 11i.

Contribution

· Provided remote implementation and go-live production support for oracle 11i (11.5.9) project purchasing and inventory modules.

· Worked with oracle implementation team, technical team and with client deployment team. designed and delivered end user training on project processes, functionality, integration and system usage.

· Responsibility defined as mapping the data from legacy to oracle erp, customizing of distribution module and integration between various third parties. prepared system test scripts, documented test results and user acceptance test (uat). Identifying report requirements documents to guide technical team in developing reports, interfaces and forms.

· Prepare the documents like rd20, bp80, br100, test scripts te40 and user manuals. Implementation of purchasing module with setups like locations, organizations, defines suppliers and customers.

· Define required prerequisites for the purchasing documents – quotations, rfq, po, auto create receipts & invoices, creating asl, define defaulting po rules, purchasing options, financial options & receiving options. Define suppliers.

· Defining employee hierarchy, setup approval document limit, define approval group, define sourcing rule.

· Received customer appreciation for successful completion of erp.

Environment Oracle applications 11.5.9 on Unix