SUMMARY

• Over 6+ years of IT experience in analysis, design, development, implementation and testing of applications in data warehousing and client/server environment.
• Experience with Oracle SQL and PL/SQL programming and used Database utility programs like TOAD and SQL Navigator.
• Experience with database objects like stored procedures, stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, parameterized cursors, Views, Materialized Views and PL/SQL collections.
• Proficiency in using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, and SQL*Loader.
• Translated the T - SQL procedure, function and views into Oracle's PL/SQL Packages, Procedure, Function and Views.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Experience in Data Analysis and managing data warehouse and data marts.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques. Oracle data loading into Oracle database from flat files using SQL loader.
• Expertise in working with built-in packages like DBMS LOB, DBMS SQL, DBMS SHEDULER, DBMS DDL, UTL FILE.
• Experience in tuning the application to optimize the cost and for higher efficiency. Involved in unit testing, systems integration testing and documented the same.
• Team player with an aim of contributing towards the team's success. Possess good communication and inter-personal skills, able to adapt quickly to new technologies and environments.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, SQL Server, MS access

Programming Languages: C, C++, HTML, SQL, and PL/SQL

Tools: and Utilities: SQL*PLUS, SQL*LOADER, PL/SQL Developer, Toad

Operating Systems: UNIX, LINUX, Windows (98/2000/XP/VISTA), DOS

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Oracle PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Experience in using various oracle PL/SQL collections VARRAYS, NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD. Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF. CURSORS.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, SQL Developer, SQL Navigator, TOAD, UNIX/LINUX, Windows.

Confidential, Charleston, WV

Oracle PL/SQL Developer

Responsibilities:

• Analyzed, designed, modeled, and implemented new database schemas
• Monitoring Fragmentation, Row Chaining and High water marks.
• Designed competent PL/SQL programs using PL/SQL collections, Records types, and Object types.
• Good knowledge on joins, which are inner join, left outer join and Hash join, Semi join.
• Writing SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.
• Using oracle 8i/9i analytical function to optimize the large OLAP Queries used for generating Reports.
• Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, and USER etc.
• Scripted in PL/SQL and SQL to migrate and manage databases
• Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.
• Involved in the support, maintenance and development of critical systems.
• Responsible for database design and development and Application Tuning.
• Implemented various UNIX scripts to generate the data in CSV format.
• Tuned several Oracle SQL statements using Explain Plan, Auto Trace utilities.
• Producing and updating relevant documentation.

Environment: Oracle 10g, SQL Plus, PL/SQL and Windows XP, TOAD, UNIX, HTML, Windows XP, Oracle SQL Developer, Putty, MS Access

Confidential, San Diego, CA

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the business requirements for the enhancements needed in the contract administration application and related policy modules.
• Documented the detailed requirements and prepared DLD for the new enhancements.
• Performed several DDL, DML and TCL operations.
• Created huge database packages with related functions and procedures.
• Created views by joining multiple cash flow tables to show output as a report to the user.
• Extensive PL/SQL programming including Development of new backend packages, procedures and functions to in corporate advanced modules.
• Worked on BULK COLLECT for bulk loading the data into various transaction tables.
• Used UTL FILE to load the data into oracle tables from FLAT, CSV and Text files.
• Added database triggers to some history tables of the database.
• Used file handling in Oracle to read and write into files associated with the modules.
• Refresh the development and test databases using export/import utilities.
• Provided 24*7 on call support to production environment.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
• Worked on inline and correlated sub queries based on business context.
• Implemented various customized Oracle reports using different techniques in Oracle SQL/PL-SQL.
• Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.
• Involved in Impact analysis of the defects to the associated functionalities and modules in the Production environment.

Environment: Oracle 10g, PL*SQL, SQL Developer, SQL*Loader, Export & Import Data, UNIX, Toad

Confidential

PL/SQL Developer

Responsibilities:

• Developed packages and customized functions and Triggers based upon the business logics.
• Assisted in Installing Application server, Report server and Database server.
• Involved in performing periodic cold backup of the databases.
• Designed, developed and customized forms by using Oracle forms 6i and Reports 6i.
• Prepared test plans for System and User acceptance test.
• Involved in documenting users requirements, technical specifications and Reporting manuals.

Environment: HP-Unix, Oracle 9i, Forms 6i & Reports 6i, Oracle Portal.