SUMMARY

• 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired applications using teh Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux. Good experience of Performance AnalysisandSQL query tuning, while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, EBS, Hints, Explain Plan.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys.
• Used Informatica Tool for ETL Process.
• 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, V arrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Knowledge of DOTNET(C#,VB.NET),Visual Studio 2008,Java, Ms excel.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
• Experience wif data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table Partitioning.
• Experience in creating SQL loader scripts to load data from flat files into teh database and also creating External Tables to manage data, which is store at teh OS level.
• Experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Worked on Oracle Forms10g/9i/6iReports10g/9i/6i.
• Well-versed wif different stages of Software Development Life Cycle (SDLC).
• Extensively used PL/SQL to build Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• Experienced in Tuning Queries for better performance wif large volume of data. Extensive experience in developing applications using Oracle Forms / Reports. Experience in almost all teh versions of Forms/Reports.
• CreatedShell Scriptsfor invoking SQL scripts and scheduled them.
• Expertise in implementing ETL (extract, transform and load) by using Oracle Warehouse Builder (OWB).
• Conducted Oracle database and SQL code tuning to improve performance of teh application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query.
• Worked wif relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Unix Shell Scripts, JSP, C, C++, java, CSS, HTML, XML.Operating systems HP-UX 11i, Solaris 2.x/8, AIX 5.3, OpenVMS, Windows XP/NT/2000

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

Oracle Utilities: SQL*Plus, SQL*Loader, SQL developer, TOAD.

GUI Tools: APEX 4.2,3.2,Oracle Forms 10g,9i,6i and Reports 10g,9i,6i, ERWIN,VISIO, Gloden Gate, Autosys Control-M, JIRA and HP quality center.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Oracle PL/SQL Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Experience wif Oracle partitioned tables and queries.
• High-Transaction environment experience.
• Loaded teh data into database tables using SQL*loader from text and excel files.
• 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 teh 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 wif exception handling..
• Created scheduled and schedule now reports.
• Load teh data from Excel file to oracle database.
• Data loads are been performed by using teh SQL loader, Imports & UTL files based on file formats. Created SQL script for ETL Process.
• Tuned SQL queries and performed code debugging using TOAD.
• Developed SQL and PL/SQL scripts to transfer tables across teh schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Using Oracle Jdeveloper Database tools to write triggers and procedures, Function.
• Worked wif 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.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF and AUTOTRACE.
• Created management analysis reporting using parallel queries, Java Stored Procedures Functions.
• Created and modified severalUNIX shell Scriptsaccording to teh changing needs of teh project and client requirements.
• Created UNIX shell scripts to automate teh process. Experience in writing shell scripting for various ETL needs Design and development of UNIX Shell Scripts to handle pre and post session processes.
• Using Bash script for database connectivity using DBI which connects to backend database drivers.
• Developed UNIX Shell scripts to run various utilities & wrote UNIX Cron jobs for teh scheduled batch processes.
• Data integration and transactions across heterogeneous systems done by using Gloden Gate.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PL/SQL, TOAD, Gloden Gate, UNIX, MS Windows 7, Linux, Putty.

Confidential, Portland, OR

Performance Test Analyst

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Experience wif Oracle partitioned tables and queries.
• Loaded teh data into database tables using SQL*loader from text and excel files.
• 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 teh 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 wif exception handling..
• Created scheduled and schedule now reports.
• Load teh data from Excel file to oracle database.
• Data loads are been performed by using teh SQL loader, Imports & UTL files based on file formats. Created SQL script for ETL Process.
• Tuned SQL queries and performed code debugging using TOAD.
• Developed SQL and PL/SQL scripts to transfer tables across teh schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Using Oracle Jdeveloper Database tools to write triggers and procedures, Function.
• Worked wif 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.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF and AUTOTRACE.
• Created management analysis reporting using parallel queries, Java Stored Procedures Functions.
• Created and modified severalUNIX shell Scriptsaccording to teh changing needs of teh project and client requirements.
• Developed UNIX Shell scripts to run various utilities & wrote UNIX Cron jobs for teh scheduled batch processes.
• Data integration and transactions across heterogeneous systems done by using Gloden Gate.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PL/SQL, TOAD, UNIX, MS Windows 7, Linux, Putty.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in designing ER diagram using oracle designer, to set teh logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded teh data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Worked wif teh Business analysts and teh DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Migration of dbms jobs to control M.
• Scheduling jobs in control M and handling them.
• Making changes to teh existing apex applications in teh production.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Part of a development team for creation and maintenance of custom apps/reports.
• Used Bulk Collections, Indexes, and Materialized Views to improve teh 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 wif exception handling.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically wif teh help of UTL MAIL.
• Developed SQL and PL/SQL scripts to transfer tables across teh schemas and databases.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Archived many applications in teh existing system and retrieval of necessary data from them.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Worked wif 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.
• Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 9i/10g, Reports 9i, SQL, PL/SQL, TOAD, SQL*Loader, UNIX, MS Windows XP/2000, Oracle Development Suite.

Confidential

Jr. Oracle Developer

Responsibilities:

• Created PL/SQL stored procedures, functions and packages for moving teh data from staging.
• Involved in using dimensional modeling, created fact tables, dimensional tables and other database objects in teh Star schema model.
• Developed ETL processes for Data Extraction, Data Mapping and Data Conversion using PL/SQL scripts and load data into warehouse Schemas.
• Worked on improving teh 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.
• Participated in performance tuning, unit test case preparation and execution.

Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.