PROFESSIONALSUMMARY:

• Over 4 years of experience as software Developer in the field of database programming with strong knowledge of SQL and PL/SQL.
• Excellent SQL, PL/SQL Developer skills including Database Queries, Triggers, Cursors, Stored Procedures, Functions, Packages in PL/SQL creating databases, generating web reports through mod plsql.
• Have been involved in analysis, coding and modifications to generate oracle web server based reports using mod plsql.
• Involved in development, enhancement and maintenance of various applications.
• Strong Communication & Management skills besides being an excellent team player.
• Adaptive in learning new technologies and diversified work environment.
• Have theoretical knowledge in Informatica and Perl understanding.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/XP, UNIX

Languages: SQL, PL/SQL, mod plsql

Database: Oracle 10g/11g

Tools: Toad, Control M

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle 10G, PL/SQL

Tools: Control - M

Responsibilities:

• Understanding of existing system model and client requirements.
• Communicate and discuss with client and support team in order to research and resolve the issues.
• Investigate for possible reasons of errors by studying backend code, and scripting as needed to resolve issues.
• Created views, Mviews, functions, stored procedures, triggers, packages by using PL/SQL to efficiently in corporate business rules
• Sub queries and Joins were extensively used in stored procedures
• Updating Stored Procedures, Functions and Packages.
• Created indexes on some columns of tables to increase the application's performance.
• Have worked on Replication of database.
• Generating feed files and reports on feeds and sending them through mail. Involved in Preparation of test cases.
• Preparation of Technical Specification document.
• Reviewed various programs, coded by team members.
• Done Unit Testing, Analyzing Bugs and Bug Fixation of existing codes.
• Scheduling and developing the business validation constraints.
• Customized existing Unix scripts for report generation and job scheduling.
• Used Control M tool for Job creation and scheduling for replication and report generation.
• Analyzed and modified mod plsql codes for oracle web server based reports

Confidential

Environment: Oracle 10G, PL/SQL

Responsibilities:

• Understanding of Existing system model and Client requirements.
• Understanding the process and interacting with functional team to resolve the issues in given objects.
• Created tables, views, indexes, sequences and developed procedures, functions, stored procedures.
• Creation of PL/SQL package and number of database objects for building distribution table and enforcing all validation rules.
• Involved in Preparation of test cases.
• Preparation of Technical Specification document.
• Investigate for possible reasons of errors by studying backend code, and scripting as needed to resolve issues.
• Sub queries and Joins were extensively used in stored procedures
• Updating Stored Procedures, Functions and Packages.
• Done Unit Testing, Analyzing Bugs and Bug Fixation of existing codes.
• Scheduling and developing the business validation constraints.
• Customized existing Unix scripts and writing database codes for report generation and job scheduling

Confidential

Environment: Oracle 10G, PL/SQL

Responsibilities:

• Understanding of Existing system model and Client requirements.
• Understanding the process and interacting with functional team to resolve the issues in given objects.
• Created tables, views, indexes, sequences and developed procedures, functions, stored procedures.
• Writing SQL queries for Report generation
• Involved in Preparation of test cases.
• Preparation of Technical Specification document