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 includes extensive 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 FLASHBACK, DBMS SQL, DBMS JOB, UTL FILE for file handling.
• Experience also includes writing sub queries and advanced SQL queries.
• Experience in using Regular expression functions, string handling functions, aggregate functions etc.
• Experience in Performance tuning (both SQL and PL - SQL Tuning) techniques using tools provided by Oracle like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, ORACLE HINTS etc.
• Used Cost-Based Optimization (CBO).
• Implemented PL/SQL advanced topics like Bulk Collects, Bulk Inserts Ref Cursors, Collections, Dynamic SQL.
• Well versed with Oracle 11g PL/SQL new features.
• Experience in the oracle Flashback techniques for restoring data using timestamp and SCN, flashback version query and transaction query.
• 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.
• 24 X 7 Production Database on Call Support.
• Have a good understanding on Service Management modules like Incident, Problem and Change Management.
• Received Global excellence award for outstanding contribution to the production support team for Managed Services to Confidential Insurance, USA.
• Possess a sound understanding of the challenges in 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.

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, Underwriter Workbench, HP Service Manager, Rapid SQL, Serena PVCS, Microsoft Team Foundation Server(TFS), IBM DB2 Connect, Amarta workflows, Autosys, VMWare.

PROFESSIONAL EXPERIENCE

Confidential, Northbrook, IL

Senior Oracle PL/SQL developer

Responsibilities:

• Involved in the analysis of business functional and technical requirements of the project.
• Involved in extensive Oracle PL/SQL development including Packages, Procedures and functions.
• Developed the load module of the ETL process to load data into oracle 11g database using extensive PL/SQL programming.
• Experience in working on a large migration project having Oracle 11gR2 database with millions of records in database tables.
• Extensively used PLSQL composite data types like table types, record types etc to handle data.
• Implemented PL/SQL advanced topics like Bulk Collects, Bulk Inserts, updates and deletes, Ref Cursors, Collections and cursors.
• Used parameterized cursors, loops, string handling functions, date conversion functions etc.
• Wrote complex sql queries using joins-left outer joins, equi joins, subqueries etc.
• Worked on Performance tuning of complex sql queries using oracle hints, indexes, explain plan, sql trace etc.
• Extensively used Error & Exception handling, user defined exceptions, save exceptions clause during bulk operations, raise application errors etc.
• Developed data restore packages using flashback techniques using flashback query through timestamp and SCN.
• Helped in the deployment activities, data validation, tracking and monitoring activities in production.
• Developed statistics collection utilities using PLSQL programming like Dashboard to display daily data changes to the database.

Environment: s: Oracle 11gR2, SQL Developer, TOAD, SQL*PLUS, SQL Loader, Export & Import Data, Microsoft Visual Studio TFS, IBM DB2 Connect, HP Service Manager, Beyond Compare.

Confidential, Milwaukee, WI

PL/SQL developer & Production Support

Responsibilities:

• Provided 24*7 on call support for Batch cycles, central point of contact for all the issues.
• Involved in Incident Resolution/Firefight.
• Co-ordinate communication to involve other stakeholders.
• Ensure all application issues are addressed consistently and returned to operation.
• Involved in Performance Testing and Capacity Management.
• Involved in Technology/Application Road mapping activities.
• Involved in Availability/Ticket Aging Reporting.
• Involved in creating and fix of Problem Tickets.
• Involved in Release planning and Change Management activities.
• Involved in Testing of Defect fixes.
• Refresh the development and test databases using export/import utilities.

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

Confidential, Chicago, IL

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.
• Used PL*SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS SQL, DBMS PIPE, DBMS JOBS, UTIL FILE, and DBMS OUTPUT.
• Participated in performance tuning of existing SQL statements and PL*SQL code.
• Developed Oracle packages involving cursors and composite data types for backend functionalities.
• Added extensive exception handling to the primitive packages to enhance error handling.
• Designed the structure of new database tables incorporated for module enhancement.
• Performed support DBA activities involving User management and table space management.
• Performed support DBA tasks for taking hot and cold backups.
• Loaded data in new tables using SQL*LOADER.
• Provided 24*7 supports to Production environment.

Environment: s: Oracle 10g/11g, PL*SQL, SQL Loader, Export & Import Data, Oracle Enterprise Manager, Toad, Serena PVCS.

Confidential, Milwaukee, WI

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, HP Service Manager, Underwriter Workbench, Serena PVCS, UNIX, Autosys, VMWare.

Confidential

PL/SQL developer

Responsibilities:

• Performed in-depth and step by step analysis of complex payment modules.
• Worked on documenting the analysis and requirement of enhancement in increasing the threshold of amarta lifecycles failures in scheduler.
• 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.
• 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, Amarta Workflows, RMAN, Export & Import Data, Oracle Enterprise Manager, Visual Basic 6.0, Serena PVCS.