PROFESSIONAL SUMMARY:

• Over 10 + years of programming experience as an Oracle Apps Technical &PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired applications using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux.
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E - Business Suite.
• Extensive experience in Oracle Applications (11.X / R12) E-Business Suite Modules in Financial (GL,AP,AR), Oracle Manufacturing & Distribution (PO, OM, INV).
• Experience in all phases of the Software Development Life Cycle (SDLC) in an ERP environment.
• Strong implementation knowledge of O2C (Order to Cash), P2P (Procure to Pay) end to end Cycles.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, Varrays, Record Types and Dynamic SQL for DML operations for better performance.
• Good experience with UTL FILE packages.
• Good working experience with UNIX shell scripting
• Proficient in Oracle 11g/10g/9i/8i, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Hands on experience in implementing RICE (Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions) components, workflows, Oracle Alerts, Lookups, OA Framework (OAF), XML Publisher Reports.
• Possess good expertise in developing programs using UTL FILE, SQL*loader, Toad and PL/SQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Expertise in implementing ETL (extract, transform and load) by using Oracle Warehouse Builder (OWB).
• Experience in development of concurrent programs, customization and modifications of reports.
• Strong familiarity with AIM methodology in creating BRD, MD-50, MD-70, MD-120 and also testing documents throughout multiple Projects.
• Good experience in deploying objects from one instance to other instance using HP PPM kintana, CVS, PVCS and AppDB

TECHNICAL SKILLS:

ERP: Oracle Apps 11i, R12.

Modules: OM, PO, INV,HRMS, AP, AR, GL

L anguages: SQL, PL/SQL, SQL Loader, Unix Shell Scripts, JSP, C, C++, JAVA/J2EE, CSS, HTML, XML, ETL.

RDBMS: Oracle 11g/10g/9i/8i, MS-SQL Server 2000/2005, Sybase, DB2 MS Access.

Tools: TOAD, SQL, Reports6i & 10g and Forms 6i & 10g, XML Publisher, Workflow Builder, OAF.

Operating Systems: Windows XP/NT/2000, HP-UX 11i, Solaris 2.x/8, AIX 5.3, OpenVMS

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Technical & PL/SQL Developer

Responsibilities:

• Providing offshore and managing team from onsite.
• Developed Stored Procedures, Functions, Packages and SQL Scripts.
• Worked on migration of data base objects from 11g to 12c
• Involved in writing Control File for SQL Loader to load sales order details into staging table.
• Developed Standard Sales Order Open Interface to upload the OM data from legacy system into Oracle Apps Base .
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and worked with exceptions handling.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Created materialized views as per the client requirement
• Developed ETL processes for Data Extraction, Data Mapping and Data Conversion using PL/SQL scripts and load data into warehouse Schemas
• Developed UNIX Shell scripts to run various utilities & wrote UNIX Cron jobs for the scheduled batch processes.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Developed data model, SQL Coding, SQL Query tuning process and Schemas

Environment: Oracle 11g, SQL, PL/SQL, SQL Loader, TOAD, UNIX, ETL, Oracle 11g, Apex, Shell, APEX, Oracle ERP R12- OM,AR, INV MS Windows 7,VISIO, CVS, PVCS and App DB

Confidential

Oracle Lead PL/SQL Developer

Responsibilities:

• Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Designed and developed various custom packages triggers and forms.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with Exception handling..
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Coding and unit testing the external interfaces
• Involved in writing Control File for SQL Loader to load PO details into staging table.
• Loaded the vendor’s information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.

Environment: Oracle ERP R12- OM,AR, PO, Oracle 9i/10g, SQL Loader, Reports 9i,forms 11g, SQL, PL/SQL, TOAD, SQL*Loader,ETL, UNIX, MS Windows XP/2000, Oracle Development Suite.

Confidential

Technical consultant

Responsibilities:

• Loaded the vendor’s information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Imported new, changed and completed sales orders from legacy system to oracle using order import(order management open interface).
• Developed Bursting file for sending Item Receipt and Inspection details to suppliers.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Developed and designed dynamic configuration wrapper in perl to generate flat fund reports.
• Provided backend support for various perl based applications.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling..

Environment: Oracle ERP R12- OM,AP, PO,Oracle 9i/10g, Report 6i,SQL, PL/SQL, TOAD, UNIX, MS Windows 7, Apex 4.2, SVN.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Preparation of documentation like MD70 & TE40 etc.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Involved in writing Control File for SQL Loader to load sales order details into staging table.
• Developed UTL FILE to extract the ASN(Advanced shipping notice ) from oracle apps standard table into text file.
• Done supplier conversion in AP module for uploading the suppliers to the oracle applications.
• Created PL/SQL Stored procedures, functions and packages as per the client requirement.
• Developed ETL processes for Data Extraction, Data Mapping and Data Conversion using PL/SQL scripts and load data into warehouse Schemas.
• Done item conversion in INV module for uploading the items to the oracle applications.
• Customized in Purchasing Document Numbering.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Part of a development team for creation and maintenance of custom apps/reports
• Implemented logic for add balance on DFF of Contract PO summary screen.

Environment: Oracle 8i, Oracle ERP 11i - PO,AP, INV, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved Migration of various Concurrent Programs From 11i to R12.
• Involved in compiling the DB Objects from 11i to R12 Instance based on coding standards.
• Aligned all DB Objects for compilation at one shot based dependencies.
• Generating LDT files with FNDLOAD utility to migrate the objects to across instances
• Prepared complete document to client for migrate the project from 11i to R12 instance.
• Registration of Concurrent programs, attaching concurrent programs to Request Groups
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Developed Involved in Registering XML Templates for Reports in R12.

Environment: Oracle ERP R12- OM, AR, PO, AP, INV, GL,. Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Delivered the components on time with quality.
• Involved in development of EDI transactions (850,856 and 810).
• Review of RICE components and testing of the custom functionality
• Created new reports and Customized standard reports in PO such as Expected Receipts Report, Printed Requisitions Report and Purchase Order Detail Report.
• Implemented the program for Merge Deliveries during packing.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Implemented the sales & budget process as for client requirement.
• Involved in customizing and developing the Reports.
• Loading Po's and generating the Sales Orders for that PO's Through Confidential EDI850 Form.
• Involved in OM transactions Up to generating Invoice and testing the data.
• Implemented PL/SQL program to validate order details before processes to sales order.

Environment: Oracle ERP R12- OM, AR, AP, INV, Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.

Confidential

Junior Developer

Responsibilities:

• Responsible for analyzing business functionality for the back end processes.
• Created PL/SQL Stored procedures, functions and packages as per the client requirement.
• Developed ETL processes for Data Extraction, Data Mapping and Data Conversion using PL/SQL scripts and load data into warehouse Schemas.
• Handled and managed customer relationship management system.
• Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.
• Involved in creating user interface Forms and adhoc reports using Oracle Forms/Reports 6i.
• Built and performed user acceptance testing on modified reports.
• Participated in performance tuning, unit test case preparation and execution.

Environment: Oracle ERP 11i- PO,AP,INV,AR,.Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000