Summary
Overview
Work History
Education
Projects Executed
Languages
Timeline
Generic

Deepa Deshmukh

CBD Belapur Navi Mumbai

Summary

Business savvy professional with more than 15+ years of success in leading Supply Chain, Finance, Manufacturing for various clients in USA, Singapore and India. MS graduate who champions more efficient, cost-effective business processes. Proactive business manager who is able to identify ways to reduce expenses without compromising quality. Effective team leader and consensus builder who can promote best practices among cross-functional teams.

Overview

19
19
years of professional experience
4010
4010
years of post-secondary education

Work History

Senior Oracle Lead

Atmus -Birlasoft
12.2023 - Current
  • Leading the roll out of the Belgium project were the GOMS legacy system was converted to Oracle EBS
  • Worked on doing setups in Order Management, Inventory modules and creating BR100 documents.
  • Worked on creating email ids for the business users in customer master ship to address CNI’s.
  • Worked on creating salesperson using CNI’s.
  • Gave infant care support after go live.
  • Worked on Medium and High tickets Such as User cannot approve the Purchase Order, Unit price not defaulting in Sales order line, Sales order not getting booked.
  • Mentored the juniors.

Senior Oracle Lead

Cigna
10.2021 - 01.2023
  • Leading the Implementation project for a new Pharmacy site (ESSDS) for Cigna by collaborating with Stakeholders, Business and Implementation partner (Accenture)
  • Monitored and did the required setups in AODEV, AOPPD for Order Management, Inventory, Purchasing modules, Manufacturing responsible for the ESSDS project which works on implicit Consigned cycle so did the required setups for Consigned LOT controlled items which are booked, picked and shipped, upon ship confirmation the ownership transfers from the supplier to Cigna, ran the Interface trip stop program, Cost recognition program and then the Create Accounting -Cost program to transfer to GL, ran Consumption advice program and did setups for automatic AP invoices.
  • Completely responsible to provide Oracle solutions on different business scenario such as Patient return drugs to be handled by RMA or Miscellaneous receipts transactions, tested the complete Consigned cycle, performance tuning for Create Accounting -Cost program, PO Receipts, Sub inventory transfer, Move Order transfer using Min- Max planning, Cycle Counting, Physical counting for Lot controlled items in AODEV and AOPPD instance.
  • Assisted in the UAT by creating detailed test scripts, upon the GO live decision did the required setups in production.
  • Trained team members.

Senior Oracle Lead

Bloom Energy San Jose
San Jose
02.2019 - 06.2020
  • Collaborated with Stakeholders, Business and Subject matter experts to gain a full understanding of current Supply Chain, Inventory, Manufacturing, Finance and Finance and Procurement business process.
  • Created MD50 functional documents for Commodity Manager, ASN, Aging Report, FTZ, Demand and Usage Report, PO Receipt Report.
  • Conducted regular meetings with business to determine the best sourcing strategies among various available such as Min -Max Planning, Reorder Point, Vendor Managed Inventory (VMI) and Consigned Vendor Managed Inventory (CVMI) and worked on Sourcing rule scenarios, OSP BOM, Drop Ship Cycle, Back-to-Back Cycle, IR/ISO process.
  • Worked closely with business on testing Shipment file, Admissions, Physical inventory for the Foreign Trade Zone project, different Sourcing rule scenarios, OSP and providing different solutions as a Functional Lead.
  • Completely responsible for planning DEV, SIT, UAT and production cutover plan.
  • Develop the Test Strategy and Test Plans, Test scenarios. Manage test exit criteria, reporting and signoffs for all testing cycles UAT testing and then moving to production.

Senior Oracle Functional Lead

Arrow Electronics
Denver
08.2018 - 01.2019
  • Interacted with the Business users, and SMEs to get a better understanding of the Distributors -Arrow Business Processes such as Quote to Cash cycle, Inventory, Manufacturing, Service Contracts, Vertex tax For SO in EBS, WMS integration with EBS, Sales and Marketing.
  • Executed projects using Agile methodologies.
  • Did the delta setups and created BR100 documents for SCM and Finance modules.
  • Involved thoroughly in SIT (Smoke testing, Sanity check and Integration testing) for SCM and finance domain such as Drop Ship cycle, Back-to-Back, Quote to Order EBS, ATO cycle, B2B EDI.
  • Involved is defect resolution process and solved the defects within defined SLA.
  • Encountered various issues while testing and fixing it such as Bill to, ship to address not active, RMA not getting processed because of few line level modifiers are archived, duplicate record exist for a particular price list and item, Drop Ship PO not getting created, Back to back order PO not getting created, Quote not getting created successfully in EBS.
  • Develop the Test Strategy and Test Plans, Test scenarios. Manage test exit criteria, reporting and signoffs for all testing cycles (SIT, UAT testing).
  • Worked closely with the implementation partner to create a detailed cut-over plan.

Senior Implementation Lead

ICU Medical
San Clemente
07.2017 - 07.2018
  • Gathered User requirements, Functional requirements interacted with the Business users, Project Manager and SMEs to get a better understanding of the ICU Supply Chain Business Processes and executed all the projects using Agile methodology.
  • Worked as a lead in Oracle R12 implementation to provide complex solutions for global rollouts in 4 countries (Canada, Latin America, Spain and US) wherein ICU Medical is acquiring Hospira Infusion Systems.
  • Determined GxP impacted scenarios and rated them as Medium, Low risk after conducting meetings with the Quality team.
  • Created the BR100 document for Oracle Order Management, Inventory and Purchasing by working closely with the implementation partner and configuring the SIT and UAT environments.
  • I worked on Screening DEA License, Customer Pharma License, Warehouse license, Denied Party list, Good and bad Supplier, Party name and Address in Global Trade Management system.
  • Developed the Test Script, Test Strategy and Test Plans, Conducted Kick off meeting to communicate to all the testers about the prerequisite sequence in which the test cases will be executed, testing evidence, testing signature before Go-Live.
  • Worked on EDI (940,945,856,846,947,850,855,810) functionality and tested the same with 3PL team.
  • Work on key processes and elements including planning and scheduling, inventory replenishment, purchase order processes, requisition/PO approval process, internal order/sales order process (IR/ISO). The replenishment process created WIP discrete jobs for over labelling items.
  • Supported business in UAT and Go-live. Resolved Issues faced during UAT and postproduction.

Senior Oracle Consultant

Zebra
Chicago
07.2015 - 07.2016
  • Conducted meeting with stakeholder, Client Architect to understand the AS-IS process and recommended the TO-BE process.
  • Created MD50s and MD70s for the Decommissioning project of Motorola.
  • Recommended APIs to cancel Purchase orders, Sales orders, Requisitions, Sourcing rules.
  • Coordinating with offshore development team in API development-Unit test.
  • Created test scenarios, test plan and test cases to test in DEV, SIT and UAT.
  • I was completely responsible to move the changes to production and provided production support for the same.
  • Zebra technologies acquired Motorola in 2014 with an agreement stating we need to convert all the components such as Purchase orders, Sales orders, and requisitions from Motorola environment (Trilogy) to Zebra environment (Merlin).

Sr Oracle Functional Lead

TCS - Ingersoll-Rand Inc
Charlotte
03.2014 - 06.2015
  • Perform all the Organization setups for Inventory, Order management and Purchasing Modules and documented the corresponding BR100, MD50 and MD70 documents.
  • Worked on creating data load in all the instances including production for Item Category, On hand inventory and BPA for Tyler, Vidalia, Trenton and Forth Smith.
  • Developed an inbound interface (loading data into staging table) and outbound interface (Truck load details are sent to third party system which stores the inventory for IR) using XML data along with Mapping of fields between Oracle and NASS (third party system).
  • Worked on different EDI functionalities, which involved 3PL and solved EDI regarding issues.
  • Worked on resolving the huge volume of rejected and on holding invoices in Accounts payables.
  • Creation of test scripts, test cases and unit testing for all the components developed in DEV, SIT, UAT.
  • Postproduction support for all the components designed.

Sr Reimplementation Lead

TCS - Air Liquide
Houston
07.2013 - 02.2014
  • Implement new Oracle COA structure [as decided by Air Liquide] for their operations in Singapore, Taiwan, China and Malaysia.
  • Did setups in Order Management, Inventory, Purchasing, Accounts Payables and created the BR100 documents.
  • Conversion of Master and Transaction data using Open Interfaces/ API. (Master Item conversions, Item category, Item On hand and AP Invoices).
  • Identifying existing Customized Oracle Reports Components of Inventory (Material balance, Report Stock in stock out, Summary of material balance, Inventory transfer, goods issued) and Account Payables and did the necessary changes based on COA Impact (Chart of Account).
  • Preparing Migration Cut over Plans, Integration test plan/test cases for Oracle applications.
  • Documentation – Preparation of MD50, testing and filling up the unit test plan for the above-recommended issues.
  • Provide end-to-end customer support which includes issue identification, implementing the fix in test instance, unit testing, and following up with users for UAT approvals.

Sr IT Analyst

Xeno soft - Cisco System Inc
San Jose
12.2009 - 09.2010
  • I interacted with the application team to understand the complete Cisco Order to Cash process and gathered the required details such as scope of the project, data load, databases impacted, upstream and downstream dependencies.
  • Created an Oracle ATO (Assemble to Order), Drop ship, Back-to-Back orders sample Order that gets successfully created, booked, pick released, Ship Confirmed and invoiced.
  • Assisted the development team to generate load of 5000 order lines after creating a sample order for both QTC/BV instance to see the performance of Replicate Cycle update program (running in SJ) as well as Cycle update program (running in QTC/BV).
  • Involved in a lot of stress testing to find out the performance of the Order Management as to whether it could handle load of 5000 orders within the SLA.
  • Well versed with the complete Cisco Order to Cash Process.

Oracle Techno Functional Consultant

Prudential Financials
Arizona
02.2008 - 12.2009
  • Involved in all phases of SDLC (Planning, Design, Development, Testing, Production, Release, Support and Upgrade) for a couple of interfaces between SE (source system) and Oracle system.
  • Worked as a system analyst to identity the columns in SE (source system), mapped them to the Oracle columns for the Auto invoice standard program and documented in Microsoft Visio.
  • Developed interfaces like Oracle Auto invoice, AP Invoice, Auto lock box, Credit Memo, Receipt’s, 1099S, GL Interface.
  • Created PL/SQL packages to load the data created in Service Engine (a Legacy System) to Oracle Accounts Receivables using the Auto Invoice Import Program, prepared test scripts, test scenarios and conducted User Acceptance Testing (UAT).
  • Moved the code to production environment and provided postproduction support.

Oracle Technical Consultant

AT&T Wireless
Alpharetta
05.2007 - 01.2008
  • Proficient in creating Business Requirements, Functional Specification Documents (FSD) and technical documents such as MD70 as per the SDLC process.
  • Worked on creating PL/SQL packages for GL Interface, AR Auto invoice, AP Invoice, Sales Order Import Program, testing in DEV, SIT and UAT moving to production environment and supporting postproduction.
  • Developed Control scripts and loaded existing data using SQL
  • Loader to be staging tables.

Education

Masters of Engineering - Electrical

Texas A&M University
Kingsville

Bachelor of Engineering - Electronics & Communication

Mumbai University
Mumbai, India

Projects Executed

  • Atmus -Birlasoft, Senior Oracle Lead, 12/2023 - Present, Leading the roll out of the Belgium project where the GOMS legacy system was converted to Oracle EBS. Worked on doing setups in Order Management, Inventory modules and creating BR100 documents. Worked on creating email ids for the business users in customer master ship to address CNI’s. Worked on creating salesperson using CNI’s. Gave infant care support after go live. Worked on Medium and High tickets such as User cannot approve the Purchase Order, Unit price not defaulting in Sales order line, Sales order not getting booked. Mentored the juniors.
  • Cigna, Senior Oracle Lead, 10/2021 - 01/2023, Leading the Implementation project for a new Pharmacy site (ESSDS) for Cigna by collaborating with Stakeholders, Business and Implementation partner (Accenture). Monitored and did the required setups in AODEV, AOPPD for Order Management, Inventory, Purchasing modules, Manufacturing responsible for the ESSDS project which works on implicit Consigned cycle so did the required setups for Consigned LOT controlled items which are booked, picked and shipped, upon ship confirmation the ownership transfers from the supplier to Cigna, ran the Interface trip stop program, Cost recognition program and then the Create Accounting -Cost program to transfer to GL, ran Consumption advice program and did setups for automatic AP invoices. Completely responsible to provide Oracle solutions on different business scenario such as Patient return drugs to be handled by RMA or Miscellaneous receipts transactions, tested the complete Consigned cycle, performance tuning for Create Accounting -Cost program, PO Receipts, Sub inventory transfer, Move Order transfer using Min- Max planning, Cycle Counting, Physical counting for Lot controlled items in AODEV and AOPPD instance. Assisted in the UAT by creating detailed test scripts, upon the GO live decision did the required setups in production. Trained team members.
  • Bloom Energy San Jose-CA, Senior Oracle Lead, 02/2019 - 06/2020, Collaborated with Stakeholders, Business and Subject matter experts to gain a full understanding of current Supply Chain, Inventory, Manufacturing, Finance and Procurement business process. Created MD50 functional documents for Commodity Manager, ASN, Aging Report, FTZ, Demand and Usage Report, PO Receipt Report. Conducted regular meetings with business to determine the best sourcing strategies among various available such as Min -Max Planning, Reorder Point, Vendor Managed Inventory (VMI) and Consigned Vendor Managed Inventory (CVMI) and worked on Sourcing rule scenarios, OSP BOM, Drop Ship Cycle, Back-to-Back Cycle, IR/ISO process. Worked closely with business on testing Shipment file, Admissions, Physical inventory for the Foreign Trade Zone project, different Sourcing rule scenarios, OSP and providing different solutions as a Functional Lead. Completely responsible for planning DEV, SIT, UAT and production cutover plan. Developed the Test Strategy and Test Plans, Test scenarios. Manage test exit criteria, reporting and signoffs for all testing cycles UAT testing and then moving to production.
  • Arrow Electronics, Denver -CO, Senior Oracle Functional Lead, 08/2018 - 01/2019, Interacted with the Business users, and SMEs to get a better understanding of the Distributors -Arrow Business Processes such as Quote to Cash cycle, Inventory, Manufacturing, Service Contracts, Vertex tax For SO in EBS, WMS integration with EBS, Sales and Marketing. Executed projects using Agile methodologies. Did the delta setups and created BR100 documents for SCM and Finance modules. Involved thoroughly in SIT (Smoke testing, Sanity check and Integration testing) for SCM and finance domain such as Drop Ship cycle, Back-to-Back, Quote to Order EBS, ATO cycle, B2B EDI. Involved in defect resolution process and solved the defects within defined SLA. Encountered various issues while testing and fixing it such as Bill to, ship to address not active, RMA not getting processed because of few line level modifiers are archived, duplicate record exist for a particular price list and item, Drop Ship PO not getting created, Back to back order PO not getting created, Quote not getting created successfully in EBS. Developed the Test Strategy and Test Plans, Test scenarios. Manage test exit criteria, reporting and signoffs for all testing cycles (SIT, UAT testing). Worked closely with the implementation partner to create a detailed cut-over plan.
  • ICU Medical, San Clemente, CA, Senior Implementation Lead, 07/2017 - 07/2018, Gathered User requirements, Functional requirements interacted with the Business users, Project Manager and SMEs to get a better understanding of the ICU Supply Chain Business Processes and executed all the projects using Agile methodology. Worked as a lead in Oracle R12 implementation to provide complex solutions for global rollouts in 4 countries (Canada, Latin America, Spain and US) wherein ICU Medical is acquiring Hospira Infusion Systems. Determined GxP impacted scenarios and rated them as Medium, Low risk after conducting meetings with the Quality team. Created the BR100 document for Oracle Order Management, Inventory and Purchasing by working closely with the implementation partner and configuring the SIT and UAT environments. I worked on Screening DEA License, Customer Pharma License, Warehouse license, Denied Party list, Good and bad Supplier, Party name and Address in Global Trade Management system. Developed the Test Script, Test Strategy and Test Plans, Conducted Kick off meeting to communicate to all the testers about the prerequisite sequence in which the test cases will be executed, testing evidence, testing signature before Go-Live. Worked on EDI (940,945,856,846,947,850,855,810) functionality and tested the same with 3PL team. Work on key processes and elements including planning and scheduling, inventory replenishment, purchase order processes, requisition/PO approval process, internal order/sales order process (IR/ISO). The replenishment process created WIP discrete jobs for over labelling items. Supported business in UAT and Go-live. Resolved Issues faced during UAT and postproduction.
  • Zebra, Chicago, USA-IL, Senior Oracle Consultant, 07/2015 - 07/2016, Zebra technologies acquired Motorola in 2014 with an agreement stating we need to convert all the components such as Purchase orders, Sales orders, and requisitions from Motorola environment (Trilogy) to Zebra environment (Merlin). Conducted meeting with stakeholder, Client Architect to understand the AS-IS process and recommended the TO-BE process. Created MD50s and MD70s for the Decommissioning project of Motorola. Recommended APIs to cancel Purchase orders, Sales orders, Requisitions, Sourcing rules. Coordinating with offshore development team in API development-Unit test. Created test scenarios, test plan and test cases to test in DEV, SIT and UAT. I was completely responsible to move the changes to production and provided production support for the same.
  • TCS - Ingersoll-Rand Inc, Charlotte –USA-NC, Sr Oracle Functional Lead, 03/2014 - 06/2015, Perform all the Organization setups for Inventory, Order management and Purchasing Modules and documented the corresponding BR100, MD50 and MD70 documents. Worked on creating data load in all the instances including production for Item Category, On hand inventory and BPA for Tyler, Vidalia, Trenton and Forth Smith. Developed an inbound interface (loading data into staging table) and outbound interface (Truck load details are sent to third party system which stores the inventory for IR) using XML data along with Mapping of fields between Oracle and NASS (third party system). Worked on different EDI functionalities, which involved 3PL and solved EDI regarding issues. Worked on resolving the huge volume of rejected and on holding invoices in Accounts payables. Creation of test scripts, test cases and unit testing for all the components developed in DEV, SIT, UAT. Postproduction support for all the components designed.
  • TCS - Air Liquide, USA-Houston, TX, Sr Reimplementation Lead, 07/2013 - 02/2014, Implement new Oracle COA structure [as decided by Air Liquide] for their operations in Singapore, Taiwan, China and Malaysia. Did setups in Order Management, Inventory, Purchasing, Accounts Payables and created the BR100 documents. Conversion of Master and Transaction data using Open Interfaces/ API. (Master Item conversions, Item category, Item On hand and AP Invoices). Identifying existing Customized Oracle Reports Components of Inventory (Material balance, Report Stock in stock out, Summary of material balance, Inventory transfer, goods issued) and Account Payables and did the necessary changes based on COA Impact (Chart of Account). Preparing Migration Cut over Plans, Integration test plan/test cases for Oracle applications. Documentation – Preparation of MD50, testing and filling up the unit test plan for the above-recommended issues. Provide end-to-end customer support which includes issue identification, implementing the fix in test instance, unit testing, and following up with users for UAT approvals.
  • Xeno soft - Cisco System Inc, USA-San Jose, Sr IT Analyst, 12/2009 - 09/2010, I interacted with the application team to understand the complete Cisco Order to Cash process and gathered the required details such as scope of the project, data load, databases impacted, upstream and downstream dependencies. Created an Oracle ATO (Assemble to Order), Drop ship, Back-to-Back orders sample Order that gets successfully created, booked, pick released, Ship Confirmed and invoiced. Assisted the development team to generate load of 5000 order lines after creating a sample order for both QTC/BV instance to see the performance of Replicate Cycle update program (running in SJ) as well as Cycle update program (running in QTC/BV). Involved in a lot of stress testing to find out the performance of the Order Management as to whether it could handle load of 5000 orders within the SLA. Well versed with the complete Cisco Order to Cash Process.
  • Prudential Financials, Arizona, Oracle Techno Functional Consultant, 02/2008 - 12/2009, Involved in all phases of SDLC (Planning, Design, Development, Testing, Production, Release, Support and Upgrade) for a couple of interfaces between SE (source system) and Oracle system. Worked as a system analyst to identify the columns in SE (source system), mapped them to the Oracle columns for the Auto invoice standard program and documented in Microsoft Visio. Developed interfaces like Oracle Auto invoice, AP Invoice, Auto lock box, Credit Memo, Receipt’s, 1099S, GL Interface. Created PL/SQL packages to load the data created in Service Engine (a Legacy System) to Oracle Accounts Receivables using the Auto Invoice Import Program, prepared test scripts, test scenarios and conducted User Acceptance Testing (UAT). Moved the code to production environment and provided postproduction support.
  • AT&T Wireless, Alpharetta, GA, Oracle Technical Consultant, 05/2007 - 01/2008, Proficient in creating Business Requirements, Functional Specification Documents (FSD) and technical documents such as MD70 as per the SDLC process. Worked on creating PL/SQL packages for GL Interface, AR Auto invoice, AP Invoice, Sales Order Import Program, testing in DEV, SIT and UAT moving to production environment and supporting postproduction. Developed Control scripts and loaded existing data using SQL
  • Loader to be staging tables.

Languages

English
First Language

Timeline

Senior Oracle Lead

Atmus -Birlasoft
12.2023 - Current

Senior Oracle Lead

Cigna
10.2021 - 01.2023

Senior Oracle Lead

Bloom Energy San Jose
02.2019 - 06.2020

Senior Oracle Functional Lead

Arrow Electronics
08.2018 - 01.2019

Senior Implementation Lead

ICU Medical
07.2017 - 07.2018

Senior Oracle Consultant

Zebra
07.2015 - 07.2016

Sr Oracle Functional Lead

TCS - Ingersoll-Rand Inc
03.2014 - 06.2015

Sr Reimplementation Lead

TCS - Air Liquide
07.2013 - 02.2014

Sr IT Analyst

Xeno soft - Cisco System Inc
12.2009 - 09.2010

Oracle Techno Functional Consultant

Prudential Financials
02.2008 - 12.2009

Oracle Technical Consultant

AT&T Wireless
05.2007 - 01.2008

Masters of Engineering - Electrical

Texas A&M University

Bachelor of Engineering - Electronics & Communication

Mumbai University
Deepa Deshmukh