Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Sanjay Sharma

San Diego,USA

Summary

Senior Techno-Functional Consultant with over 12 years of experience in implementing, upgrading, and supporting Oracle ERP Applications (11i, R12). Managing end-to-end processes within Supply Chain Management (SCM) and also worked on Finance modules, including Order Management, Shipping, Inventory, Payables, and Receivables. Extensive hands-on experience in Oracle Integration Cloud (OIC) over the last 6 months, focusing on integration development.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Senior Techno-Functional Consultant

LTI US
06.2023 - Current
  • Working on Logistic and Distribution Production issue and development story on daily basic
  • Help business for plan the inventory and release and ship the order on time
  • Worked on integration to automate the creation of customer and customer sites in Oracle EBS and Oracle Cloud using Kafka Events
  • Customer and site data were initially defined in MDM, and once completed the information seamlessly flowed to both Oracle EBS and Oracle Cloud
  • Developed an integration between Oracle EBS and Oracle Cloud to automate the creation of orders for the EMEA region
  • Configured an ORDS connection within the Apex database and use REST API to transfer order data from Oracle EBS to Oracle Cloud
  • Also, the integration captures the response from Oracle Cloud and store it back in Oracle EBS
  • I worked closely with the business team to identify their challenges and delivered prompt, effective solutions
  • Previously, the shipping and planning teams spent considerable time manually calculating Oracle inventory and tracking open orders
  • I developed custom reports that automated the tracking process, enabling the teams to easily monitor open orders and inventory levels in real-time
  • This significantly reduced manual effort, saved time, and contributed to a smooth quarter-end close with zero escalations
  • Skills: Oracle EBS Order Management, SQL & Database testing, Oracle EBS Inventory (INV), XML Publisher, Shell Scripts, Web ADI, SOAP and REST API

Senior Techno-Functional Consultant

LTI INDIA
09.2019 - 06.2023
  • Company Overview: Dexcom is a company specializing in the development, manufacturing, and distribution of continuous glucose monitoring (CGM) systems for diabetes management
  • Headquartered in San Diego, California, Dexcom operates on a global scale, providing innovative health solutions for individuals managing diabetes
  • Handled month-end activities by providing support for Order Management issues and resolving Oracle Service Requests (SRs)
  • Additionally, oversaw the management of a custom interface between Salesforce and Oracle, ensuring seamless data integration and smooth operations during the month-end close process
  • Dexcom is a company specializing in the development, manufacturing, and distribution of continuous glucose monitoring (CGM) systems for diabetes management
  • Headquartered in San Diego, California, Dexcom operates on a global scale, providing innovative health solutions for individuals managing diabetes
  • Skills: SQL, PLSQL, AOL, Order Management, Receivable, SQL Developer, Oracle Accounts Payable, Unix/Linux Scripting, Classic ASP

Senior Techno-Functional Consultant

LTI INDIA
10.2018 - 11.2019
  • Oracle Integration project b/w Disney and Marvel using WebServices
  • I worked on an inbound interface for supplier and customer data and developed an XML Publisher report to display interface errors
  • Additionally, I created an outbound interface and used a web service to send data from Oracle to SAP
  • I also implemented bursting to automatically send reports via email to users as part of the web service integration
  • Skills: SQL, PLSQL, AOL, XML Publisher, Web Service and Unix, SQL Developer, Putty

Senior Techno-Functional Consultant

LTI INDIA
09.2018 - 10.2018
  • Company Overview: HD Supply is an industrial distributor in North America
  • HD supply and get access to a broad range of products and value – add services from a leading distributor of maintenance, repair and operations solutions and construction supplies
  • Materialized view created for customer and customer site
  • Materialized view created for Pricing
  • Materialized view created for Product(Item)
  • JSON Implemented through Apex
  • HD Supply is an industrial distributor in North America
  • HD supply and get access to a broad range of products and value – add services from a leading distributor of maintenance, repair and operations solutions and construction supplies
  • Skills: SQL, PLSQL, AOL, APEX, SQL Developer

Senior Techno-Functional Consultant

Supra India
12.2017 - 08.2018
  • Company Overview: Amar Ujala is a language daily newspaper published in India
  • It has 19 editions in seven states and one union territory covering 167 districts
  • Amar Ujala publishes a 16- to 18-page issue daily and also supplements focusing on matters such as careers, lifestyle, entertainment and women
  • Worked on AR Interface GST change in report and Interface Worked on Report Retro fitment 11i to R12 Worked on PO Conversation Worked on Item Conversation
  • 11i to R12 Upgrade
  • Amar Ujala is a language daily newspaper published in India
  • It has 19 editions in seven states and one union territory covering 167 districts
  • Amar Ujala publishes a 16- to 18-page issue daily and also supplements focusing on matters such as careers, lifestyle, entertainment and women
  • Skills: SQL, PLSQL, Shell Script, Purchasing, Receivables and Inventory, TOAD, PUTTY

Senior Techno-Functional Consultant

Supra India
04.2017 - 11.2017
  • Company Overview: Thales OCM UK is a UK based company having business in Aerospace, Transport, Defense and Security domains
  • Sopra Group India is responsible for functional analysis, detailed functional specification writing, test script writing, development, functional testing and system verification testing
  • Release Management, DBA and Setup activities are also carried out from Sopra Group India
  • We have a relationship with this client since 2008
  • Working on Unix Shell Script Working on Excel Layout in Bi-Publisher Working with report Data Template, Data Definition and Bursting Control File
  • Worked on PA Module
  • Worked on Purchasing
  • Worked on AP Report
  • IFRS-15 Accomplishment and 2D Barcode Implement
  • Thales OCM UK is a UK based company having business in Aerospace, Transport, Defense and Security domains
  • Sopra Group India is responsible for functional analysis, detailed functional specification writing, test script writing, development, functional testing and system verification testing
  • Release Management, DBA and Setup activities are also carried out from Sopra Group India
  • We have a relationship with this client since 2008
  • Skills: SQL, PLSQL, Shell Script, Purchasing, Payable and Project Accounting., TOAD, Putty, SVN, WinScp

Senior Techno-Functional Consultant

PWC
09.2016 - 03.2017
  • Company Overview: AT&T is an American telecommunications company, headquartered in Dallas, Texas
  • AT&T is the second largest provider of mobile services and the largest provider of fixed telephone services in the United States
  • Worked with report Data Template, Data Definition and Bursting Control File
  • Worked on Unix Shell Script and Connecting Database
  • Worked on Customer Issue and providing satisfaction via Data Base query
  • Worked on OM Module
  • Third Party Dashboard created using OAF
  • Using Oracle Application Framework created Third Party Dashboard
  • AT&T is an American telecommunications company, headquartered in Dallas, Texas
  • AT&T is the second largest provider of mobile services and the largest provider of fixed telephone services in the United States
  • Skills: SQL, PLSQL, OAF, Shell Script and OM Module., JDeveloper, Toad, Putty, SVN

Senior Techno-Functional Consultant

KPMG
09.2015 - 08.2016
  • Company Overview: KPMG in India is one of the leading providers of risk, financial & business advisory, tax & regulatory services, internal audit, and corporate governance
  • Worked on Fixed Asset Interface
  • Worked on Web Adi for creating lov and KFF Worked on AR Report Trial Balance, Invoice Summary, Invoice Register, Prepayment Report, AP PO Accrual Report
  • Worked on Intercompany Interface from AR to AP
  • Worked on GL Account Analysis Report
  • Worked on Oracle Alert
  • Worked on Account Generator Workflow
  • Account Generator Workflow successfully complete
  • KPMG in India is one of the leading providers of risk, financial & business advisory, tax & regulatory services, internal audit, and corporate governance
  • Skills: SQL, PLSQL, Workflow, WebAdi, Scripting, AR, AP, PO, FA and GL, TOAD, Putty, WinScp, XML Publisher

Senior Techno-Functional Consultant

NCR Corporation
06.2012 - 08.2013
  • Company Overview: The NCR Corporation (formerly National Cash Register) is a US-based computer Hardware, Software and Electronics Company that provides products and services that enable businesses to connect, interact and transact with their customers
  • Its main products are self-service kiosks, Automated Teller Machines, Check processing systems, Barcode Scanners, and business consumables
  • Creating packages, procedures and other database objects to meet requirement of the project/change
  • Working with report Data Template, Data Definition and Bursting Control File
  • Work on Unix Shell Script
  • Responsible for Unit Testing and Maintaining test cases of the development
  • Worked on OM Module including Internal Sales Order via Part Requirement Form and Manage Shipment Form
  • Handful Experience on UTL Files
  • SO-PO Interface
  • The NCR Corporation (formerly National Cash Register) is a US-based computer Hardware, Software and Electronics Company that provides products and services that enable businesses to connect, interact and transact with their customers
  • Its main products are self-service kiosks, Automated Teller Machines, Check processing systems, Barcode Scanners, and business consumables
  • Skills: SQL, PLSQL, Shell Script, XML Publisher, Order Management., TOAD, Putty, WinScp

Education

MCA - Computer

Sikkim Manipal University

Skills

  • Oracle EBS Order Management
  • SQL
  • Database testing
  • Oracle EBS Inventory (INV)
  • XML Publisher
  • Shell Scripts
  • Web ADI
  • SOAP
  • REST API
  • PLSQL
  • AOL
  • Receivable
  • SQL Developer
  • Oracle Accounts Payable
  • Unix/Linux Scripting
  • Classic ASP
  • APEX
  • Purchasing
  • Receivables
  • Inventory
  • TOAD
  • PUTTY
  • OAF
  • OM Module
  • JDeveloper
  • SVN
  • WinScp
  • Workflow
  • WebAdi
  • Scripting
  • AR
  • AP
  • PO
  • FA
  • GL

Certification

Oracle Finance Certification

Oracle Cloud Certification

Oracle AI Certification

Languages

English

Timeline

Senior Techno-Functional Consultant

LTI US
06.2023 - Current

Senior Techno-Functional Consultant

LTI INDIA
09.2019 - 06.2023

Senior Techno-Functional Consultant

LTI INDIA
10.2018 - 11.2019

Senior Techno-Functional Consultant

LTI INDIA
09.2018 - 10.2018

Senior Techno-Functional Consultant

Supra India
12.2017 - 08.2018

Senior Techno-Functional Consultant

Supra India
04.2017 - 11.2017

Senior Techno-Functional Consultant

PWC
09.2016 - 03.2017

Senior Techno-Functional Consultant

KPMG
09.2015 - 08.2016

Senior Techno-Functional Consultant

NCR Corporation
06.2012 - 08.2013

MCA - Computer

Sikkim Manipal University

Similar Profiles

CREATE PROFILE
Sanjay Sharma