SUMMARY

• 7 Years of IT industry experience including analysis, design, development in Client Server Applications. Highly proficient in Oracle 10g/9i, Oracle PLSQL programming and SQL Server 2008.
• Hands - on knowledge of PLSQL programming and performance tuning.
• Expertise with Oracle Concepts and methodologies
• Extensive experience in improving query performance by tuning long running sqls using Oracle performance related features such as Query Optimizer, Execution Plans, Indexes and hints.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Query Re-Write.
• Expertise in Client-Server application development using Oracle 10g/9i, PL/SQL, SQL *PLUS, SQL Server 2008 TOAD.
• Sound knowledge in invoking plsql packages,procedures.
• Very strong Professional experience in the related area, Demonstrated accomplishments in analyzing problems, involved in developing and implementing standards and best practices.
• Excellent Client Interaction, Communication and Presentation skills.

TECHNICAL SKILLS

Operating System: Windows 7,Windows 2000, Windows NT 4.0/98/95

Languages: SQL, SQL*PLUS, PL/SQL, C, Pro*C

RDBMS and Tools: Toad, PLSQL Developer, Sql Developer, Sql Server Management Studio 2008, TFS

PROFESSIONAL EXPERIENCE

Confidential

Developer/Module Lead, Enterprise Data Management System

Responsibilities:

• Worked with business customers on requirement gathering and request prioritization.
• Analysing the requirements with business team and preparation of the design documents.
• Development of Database Objects to handle various functional requirements
• Implemented a tool which will run on production daily and provide the data discrepancy report to the end users.
• The tool gathers the metrics from SOR team and compares them against the metrics calculated on Landing database and staging database.
• Notify the end users in case of any data discrepancy through mail.
• Tuning the queries to enhance the performance of the tool.
• Daily calls with onsite team and discuss on the requirements and changes if any.
• Performing unit testing & System Integration Testing for the application modules.
• Taken care of improving Performance for some of the long running queries
• Responsible for mentoring Developers and Code Review of Mappings developed by team members.
• Responsible for internal reviews between all the developers and projecting the status to the project manager at regular intervals.
• Played a major role in improving the performance of the system by identifying pain areas and tuning the processes.
• There are lot of other responsibilities that were performed for successful implementation of the project

Environment: Oracle 10g, SQL, Quality Center

Confidential

Developer / Team member, Operational Data Store

Responsibilities:

• Responsible for preparing the data model by analyzing the source.
• Responsible for creating landing tables and extracting the data from source by using Auto ETL process.
• Designed strategy and coded procedures to extract daily incremental data
• Perform unit testing and system integration testing.
• Responsible for mentoring Developers and Code Review of Mappings developed by team members.
• Developed PL/SQL procedures, functions, and packages
• Developed materialized views for aggregate data information
• Involved in Performance Tuning of SQL Query, views etc
• Responsible for internal reviews between all the developers and projecting the status to the project manager at regular intervals.
• There are lot of other responsibilities that were performed for successful implementation of the project

Environment: Oracle 10g, PL/SQL, Toad, SQL Plus, sql server 2008

Confidential

Developer / Team member

Responsibilities:

• Responsible for preparing the data model by analyzing the source.
• Handled the data from java application into oracle database and taken care of exceptions is any.
• Prepared data migration strategy for migration historic data from lotus notes to oracle database.
• Performing unit testing & System Integration Testing for the application modules.
• Taken care of improving Performance for some of the long running queries
• Responsible for mentoring Developers and Code Review of Mappings developed by team members.
• Developed PL/SQL procedures, functions, and packages
• Developed materialized views for aggregate data information
• Involved in Performance Tuning of SQL Query, views etc
• Responsible for internal reviews between all the developers and projecting the status to the project manager at regular intervals.
• There are lot of other responsibilities that were performed for successful implementation of the project

Environment: Oracle 10g, PL/SQL, Toad, SQL Plus

Confidential

Developer / Team member

Responsibilities:

• Analysed the requirements and prepared design documents
• Responsible for preparing the data model by analyzing the source.
• Developed PL/SQL procedures, functions, and packages
• Involved in Performance Tuning of SQL Query, views etc
• Responsible for internal reviews between all the developers and projecting the status to the project manager at regular intervals.
• There are lot of other responsibilities that were performed for successful implementation of the project

Environment: Oracle 10g, PL/SQL, Toad, SQL Plus,PLSQL Developer

Confidential

Oracle developer/Team Member

Responsibilities:

• Analyzed business requirements and worked closely with the various application teams and business teams to develop plsql procedures that are consistent across all applications and systems
• Requirement analysis.
• Created PL/SQL packages and procedures to build business rules to load data
• Designed strategy and coded procedures to extract daily incremental data
• Developed PL/SQL procedures, functions, and packages
• Developed materialized views for aggregate data information
• Involved in Performance Tuning of SQL Query, views etc
• Weekly status meeting with the onsite team and update the status.
• Performing unit testing & System Integration Testing for the application modules.
• Handle Release management activities.
• Handled Mass printing activity and resolving corresponding issues.
• Provided production support on a daily basis for the load jobs

Environment: Oracle 10g/9i, PL/SQL, Toad, SQL Plus, proC