Oracle Developer Customer Engineer

Location:

Keene, NH

Posted:

June 12, 2021

Contact this candidate

Resume:

**************@*****.***

Pavan Dama Tel: 901-***-****

Professional summary:

Oracle Procurement Cloud 2016 Certified Implementation Specialist (1Z0-327)

Around Fourteen years of extensive experience in implementing various Oracle Application related to SCM and MFG modules like OM, Oracle Advanced Pricing, Oracle Purchasing, Oracle Inventory, Oracle Shipping, Oracle BOM, Oracle AR, Oracle Payables, Oracle WIP, General Ledger, Warehouse management, Oracle iProcurement, iSupplier, Contracts, Sourcing, Spares Management, Advanced Supply chain planning.

Leader of global cross-functional teams using open communication and flexible problem-solving approach. Effectively prioritized broad range of responsibilities to consistently meet tight deadlines and achieve performance objectives.

Highly creative and innovative Oracle professional with advanced communication skills and abilities, who seeks and enjoys responsibility, a problem solver, experienced with multi-tasking and resolving complex problems.

Managed key organizational IT initiatives, such as system performance enhancement, continuous improvement initiatives, and documentation.

Expert in scoping, set-up, implementation and support of Oracle ERP (Oracle OM, Oracle Advanced Pricing, Oracle Purchasing, Oracle Inventory, Oracle Shipping, Oracle BOM, Oracle AR, Oracle Payables, General Ledger, Warehouse management, Oracle iProcurement, Oracle iSupplier and Advance Supply chain planning).

Excellent skills in Functional Requirement analysis, Application Design, Gap Analysis, Module Setup and Production Support.

Extensive experience in handling Functional & Technical responsibilities

Functional: Requirements gathering, AS-IS Study, TO-BE processes, GAP analysis, application design & configuration, test script, System Integration Testing (SIT), CRP testing, writing training manuals, training end users and production support.

Technical: Identify technical gaps, Development estimate chart, architecting system interfaces, designing custom solutions, leading development team, coding, Release rollout Plan and production support.

Utilized Oracle’s Application Implementation Method (AIM) approach, and documented the processes using the recommend AIM documentation.

Proven experience and knowledge of support processes, implementation

Provide customer support for business-critical application problems and issues, Assist in testing and deployment of solutions in production environment. Proactively work through service requests with oracle SR’s as needed.

Ownership of building working relationships with our business partners, development engineers and Problem Management teams for driving and resolution of complex issues

Manage the communications, escalations and expectations of the business as it pertains to system availability and application performance

2 years of experience on working on Python, Apache Airflow, pandas, numpy, Django Rest Framework

Technical skills:

Packages: Oracle Applications 11i, R12

Modules: Order Management (OM), Oracle Purchasing (PO), Oracle Inventory (INV), Account Receivables (AR), Spares Management (CSP), Application Object Library (AOL), Advanced supply chain planning (ASCP), iProcurement

Language Programming: SQL, PL/SQL, Shell scripting, Python,Apache Airflow,Django Rest FrameWork

Database: Oracle 11g, Oracle 12c

GUI (Forms 6i&11g & Reports 6i&11g), JDeveloper 11g, OAF personalization, ADF, CloudIO

Tools TOAD, SQL* LOADER, SQL* Plus, Oracle Forms Builder, Reports Builder, SOA

, workflow, Oracle Apex,Python, Pandas, Apache Airflow, Djano Rest Frame Work,

BI Publisher

Methodology AIM (Application Implementation Methodology)

Others Oracle XML Publisher, Functional Point counting, QTP (Automated testing Tool)

Education: B. Tech from Jawaharlal Nehru Technological University, Hyderabad, 2001 – 2005

Professional experience:

Client: C&S Wholesale Grocers, Kenne, NH Sep 2020 – Present

Role : Technical Consultant

Project : AWI OTC Project

Description: This Project is replacement of Old Legacy system and implementing of OTC functionality

Designed and implementing of Pricing Engine

Designing and developing the necessary components using Apache Airflow, Plsql and Django restframework

Developed BI Reports for Open Orders, Invoices using RTF Templates,Excel Templates

Custom OTBI reports

Knowledge on OIC

Client: C&S Wholesale Grocers, Kenne, NH Jan 2020 – Sep 2020

Role : Technical Consultant

Project : AD Processing Sytem (APS)

Description: APS is the newly developed System in which demand planning team can create, process, forecast and manage Customer Promotion data.

Designed and implemented Apache Airflow for this Project, which is workflow based design interacts with multiple systems and processing/transferring data from/to APS sytem

Developed all the necessary interfaces (ETL) only in airflow

Designed and developed all the backend business functiaonality

Co-ordinated with UI Development Team for necessary UI development

Client: C&S Wholesale Grocers, Kenne, NH Mar 2019 – Dec 2019

Role: Oracle Application Techno Functional Consultant

Project: AWI OTC Conversion Phase -1

Description: C&S Wholesale Grocers is an American wholesale distribution of food and grocery store items with its headquarters in Keene, New Hampshire, United States.

Interacted with Business users for requirements, analyzed the existing process Involved in Solution Design for different business requirements.

Lead and facilitated business user meetings to gather business requirements and documented the same in

the BR-100 using AIM methodology

Completed configurations and setups for OM, shipping, Advance pricing and Purchasing modules

Solutioning new OTC model for C&S order management

Integrating Order management with other oracle modules

Developing Functional Specs for complete project and guiding Dev and QA

Driving UAT and User Testing Sessions

Developing Customizations

Interacting & training customer partner teams

Client: C&S Wholesale Grocers, Kenne, NH Feb 2018 – Mar 2019

Role: Lead Oracle Apps Techno-Functional consultant

Project: Reclamation

Description: C&S Wholesale Grocers is an American wholesale distribution of food and grocery store items with its headquarters in Keene, New Hampshire, United States.

Reclamation Project is a new application which supports reverse logistics business of C&S Whole Sales Groceries

Interacted with Business users for requirements, analyzed the existing process Involved in Solution Design for different business requirements.

Involved in designing of the Reclamation Application

Design of Item Interface from MDM system to Reclamation application

Developed new logic for implementation of Rules that are to applied for customers and vendors

Worked on Design of Vendor Interface, customer interface

Developed logic for conversion of files generated in oracle to EBCDIC format which is used by mainframes

Developed in AR interface from this reclamation application, and processing of AR Data in EBS

Co-ordinated with various teams like (EDI, Webservices, UI, MFT, Mainframes) for successfully implementation of the Project

Product Support of the application

Developed BI Reports for scan process using RTF and Excel Templates

Client: Honeywell Intelligrated - Mason, OH Sep 2017 – Feb 2018

Role: Lead Oracle Apps Techno-Functional consultant

Project: Implementation of Product Map Project

Description: Intelligrated is a material handling automation and software engineering company based in Mason, Ohio

Responsibilities:

Interacted with Business users for requirements, analyzed the existing process Involved in Solution Design for different business requirement.

Worked as a liaison between the client and offshore teams and successfully delivered the project

Co-ordinating with offshore for development updates, clarifying the doubts in developing the necessary components based on the requirements

Performing the unit test and IT testing for developed components

Involved in providing KT to business for understanding the new functionalities and supported in CRP and UAT testing

Developed Apex form for sales order warehouse change process and BOM commoning

Created documents for technical design flow of the requirements

Setting up of PIM User roles for providing access to the specific functionalities

Customized ECO implementation for BOM update using Web ADI

Worked on PIM business events like oracle.apps.eng.ecoImplement, for changing the items from creation status to Active status.

Environment: Oracle Applications R12- 12.2.6 –Inventory (INV),O2C, P2P, Bills of Material(BOM), Order Management(OM), Oracle PIM,PL/SQL, SQL Developer, Oracle Developer Suite (Forms & Reports), Oracle APEX forms

Client: Canon – New Jersey Feb 2016 – Sep 2017

Role: Sr Oracle Apps Techno Functional Consultant

Description: Canon Inc. is a Japanese multinational corporation specialized in the manufacture of imaging and optical products, including cameras, camcorders, photocopiers, steppers, computer printers and medical equipment

Project: Implementation of Software Sales and registration process for Printers

Responsibilities:

Interacted with Business users for requirements, analysed the existing process Involved in Solution Design for different business requirement.

Prepared Business Process Document, Setup Document, Functional Document, Technical Document and Unit Test Cases/Results based on AIM Methodology

Development of software sales, Importing the orders from custom application SOM to OM

Supporting day to day issues related to the application in production

Developed reports for on hand quantity availability

Worked on drop ship PO creation and receipts creation

Supported ASCP modules,Issues like ODS load failures

Setting up the position hierarchy for PO approvals

Setup of supplier and B2B gateway for performing EDI transactions.

Environment: Oracle Applications R12- 12.1.3 – Oracle Order to Cash, Inventory (INV), PL/SQL, SQL Developer, Oracle Developer Suite (Forms & Reports), Oracle Purchase to Pay,PVCS

Client: XEROX India Limited, India Apr 2013 – Feb 2016

Role: Lead Oracle Apps Techno Functional Consultant

Xerox is the leading enterprise for Xerox machine manufacturing, business process and documentation management. It also provides the true end-to-end solutions from back office support to the printed pages to help operate the business and manage information.

Responsibilities:

Worked on Implementation of ASCP and post implementation support of ASCP, SCM and financial modules

Developed oracle alerts for sending notifications to business if a program fails.

Developed report of Inventory outlook report for ASCP module

Tuned few packages for improving the performance of the codes

Developed a program to mass update the default buyers of items at organization level

Support project on 24/7 environment

Standardized the delivery processes

One of the Point of contact for all P1 and high priority incidents

Successfully provided solutions for all production related issue and delivered fix on time and maintained 100 % SLA

Deliver the weekly status report of different applications that we support to all stake holders of the client.

We are also involved in doing enhancements which are value addition to the day-2-day business operations.

SLA reporting, ticket handling, Quality assurance, monitoring of scheduled jobs, Customer interaction and coordination for various issues

Worked on ASCP Detailed Scheduling support

Worked on issue related to ASL changes not updating properly in ASCP from EBS

Responsible for converting the orders from legacy system to ERP using the Open Interface to import data from OM interface tables into the base tables.

Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor information Base tables.

Month end coordination with business Team for Period closing and Pending Transactions Handling.

Member of a release management board,which involves the code review and performing impact analysis of the code changes so that support will go smoothly

Performed physical inventory and cycle counting of items in the warehouses

Co-ordinate with business team for testing the codes that are modified for day to day issues

Developed code for performing WIP job completion, which is interface from QAS system

Environment: Oracle E-Business Suite 11i/R12(12.1.3) Distribution/Financial ( OM, PO, INV, CSP, AOL, ASCP,WIP,BOM), Oracle Database 11g/10g/9i, Oracle XML Publisher 10g, Developer Suite 10g/6i, Solaris 10, Toad, SQL*Plus, WebLogic 11g, SQL*Loader,PVCS

Client: NCR Corporation India Pvt Ltd- India Nov 2012 – Mar 2013

Role: Senior Software Engineer

Description: NCR Corporation is the leading ATM manufacturer and Cash machines in the world. Enterprise Services deals with services provided by NCR to the customers. This project ES Release 2.1 deals with implementation of ES project in 3 countries (Japan, China and Singapore)

Responsibilities:

Prepared the F-spec and D-spec for different requirements

Prepared the Inspection log for Design Spec

Coordinated with business and prepared the necessary setup documents for different countries deployment of ES project and performed the setups in development environments testing the setups and moved them to different testing environments for business testing.

Involved in the data conversion of sales orders and item conversion

Developed a program for assigning of items from one organization to other organizations

Designed and developed various interfaces like user fetching the data for identifying the open orders for him and quantity need to be received. After fetching the necessary data perform the receipts

Designed and developed average on hand cost conversion program

Designed and Developed the EDI Transactions required for NCR and Third party logistics who maintains the NCR Sub inventory in APAC region.

Designed and developed various outbound interfaces for sending data to EDW for reporting purposes for P2P and O2C cycles

Designed and developed program for enabling an organization from locator controlled to non-locator controlled sub inventories.

Involved in Performance Testing of the ES Project using OATS tool

Supported the business testing in various phases of testing CIT,SAT

Environment: Oracle E-Business Suite R12.1.3 Distribution/Financial ( OM, PO, INV, CSP, AOL), Oracle Database 11g/10g/9i, Oracle XML Publisher 10g, Developer Suite 10g/6i, Solaris 10, Toad, SQL*Plus, SQL*Loader

Client: NCR Corporation India Pvt Ltd - India Oct 2010 – Nov 2012

Role: Senior Software Engineer

Description: NCR Corporation is the leading ATM manufacturer and Cash machines in the world. Enterprise Services deals with services provided by NCR to the customers. This project ES Release 2.0 deals with implementation of ES project in 4 countries (Hong Kong, Australia, Newzeland and Switzerland).

Responsibilities:

Prepared the F-spec and D-spec for different requirements

Prepared the Inspection log for Design Spec

Designed and Developed the conversions required for creating the Customer Engineer Addresses, Sub inventories, On hand and Average cost of items

Designed and Developed the EDI Transactions required for NCR and Third party logistics who maintains the NCR Sub inventory in APAC region.

Involved in Performance Testing of the ES Project using OATS tool

Designed and developed the Inventory onhand discrepancy report and Inventory adjustment forms between Third Party and NCR

Performed setups required for cycle count, like ABC classification setups, item organization assignments.

Travelled to Honkong for providing KT to business users along with Business Analysts

Supported the business testing in various phases of testing CIT,SAT and UAT

Active Member of Go live war room and supported the go live issues for smooth deployment

Client: NCR Corporation India Pvt Ltd - India Mar 2008 –Sep 2010

Role: Software Engineer

NCR Corporation is the leading ATM manufacturer in the world. The present project Enterprise Services deals with services provided by NCR to the customers.

Description: This project ES Release 1.0 is an upgradation of oracle application from 11i to R12

Responsibilities:

Done the Up-gradation of oracle application from 11i to R12.

Worked with API’s and interfaces.

Some of the tables are obsoleted in R12. So created views with same name to execute the existing custom code without any issue

Development of new PL/SQL programs for O2C cycle

Involved in upgradation of MOVE interface, which actual perform the inventory transactions

Ex: working on orders stuck in interface; working on flow of data from Oracle to Data warehouse; trouble shooting Unix Job failures, developed scripts to send the data from Oracle to EDW using xmlgen process which is used for reporting purposes

Performing Function Point counts for Projects/Releases

Performed Unit, SAT, CIT and UAT Tests

Active Member of Go live war room and supported the go live issues for smooth deployment

Environment: Oracle E-Business Suite R12.1.3 Distribution/Financial ( OM, PO, INV, CSP, AOL, AP, AR), Oracle Database 11g/10g/9i, Oracle XML Publisher 10g, Developer Suite 10g/6i, Solaris 10, Toad, SQL*Plus, SQL*Loader),SVN

Client: TANGENT IT SOLUTIONS, India Jun 2007 – Feb 2008

Role: Oracle Apps Technical Consultant

Development and implementation of Oracle 11i Manufacturing/Financial applications

This Project is to automate and standardize Purchase Order for Direct procurement process in Asia for Seagate. This project was developed in Forms 6i, Reports 6i and PL/SQL project integrated with Oracle Applications Purchase Order Module.

Responsibilities:

As an Associative consultant, am responsible for the following:

Involved mainly in the implementation and customization of the tasks related to the Oracle Purchase Order module.

Reports have been developed to furnish information as required by the client for reporting and generated customized reports using Reports Builder.

Worked with Form builder to modify and create the forms, record groups, libraries, menus and giving access to them by using maintain security.

Customized PO forms according to the client specs like adding check boxes, radio buttons, disabling certain fields.

Worked with PL/SQL for hide/unhide the fields, set the default values, data validations and implementation as business rules.

Query Tuning to run reports/scripts faster

Environment: Oracle Applications 11i (OM, INV, PO, AOL), PL/SQL, Developer 2000, TOAD and HP-UX.

Client: TANGENT IT SOLUTIONS, India Feb 2006 – May 2007

Role: Oracle Apps Developer

Development and implementation of Oracle 11i Manufacturing/Financial applications

Agropur Cooperative Agro-Alimentaire. The Group's principal activities are to process and market dairy products within a regulated raw milk-sourcing environment. Industrial cheese, fine cheese, yogurt and products associated with fluid milk are the major products of the Group. The products are distributed to major Canadian food chains and industrial customers. The Group is a dairy Co-operative that operates through its subsidiaries Natrel Inc and Ultima Food Inc. This project is basically Implemented Manufacturing and Financial modules for their requirements. Data Conversion, Customization of forms using form builder, Customization of standard reports and developing new reports using report builder

Responsibilities:

As an Associate consultant, was responsible for the following:

Extensively Worked in Oracle Applications Standard Reports Customization

Worked with Form builder to modify and create the forms, record groups, libraries, menus and giving access to them by using maintain security.

Customized forms according to the client specs like adding check boxes, radio buttons, disabling certain fields.

I worked with PL/SQL for hide/unhide the fields, set the default values, data validations and implementation as business rules.

Developed Packages and Procedures and Functions to convert the Legacy data to new Oracle System

Developed PL/SQL programs using UTL_FILE package to generate output files.

Worked with the designing of inbound and outbound interfaces like move the data from flat files to Oracle Applications tables and make the data from Oracle Applications tables to flat files with the combination of PL/SQL and SQL*Loader.

Environment: Oracle Applications 11i (OM, INV, PO, AOL), PL/SQL, Developer 2000, TOAD and HP-UX.

Client: EXERT INFOTECH, India Aug 2005 – Jan 2006

Role: Oracle Developer

The System automates the complete warehouse management integrated with bar code technology starting from the Receipt of Goods till the Goods are shipped out. Inventories are tracked, based on barcode technology. Real time stock status & updation. Validates the date of the cargo receipt against the delivery due date in the with regard to the preferred location for binning. Allows the user to transfer/reserve stock from one customer/project to another. Keeps track of the movement of items on a real time basis.

Responsibilities:

As a Programmer was responsible for the following

Played a major role to develop custom screens in the Forms 6i

Developing various reports as per customer requirements.

Developing backend Procedures, Functions, Triggers etc.

Environment: Windows XP Workstations, Windows 2003 Server, Oracle 9i Databases, Oracle Forms/Reports 6i.

Contact this candidate