Oracle Data
Resume:
Sanjay Sharma
********@*****.***
Irvine, CA
Profile
** ***** ** ********** ** Oracle E-Business Suite Analysis, Design, Development, Implementation, Upgradation, Testing and Maintenance of Oracle Applications (R12/11i).
Experience in Development, Implementation, and Migration, and Support projects for Oracle SCM (OM, INV, BOM, WIP, AME, and PO) and TCA for Customer, and financial modules (AP, AR)
Experience in Oracle Integrated Cloud service (OICS) and Integration using DBCS
Experience in creating custom API, exposing API as webservice using Integrated SOA gateway and Integrating EBS with other ERP system or 3rd party system via Oracle Integrated Cloud (OIC)
Experience in SOAP and REST APi for Integration and export and Import data between SaaS applications
Knowledge of Dell Boomi and Mulesoft/Anypoint
Versatile technically in Oracle applications including Oracle SQL, Pl/Sql, Forms and Reports, BI Publishers, Business Event, Oracle Workflow, AOL, UNIX shell scripting, AME, and Form Personalizations.
Proficient in Toad, SQL Developer, SQL* Plus and SQL*Loader
Technical and Functional knowledge in Order-to-cash and procure-to-pay flows in Oracle ERP and Oracle ERP Cloud
Good understanding of Oracle Cloud Infrastructure (OCI).
Experience in developing BIP Reports and OTBI Reports and Scheduling ESS and BIP jobs
Good knowledge of Multi Organizations Access Control (MOAC) in Oracle R12
Good knowledge of other programming language like Java, JavaScripts, Python, HTML and XML, JSON
Rich experience on the RICE components (Reports, Interfaces, Customization and Extensions of Oracle Applications R12 and 11i)
Extensively used API’s in Data conversions/migrations, validate, error trapping, loading processes.
Full life cycle O2C implementation going through Development (Dev), Conference room pilot (CRP), User acceptance Testing (UAT) and production, user training, go-live and post go-live support in multi org environment
Hands on experience in data conversion from legacy applications to EBS R12 using Open Interface, API and custom SQL/PLSQL Scripts.
Expertise in writing script for bulk data load and query tuning for optimal performance.
Ability to learn and adapt to new technologies, good team player in dynamic group work environments and self-motivated to work independently.
Knowledge of Cloud computing and data analytics
Amazon Web Services (AWS)
Certification
**Oracle Certified Specialist**
**Oracle Certified Professional**
Professional Experience
Sep’18 – Till Date Oracle Technical Analyst RTJ Compuquest Dba Apolis
Client : Apolis, Irvine, CA (Oct 2020 - Till date)
Project : Oracle Fusion Cloud 20C
Role : Oracle Technical Consultant
This is the inhouse project at Apolis, Working on multiple initiative of Oracle Fustion/Erp Cloud and Oracle Infrastructure Cloud.
Environment: Oracle Fusion Cloud, SCM Modules
Responsibilities:
Worked on MuleSoft/Any point to integrate Oracle ERP Cloud for FBDI uploads for Items
Developed BIP records and create Custom ESS to generate PDF report for daily status monitoring for open invoices and balances
Worked on Conversion of Purchase Order
Integration between on-premise system with Oracle Cloud using MuleSoft
Client : Youngs Market Company/Tustin, CA (Sep 2018– Oct 2020)
Project : R12.2.5 Production Support/Enhancement Project/ Oracle Fusion Cloud 20C
Role : Technical Consultant/Developer
Youngs Market Company distributes alcoholics beverages in California, Oregon, Washington, Arizona and Idaho.
In this project I was involved in rolling out ERP system for PNW states like Washington and Oregon
Environment: Oracle Application R12.2.5 SCM (INV, PO, OM, AR, Pricing, Oracle Incentive Compensation), Toad, UNIX, Workflow Builder, Automatic job scheduling
Responsibilities:
Design and develop integrations in OIC to Oracle SCM Cloud including making REST calls, FBDI File Uploads.
Design and develop integrations in OIC to Oracle SCM Cloud including extracting Oracle SCM Cloud data using BI Publisher reports, analysis and OTBI Reports.
Developed reports using BI Publisher (BIP) in Oracle ERP Cloud
Helped in development of OTBI reports for daily Orders status and reporting
Create custom API for Order Import Process and use it for parallel execution of Order Import process.
Worked on workday HRMS to Oracle ERP Interface and enhanced the program to handle multiple employee hierarchy Import.
Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
Implemented several custom logics using Form personalization.
Created data extract program to collected master data like Item, Pricing, qualifier, modifiers, AR payments/balance etc. from Oracle ERP and schedule it to run daily to send data to Data Warehouse
Creating code deployment scripts using Unix shell script
Worked on customizing Oracle Incentive Compensation as per invoice Model, created custom API and calling it from the pre-notification
Developed BI reports for Oracle Incentive Compensation commission reconciliation, Open PO, Order Import etc. Exception for Business
Aug’10 – Sep’18 Technical Team Lead /Technical Consultant IBM India Pvt. Ltd.
Client : ICU Medical /San Jose, CA (Aug 2017– Nov 2018)
Project : R12.2.5 Implementation/Oracle Cloud (PaaS)
Role : Technical Lead
ICU Medical, Inc., a San Clemente, California-based company, is one of the world's leading pure-play infusion therapy companies with global operations and a wide-ranging product portfolio that includes IV solutions, IV smart pumps
The Project was involved in conversion of legacy data, development and implementation of custom interfaces, Reports and Forms.
Environment: Oracle Application R12.2.5(OM, PO, CRM, CSI), SQL*Loader, Toad, UNIX, Workflow Builder, Report Builder 10g, Form Builder 10g, XML publisher.
Responsibilities:
Work with client to understand AS-IS process and map with Oracle standard.
Working with Business to create functional specification
Design and develop Interface between EBS and 123C(GCM) system using Oracle Integrated Cloud Service (OIC), Integrated SOA Gateway and REST Webservices.
Integration work involve Data and field mapping between EBS and 123C system. Automated the system to trigger the data transfer using Oracle Integrated Cloud Services (OIC).
Create Workflows and Integrated it with Business Event and used it in Integration via OIC to transfer data from EBS to 123C system
Create high level design for Business process.
Design and develop Service PCI/PVT form.
Provide Fit-Gap analysis and propose Oracle solution.
Review Functional design and propose optimal solution
Design and develop solution in Oracle, using pl/sql, AOL and database.
Develop reports in BI Publisher
Prepared and execute test scripts
Design & Develop Integration solution between EBS and Salesforce 123C system via Oracle Integrated Cloud Services (OIC)
Prepared and reviewed Technical design document
Working on EBS to third party Integration using Oracle Integrated Cloud Service (OIC).
Design mapping in OIC and build integration between two external system
Worked on Install Base Conversion: Converting legacy data from SAP to Oracle.
Working on Business Event and integration with workflow to generate data required for outbound interface.
Client : Google/San Jose, CA (Jul 2016 – Aug 2017)
Project : Oracle ERP 11.5.10 Support / Upgrade to R12.2.5
Role : O2C/P2P Lead Consultant
Google is an American multinational technology company specializing in Internet-related services and products. These include online advertising technologies, search, cloud computing, software, and hardware.
Google AMS project, 11.5.10 production support project where we are supporting Google production environment and few other integrated applications with Oracle. Google later upgraded from 11.5.10 to R12.2.5 version
Environment: Oracle11i/R12, Forms6i, Reports 6i, AR, INV, OM, PO, Forms6i, Reports6i, PL/SQL
Responsibilities:
Worked as a Technical Team Lead for SCM and OTC track
Worked extensively in process improvement, production bug fixes and enhancement requirement
Worked on production issue, do root cause analysis, and provide fixed for the issues
Analyze and perform bug fixes for identified code issues
Design and implement complex process to reduce production issues to gain more customer satisfaction.
Tracking and fixing defects logged by business owners.
Development and update of technical design and migration documents (MD070 and MD120).
Client : Pearson/Kolkata – WB, India (Jul 2015 – Jul 2016)
Project : Oracle ERP R12.2.4 Implementation
Role : Lead Consultant
Pearson Education is a British-owned education publishing and assessment service to schools and corporations, as well as directly to students
Pearson R12 Implementation project is an Oracle ERP 12.2.4 implementation project for UK region. It has around 600 RICE components distributed across Conversion, Interface, Extension, Reports, and OBIEE etc. Implementation was rolled out in phases started with UK, followed by US and SA and other regions
Environment: Oracle ERP R12.2.4(PO, OM, BOM, AR), UNIX, PL/SQL, SQL Plus, Reports, Forms, Workflow, Business Event.
Responsibilities:
Review FS for design and suggest best solution
Review and create Technical Specification
Responsible for development delivery. Design, develop, review and deliver technical component.
Developed extension on Oracle Alert, Workflow, hook and AME etc.
Leading and Mentoring Team
Functional / Technical analysis of existing business process flow.
Customization of Sales Order workflow to include complex business requirement for hold check, order restriction and eligibility check, BOM explosion.
Integrated Business Event with Sales Order line workflow to explode BOMs for eligible Orders
Developed and configured AME for expense workflow.
Worked extensively on form personalization on AP invoices, Sales Order Form
Developed complex PL/SQL packages, procedures, functions for program to import bank account.
Lead a team of extension and manage delivery of extension objects.
Development and update of technical design and migration documents (MD070 and MD120).
Client : Toshiba Global Commerce Solution (TGCS)/RTP, NC (Nov 2013 – Jun 2015)
Project : Oracle ERP R12.2.4 Implementation
Role : Technical Consultant
Toshiba Global Commerce Solution Plan B Implementation project was an R12 implementation projects with around 800 custom components. This implementation was planned in phases with identified objects in each phase. It was a global implementation.
Environment: Oracle ERP R12.2.4, UNIX, PL/SQL, SQL Plus, Reports, BI Publisher,
Responsibilities:
Creating and reviewing MD070s for technical components
Responsible for Code delivery, reviewing technical design
Developed complex AR reconciliation report
Developed complex pl/sql program to generate accounting for few identified sources like Service Contract and Sales Order and insert/update segments into interface table.
Worked extensively in Install base conversion program. Worked on complex logic to integrated various sources and create single record in Oracle merging other sources.
Worked on Oracle data transformation tool (OEDQ) to clean data from legacy system and bring to Oracle for further conversion.
Worked on Install base Web ADI to merge various install base records for cleanup.
Created custom Indexes, tables, APIs for conversion
Worked on performance tuning for complex sql code
Client : NetApp/Sunnyvale, CA (Apr 2011 – Nov 2013)
Project : Oracle R12.2.4 Support
Role : Technical Consultant
NetApp is an American hybrid cloud data services and data storage and management company. At NetApp I was involved in production support.
Environment: Oracle ERP R12.2.4(OM, PO, AP, AR, INV, BOM), UNIX, PL/SQL, SQL Plus, Reports, Forms
Responsibilities:
Production ticket analysis and fixes
Design and developed highly configurable Alert monitoring utility, using unix shell script, sql scripts and Oracle Application lookup.
Worked on root cause of production issue, propose potential fixes, develop optimal solution to stop recurrence of issue on Production.
Worked extensively in pl/sql, form personalization, AOL objects, forms customization and reports.
Worked on various B2B messaging system like 3B2, 3B13, 3B11,3B3(POD) etc.
Prepared data fixes for transactions which got stuck due to system or operational issue. Like serial number data fixes when Menlo send invalid serial number.
Worked on B2B integration system and worked closely with Contract Manufactures and Logistics and make sure transactions are completed and accounted in Oracle.
Worked as Incident manager in P0 and P1 calls
Worked directly with Business user to discuss on process improvement opportunities
Worked on month end and year end period closure activities, like Order reconciliation, make sure AR transactions are closed (no unclosed transaction). Order shipment/fulfillment falls in the closing period
Lead and mentor a team of 8 members for Innovation. Developed Alert monitoring tool as a part for innovation initiative.
Client : Michelin Tire/Kolkata, WB (Aug 2010 – Mar 2011)
Project : R12 Re-Implementation
Role : Technical Consultant
Michelin was using 11i version and they switched to R12.1. The project required to understand the existing customization and business processes and then re-implement them on R12. Project customization was identified in portable, major, minor and new categories. For portable objects, we validated and moved the custom object straight to R12.
Environment: Oracle 11i/R12 (OM, PO, INV, AR, AP), UNIX, PL/SQL, SQL Plus, Reports, Forms, Workflow
Responsibilities:
Prepared Technical Design of the identified Functional gap
Worked extensively on form personalization (like sales order, inventory and PO form etc), reporting with BI Publisher
Worked on PO print report and modified it using BI publisher.
Converted various rdf reports to BI publisher reports
Prepare understanding document and Technical Overview document
Build and Deliver the Custom Component
Prepare Unit Test Plans, code pack, migration script in unix shell script
Feb 08 – Aug 10, Technology Lead Infosys Technologies, B’lore, India
Client :Toyota Kirloskar /Bangalore, KA (Aug 2009 – Aug 2020)
Project : Oracle ERP 11.5.10 Support
Role : R12 SCM Technical Consultant
Toyota Kirloskar Motor Pvt Ltd is a subsidiary of Toyota Motor Corporation of Japan with Kirloskar Group, for the manufacture and sales of Toyota cars in India
This was a Production Support Project in Oracle Applications. The support included bug fixing and enhancement of Oracle Application custom components. Mainly OTC, PTC, INV, BOM, WIP, Finance (AP, AR, GL) etc modules were supported. The production support involved various kinds of activities like: Post Production Requests (PPR, bug fixing), System Change Requests (SCR, Enhancement), Data Modification Request (DMR, database modification), One-Off (study and analyse) and adhoc activities (sql queries).
Environment: Oracle 11i, UNIX, PL/SQL, SQL Plus, Reports, Forms, Workflow, Business Event.
Responsibilities:
Technical Design of the identified Functional gap
Resolving Production issue
Work with Business user, understand issue, propose workaround, replicate issue, analyze and fix production issues.
Resolving issues in adherence to SLA
Process understanding and documentation for each type of request: Production Problem, Service Change and Data migration request.
Release Management: to control the version of code for the enter team
Suggesting workaround wherever required.
Release Code for change, Code fix, review code, Migrate Code, Daily Monitoring activity etc., are few other Production activities.
Skill used: Workflow, Form Personalization, PlSQL, Sql queries, RDF & XML report, Discoverer reports
Client :AFC (Al futtaim Carillion) /Bangalore, KA (Mar 2009 – Aug 2009)
Project : R12 HRMS Implementation
Role : Oracle Consultant
AFC is Dubai based electrical/electronic manufacturing company.
This project was an implementation project, which included Core HR, Payroll, Workforce Management, iRecruitment, OLM, Compensation Workbench etc. The implementation was done in two phases: Phase I for Core Hr and Payroll related modules and Phase II for all imodules
Environment: Oracle ERP R12.1, UNIX, PL/SQL, SQL Plus, Microsoft Visio
Responsibilities:
Payroll reports using discoverer
Prepare business process and oracle fitment diagram using Visio for OLM module.
Thorough understanding of client requirement.
Identifying Gaps and Mapping To-be processes and Oracle HRMS processes.
Create functional and technical design document.
Good Understanding of Oracle Learning Management Processes
Design AME for OLM.
Personalization, SIT & EIT design
Security design and configuration using Security profile
Fndload scripts for moving personalization, responsibility, menu etc from instance to instance.
Prepare CRP script, setup and configure instance for CRP, UAT
Prepared and executed Test scripts.
Client : KNPC (Kuwait National Petroleum Company)/Bangalore, KA (Jun 2008 – Nov 2008)
Project : Blueprint/Consulting project
Role : Oracle Functional Consultant
The Kuwait National Petroleum Company is the national oil refining company of Kuwait.
KNPC HCM Blueprinting was a consulting project, where Infosys had to study KNPC As-Is HR Business Process, map re-engineered KNPC HR processes to Oracle HRMS, Identify Gaps, and workaround and suggest a road-map for Oracle HRMS System (Blue-printing)
Environment: Oracle ERP R12.1 (HRMS, OLM)
Responsibilities:
Prepare business process and oracle fitment diagram using Visio.
Module Inter-Integration within Oracle HRMS
Through understanding of client As-Is processes
Identifying Gaps and Mapping To-be processes and Oracle HRMS processes.
Create functional and technical design document.
Good Understanding of Oracle Learning Management Processes
Configure CRP environment
Documenting BR100, Future HRMS Process, MD050s, MD070s
Oct 04 – Feb 08, Senior Software Engineer HCL Technologies, Bangalore, India
Client : Halifax Bank of Scotland/Bangalore, KA (Aug 2007 – Feb 2008)
Project : Support/Enhancement
Role : Oracle Developer
Halifax is a British banking brand operating as a trading division of Bank of Scotland, itself a wholly owned subsidiary of Lloyds Banking Group
This Winexcel/Oracle 9i is support/enhancement project, I was involved in solving Oracle related production issues
Environment: Oracle 9i, UNIX, PL/SQL, SQL Plus
Responsibilities:
Good Understanding of Client Application and interfaces
Debugging and fixing PL/SQL, SQL code
Preparing automated script for re-importing failed data in database.
Fixing Oracle database related issues like data missing and re-import, checking user configuration
Identifying the root cause and providing resolution
Regenerating problem in test environment
Responsible for analyzing the problem in application, proposing fix to client, fixing, testing and implementing the code change.
Providing resolution for the live defects.
Client : Halifax Bank of Scotland/Halifax, West Yorkshire (Jan 2006 – Aug 2007)
Project : Support/Enhancement
Role : Oracle Developer
Halifax is a British banking brand operating as a trading division of Bank of Scotland, itself a wholly owned subsidiary of Lloyds Banking Group
This Winexcel/Oracle 9i is support/enhancement project, I was involved in solving Oracle related production issues
Environment: Oracle 9i UNIX, PL/SQL, SQL Plus
Responsibilities:
Good understanding of several HBOS application
Analyze problem and provide resolution within few hours
Debugging and Fixing PL/SQL, SQL code
Fixing ORA related error, importing missing data, creating, and configuring user in oracle database
Creating import and export sql script
Sometime used sql loader to import data from the flat file.
Remotely accessing user pc and server for problem fixing and debugging.
Client : Reshmi Cement/Kolkata, WB (May 2005 – Oct 2005)
Project : Oracle ERP 11.5.9 Implementation
Role : Oracle Developer
Reshmi cement is one of the fasted growing business conglomerates in the easter region of india.
It was an implementation project that for SCM and Financial modules.
Environment: Oracle ERP 11.5.9 (OM, PO, INV, AR, AP), UNIX, PL/SQL, SQL Plus, Reports, Forms.
Responsibilities:
Responsible for creating inventory extension for Rashmi Cement
Responsible for standard forms and reports customization.
Develop inventory dashboard form from scratch using Template.fmb, and created critical FIFO method modeling.
Creating Few Descriptive Flexfield, and Value Sets
Procedures for populating RG Part I Report for Finish goods, RG 23 A Part I for Raw Materials
Created Report like Form IV for non-excisable goods and Items Expense Report
Using Inventory Open Interface for integrating inventory Dashboard with RG registers.
EDUCATION:
Bachelor of Engineering (Electronics and Telecommunication), Amravati University, Amravati, Maharashtra, India
Contact this candidate