SUMMARY:

• Having 9+ years of experience in IT industry
• 9 years of Experience in Oracle PL/SQL Database Programming
• Extensive knowledge in writing complex SQL Queries
• Worked in all the phases of Software Engineering Life Cycle from Requirements Analysis through Development, Testing and Support
• Experience in working in different Software Development Processes like Waterfall Model and Agile Model
• Good knowledge in Analysis, Estimation, Design, Development, Testing, Implementation and Maintenance
• Good Experience in leading a team of individuals to achieve high quality deliverables on time
• Experience in performance Tuning SQL Queries using EXPLAIN PLANS, HINTS, AWR
• Worked in all the phases of Software Engineering Life Cycle from Requirements Analysis through Development, Testing and Support
• Good working knowledge in creating and using different Database Objects like Tables, Views, Indexes, Triggers, Stored procedures, Packages, Functions, Synonyms, Views, Sequences
• Experience in using Analytic Functions, Hierarchical Queries, Materialized Views, External Tables, Collections, Oracle Supplied Packages
• Experience in creating Jobs using DBMS JOB and DBMS SCHEDULER
• Experience in loading Data from External Files to Oracle Database using SQL Loader
• Experience in creating and Querying different types of Table partitions such as Range Partitioning, List Partitioning and Hash Partitioning
• Enthusiastic and Goal Oriented Team Player having excellent communication, interpersonal and leadership capabilities with high level of adaptability.
• Experience in Forms and reports - Oracle D2K
• Good exposure in Analysis, Design and Development using ODI technologies and warehouse modules.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003/2008

Programming Languages: SQL, PL/SQL, C, APEX,Java

Databases: Oracle 9i/10g,11g, 12c, Microsoft SQL Server 2008/2012, Oracle XML DB, DB2, MySQL

Database Tools: TOAD, SQL Developer, SQL Server Management StudioPLSQL Developer,SqlPlus

Other Utilities: Export/Import,SQL Loader, Quality centerUnix Shell Scripting

Source Safe Tools: Microsoft Visual Source Safe Version 6, PVCS, Dimensions, SVNClear case

PROFESSIONAL EXPERIENCE:

Confidential

Team Lead

Responsibilities:

• Complete the impact analysis and suggest various approaches/ possibilities for implementation
• Documenting the Change in the project specific format
• Providing functional clarifications to the QA Teams and Development Teams
• Analysis on the performance data to resolve any performance related issues in the integrated environment.
• Coordinate with various administration teams for migrations of code to QA & Production environments
• Coordinate with business partners/ development team for clarifications and change requests
• Timely Interaction with Client through mails, conference call and web-ex
• Coding Oracle ( PL/SQL)
• Data Base design

Confidential

Team Lead

Responsibilities:

• Business requirement gathering
• Functional requirement gathering
• Details Design Documentation
• Coding Oracle ( PL/SQL)
• Data Base design

Confidential

Team Lead

Responsibilities:

• Business requirement gathering
• Functional requirement gathering
• Details Design Documentation
• Coding Oracle ( PL/SQL)
• Coding in Sql Server
• Data Base design
• Code review

Confidential

Team Lead

Responsibilities:

• Business requirement gathering
• Functional requirement gathering
• Details Design Documentation
• Coding Oracle ( PL/SQL)
• Data Base design
• Code review
• Unit test case Preparation
• Production Support activities

Confidential

Team Lead

Responsibilities:

• Leading the Offshore DB Team.
• Assigning work to the team members and technical guidance to the team and review of the deliverables from offshore.
• Involved in weekly/monthly status calls with business and tracking the risks/issues in an effective manner.
• Mentoring the new joiners and imparting domain knowledge to them.
• Involved in Requirement analysis and prepared the functional requirements document as well as the detailed design document.
• Involved in Preparing test execution document and test case document for client testing.
• Prepared complexity point estimation for major enhancements.
• Handling of the batch/online stored procedures, Package, Function, and MV.

Confidential

Team member

Responsibilities:

• Involved in requirement analysis.
• Preparing the functional requirements document as well as the detailed design document.
• Involved in developing and testing Oracle Stored Procedures, Functions and Packages.
• Handling of the batch/online stored procedures, Package, Function, and MV.
• Developed complex Materialized Views
• Involved in tuning queries in Oracle SQL and PL/SQL.
• Involved in preparing deployment scripts.
• Involved in change requirement analysis and developed the code for the same.
• Involved in Preparing test execution document and test case document for client testing and bug fixing
• Prepare complexity point estimation for major enhancements

Confidential

Team Member

Responsibilities:

• Handling of the batch/online stored procedures, Package and Function.
• Involved in requirement analysis.
• Involved in developing and testing Oracle Stored Procedures, Functions and Packages.
• Developed complex Materialized Views
• Involved in tuning queries in Oracle SQL and PL/SQL.
• Involved in preparing deployment scripts.
• Involved in change requirement analysis and developed the code for the same.
• Involved in Preparing test execution document and test case document for client testing
• Involved in bug fixing
• Prepare complexity point estimation for major enhancements

Confidential

Team Member

Responsibilities:

• Created stored procedures by coordinating and gathering the requirements from the application team and implemented them successfully.
• Developed complex Materialized Views for the Report Generation by interacting with the respective teams in the project for understanding the functionality involved in each and every Report.
• Involved in development and unit testing of stored procedures for running the batch jobs that loads data either from a flat file or by using a db link.

Confidential

Team Member

Responsibilities:

• Data Model Comparison using Erwin Data Modeler
• Developing Database Objects like Procedures, Functions, Triggers, Cursors, Views, Ref cursors.
• Query Level Performance Tuning.
• Unit testing and Integration Testing for the developed Modules.
• Support for the Functional Testing Team.

Confidential

Team Member

Responsibilities:

• Involved in writing Triggers, Packages and Procedures.
• Involved in various modules of report development using Forms & Reports.
• Unit testing and Integration Testing for the developed Modules.
• Maintenance and Support and User Training.
• Support for the Functional Testing Team.

Confidential

Team Member

Responsibilities:

• Involved in writing Triggers, Packages and Procedures.
• Unit testing and Integration Testing for the developed Modules.
• Maintenance & Support and User training