We provide IT Staff Augmentation Services!

Oracle Apps Technical Consultant Resume Profile

PROFESSIONAL Summary:

  • Result oriented professional with 6 years of experience in Oracle Applications.
  • Extensive experience in the Technical aspects of Oracle Applications 11i PLSQL, SQL, Oracle Reports, Oracle Forms, Interfaces, Oracle Discoverer Admin and Oracle Discoverer Desktop.
  • Posses knowledge on XML reports and Unix Shell Scripting.
  • Hands on experience on different functionalities of Oracle Supply Chain Management Modules Purchasing, Inventory and Order Management and Oracle Financial Modules Accounts Receivables and General Ledger .
  • Real time working knowledge experience on Order to Cash and Procure to Pay cycles.
  • Working knowledge on core Oracle databases Oracle 9i/10g.
  • Good experience in using Kintana tool for migration of database objects.
  • Proficient in SQL and PL/SQL tuning techniques
  • Proficiency in end-to-end development of various Interfaces from requirement analysis to system study, designing, coding, testing, debugging, documentation and implementation.
  • Good experience in analyzing and fixing the Production issues and developement of enhancements according to the business needs.
  • Experienced in interacting with business users, offshore/Onsite teams
  • Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.
  • Capability to adapt and learn new tools and applications.
  • Keen and enthusiastic with constant desire to learn and a commitment to excel.
  • Self-starter with potential, initiative and a positive attitude

PROFESSIONAL Experience:

Confidential

Project Description:

  • A large portion of Xerox business is done in the area of supplies, which would include paper, toner, etc. Currently, all of the systems that manage all aspects of the supplies business are legacy systems. Xerox is going to replace these systems with the Oracle Financial applications suite over the next few years in a phased approach.
  • This project was developed to Re-engineer and implement Global Consumables Manufacturing in support of the CD MG group from multiple Platforms onto the Global Supply Chain Backbone Oracle instance. The Worldwide Xerox CDMG business will be on the Global Supply Chain Backbone instance over a period of time. The Scope is Global, and implementation will be multi-year implementation of Business Releases.

Oracle Apps Technical Consultant

Responsibilities:

  • Developed several stored procedures, functions and packages extensively involving with the collections and records such as PL SQL records, PL SQL tables, VARRAYs, TABLE index by binary integer, sorting the PL SQL Tables and reading them by using multiset operator, reference cursors, parameterized cursors, global temp tables, DBMS SQL Package, UTL FILE package for OM, and INV modules
  • Handled the data errors with appropriate exception handling and printing the corresponding sqlerrm and SQL code
  • Developed Part Source interfaces from current ERP system to a legacy system for both NET and FULL feeds. This also included identification of business critical fields in document and designing the solution.
  • Development of a custom package to fire Auto Invoice Master Program based on the AR grouping attributes.
  • Developed a custom Electronic Export Information EEI report which is required by the Government authorities of shipping country when shipping material to other foreign country.
  • Developed a robust solution for one of the critical month end reports required for business Gross Margin report to generate the month ending GL cogs and revenue balances. This involved pre-production extensive testing with the Functional Analyst too.
  • Writing Packages and Procedures, registering them as Concurrent Programs in Apps.
  • Scripts in PL SLQ to read file from remote server and import the lines into custom tables for Point of sale data and present the data to the users using custom forms
  • Creation of Request Sets
  • Implemented number of techniques to eliminate redundancies in the Database.
  • Documentation of Technical Design document TDD which includes all the components developed as part of the requirement packages, procedures, table creation scripts etc.
  • Preparation of Unit Test Cases, Defect logs and Issue Log
  • Providing Knowledge Transfer to the production support team on the requirements handled by me.

Confidential

Project Description:

Post acquisition of ACS, Xerox implemented the project 'ACS e-procurement project' which involved integration and rationalization of supplier base, deployment of procurements module to provide robust catalog content and easing the process of raising Purchase requisitions. Besides this resulted in synergies derived from an efficient procure to pay cycle on a common platform.

Oracle Apps Technical Consultant

Responsibilities:

  • Registration of Forms and Reports in Oracle Apps.
  • Creation of new tables, indexes, packages which are called from custom forms.
  • Developed and enhanced the custom RICE Reports, Interfaces, Conversion and Extension components as part of the upgrade.
  • Development of an interface to send daily On Hand Balances of items at sub-inventory level of an organization to a legacy system.
  • Development of Packages, Procedures, Functions and Triggers in PL/SQL.
  • Development of Reports through Report Builder.
  • Involved in fixing the issues occurred during development and testing.
  • Documentation of Technical Design documents TDD for the developed components.
  • Documentation of Unit Test Cases for the developed components
  • Involved in Migrating the components to test and production environments.
  • Involved in Integration Testing with business users of different legacy systems.
  • Played a key role in project go live activities.
  • Resolved post production issues as per the SLA
  • Conducted trainings on Oracle apps AOL components, Oracle Forms and Reports

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Involved in the complete life cycle of software development: Analysis, Design, Development, Testing and Implementation
  • Created complex validation units based on Value Sets and list of values by creating various views and tables
  • Created Value Sets and attaching those value sets to the value set name for the parameters of the report or PL SQL Packages.
  • Created Custom forms for specific users and assigned those forms to their menus to restrict their accessibility
  • Defined concurrent program and assigned to request groups
  • Created and register Tables in Oracle Application
  • Developed custom XML reports using Report 6i for generating the orders that have got the invoices. Also, validated the date columns by writing plsql script in the value set at the front end
  • Designed and developed numerous packages and procedures utilizing various seeded APIs to UPDATE task assignment status from one to other and also to load data from temporary tables into Oracle base table
  • Created DB Triggers, Functions, Packages, Stored Procedures, Views, Sequences, Synonyms at the back end using SQL and PL SQL
  • Development and Refinement of Oracle Forms functionality including navigation, Master detail Co-ordination, commit consistency, and context awareness customization of Oracle Forms including label changes, addition of fields
  • Worked on forms personalization on various oracle standard forms of modules INV, Field Service and Debrief screen as part of customization

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Involved in customizations of various Oracle manufacturing modules like Order Management, Inventory, PO, AP and AR
  • Involved in Development, Testing, Implementation and Training phases of the project
  • Created temporary tables using PL SQL and developed SQL Loader control files to load data from Legacy system into temporary tables
  • Involved in designing and developing various reusable packages and procedures which were utilized by various programs
  • Creating synonyms to mask the owner of the object and easy management of privileges.
  • Effectively handled System Administrator responsibility for creating Users, Responsibilities, Value Sets, Request Groups and Request Set
  • Created Stored Procedures at back-end and integrated them with front-end systems
  • Created and maintain custom responsibilities and menus
  • Handled exceptions in the pages for various functions involved in OM, PO, and CRM modules.
  • Developed different screens involving the use of different regions styles like LOVs, pop lists and other styles declaratively.
  • Responsible for developing and customizing reports using Reports 6i Oracle XML Publisher generating output in the format of RTF, PDF, HTML and EXCEL as per Client requirement.
  • Experience in forms personalization of Oracle standard forms and migrated them into other oracle instance using ldt file
  • Used Clear Case for Code Deployment and Mercury Kintana for Code Migration.
  • Used Test Director for Defect Tracking.

Confidential

Project Description:

Project mainly consisted of development of scheduled interfaces to source highly secured HR data from the Oracle base tables into the custom tables of the Data warehouse environment. Reporting is developed in OBIEE Oracle Business Intelligence Enterprise Edition out of these tables.

Oracle Apps Technical Consultant

Responsibilities

  • Issues are fixed based on the business criticality Critical/High/Medium/Low using the Dev Track Tool for issue logging in reference of a remedy ticket or email from the user.
  • Documentation of functional document MD70 which includes all the components that needs to be developed as part of the requirement packages, procedures, table creation scripts etc.
  • Providing support at customer site by solving bugs/problems and providing requested business information by building queries and/or extracting required data.
  • Code reviews to achieve code optimization in order to enhance performance.
  • Preparation of Unit Test Cases, Defect logs and Issue Log
  • Administrating various support and analytical activities on a regular basis.
  • Supporting Monthly outages.
  • Handled Critical Business Interfaces.
  • Performance tuning.
  • Migration among different environment Dev Test Prod using ITG Migration Kintana .
  • Enhancement based on change request mechanism of Dev Track.
  • Identify and Implement Continuous Improvement Solutions
  • Development Work on Minor Enhancement requests
  • Understand and Prepare Process Documentation for the Implemented Interfaces

Hire Now