SUMMARY:

• Having 10+ years of experience in Information Technology with special Emphasis on ORACLE and having good experience in analysis, design, development, testing and implementation of applications in ORACLE,SQL and PL/SQL
• Extensive experience in developing UNIX Shell scripts
• Have strong ORACLE developer experience in writing Stored Procedures, Functions, Packages and Triggers.
• Highly experienced in software design, analysis, coding, development and testing with specialization in ORACLE based client server computing, implementation, maintenance and quality assurance.
• Profound knowledge and ability to write stored procedures, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Experience in designing & creating databases in Oracle 8i/9i/10g/11g for OLTP applications.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating external tables to manage data which is store at the OS level.
• Have good knowledge on Oracle utilities like Export and Import
• Have good experience in writing the functional and technical design document.
• Expertise in Database Performance Tuning and Optimization using Oracle Hints, Explain plans and Table partitioning.
• Working knowledge of SQL Trace,Explain Plan and TK - Prof for performance tuning and database optimization.
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Experience in shell scripting, includes file formatting scripts, data manipulation scripts and data load scripts. Extensively used VI editor.
• Extensive experience in batch monitoring and analyzing the failed jobs
• Have good experience in data migration projects.
• Experience in Understanding complex performance issues and worked with DBA’sto suggest valuable ways to fix the problem.
• Strong experience in Version control tools like IBM Rational Clear case activities
• Experience in independently handling design, development, documentation and testing phases in a project environment.
• Extensive experience in creating the deployment documents and creating the roll back scripts
• Have a good experience on Data warehousing systems.
• Have good experience in banking and Insurance domains.
• Have good experience in handling the Incidents and Defects.
• Experience in a variety of different environments like Unix,HP-UX, Solaris and Windows
• Have good experience in Production support.
• Experience in on-call 24*7 support in production environment even during off-hours.
• Experience in onsite-offshore business model and coordinating with team in off-shore
• Extensive experience in performing unit testing
• Have good knowledge on ETL concepts like SCD,STAR and Snow flake schema.
• Experience in providing the daily status to the client.
• Experience in automating the routine tasks
• Experience in production data corrections
• Result oriented, self-motivated, team player, ability to work independently.
• Have a good experience in ETL testing.
• Hands on experience on Test director
• Good knowledge on testing life cycle
• Sound knowledge of software development life cycle (SDLC)

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, C,VISION, ACCELL

Database Utilities: TOAD, SQL Developer,SQL*Plus

Database: Oracle 8i, 9i, 10g,11g, MS SQL Server

ELT Tools: Info sphere Data stage and Quality Stage 8.7, Informatica

Operating Systems: UNIX,HP-UX,Sun Solaris, AIX, Windows Server 2008/2003/2000/ NT

Scripting Languages: Shell Scripting

Tools: BMC Remedy, Putty

Version Control Tools: IBM Rational Clear case,PVCS,SVN

PROFESSIONAL EXPERIENCE:

Confidential, Cranbury, NJ

Oracle Lead Sr Developer

Responsibilities:

• Incident management - logging, prioritizing and resolving incidents and track them against various SLAs.
• Problem management - resolving recurring incidents permanently, performing break fixes and implementing preventative action items.
• Document and execute disaster recovery processes.
• Batch monitoring, analysis on the failed jobs and document the root cause analysis of the issue.
• Completing the scheduled activities on time and provide the reports to end users on time..
• Involved in writing stored procedures, functions, packages and triggers as per the business requirements.
• Coordinate with offshore team, Assigning the incidents, defects and development work
• Created new database objects like Tables, Views, Synonyms and sequences
• Extensively using Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Bulk methods to improve the performance of the application
• Executing PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL
• Created constraints on the tables for data validations and for maintaining the clear data without any issues.
• Involved in providing the weekly status to client managers i.e walk through the incidents, defects and development activities.
• Involved in creating/modifying the shell scripts
• Involved in updating the application understanding document with new changes.
• Discuss with business analyst and gather the requirements.
• Involved in analysis of the functional design document.
• Involved in preparing the technical design document.
• Involved in requirements review meetings.
• Involved in SOX audits and respond to SOX team with appropriate documents.
• Involved in preparation of unit test cases and execution of unit test cases.
• Responsible for performing code reviews.
• Involved and Coordinated Production / QA release activity.
• Analyze the new change requests and provide the estimations.

Environment: Windows XP, Oracle 10g,11g,SQL,PL/SQL HP-UX,Shell Scripting, Vision, Accell, PVCS,BMC Remedy Toad

Confidential, New York, NY

Oracle Sr developer

Responsibilities:

• Discuss with business analyst and gather the requirements.
• Provide the daily status and prioritize the tasks.
• Involved in analysis of the functional design document.
• Involved in preparing the technical design document.
• Involved in requirements review meetings.
• Created new database objects like Tables, Views, Synonyms and sequences.
• Involved in doing the impact analysis for new change requests.
• Extensively using Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Bulk methods to improve the performance of the application
• Executing PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL
• Created constraints on the tables for data validations and for maintaining the clear data without any issues.
• Involved in modifying the existing views as per the requirement
• Involved in coordinating different application teams and collect the requirements.
• Involved in preparation of unit test cases and execution of unit test cases.
• Responsible for performing code reviews.
• Analyze the new change requests and provide the estimations.
• Involved in providing support to System testing and Unit testing
• Involved in preparing the deployment documents
• Involved in providing the KT to application support team.

Environment: Windows XP, Oracle 11g,SQL,PL/SQL,Unix, Java,SQL Developer, Putty,Informatica

Confidential, Providence, RI

Oracle Sr developer

Responsibilities:

• Involved in analysis of the functional design document.
• Involved in preparing the technical design document.
• Involved in requirements review meetings.
• Created new database objects like Tables, Views, Synonyms and sequences
• Involved in writing stored procedures, functions, packages and triggers as per the business requirements.
• Utilized SQL*Loader to load flat files into database tables.
• Extensively using Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Bulk methods to improve the performance of the application
• Executing PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL
• Created constraints on the tables for data validations and for maintaining the clear data without any issues.
• Involved in improving the performance of the SQL queries by using the SQL trace and TK PROF
• Involved in writing the shell scripting, includes file formatting scripts, data manipulation scripts and data load scripts.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Involved in preparation of unit test cases and execution of unit test cases.
• Responsible for performing code reviews.
• Involved in preparing and providing the daily status.
• Involved in Smoke Testing and found out the defects at initial stage
• Involved in Functional Testing and Regression Testing
• Hands on experience on Test Director.
• Involved in Equivalence, Reconciliation Testing
• Involved in peer reviews and provide constructive feedback to other members of the team.

Environment: Windows XP, Oracle 11g,SQL,PL/SQL,EXADATA,Informatica, TOAD,Unix,Putty

Confidential, Providence, RI

Oracle developer

Responsibilities:

• Involved in analysis of functional design document and prepare the technical design document.
• Involved in design document reviews and Design review meetings
• Developed PL/SQL Packages, Procedures, Functions and Triggers accordance with Business Requirements for loading data into database tables.
• Executing PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL
• Created constraints on the tables for data validations and for maintaining the clear data without any issues.
• Developed shell scripts to read and validate the data from flat file
• Develop the PL/SQL packages to generate the reports
• Utilized SQL*Loader to load flat files into database tables.
• Created new database objects like Tables, Views, Synonyms and sequences
• Responsible for performing code reviews.
• Involved in writing the shell scripting, includes file formatting scripts, data manipulation scripts and data load scripts.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Preparation of the Test Cases and involvement in Unit Testing
• Created Indexes for better performance of application
• Contributed extended support for system testing and UAT testing

Environment: Windows XP, Unix Oracle 10g, SQL, PL/SQL, Java, Shell scripting, TOAD

Confidential

Oracle developer

Responsibilities:

• Involved in analysis of functional design document and preparation of technical design document.
• Involved in design document reviews and Design review meetings
• Involved in writing stored procedures, functions, packages and triggers as per the business requirements.
• Executing PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL
• Created constraints on the tables for data validations and for maintaining the clear data without any issues.
• Developed shell scripts to read and validate the data from flat file
• Involved in writing complex VIEWS
• Utilized SQL*Loader to load flat files into database tables.
• Created database objects like Tables, Views, Sequences, Synonyms and Indexes
• Tune the SQL queries to improve the performance of the application.
• Involved in coding, support across the completion of project.
• Involved in preparation of unit test cases and execution of unit test cases.
• Responsible for performing code reviews.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Contributed extended support for system testing and UAT testing
• Involved in giving the KT to application management team

Environment: Windows XP, Oracle 10g, SQL,PL/SQL,HP-Unix,Secure CRT,TOAD,HP service center, Clear case

Confidential

Oracle developer

Responsibilities:

• Involved in analysis of functional design document and preparation of technical design document.
• Involved in design document reviews and Design review meetings
• Involved in writing stored procedures, functions, packages as per the business requirements.
• Created database objects like Tables, Views, Sequences, Synonyms and Indexes
• Executing PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL
• Created constraints on the tables for data validations and for maintaining the clear data without any issues
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Involved in preparation of unit test cases and execution of unit test cases.
• Involved in coding, support across the completion of project.

Environment: Windows XP,Oracle 9i, SQL,PL/SQL, Unix, Sql*plus, Toad,SVN

Confidential

Oracle developer

Responsibilities:

• Involved in writing program specifications and coding.
• Involved in writing stored procedures, functions and packages.
• Created database objects like Tables, Views, Sequences, Synonyms and Indexes
• Executing PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL
• Created constraints on the tables for data validations and for maintaining the clear data without any issues
• Utilized SQL*Loader to load flat files into database tables.
• Involved in writing/modifying the views
• Involved in preparation of unit test cases and execution of unit test cases.
• Involved in coding, support across the completion of project.

Environment: Windows XP,Oracle 9i, SQL,PL/SQL,Unix,SQL Developer,Putty