SUMMARY

• Over 7 years of experience in design, development, testing and implementation as ORACLE PL/SQL DEVELOPER.
• Expert level experience in Oracle 11g, 10g, 9.x, 8.x, 7.x, MS SQL Server 2000/2005.
• Programming experience in Oracle 11g, 10g/9i/8i, Developer 2k, SQL, PL/SQL.
• Specialized in writing packages, stored procedures, functions and database triggers using SQL and PL/SQL in oracle.
• Extensively used Export, Import, SQL*Loader and PL/SQL UTL FILE to load bulk data.
• Strong in using tools such as PL/SQL developer, TOAD, Aqua Data Studio 4.7 and SQL*Plus.
• Exposure to the entire process of Software Development Life Cycle.
• Created UNIX shell scripts for the automating the routine jobs.
• Experience in System maintenance, analysis and performance in Windows, UNIX environment.
• Expert in using Ref - cursors, Collections and Bulk Collects for memory intensive processes and to improve traceability
• Experienced in Extraction, Transformation, Loading process tool (ETL).
• Experienced in report templates using Crystal Report arts as per company standards.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Proficient in preparing database designs to support the reporting requirements.
• Experience in writing complex SQL Queries, created materialized views, used complex INNER and OUTER JOINS for Reports.
• Proficient in import/export using Oracle Datapump.
• Experience in Testing, Debugging and Deployment of application.
• Expert in data extraction, data migration and Data loading.
• Experience related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using DataStage.
• Involved in helping QA Team in Managing Test plans and testing the application using Test Director and Win Runner and QTP.
• Strong Domain knowledge of Insurance, Financial and Automobile Industries.
• Worked on 24*7 environments to provide production support.
• Excellent communication skills and ability to work individually and as a member of a team.

TECHNICAL SKILLS

• Sun Solaris 8.0 / 9.0
• Unix
• Windows 9x / 2000 / NT
• MS-DOS
• SQL
• PL/SQL
• C
• C++
• Java
• HTML
• XML
• Pro*C
• Perl and UNIX
• Oracle 10g / 9i / 8i / 7.x
• MS SQL Server 2000/2005
• MS Access
• Visual Basic 6.0
• Developer 2000
• SQL*LOADER
• Import /Export
• SQL*PLUS
• Informatica 5.x/6.x
• Business Objects 6.5
• Edit Plus
• Erwin
• Visio 3.5
• TOAD 7.6
• Quest central tuning Lab
• Appworx scheduler
• PLSQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, MA

Sr. Oracle Developer

Responsibilities:

• Developed Oracle XML Packages based on business requirement.
• Wrote Oracle Store Procedure and Functions for XML Package
• Worked on Oracle EBS and Lawson Database for fetching the data from these databases.
• Generated XML Schemas using the output of the Oracle XML Packages.
• Used Altova XML Spy tool for generating tXML.
• Used Altova MapForce tool for mapping with target Schema.
• Generated XLST stylesheets to transform datainto a new PkMS Warehouse.
• Involved in SDLC - Analyzed the existing partially developed tool. Provided input to the requirements analysis team and supported ongoing release activities.
• Prepared the technical design documents (TDD) for most of the core modules of Project.

Environment: Oracle EBS, Lawson Database, Oracle 9i, Altova XML Spy, Altova MapForce, Oracle Pl/SQL Developer tool, PVCS 3.6, SQL*PLUS, Windows XP.

Confidential, Jersey City, NJ

Pl/SQL Developer

Responsibilities:

• Understand the data flow of the financial module in the old 2020 system, which is migrated to the new Oracle system.
• Developed Various Oracle packages with procedures, functions, cursors, ref-cursors.
• Used Data Pump and Cold backup to backup of the Database and export data between Databases.
• Worked on creating External Tables, temporary tables in different schemas for data export and import.
• Worked extensively on the entire financial module of the company which involved various AR Invoice, AR Payment, AP Purchases, Billing and Job cost modules.
• Extensively worked with Sql*Loader for data import into the new Oracle 11g from the 2020 system.
• Used Oracle Packages UTL SMTP, UTL MAIL and UTL FILE for writing out data to files and emailing the files as attachments to vendors.
• Performance Tuning: Tables are partitioned and SQL queries are tuned using Explain Plan and TkProf.
• Wrote complex PLSQL/SQL scripts to populate various tables and views used for reporting purposes.Written complex SQL using hints, indexes for fast performance for reporting and ad-hock purposes.
• Written Packages, functions and procedures for Oracle reports.
• Worked on both web and paper source of the reports for various output formats like the Spreadsheet, text and PDF formats.
• Used the HTML and XML coding in the web source of the Oracle reports for Excel output.
• Used Oracle Discoverer 10g for building workbooks, modifying existing workbooks.
• Used most of the Discoverer features for the Management Analysis. Such as pivoting and drilling up and drilling down data.

Environment: Oracle 11g, Toad 9.0.1, SQL: Developer, SQL Plus 10.2, SQL*Loader 10.1.0, Discoverer 10g, HP-Linux 4.5, Putty 0.60, WinSCP 4.1.9.

Confidential, Atlanta, GA

PL/SQL Developer

Responsibilities:

• Involved in Tuning and monitoring database (database applications tuning, which included testing the application and suggesting changes in code so as to improve performance, disk usage, memory, and tuning sort operation).
• Monitoring existing SQL code and performance tuning if necessary.
• Created indexes for retrieving data quickly.
• For better performance used EXPLAIN PLAN, HINTS to tune queries.
• Performed various types of testing, inserting sync points, check points (GUI, Bitmap, text check points), enhancing using TSL.
• Involved in performance tuning of queries using EXPLAIN PLAN and TK PROF.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD by using Crystal Reports 10.
• Strong experience in working with advanced features like dynamic parameter, incorporating a parameter into a formula, parameter with multiple prompting, dependency checker, work beach, HTML preview etc.
• Used Forms to design front-end development.
• Wrote Oracle PL/SQL programs for backend processing.
• Developed various Complex Queries, Views for Generating SQL Reports.
• Created Shell scripts for running the process in the background
• Used External tables to allow Oracle to query data that is stored outside the database in flat files.
• Testing and deployment of the crystal reports developed / modified according to the business requirements or changes initiated because of the enhancements.
• Read data from flat files to oracle tables using SQL*loader.
• Developed Unix Shell scripts.

Environment: Oracle 10g/9i, Oracle SQL Developer, Business Objects XIR2, PL/SQL, MS Access, Unix, Shell Scripts, JavaScript, XML, ASP, HTML, Windows NT.

Confidential, Raleigh, NC

Oracle PL/SQL Developer

Responsibilities:

• Developed and enhanced suit further needs using SQL and PL/SQL extensively
• Developed data model for the payout Erwin stream using as a data modeling tool.
• Wrote several stored procedures in PL/SQL. Wrote ad-hoc queries using SQL.
• For better performance used EXPLAIN PLAN, HINTS to tune queries.
• Created Tables, Views, Materialized views, and constraints.
• Involved in database design physical and logical database structure.
• Did impact analysis on every requirement change.
• Wrote Triggers to transfer datato master tables.
• Prepared various documents like User manual, best practices.
• Used SQLLDR utility effectively to add records into the staging tables.
• Developing, Testing and debugging the code according to business requirements.
• Tuned SQL queries for optimum result.
• Used Autosys to schedule the jobs.
• Tuned database and SQL statements and schemes for optimal performance.
• Involved in the design and development of Forms and Reports.
• Maintained existing system and later on-call support.
• Coordinated between client and offshore development team.
• Translated the requirement from client and documenting them to be sent to offshore team.
• Wrote the Scripts to create tables, functions, stored procedures, Triggers, Packages, Indexes, and Views.
• Prepared the testing environments for testing.

Environment: Oracle 9i, SQL and PL/SQL, SQLLDR (SQL loader, using parallel and conventional paths).

Confidential, Princeton, NJ

PL/SQL Developer

Responsibilities:

• Understand the Use Cases and Map with Database
• Developed various large packages for interfacing this project with PeopleSoft, Legacy systems using Oracle Objects, collections and bulk operations.
• Developed various scripts (Stored Procedures) using Dynamic SQL, for managing several activities like, Generating Audit Tables, Audit Triggers, and Other General Triggers etc.
• Developed large number of Queries to be used by Report Development Team
• Experience in Unix scripts to ease batch jobs execution, when there is a backlog
• Developed Unix Utilities for other operations like secured ftp, extract specific information from files in one folder and generate a new file etc.
• Involved in requirement discussions and finding risk areas within the requirement with the Business Analysts
• Involved in Gap-Analysis between the requirement and the Specification
• Provided suggestions and corrections in the Use cases to the Business Analysts
• Developed and Created Test Scenarios for Development - Development Interface Testing
• Involved in Data Analysis and Corrections related to Finance Interface
• Identified unknown problems based on Data Analysis which will impact Finance interface and other areas
• Involved in Tuning Report Queries for better performance
• Tuned PL/SQL Packages to enhance performance, which reduced the execution time of Jobs to less than 10% of the execution time before tuning. These PL/SQL packages contained several procedures and Functions.
• Involved in managing the core reference data for every testing and production releases
• Provided assistance to STEP Team, in defining and Validating the test scenarios in my work area
• Being responsible for providing data to PeopleSoft on monthly basis for Backlog, making sure that we send correct data to PeopleSoft.

Environment: PL/SQL, Oracle 9i, UNIX

Confidential

PL/SQL Developer

Responsibilities:

• Coordinated with the team lead to study and gather the system requirements.
• Created new databases according to client requirement. Developed DDL, DML statements in Oracle databases.
• Designed the necessary table structures and table relations.
• Developed scripts to create tables, views, procedures and functions and executed them.
• Created scripts to insert records and execute them using SQL*Plus.
• Created indexes to improve the system performance.
• Created Views to hide tables and queries.
• Developed sequences, packages, functions, triggers and procedures using PL/SQL.
• Extensively used SQL, PL/SQL in developing functions and triggers.
• Created stored procedures, worked on query optimization.

Environment: Oracle 8i, SQL*Plus, PL/SQL, MS SQL SERVER, Windows 2000.