Post Job Free
Sign in

Oracle EBS developer

Location:
Vista, CA
Posted:
July 02, 2017

Contact this candidate

Resume:

Venkateshwar Reddy Nimma Reddy

Phone: +1-424-***-****

Email: ****************@*****.***

Oracle EBS Technical Consultant

Almost 9 years of experience in Oracle Applications Releases 11.5.10.2,12.0.6,12.1.3 and R12.2.4 as a technical consultant.

Extensive experience in Implementation, Customization, Upgrade, Production Support of Oracle EBS.

Extensive experience in all phases (SDLC) of Oracle EBS Implementation with major focus in Order Management, Purchasing, Advanced Pricing, Service Requests, Service Contracts, Install Base, Payables, Receivables, Fixed Assets, Oracle Budgets, General Ledger Modules.

Extensive experience in Reports, Interfaces, Conversions and Extensions (RICE) and Configuration, Extensions and Integration

Extensive experience in developing Interfaces/Conversion Programs using SQL, PL/SQL, SQL*Loader, APIs.

Extensive experience in developing custom forms using forms 6i/10G.

Extensive experience in customizing the forms functionality using Form Personalization, Logical apps rules and Custom.pll

Extensive experience in developing custom reports and customizing standard reports using reports 6i /10G.

Expertise in System Administrator functions like Registering Concurrent Programs, Forms, Form Functions, Menus, Request Groups, Value Sets, and Responsibilities etc.

Expertise in Oracle XML Publisher and Discoverer reports.

Knowledge on UNIX Shell Scripting.

Extensive experience in creating Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Familiar with application development tools like PL/SQL Developer, SQL*Plus and TOAD

Experience in customizing workflows

Experience in creating Documentation using AIM methodology. Familiar with all the Standard Documents like MD.50, MD.70 and TE.20

Involved in production support, development and migration activities.

Experience in working with ITG Kintana/ HP PPM change management and migration tool.

Worked in teams, involved in various responsibilities like Requirement gathering, development, Unit testing and UAT

Experience in understanding the business requirement and coordinating with development team in implementing the same.

Excellent analytical, problem solving and communication skills, detail oriented with ability to be an effective team player and work under severe time constraints

Received many appreciations, certificates, prizes from client for identifying and fixing the production issues.

Domain Skills:

Oracle Order Management

Oracle Purchasing

Oracle Pricing

Service Contracts, Service Requests

Install Base

Advanced Pricing

Account Payables

Account Receivables

Oracle Budgets

Fixed Assets

AOL concepts

Oracle Application Framework(OAF)

Oracle vertex system

Export on Demand

Tools:

Oracle forms

Oracle Reports

Oracle Discoverer reports

XML Publisher Reports

Oracle workflow builder

TOAD

Oracle SQL Developer

JDeveloper for OAF

Oracle vertex system

Putty

Windows SFTP- SCP Client

PVCS

Kintana

Jira

Perforce

Data Loader

EXPERIENCE SUMMARY:

1)Employer : DJO Global, San Diego (Oct 2016 – till date)

Project

R12 Support Project

Description

This Project is for support and enhancements. Co ordinate offshore team. Oracle apps environment is R12.0.6.

Role

Technical Developer and Coordinator in onsite-offshore model.

Modules/System Involved

Oracle SCM, CRM, Financial modules and OBIEE support on EBS front

Contribution

Coordinate with the Oracle production support team by providing solutions to business issues in Oracle applications, fixes and enhancements to custom components.

Interacting with onsite for getting the requirements clarified and develop accordingly in the development environment.

Application bug fixes, enhancements and customization Setting up the causal factors and working

Development, maintenance, enhancement and customization of Oracle Reports and Forms.

Maintenance, enhancement and customization of inbound and outbound data interface programs.

Unit testing and system integration testing.

Preparing technical specification document and test cases and test result documents.

Coordinating for functional testing with functional team.

Migration of components to TST environment by coordinating with quantum database team.

Review for all offshore deliverables including:

a. Technical specifications document review

b. Code Review

b. Unit test document review

c. Migration details document review

Involved in resolving the Production issues as part of current production support

2)Employer : TCS (May 2008 – Sep 2016)

a)Client : Omnitracs LLC, Dallas

Duration : Oct 2012 – Sep 2016

Project

R12 Upgrade Project

Description

As Oracle has decided to stop their support for 11i environments, Omnitracs LLC. decided to upgrade their Oracle apps environment from R11.5.10 to R12.2.4 and current production support

Role

Technical Developer and Coordinator in onsite-offshore model.

Modules/System Involved

Oracle SCM, CRM and Financial modules, Oracle Vertex system, Demantra, Export on Demand (EOD)

Contribution

Involved in preparing 11i environment to readily available for R12 patching by coordinating with admin team in running the readiness reports and fixing the issues raised by readiness reports.

Involved in running TCS ASSAY tool to identify all the impacted custom objects that has to be retrofitted.

Involved in re-implementing the personalization in OAF forms which are mandatorily changed to OAF.

Coordinating with offshore team in compiling the custom forms and reports in 10g which are developed in 6i.

Involved in arranging the sequence of objects for migration activities.

Expertise in using the PVCS and Kintana tools for version control and migrating objects from instance to instance.

Involved in resolving the Production issues as part of current production support

Duration

17 months

Project

Production Support and Enhancements on release 11.5.10.2

Client

Omnitracs LLC.

Description

This project involves the production Support and developing Enhancements for Omnitracs LLC.

Role

Techno-functional consultant

Modules/System Involved

SCM Modules, Account Payables, Account Receivables, Fixed Assets, Oracle budgets, Oracle vertex system

Contribution

Involved in developing the sterling process (Inbound and outbound) for our suppliers to automatically create Payable Invoices in our system through inbound process and sending back the payment information through outbound process after payment completes.

Involved in developing the AR Receipt Automation program to create the receipts for intercompany process and NGB through flat file.

Involved in creating the discoverer reports to assist the business for their reconciliation and verification process.

Involved in maintaining the Oracle vertex system and owns it completely and creating exemptions according to business taxation process.

Involved in training the user to upload the customer certificates through ECM process.

Duration

3 Months

Project

XRS & Omnitracs Canada GSM

Description

XRS is a new Operating unit which is purchased by Omnitracs LLC and this project aims to maintain the XRS business similar to Omnitracs Business in Omnitracs system and Supporting the Production instance.

Role

Techno-functional consultant

Modules/System Involved

Order Management, Service Contracts, Install Base, Advance Pricing, Inventory, Account Payables, Account Receivables, Fixed Assets, Oracle vertex system, Oracle budgets, Export on Demand (EOD)

Contribution

Involved in merging the new Operating unit called “XRS”.

Involved in Development of Customers, Service Contracts, Subscription Contracts, Install Base, Advanced Pricing and Item Conversions.

Involved in development of AR interface by making it flexible to upload the invoices/CM across all operating units.

Involved in setting up the Intercompany transactions.

Involved in developing the web ADI to upload the assets monthly.

Involved in testing the interfaces to send the data (customers, products, Delivery) to Export on Demand.

Involved in development of a custom program to migrate the responsibilities from one instance to other instance by changing the OU Name which is Value Addition for Omnitracs

Involved in developing the new interface (From return to shipping) to fulfill the Canada GSM requirement.

Involved in resolving the Production issues

Converting the data required to Vertex, maintain the tax rates and updating them monthly with the data provided by vertex.

Maintaining the Tax exemptions in oracle vertex system and involved in uploading the customer exemption certificates by the business user through ECM.

Duration

6 months

Project

ROADNET and Omnitracs

Description

Roadnet is a new Operating unit which is purchased by Omnitracs LLC and this project aims to dissolve the Roadnet business application into the Omnitracs system.

Role

Techno-functional consultant

Modules/System Involved

Order Management, Service Contracts, Install Base, Advance Pricing, Inventory, Account Payables, Account Receivables, Fixed Assets, Oracle vertex system

Contribution

Involved in merging the new Operating unit called “Roadnet”.

Coordinating with the business users in understanding their business scenarios and working closely with the technical and functional team.

Involved in Development of Customers, Advanced Pricing and Item Conversions.

Involved in development of new interface to meet their business scenario especially.

Coordinated with users to get the data and maintain data in the required format to use in conversions of oracle apps system.

Involved in writing few test cases for different scenarios.

Involved in designing the complete business process from Order management to Account receivables.

Involved in resolving the issues for user in Oracle vertex system

Duration

5 Months

Project

Production Support, Enhancements and Onsite Co-ordinator

Description

This project is for Production support and identifying the un-necessary integrated systems. Vista aims at using the oracle apps as a parent system and it is replacing the third party systems by oracle applications.

Role

Techno-functional consultant

Modules/System Involved

Order management, Advanced Pricing, Service Contracts, Install Base, Service Requests, Account Receivables, Account Payables, Fixed Assets, Oracle vertex

Contribution

Coordinate with the Oracle production support team by providing solutions to business issues in Oracle applications, fixes and enhancements to custom components

Major Customization in Service Contract Module

Customers are ready to sign for the extended warranty of all the units they own in Install base.

Developed a PL/SQL Executable type concurrent program to automate the whole service contract creation to Auto approval stage.

Included all the service contracts APIs to create contract, contract line and sub line.

Then Perform the QA check. Once the QA check is successful then submits the contract for approval. Once approved the contract becomes active.

Interacting with onsite for getting the requirements clarified and develop accordingly in the development environment.

Application bug fixes, enhancements and customization Setting up the causal factors and working

Development, maintenance, enhancement and customization of Oracle Reports and Forms.

Maintenance, enhancement and customization of inbound and outbound data interface programs.

Unit testing and system integration testing.

Preparing technical specification document and test cases and test result documents.

Coordinating for functional testing with functional team.

Migration of components to TST environment by coordinating with quantum database team.

Review for all offshore deliverables including:

a. Technical specifications document review

b. Code Review

b. Unit test document review

c. Migration details document review

Preparing weekly ITG Status Update Report

Involved in writing the different interfaces and conversions.

Involved in many conversions like Customer, Supplier, Sales Order, AR Invoice conversions.

Developed many packages, procedures, functions using dynamic sql

Involved in adding the extensions to the standard form through CUSTOM.pll, logical apps and form personalization.

Involved in changing the invoice print templates.

Developed automation process to send AR Invoices to Customer email addresses.

Involved in Production support

Duration

13 months

Project

Convoy(Omnitracs Separation from Qualcomm)

Description

Convoy Project is for the separation of an operating unit from Qualcomm business to an independent instance. This project is started when Qualcomm sells their unit (VTS) to other vendor. This Project has started aggressively under strict deadlines.

Role

Technical lead at Onsite

Modules involved

Oracle Order Management, Oracle Purchasing, Oracle inventory, Oracle Pricing, Service Contracts, Service request, Install Base, AOL Concepts

Contribution

Involved in identifying the customizations that related to a particular operating unit in SCM and MFG modules.

Involved in identifying the technical objects which relates to that particular customization and segregate the list and working with the respective teams.

Involved in managing both the teams and worked closely with them by clarifying the issues.

Involved and worked with the functional team in setting up the new instance and worked with them in completing the initial setup for new instance.

Worked with the development teams to migrate the technical objects to different instances at different times.

Worked with the functional team in developing the data loader scripts for data loading into Oracle application system.

Duration

6months

b)Client: QUALCOMM INC, San Diego

Duration: May 2008 – September 2012

Project

Production Support and Enhancements

Description

The project deals with providing entire Functional, Technical and DBA Support for Omnitracs. Project provides Level 1, Level 2 and Level 3 support through problem resolution and closing the problem tickets raised in the Functional, Technical and DBA areas of OM/PO/INV/MFG/AR/AP/SERVICE Modules.

Role

Technical Developer

Responsibilities

Trade Export System Outbound Interface

R12 Upgrade: Used panaya tool to identify the affected objects from 11i to R12. Performed code retrofit of affected objects. Analyzing and suggesting the solutions to business to fill the gap between R12 features and business process.

Worked on Inbound interface

Worked on APIs for the Customer Creation process for BPEL integration.

SQL queries performance tuning to improve the run time results.

Collection Letter Print Program

RMA Receipting Validation and Defaulting Rules

Qualcomm Service Contracts Expiration Report

Complete Development of Prepaid collection letter pdf program.

Ability to Email the Collection Letter

Development of PO Email Notification program for Purchase Orders.

Developed Oracle report and XML publisher report for Quoting Module implementation based on the Quoting Sales Manager Responsibility.

Major Customization in OM Module.

HDCP Contract. (Developed three forms, also wrote utl script for the data loading into the new created tables. Applying a hold while booking the order for which a function has been added to the workflow.)

Interacting with onsite for getting the requirements clarified and develop accordingly in the development environment.

Developed the Oracle Alerts to satisfy the business requirements.

Worked on Logical Apps Rules.

Worked on Form Personalization and custom pll.

Created AOL objects as per the project requirements

Application bug fixes, enhancements and customization Setting up the causal factors and working

Development, maintenance, enhancement and customization of Oracle Reports and Forms.

Maintenance, enhancement and customization of inbound and outbound data interface programs.

Unit testing and system integration testing.

Preparing technical specification document and test cases and test result documents.

Coordinating for functional testing with functional team.

Migration of components to TST environment by coordinating with quantum database team.

Review for all offshore deliverables including:

a. Technical specifications document review

b. Code Review

b. Unit test document review

c. Migration details document review

Preparing weekly ITG Status Update Report

Experience in creating Documentation using AIM Methodology.

Significant Achievements:

1.Received many appreciations and certificate from Qualcomm for successful completion of Convoy Project.

2.Got the cash Prize from Omnitracs LLC for resolving their production issue.

Personal Information:

Name

Venkateshwar Reddy Nimma Reddy

Qualification

Master Of Computer Applications(MCA)

VISA

H1B

Nationality

India



Contact this candidate