SUMMARY

• 7 years of experience as Oracle PL/SQL Developer with expertise in design, development, testing and deployment of applications built on top of Oracle Database and also involved in support DBA activities.
• Experience in working with Oracle 9i, 10g and 11g database.
• Experience in Database design using Normalization and E/R Diagrams.
• Experience in Database Development, based on the business case description and requirements created E/R Diagrams, designed database diagram and tables and populated data using DML and SQL scripts.
• Experience includes Coding in PL/SQL, developing Packages, Procedures & Functions including Cursors and Exception handling.
• Experience in writing database triggers & anonymous SQL scripts.
• Expertise in using user defined and system defined Exceptions for Error handling.
• Experience in using Oracle supplied packages such as DBMS SQL, DBMS JOB, DBMS SCHEDULER, UTL FILE for file handling.
• Experience also includes writing sub queries and advanced SQL queries.
• Experience in Performance tuning (both SQL and PL - SQL Tuning) techniques using tools provided by Oracle like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, HINTS etc.
• Used Cost-Based Optimization (CBO).
• Implemented PL/SQL advanced topics like Bulk Collects, Bulk Inserts Ref Cursors, Collections, Dynamic SQL.
• Experience with Oracle Reports and Forms.
• Experience in working with Crystal Reports.
• Well versed with Oracle 11g PL/SQL new features.
• Experience in managing Users, privileges and roles.
• Experience in handling administrative tasks like table space management, User Management and database monitoring tasks.
• Experience in Working with Backups both Logical and physical.
• Experience in Recovering data from user errors using Flashback Technology.
• Experience in Using RMAN for Backup and Recovery.
• Refreshing development/test database from production using Export/Import. This was done so that the latest data is available in the development/test database.
• Supported variety of critical and complex custom applications using Oracle databases and tools in Linux, Unix and Window environments.
• Involved in project development following SDLC starting from Analysis, Requirements, Design, Coding, Implementation and Support.
• Extensive knowledge of New Business modules and Underwriter Workbench for Variable Universal Life Insurance products. Have a good understanding of Policy Servicing modules.
• Have a good understanding on Service Management modules like Incident, Problem and Change Management.
• Understanding the challenges of Production environment, combined with leadership ability, team player and creative problem solving skills in both strategic and tactical areas.
• Strong interpersonal and problem solving skills.

TECHNICAL SKILLS

Languages: Visual Basic 6.0, VB.NET, C, C++, SQL, Java (core), HTML, Java Script.

Databases: Oracle 9i 10g 11g, SQL Server, MS Access.

Operating System: Windows XP, Linux/Unix.

Tools: SQL Developer, SQL*Plus, EXPORT, IMPORT, RMAN, TOAD, SQL*LOADER, Microsoft Visio 2008, Underwriter Workbench, HP Service Manager, Serena PVCS, Autosys

Reports: Crystal Reports, Oracle Forms and Reports Builder.

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

PL/SQL developer

Responsibilities:

• Enabled the system to receive the flat files and transformed the data to the data base.
• Performed Data Validations, Data Conversions for bringing the data from legacy system to Interface Tables.
• Transformed the data to flat files using UTL FILE.
• Loaded new data to the database by using SQL Scripts.
• Worked on the data conversion part to be uploaded into corporate reports using Oracle PL/SQL.
• Created users and provided privileges and roles.
• Automated the process to run the business flow automatically using database triggers.
• Modifying existing procedures and packages.
• Analyze SQL statements and reorganize database objects to improve response of queries.
• Done performance tuning for the complex SQL queries and the PL/SQL program constructs using EXPLAIN PLAN, SQL * TRACE, HINTS, AUTOTRACE and TKPROF utilities.
• Analyzed and redesigned the INDEXES.
• Used CACHE mechanism to improve the performance.
• Worked with BULK COLLECT, BULK INSERTS REF CURSORS program constructs.
• Developed stored packages with Oracle’s SQL Developer.
• Designed and developed PLSQL scripts using various oracle packages like DBMS JOB, DBMS SCHEDULER for creating and scheduling jobs.
• Also developed PLSQL scripts using oracle package DBMS SQL for using dynamic SQL in PLSQL scripts.
• Implemented the business logic using PLSQL and advanced topics like Collections.
• Generated dynamic web-reports using java, JavaScript, and HTML.
• Involved in fixing the bugs runtime.
• Analyzed the PL/SQL code for SQL Injection.
• Developed user interface Forms, Reports, PL/SQL Packages, Procedures, Functions and Database Triggers to meet the business requirements.
• Designed and generated reports using Crystal Reports.
• Worked in Oracle 11g environment.
• Played key role in project coordination and development from business requirements analysis, design, testing and support.

Environment: s: Oracle 11g, PL*SQL, SQL Developer, Crystal Reports, Autosys, Oracle Forms and Reports Builder, Export & Import Data, HP Service Manager, Serena PVCS, UNIX, VMWare.

Confidential, Indianapolis, IN

PL/SQL developer & Support DBA

Responsibilities:

• Analyzed business, functional and technical requirements to make sure project met expectations.
• Designed and developed GUI modules with VB 6.0 as front end.
• Designed the structure of new database tables incorporated for module enhancement using Entity Relationship Diagrams and Normalization concepts.
• Designed and created Entity-Relationship diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures.
• Developed custom database objects like tables, materialized views, triggers, indexes, cursors to implement efficient data management techniques.
• Designed and created ER and Data Modeling diagrams using VISIO 2008 software.
• Developed an Interface Program to transfer legacy data to the HR/payroll tables using SQL*Loader.
• Used PL*SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS SQL, DBMS PIPE, DBMS JOB, UTL FILE, and DBMS OUTPUT.
• Participated in performance tuning of existing SQL statements using Oracle cost-based SQL optimizer (CBO).
• Developed Oracle packages involving cursors and composite data types for backend functionalities.
• Added extensive exception handling to the primitive packages to enhance error handling.
• Interacted with the DBA team for Performance Tuning and database issues.
• Performed Physical and logical backup on a frequent basis using Recovery Manager (RMAN) and Oracle export and import utilities.
• Prepared Crystal Reports time estimates.
• Supported and maintained current Crystal Reports.
• Performed support DBA activities involving User management and table space management.
• Performed support DBA tasks for taking hot and cold backups.
• Performed DBA monitoring tasks with the help of various scripts for database monitoring.
• Loaded data in new tables using SQL*LOADER.
• Provided 24*7 supports to Production environment.

Environment: s: Oracle 10g/11g, PL*SQL, SQL Loader, Crystal Reports, Export & Import Data, Unix, Microsoft Visio 2008, RMAN, Oracle Enterprise Manager, Autosys, Toad, Serena PVCS, Oracle Forms and Reports Builder.

Confidential, Atlanta, GA

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.
• Designed and developed new features for the Reports option in Ulife Contract Admin application with coding in VB 6.0 in front end and developed new oracle packages for the backend functionality.
• Extensive PL/SQL programming including Development of new backend packages, procedures and functions to in corporate advanced modules.
• 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.
• Made some backend changes in Oracle packages in order to fix defects related to feeds sent to external teams from Ulife products.
• Refresh the development and test databases using export/import utilities.
• Provided 24*7 on call support to production environment.
• 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.
• Performed intensive testing for verification of the defects existing in the Production.
• Extensive documentation and updating of the problem tickets in HP Service Manager.

Environment: s: Oracle 10g, PL*SQL, SQL Developer, Export & Import Data, Autosys, HP Service Manager, Underwriter Workbench, Serena PVCS, UNIX, VMWare.

Confidential

PL/SQL developer

Responsibilities:

• Performed in-depth and step by step analysis of complex payment modules.
• Worked on introducing a new feature in Payment Confirms processing to trace the live technical errors encountered during Confirms processing through log files and automatic emails sent to the support team.
• Added file handling in Oracle procedures along with coding for sending automatic emails to the support team when the limit of errors was exceeded.
• Added and modified some complex queries in the backend using joins and sub queries.
• 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.
• Made some backend changes in Oracle packages in order to fix defects related to feeds sent to external teams from Ulife products.
• Also performed daily tasks of User Management and backups using RMAN.
• Examine trace files and alert log for error messages.
• Involved in the development of new modules adding indexes, sequences and views to the database.
• Refreshing development/test database from production using Export/Import. This was done so that the latest data is available in the development/test database.

Environment: s: Oracle 9i, PL*SQL, RMAN, Export & Import Data, Autosys, Unix, Oracle Enterprise Manager, Visual Basic 6.0, Serena PVCS.