SUMMARY

• Over 8 years of experience in the development of client/server and multi tired applications using Oracle Database, SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX.
• Worked in various levels of SDLC (System Development Life Cycle) which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
• Strong knowledge on oracle architecture and database design concepts like Normalization and ER Diagrams.
• Extensively used PL/SQL to build Oracle Packages, stored procedures, functions, triggers, cursors, ref cursors, views for processing data, enforcing referential integrity and needed business rules.
• Knowledgeable in client - server technology, GUI design, and Relational Database Management.
• Experienced with DBA activities like granting and revoking privileges on database objects.
• Experienced in Tuning SQL and PL/SQL code for better performance with large volume of data.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Worked in Manufacturing Process, Banking Information Systems, and Health Care Management domains on various applications.
• Strong Technical experience on Oracle ERP in Implementation, Support, and Maintenance of Oracle EBS 11i, R12.
• Extensively worked on AR, AP, GL, PO, INV, OM, Service Contract Manager and System Administration modules.
• Involved in oracle application Implementation, Support and Development projects.
• Proficient in AIM Methodology, involved in Client Interaction, Requirement Gathering, GAP Analysis, preparing Functional Mapping documents for customizations as well as preparing Test case scenarios.
• Very strong in full suite of Oracle tools including SQL, PL/SQL, Forms, Reports, Discoverer.
• Strong track record for developing innovative solutions and exceeding client expectations.
• Experience of Development, Interfaces & Data Conversion, Implementation, Customizations of Oracle Financial modules.
• Excellent communication and interpersonal skills.
• Self-motivated, excellent team player with proven leadership skills and ability to follow through with projects from inception to completion successfully.

TECHNICAL SKILLS

Oracle E-Business Suite 11i: (EBS 11.5.10) General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Purchasing, Inventory, Multi-Org., Service Contract Manager, AIM Methodology

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

Java/Web Technologies: J2EE, XML

Application Framework: OA Framework, ADF

Oracle Tools: Discoverer, BI/XML Publisher, Toad, Forms, Reports, SQL* Loader

Web/App Servers: ERP- Oracle Applications 12/ 11i (11.5.10, 11.5.9)

RDBMS: Oracle 10g/9i/8.i, SQL Server

IDE's: JDeveloper

OS: Unix, Windows-NT/2000

PROFESSIONAL EXPERIENCE

Confidential, Plainsboro, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• UpgradedOracle 10g to 11gsoftware in different environments for latest features and also tested databases.
• Creating new Forms (Developer 2000), Reports (Reports 10g) and writing back end procedures, function, trigger, packages (PL/SQL).
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Provide technical support for database maintenance and disaster recovery.

Environment: Oracle 10g/11g, Reports 10g/9i/6i, Forms 10g/9i/6i, Oracle applications 11i/12,BashShell, PL/SQL, SQL, Sun Solaris, OEM, SQL*Loader.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• UpgradedOracle 10g to 11gsoftware in different environments for latest features and also tested databases.
• Creating new Forms (Developer 2000), Reports (Reports 10g) and writing back end procedures, function, trigger, packages (PL/SQL).
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Provide technical support for database maintenance and disaster recovery.

Environment: Oracle 10g/11g, Reports 10g/9i/6i, Forms 10g/9i/6i, Oracle applications 11i/12,BashShell, PL/SQL, SQL, Sun Solaris, OEM, SQL*Loader.

Confidential

Oracle Developer

Responsibilities:

• Developed Stored Procedures, Function and Packages for the Financial System.
• Setup, tested and implemented new descriptive flex fields in Oracle Financials.
• Used database triggers and PL/SQL for development of system.
• Extensively used PL/SQL to write Cursors for acquiring information to be used in calculations written in stored procedures.
• Created Korne Shell scripts which act as a wrapper for various tasks like - for executing the SQL*Loader command lines, for refreshing the materialized views and for updating the Fact and the Dimension tables.
• Worked on various projects involving gap and map analysis, design and customization as per the business rules and worked on custom applications development involving.
• Load the data into Oracle 9i, Oracle High -Performance, scalable database. Change of Accounts, Currencies, Defining calendars, setup books and Multiorg setup.
• Design, development, testing and implementation of a custom billing System and order entry system. Implemented using Oracle 9i and Forms 6i.
• Developed forms to view payments, accept payments, view financial transactions, maintain and view cash assignments, view refunds, credit accounts, and transfer debit balances.
• Involved in Tuning Database & Application performance using Explain Plan, tkprof, resolving lock contentions, identifying & killing sessions.

Confidential

Oracle Developer

Responsibilities:

• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader - for different cases)
• Explain Plan, TKPROF was used for checking the performance of queries
• Modified and updated existing custom forms to adapt to new database schema
• Created SQL scripts for conversion of legacy data (including validations) and then load it into the tables
• Developed SQL*Loader programs &PL/SQL scripts to load legacy data into Oracle Apps.
• Developed reports using Reports 6i.
• Developed PL/SQL programs for various modules to validate data while importing into oracle system.
• Participated in database development like creating PL/SQL triggers, packages, procedures function.
• Handling errors using Exceptions.
• Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Wrote UNIX scripts to automate loading files into database using error handling and notification.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.

Environment: ORACLE 7.x, Reports 6i, PL/SQL, SQL Loader, SQL.

Confidential, CA

Technical Consultant

Responsibilities:

• Worked as technical consultant to provide the client with support with various issues.
• Customized custom pages using OA Framework
• Involved in customization and personalization of Service Contracts, Order Management pages.
• Created AMs, VOs, and EOs required to implement pages, regions and its items.
• Implemented multi select and quick select LOV's in various pages.
• Worked on various BC4J objects for implementing update, delete, insert, lock, and rollback.
• Involved in design, development and execution of the data conversion programs to convert Customers, AR Invoices, and Sales Orders.
• Automated the replacement order process in service contracts and created the PL/SQL report EQX AUTO REPLACEMENT using different API’S.
• Customized the Contacts Renewal process in Service Contracts
• Developed various Discoverer reports in AR, OM modules.
• Worked with XML Publisher to develop some of the reports per the requirement.
• Customized and created various PL/SQL reports in Service Contracts and AR.
• Created PL/SQL report to update the Customer Address.

Environment: Oracle Applications EBS11i (GL,AR,OM, iExpenses, Service Contract, PO), Reports 6i, XML Publisher, OA Framework, Oracle 9i (SQL, PLSQL), TOAD and SQL Loader

Confidential, CA

Technical Consultant

Responsibilities:

• Customizing Alerts to notify users of the critical events that occur in the system
• Customized the standard Printed Purchase Order Report from PO module.
• Thoroughly used Application Implementation Methodology (AIM).
• Designed and Developed Item Interface program for loading legacy items information into Inventory Item Interface table.
• Developed Migration Scripts using FNDLOAD commands to download and upload LDTs which is used to migrate all the objects from Dev instance to test and production instances
• Registration of Concurrent Programs and Request Sets in AOL and System Administration.
• Knowledge of Performance tuning of various queries and stored procedures.
• Involved in Data Conversion to Import Customer information into AR using TCA APIs

Environment: Oracle Apps EBS 11i (GL, PO, AP, OM), Reports 6i, XML Publisher, OA Framework, Oracle 9i (SQL, PLSQL), TOAD and SQL Loader

Confidential

Technical Consultant

Responsibilities:

• Involved in Data Conversions, Developing, customizing reports and interfaces in GL Module i.e. Journals importing from mainframe legacy system using SQL Loader.
• Developed customer interface program to load inventory adjustment data from external feeder system in to MTL TRANSACTION INTERFACE.
• Involved in development of PL/SQL packages, procedures and functions.
• Customized existing forms and reports and developed new forms and reports as per requirement definition in AP, Purchasing, AR and Order Mgmt modules.

Environment: Oracle Apps11i (GL, INV, AP, AR, OM), Reports 6i, forms 6i, Oracle 9i (SQL, PLSQL), TOAD and SQL Loader