SUMMARY

• Around 6years of IT Experience as Oracle Developer for System Analysis, Designing, Testing, Development & Support of Oracle 9i, 10g & 11g in Production, Development environments.
• Experience in Software Development Life Cycle (SDLC) and AGILE SCRUM methodologies of development process such as requirement analysis & definition, prototyping, designing, coding, testing, deployment and implementation
• Expert in creating SQL Queries, PL/SQL Packages, Function, stored procedures, triggers, and cursors, Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL
• Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER - Diagram, Test Plan, and Test Script & Test Cases.
• Experience in Tuning SQL queries using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve teh performance.
• Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes
• Expertise in ETL Data Loading techniques using Oracle SQL* Loader, UTL FILE and External Tables.
• An TEMPeffective communicator with excellent analytical, process oriented & relationship management skills with teh ability to relate to people at any level of business & management
• Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and Load testing. Seamlessly migrated teh Code from Development to Testing, UAT and Production.
• Strong team player, ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning, Possess excellent communication, project management, documentation, interpersonal skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Core Java

Database: Oracle 11g/10g, MS - SQL Server, MySQL, MS - Access

Operating System: Windows, Unix

Development Tools: TOAD, SQL*Plus, SQL Developer, D2K, SQL- Loader

PROFESSIONAL EXPERIENCE

Confidential - White Plains, NY

Oracle PL/SQL Developer

Responsibilities:

• Involved in database development by creating Oracle PL/SQL Functions, Stored Procedures, Triggers, and Packages.
• Worked with different types of sub queries (Inline, correlated) and used loops to suit teh business logic.
• Written a number of Cursors to select various types of records.
• Worked with Bulk Collects to improve teh performance of multi-row queries.
• Used teh Pragma Exception INIT to name teh system exceptions that are raised by teh program.
• Extensively involved in coding of teh procedures, triggers, and making use of built in packages
• Modified existing stored procedures, functions and triggers
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Knowledge on taking Export (exp) and Import (imp) utilities to move data between different databases and schemas.
• Worked with Bulk Collects to improve teh performance of multi-row queries.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays).
• Developed PL/SQL packages using Oracle Standard/ Custom Exceptions.
• Written and edited shell scripts to automate teh execution of teh procedures.

Environment: Oracle 11g, SQL*LOADER, TOAD, SQL*Plus, UNIX

Confidential - Ridgefield, NJ

Oracle PL/SQL Developer

Responsibilities:

• Involved in designing and development of data warehouse for teh corporate data repository.
• Created and maintain Database Objects (Tables, Views, Indexes, Sequences, Database triggers, stored procedures)
• Gatheird teh requirements from teh users and analyzed their business needs and created SRS documents.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries for various reports.
• Involved in debugging and Tuning teh PL/SQL code, tuning queries, optimization for teh Oracle database.
• Developed SQL* loader scripts to load data in teh custom tables.
• Modified existing codes and developed PL/SQL packages to perform certain specialized functions / enhancement on oracle application.
• Developed and optimized SQL queries using TOAD Explain Plan utilities.
• Tuned SQL queries and performed refinement of teh database using tools like EXPLAIN PLAN and TKPROF to significantly improve teh system response, time and efficiency.
• Run batch jobs for loading database tables from flat files using SQL* Loader.
• Used Version Control tools like SVN for Source Control.
• Developed Materialized views and Ref Cursors for reporting purpose.
• Defined indexes on various tables to improve teh performance of teh queries for reporting purpose.
• Worked with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure, played liaison role with customers as well with other business segments
• Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.

Environment: Oracle 11g, SQL*Plus, SQL* Loader, TOAD, Putty, UNIX

Confidential VA

Oracle PL/SQL Developer

Responsibilities:

• Proactively tuned SQL queries and performed refinement of teh database design leading to significant improvement in system response time and efficiency.
• Reviewing and developing data models and database designs with development teams, entity-relationship models are used with relational databases, normalizing, and de-normalizing, indexing, and defining views.
• Creation and maintenance of tables, views, procedures, functions and packages.
• Developed SQL Loader scripts, conversion scripts for teh conversion of teh data to teh custom new Schema.
• Provide timely Production Support by quickly analyzing teh root cause and by providing alternatives to resolve issues.
• Identified of Performance tuning queries, database tuning, suggesting and implementing alternative approaches like range partitioning of tables, use of global temporary tables.
• Extensively worked on developing custom packages using Oracle PL/SQL for various business requirements.
• Supported operations during teh build/deployment of a new release to teh Integration, QA and Production environments.

Environment: SQL*Loader, TOAD, Oracle 10g

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Used Oracle Developer to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle and Access.
• Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Strong analytical and problem solving skills.
• Creating database objects like tables, indexes, views, packages and procedures using PL/SQL Developer.
• Sequences packages and procedures.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Worked on XML along with PL/SQL to modify/create interface between system Performed Database Administration of all database objects including tables, clusters, indexes, views, Performance tuning of Oracle Databases and User applications.
• Used SQL*Loader as an ETL tool to load data into teh staging tables.
• Provided user training and production support.
• Improved teh performance of teh application by rewriting teh SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment: ORACLE 9i.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Analyzed, created new and modified existing forms, reports, scheduled reports, Oracle, PL/SQL, Stored Procedures, Functions, Packages, and Triggers etc.
• Designed, developed and enhanced custom Forms and Reports according to teh functional specification.
• Did code reviews of other developers and provided suggestions to improve performance
• Provided expertise to development managers in design or preparing proof-of-concept testing.
• Converted Forms & Reports from 6i to 10g.
• Involved in handling Exceptions through PL/SQL Blocks
• Developed SQL *Loader scripts to load data from flat file to Oracle 10g database tables.
• Tuned batch jobs and other daily/monthly reports/downloads.
• Used Toad for creating and modifying procedures, functions and triggers.
• Created Test Plan for QA and implementation plan for Production implementation once teh unit test is done.
• Performed SQL performance tuning using Explain plan, Trace utility & TKPROF

Environment: Oracle 9i, Windows XP/2003, SQL Developer, Toad