SUMMARY:

• Proficiency in PL/SQL, RICE components for Oracle Modules - PO, AR, INV, GL, OM and AP. Worked extensively on interfaces and conversions. Worked on customization of forms and xml reports.
• Worked extensively on following SDLC concepts for design and development of Oracle Applications and products based on micro controller for about ten years, leading to problem solving ability using a step - by- step and logical approach to tackle complex and unexpected issues.
• Quality control: Ensuring the highest quality is maintained throughout the project by using tools like Kintana, PVCS, and HP Quality Centre.
• Expertise in inbound and outbound interfaces and creation of automated process using Application Program Interfaces (APIs).
• Extensively worked on Data Conversion, Migrations and Interface Programs.
• Good understanding of relational database model, work responsibilities involve creation of database objects like tables, views and synonym as per desing needs.
• Experience in the customization by extension and modification of the standard application suite using Application Object Library (AOL) on features like concurrent programs, request sets, value sets, and profiles and implemented key Oracle Application features like folder form, KFF, DFF.
• Excelling project management skills and ensure timely delivery with no compromise to quality standards of the organization.
• Proven ability to meet deadlines, sales support and write general and project related technical documents conforming to AIM methodologies.
• Knowledge of BPEL, SOA, Shell Scripting, XML Publisher, SaaS, Embedded and Telecom Technologies.

TECHNICAL SKILLS:

ERP: Oracle Apps 11i (AR, AP, GL, PO, OM, INV), R12 (GL, AR).

Database: Oracle 8,9i, 10g and 11g.

GUI: Developer 2000(Forms 6i and Reports 6i).

Tools: Kiel, IAR, AutoCAD, VC++, Microsoft Visio, ANITE’s NEMO, TOAD, SQL *PLUS, SQL *LOADER,Winscp3, Putty, HP Quality Centre, PVCS, PL/SQL Developer and Kintana.

Languages: Assembly, C++, C, PLSQL, and Shell Script.

Operating Systems: DOS, Windows, and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Richmond

Sr Oracle Applications Technical Consultant

Environment: Oracle 11g, Applications 12.0.3 (PO, GL, HRMS), reports BI Publisher.

Responsibilities:

• Design, documentation for the mentioned objects.
• Data massaging in R12 required for conversion leading to conversion of supplier, requisition and purchase order data.
• Developed Packages, Procedures and Functions to validate data in the staging tables and insert into base tables using open interfaces or API’s.
• Populate the data from legacy system to R12.
• Creation of tables, synonyms and sequences in test and dev schema as needed.
• Registering concurrent programs.
• Involved in functional setup for item category.
• Involved in the development process-Analysis, Design, Implementation, Testing
• Working in an agile Environment to deliver higher-quality software far more rapidly
• Involved in Developing Multi-Threaded logic using thread safe mechanism.
• Created SQL Stored Procedure to implement complex business logics to improve performance
• Performed Unit Testing. Technical consultant for Finance modules which includes INV, PO & AR
• Also worked in Inventory, Order Management, Quoting and Purchasing.
• Interaction with functional team for requirements and delivery
• Preparing scripts required for Data Migration from Legacy system to Oracle Applications.
• Worked on Customizations using Oracle Apps standard API & Packages
• Unit testing and System testing (with various other systems deployed in the organization) for the applications built and customization performed
• Have built custom components using PL/SQL, required for integration of Oracle Apps with the legacy system using Oracle BPEL as middleware
• Also developed BPEL Database Adapters to integrate with legacy system.
• Performance tuning of system processes to remove the bottlenecks for the system
• Created Deliverables like MD070, TE20.
• Prepared development guidelines document and review checklists

Confidential

Oracle Apps Technical Consultant

Environment: Oracle 8, applications 11.5.10 (AR, GL), forms and reports 6i

Responsibilities:

• Implement changes in reports and associated PL/SQL packages for faster retrieval of data.
• Unit and peer test of the object.
• Gather the data required to test the object and upload to test environment.
• Creation of tables, synonyms and sequences in test and dev schema as needed.
• Build the business case for a proposed solution to address the customer’s business needs.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Involved in customization of standard Oracle reports in AR, AP and GL as per client requirements using Oracle Reports.
• Registering Concurrent Program and Forms. Supporting the Issues from various customizations (forms, reports, and interfaces) during the test cycles on priority basis.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle 10g, Oracle Forms 6i, Oracle reports 6i, ADF, Applications 11.5.10 & R12 (GL and AR)

Responsibilities:

• Development of API as per the business requirement.
• Responsible to deploy the package and associated .fmb for ADF Environment.
• Worked with team member to modify the oracle form.
• Creation of tables, synonyms and sequences in test and dev schema as needed.
• Responsible for peer testing and unit testing of the objects associated with API.
• Involved in functional set up for application versions R12 - GL, AR; 11i - OM, INV.
• Development for Conversion includes moving of the data from legacy into oracle system using SQL loader.
• Documentation for MD70 as per AIM standards.
• Unit testing and peer testing of assigned objects and made use of functional set up.
• Overseeing project implementation and process changes.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Coding for the Interface programs to extract data into flat file and uploading of data files to the media application.
• Fine tuning the SQL Queries to improve the speed of program execution.
• Coordinated with users to ensure that the User Acceptance Testing is done successfully.
• Ensured the programs, scripts, procedures fully tested to ensure bug free performance.
• Design and development for using the API as per the business requirement.
• Responsible for moving of data from Legacy Systems to Oracle System using SQL *Loader and PLSQL.
• Responsible for peer testing and unit testing of the objects.
• Creation of tables, synonyms and sequences in test and dev schema as needed.
• Involved in functional set-ups
• Initiate coding standards and documentation.
• Design and documentation for host script to be developed as Common Data Loader and to implement the Error Handling Exception on the same
• Ensure team deliverables and co-ordinate with onsite and offshore team members.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Applications 11.5.10, TOAD, D2K (Reports6i, Forms6i)

Responsibilities:

• Worked on PL/SQL Procedures and Packages as part of Development.
• Development for Conversion includes moving of the data from legacy into oracle system using SQL loader.
• Documentation for MD70 as per AIM standards.
• Creation of tables, synonyms and sequences in test and dev schema as needed.
• Development and customization of Cancel Order Report using XML Publisher.
• Unit testing and peer testing of assigned objects.
• Ensure team deliverables and co-ordinate with onsite and offshore team members.
• Payroll outbound package.
• Host script file to run SQL Loader.
• Customize PO Requisition form for the requirement.
• Developed interface using PLSQL packages to import data into General Ledger for Journal Import.
• Develop the outbound package for payroll.
• Documentation as per AIM standard for host script.
• Creation of tables, synonyms and sequences in test and dev schema as needed.
• To furnish AOL and SYSADMIN tasks for respective concurrent programs.
• Unit testing and peer testing of the assigned objects.
• Creation of tables, synonyms and sequences in test and dev schema as needed.

Confidential

Support Analyst

Environment: Oracle Apps 11i

Responsibilities:

• Creation of tables, synonyms and sequences in test and dev schema as needed.
• Prepare Technical Specifications
• Develop (code) required interface between legacy systems and oracleapps11i
• Involved typically in the product extensions/custom development comprising design, development and testing of extensions to the oracle Applications Product based on customer requirement
• Implementation using AIM Methodology
• Unit testing and peer testing of the assigned objects.
• To resolve issues for raised tickets.
• Tender compliance of drive test software tools and associated equipment.
• Tender compliance of network active and passive equipment and components.
• Verification/ validation of enhancements to software tools by conducting drive tests for the principal.
• Responsible for the inventory, issue and renewal of license associated with software tools for clients.
• Statistical and qualitative analysis of speech, noise levels, echo delay, return loss, and transmission quality scores for voice and data networks.
• Liaison between the project team and data collection team for post-sales support.

Confidential

Design Engineer (Contract Employee)

Environment: 8 and 16 bit micro controller programming in C++ and assembly level language as needed.

Responsibilities:

• As a team member was aggressive about creating a simulator for Single Section Digital Axle counter System under the guidance of Managing Director.
• Validation of simulator operation by fusing code into appropriate components.
• Updating and fusing the code for coin operated payphones as per telecom standards.
• Programming LCD interface of user and billing end for the long distance phones.
• Updating and fusing the code into appropriate components.
• Individually testing the involved printed circuit boards and as a unit.
• As a team member involved in the design, testing and delivery of Winch System (2 No’s) to National Physical and Oceanographic Lab, India.
• Documenting the programming principles and flow charts for logic used.