SUMMARY:

• Around 12 years of IT experience in software development, maintenance and support of various web based applications using Oracle 10G/11G, Pl/Sql, Forms, Reports, Pro*c, Oracle ERP.
• Expertise in Interfaces, Conversions, Customizations and Extensions in Oracle Applications.
• Ability to work on completely custom applications.
• Extensive experience in Oracle 8i/9i/10g/11g/12c, PL/SQL, SQL and SQL*Loader.
• Extensively worked on Forms Personalization’s.
• Having good exposure on PL/SQL advanced concepts like collections, varrays, nested tables, bulk collect, table type objects, REF cursors etc.
• Hands on experience with cursors and ref cursors for PL/SQL objects
• Experienced in using Tables, Views, Complex views, Synonyms, Indexes, Sequences, Constraints, Functional Based index, External tables, DB links.
• Involved in activities including requirement analysis, design, coding, testing and implementation of business logic using PL/SQL technologies.
• Ability to support and assistance development team in the design and development
• Peer review of PL/SQL code and shared effective feedback to the team members.
• Good knowledge on Object Oriented Concepts, java/j2EE technologies, Oracle Applications.
• Experience on Unix & shell scripting
• Having the good knowledge on Banking and financial domain
• Have experience in Customization of Oracle Application features.
• Proficient in writing PL/SQL Stored Procedures, Functions, Packages and Triggers.
• Strong Conceptual, Analytical and problem solving skills. Highly motivated team player with immense ability to grasp new concepts and apply them.
• Excellent verbal, written, communication and presentation skills.
• Highly proficient in creating Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Technical Detailed Design Documents.
• Adept at Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle database environments
• Work Experience in RICE Components, OAF, SQL, PL/SQL, Performance Tunning, AOL,SQL Loader, Unix Shell Scripting, Oracle Reports 10g, Oracle Forms, D2K, Data Conversion, Concurrent Program API’s.

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications (PO, INV, OM,PA)

Operating Systems: Unix, Linux, Windows XP/7.

Languages: SQL, PL/SQL, C, C++, HTML, JavaScript

Databases: Oracle 8i/9i/10g/11g/12c

Tools: Oracle Forms 6i, Reports 6i, TOAD, SQL*Plus, SQL*Loader, Data loader, Kintana, PVCS, Quality Center, Putty

Utilities: MS - Office (Word, Excel, Outlooks)

Scripting Language: Shell, Java Script

WORK EXPERIENCE:

Confidential, Red Wood City, CA

Product Development, Support, Upgrade, Implementation

Responsibilities:

• Created data conversion script.
• Created custom FORM for Events entry.
• Developed API for PCI compliance for payment security.
• Developed Notification reports.
• Designing Technical Design Documents as per the requirements
• Developed Custom reports.
• Developed Custom API for Invoice Notifications and creation.
• Done the database analysis to map legacy system in new system.
• Created custom FORMS as per the requirement.
• Used SQL loader and Data loader tool to upload data from legacy system to new system.
• Creating unit test case and testing the same as Per Functional specification.

Data Modeler

Responsibilities:

• Designed daily load of feed data using oracle technologies (Job Scheduler, PL/SQL, SQL-Loader).
• Successfully designed and implemented daily data transfer from internal and external systems through various technologies.
• Managed the project with offshore and onsite resources.
• Involved in the design and implementation of data architecture for the OLTP and Data transformations.
• Preparation and execution of Unit Test Cases
• Involved in writing PL/SQL blocks which implement business logic.
• Involved in code reviews for the code written by other team members.
• Involved in Exporting and Importing tables.
• Coding and resolving defects raised by QA.

Oracle Apps Technical Consultant

Responsibilities:

• Requirement analysis
• Prepared installation documents for the conversions done with detailed step-to-step procedure for implementing the conversions.
• Participated in team meetings and provided valuable inputs towards the implementation of the conversions.
• Involved in the setting up of a new team offshore and onsite.
• Using SQL Loader, loading the data from Old System to New System and performingData validation on staging tables then loading into main tables.
• Preparation of FD review check list, Technical Design Document,
• Coding and resolving defects raised by QA team using Quality Center
• Creation of Kintana Packages for the migration of code to various test environments.
• Creation of Custom Form for environment verification automation program using the concept of advance PLSQL for verifying new database instance.
• Developed SQL script for creating Responsibilities, request group and for enabling and disabling concurrent program from the backend.
• Creation of API for OM and PO business setup.
• Done the Form personalization for OM.
• Used SQL Loader extensively to load data.
• Used FNDLOAD for Deploying Responsibility, Menu and Concurrent Program.
• Creation of API for custom OM and INV process.
• Redesigning the existing standard Reports using XML Publisher.
• Analysis of the changed functionality of R12 and comparing with the existing functionality, analyzing the impact of up gradation of existing customizations of Cisco.
• Designing Technical Design Documents as per the requirements.
• Testing the same as Per Functional specification.
• Prepare Test Case and Test Reports.
• Migration of the developed Objects.

Oracle Apps Technical Consultant

Responsibilities:

• Developed custom alerts for PO, HRMS, OM and INV modules.
• Developed custom packages to upload data from legacy system to Oracle.
• Created data abstract to fetch data for others applications so for that write complexquery.
• Developed Inbound and Outbound interface for PO.
• Created custom reports using XML publisher.
• Developed functions, procedures, Packages and triggers.
• Writing Oracle PL/SQL Stored Procedures (Procedures, Functions, Packages).
• Upload the data using SQL Loader.
• Used FNDLOAD for migrating custom alerts and concurrent program.
• Designed Technical Design Documents based upon the BRD100.
• Testing the custom objects as Per Functional specification.
• Prepared Test Cases and Test Reports.
• Migration of the developed Objects.

Software Developer

Responsibilities:

• Developed all forms of objects (Table, View, Triggers, Stored Procedures, SQL-Loader, etc).
• Writing Oracle PL/SQL Stored Procedures.
• Created both the Physical and Logical Data Model.
• Development of forms /Reports.
• Coordinated and worked in the design with global teams to create Database with new Database Architecture in Oracle 9i from multiple database systems.
• Created both the Physical and Logical Data Model.
• Prepared BRD for the maintenance system.