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