SUMMARY

• 9+ years of experience as a Tech Lead & Senior Oracle PL/SQL Developer with expertise in design, development, testing and deployment of applications involving Oracle Database along with use of ETL methodologies and also involved in support DBA activities.
• Experience as a Team Lead involved in Onsite - Offshore Management, operational & functional dimensions of the project.
• Experience in Capacity planning both at the application level & support level.
• Worked as a vital liaison between different teams & stakeholders like DBAs, system analyst, architects, business clients, managers and development teams.
• Involved in project development following SDLC waterfall initiating from Analysis, Requirements, Design, Coding, Implementation and Support.
• Experience in Agile Product Development, participating in daily Scrums, peer code reviews etc.
• Experience in working as a Senior Database Developer on Oracle 9i, 10g and 11g database.
• Experience in Database design using Normalization and E/R Diagrams.
• Extensive knowledge in Development, Analysis and Design of ETL methodologies in all the phases of Data warehousing life cycle.
• 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, DBMS STATS and UTL FILE for file handling.
• Experience also includes writing sub queries and advanced/complex SQL queries.
• Experience in using Regular expression functions, string handling functions, aggregate functions etc.
• Experience in Performance Tuning (SQL, PL-SQL Tuning and database) techniques using tools provided by Oracle like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, ORACLE HINTS, OEM (Oracle Enterprise Manager), AWR, ASH etc.
• Used Cost-Based Optimization (CBO) and experience in working with v$ views & DBA tables.
• Implemented PL/SQL advanced topics like Bulk Collects, Bulk Inserts, Ref Cursors, Collections, Dynamic SQL, Table functions, Pipelined table functions, Result cache.
• 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 developing the reports with Oracle Apex.
• 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.
• Experience in working with ETL tools like IBM Infosphere Datastage 8.1 & 8.5 for data extract, transform & load.
• Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
• Experience in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
• Worked in designing Parallel & Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• 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.
• 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, problem solving skills along with strong oral and written communication.

TECHNICAL SKILLS

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

Databases: Oracle 9i 10g 11gR1/R2, SQL Server, MS Access

Operating System: Windows7/Vista/XP, Windows Server 2003 & above Linux/Unix

Tools: SQL Developer, SQL*Plus, EXPORT, IMPORT, RMAN, TOAD,SQL*LOADER, IBM Rational Clear Case, Lotus Notes 8.5, Mercury Quality Centre, VMWare Workstation 8.0, Agent Ransack, Beyond Compare, IBM Info sphere Datastage v8.1,Oracle APEX, Underwriter Workbench, HP Service Manager, Rapid SQL, Serena PVCS, Microsoft Team Foundation Server(TFS), IBM DB2 Connect, Amarta workflows, Autosys, PSPad, Notepad++

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

Senior Oracle Developer

Responsibilities:

• Involved in extensive Oracle development for enhancement and extension of existing features of Synapse compliant to DICOM standards.
• Performed performance tuning including both sql tuning and application tuning for Synapse.
• Extensively involved in sql tuning of poor performing long queries using Explain Plans, tkprof, sql trace, dbms xplan etc.
• Experience also includes data modelling for addition of new functionality involving physical database design DDL, creating tables, constraints, primary keys, foreign keys, indexes, views, objects etc.
• Involved in Oracle PL/SQL development including Packages, Procedures and functions.
• Performance tuning the database with the help of DBAs by gathering the trace files & identifying the complex sql queries through DB statistics using Explain Plans and oracle hints.
• Worked extensively for defect fixing including complaint tickets (CAPA compliant) under Quality Control, Problem, and Incident & Ticket management.
• Extensively involved in root cause analysis, impact analysis, applying fixes to the database and testing.
• Experience in working as a Database Developer 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 different types of cursors, loops, string handling functions, date conversion functions etc.
• Wrote complex sql queries using joins-left outer joins, equi joins, subqueries etc.
• Also lead the offshore unit testing team by providing test specifications, monitoring the continuous integration environments, nightly build and other onsite-offshore tasks.
• Extensively used IBM Rational Clear Case tool for source code version control throughout the project.
• Performed inter team communications involving various stakeholders like DBAs, system analysts, system & integration test teams, managers leading other teams like DICOM, workstation etc.

Environment: Oracle 11gR2, TOAD, SQL*PLUS, SQL Loader, Export & Import Data, IBM Rational Clear Case(Version Control), Lotus Notes, Mercury Quality Centre 9.0l, VMWare Workstation 8.0, Agent Ransack, Beyond Compare, Synapse Workstation, RIS Scheduler, PSPad, Notepad++, Microsoft Office Tools, Go To Meeting.

Confidential, Norwalk, CT

Technology Lead & Senior Oracle Developer

Responsibilities:

• Working as an onsite Tech Lead for the Asset Management & Capacity Reporting Project for Confidential Capital.
• Involved in Client/Business coordination, meetings, Offshore Team management.
• Involved in the Capacity Planning of the Applications & Servers we support.
• Extensively involved in requirements gathering, analyzing & liaison among the various stakeholders of the project.
• Working with BA, system analysts, DBAs and Architects for the different aspects of Project activities.
• Involved in Oracle PL/SQL development including Packages, Procedures and functions.
• Performing bulk data load using SQL Loader using both conventional & Direct Path modes.
• Performance tuning the database with the help of DBAs by gathering the trace files & identifying the complex sql queries through DB statistics using Explain Plans.
• Creating reports for the application using Oracle APEX.
• Involved in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using DataStage to populate tables in Data Warehouse.
• Worked on IBM Infosphere (DataStage, Quality Stage) / Information Analyzer 8.1.
• Experience in both Parallel Extender Jobs and Server Jobs in DataStage.
• Experience in usage of QualityStage for maintaining and cleansing of data.
• Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• Involved in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Change Capture, Complex flat file, Modify, Aggregator, XML etc,.
• Experience in working as a Database Developer 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 different types of 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.

Environment: Oracle 11gR2, TOAD, SQL*PLUS, SQL Loader, Export & Import Data, Microsoft Visual Studio TFS, IBM Infosphere Datastage 8.1, Service Now, HP Service Manager, Beyond Compare, Apache Tomcat, Oracle Apex.

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 Ab-Initio ETL process to load data into oracle 11g database using extensive PL/SQL programming.
• Worked in close conjunction with the Ab-Initio ETL team and helped in integrating the database load module with the ETL piece in the project.
• Experience in working as a Database Developer 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: 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

Senior 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: 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.
• Developed some web pages for existing app using jQuery, HTML, Java Script & AJAX.
• 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: Oracle 10g/11g, PL*SQL, SQL Loader, AJAX, jQuery, 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: 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.
• 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: Oracle 9i, PL*SQL, Amarta Workflows, RMAN, Export & Import Data, Oracle Enterprise Manager, Visual Basic 6.0, Serena PVCS.