Senior Software Engineer Resume

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

Senior Software Engineer

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

Senior Software Engineer

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

Associate Software Developer

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