SUMMARY

• Over 6+ years of extensive IT experience in all aspects of Systems Development and complete Project Life Cycle in Oracle PL/SQL including requirements, Analysis, Design, Development, Testing and Implementation.
• Extensively worked in Client - Server application development using Oracle 8.0/8i, 9i, 10/g/11g, PL/SQL and SQL *PLUS.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Extensively worked in PL/SQL for creating stored procedures, clusters, packages, database triggers, exception handlers, cursors, cursor variables.
• Extensively Worked on Oracle Database creation, Tablespace management, (Export & Import) Backup, Performance tuning.
• Working knowledge of SQL Trace, TK-Prof, Explain Plan, SQL Loader for performance tuning and database optimization.
• Extensively worked in writing PL/SQL stored procedures, database triggers, exception handlers and cursors and ref-cursors and PL/SQL test cases.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL .
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.
• Expert in maintaining data integrity using various constraints and database triggers.
• Expertise in data migration with both (target - source) same database as well as with heterogeneous databases.
• Extensively worked on TOAD DATA POINT to create the automation scripts of the monthly reports.
• Proficient in interpersonal relations, team lead skills, project management, communication, outsourcing partner teamwork and organization with excellent communication and presentation skills.

TECHNICAL SKILLS

• Windows 95/98
• Windows2000/NT/XP
• Unix
• Sun-Solaris2.x
• SQL
• PL/SQL
• C and UML
• Oracle 8i/9i/10g/11g
• Visual Basic6.0
• SQL*Loader
• Export/Import
• TOAD
• SQL Navigator
• MS-Office Tools (MS-Office 2000
• Internet Explorer MS-Excel
• Visio)
• ERWin
• Dreamweaver4.0
• Flash 5
• Data reports
• SQL Navigator and TOAD
• Oracle Internet Applications Server (9iAS)
• Oracle Application Server (OAS)
• Apache Server
• Toad Data Point
• Toad for data analysts.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Extensively worked on the Adhoc Data requests to satisfy the needs of the program managers to achieve different goals of the project.
• Extensively worked of Toad Data Point to create automation scripts for the recurring Monthly, Weekly and Daily data requests.
• Extensively did Quality test plans and reviewed the Quality System Test Plan & Test cases.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Developed Oracle PL/SQL triggers and procedures. Set up Oracle PL/SQL package to analyze the tables and indexes, records tables and rebuild indexes.
• Created database objects, tables, indexes, procedures, SQL scripts.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Worked extensively in PL/SQL to develop packages, stored procedures, functions and database triggers.
• Loaded External files into database using import utility in Toad data-point.
• Support for the development, test and the production databases
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Extensively worked with testing team to coordinate changes in the system.
• Involved in managing security, granting and revoking privileges on database objects.
• Extensively coordinated with program managers to explain what tasks were possible for the system to achieve their desired output.
• Managed the monthly pool of recurring reports and data requests

Environment: Oracle 11g, SQL * Plus, TOAD for oracle, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, Microsoft Visio 2007,Data modeler, TOAD Datapoint.

Confidential, Holmdel, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Extensively did Quality test plans and reviewed the Quality System Test Plan & Test cases
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Fine-tuned for performance and in corporate changes to complex PL/SQL procedure / Packages for updating the existing dimension tables using PL/SQL Developer on Oracle RDBMS
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD
• Develop Oracle PL/SQL triggers and procedures. Set up Oracle PL/SQL package to analyze the tables and indexes, records tables and rebuild indexes.
• Created database objects, tables, indexes, writing procedures, SQL scripts
• Worked in Identifying and requirements and developing models according to the customer’s specifications and drafting detailed documentation for the same.
• Worked extensively in PL/SQL to develop packages, stored procedures, functions and database triggers.
• Used %Row type and %type to define data types based on row and column respectively.
• Loaded external files into our Database through UTL FILE.
• Involved in Tuning SQL queries using Explain Plan and TKPROF utility to improve performance of the queries.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Developed UNIX shell script to automate notification of Emails, to the users when a process fails in production.
• Involved in managing security, granting and revoking privileges on database objects

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, Microsoft Visio 2007

Confidential, Southborough, MA

Senior PL/SQL Developer

Responsibilities:

• Gathering business requirements.
• Worked with many different clients to deliver new products, upgrades and program fixes.
• Active Participation in the System Study
• Physical designing and development of Database
• Creating database objects like tables, synonyms, sequences and views
• Created and modified procedures and functions to suite the improved business requirements.
• Worked closely with the technical teams and DBAs for issues related to code changes, data fixes, and testing
• Loaded external files into our Database through UTL FILE.
• Extensively used Replication improves performance and increase availability of applications.
• Extensively worked towards optimizing the query to enhance the performance.
• Managed and resolved design issues during different phases of Project.
• Created records and nested tables in the procedures for handling of data
• Worked on different types of Array’s (Collections, Record Types).
• Used %Row type and %type to define data types based on row and column respectively.
• Coded complex SQL queries to retrieve data from the database depending on the need
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Performed exception handling for the procedures created
• Experience in resolving anomalies in the production database
• Created indexes for faster retrieval and improved query performance
• Worked with performance tuning tools like TK-Prof, explain plan, hints to improve the database performance
• Support for the development, test and the production databases
• Used SQL plus and TOAD to develop database applications

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting.