SUMMARY:

• Over 8+ years of experience as a Software Programmer and Oracle PL/SQL Developer in Application Development and Production Support.
• Proficient in writing Packages, Stored Procedures, Functions, Views, Cursors, Constraints, Materialized Views and Database Triggers using SQL and PL/SQL in Oracle.
• Strong in using tools such as TOAD, SQL*Plus
• Capable of calling oracle stored procedures and packages from Powerbuilder for front - end and have good knowledge about Object Oriented Programming (OOP).
• Comfortable in Tuning SQL Statements using Execution Plan, HINTS and Procedures for enhancing the load performance in various schemas across databases.
• Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, debugging, System Test Plan, User Acceptance Testing (UAT), Quality Assurance, Code Review.
• Experienced in environments requiring direct customer interaction during design specification, development, and acceptance testing and implementation phases.
• Proficiency in solving issues after an application release in production.
• Capable in leading a team by providing them direction, knowledge transfer and assistance in work.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.
• Capable in providing creative and long-lasting solutions to challenging business problems and worked collaboratively and proactively with cross-functional teams.
• Ability to learn new technologies at rapid speed.
• Good Team Player and ability to work independently.
• Ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
• Excellent written and oral communication skills with a result-oriented attitude.

TECHNICAL SKILLS:

Databases: Oracle 9i, MS-SQL Server 2000

Database Tools: Toad, SQL * Plus.

OS: Windows Vista, Windows 2000/2003/XP professional.

Documentation: MS Office 2003, MS Office 2007.

Version control tools: Rational Rose, Clear quest, Teamforge, Source-control.

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, AL

Oracle- PL/SQL Lead

Responsibilities:

• Involved in gathering of business scope and technical requirements and created technical specifications.
• Involved in leading a team of engineers, Develop and review deliverables including requirement, design and test documents and collaborate with functional and technical teams to resolve technical database related issues.
• Help team members by providing them direction, knowledge transfer and assistance in work.
• Modified the existing PL/SQL Packages, Stored Procedures and functions to cater additional business enhancements.
• Created different schemas and maintained schema objects.
• Created views and materialized views to get specific data to be accessed by the front end.
• Extensively used cursors and ref cursors in creating packaged procedures and functions.
• Reviewed the existing Packages, Stored Procedures and functions and modified them to improve their performance which enhanced the speed of loading of data in the application.
• Used Indexes, Hints, Explain Plan for better performance of queries.
• Used Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.

Environment: Oracle 9i, PL/SQL, SQL*Plus, TOAD, MS Office, Teamforge.

Confidential

Oracle - PL/SQL Lead

Responsibilities:

• Involved in requirement gathering and analysis phase.
• Involved in leading a team of six engineers and brought in new business requirements from clients and introduced various new modules in the applications.
• Help team members by providing them direction, knowledge transfer and assistance in work.
• Develop and review deliverables including requirement, design and test documents and collaborate with functional and technical teams to resolve technical database related issues.
• Created Database Objects such as indexes, sequences, and views and materialized views.
• Wrote PL/SQL Stored Procedures, Functions and Packages with extensive use of cursors, sub-queries, complex joins, records and collections, date functions and string handling functions to implement business rules into the application.
• Developed triggers for auditing and error handling.
• Utilized Oracle’s bulk processing techniques like Bulk Collect and FORALL.
• Conducted performance tuning using Explain Plan, Hints, and Indexes etc.
• Involved in Code Review and User Acceptance Testing (UAT) of the application.
• Understanding the process and Interacting with functional team to resolve the issues in the given objects.
• Tested new enhancements and fixed various bugs before Deployment into the Production environment.
• Involved in preparing System documentation such as Technical Specifications, functional specifications, release notes, Unit Test Plan, Data Flow Diagram using MS-Word.
• Involved in preparing weekly status reports.

Environment: Oracle 9i, PL/SQL, SQL*Plus, TOAD, MS Office, Teamforge.

Confidential

Sr. PL/SQL Developer & Project quality lead

Responsibilities:

• Analyzed and reviewed the database design for better understanding the relations and dependencies within the database.
• Developed database objects including tables, cursors, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Tuned complex Stored Procedures for faster execution and developed database structures according to the requirements.
• Made timely changes and fixes to all the modules on reported problems from the database administrator.
• Wrote PL/SQL Stored Procedures, Functions and Packages with extensive use of cursors, sub-queries, complex joins, date functions and string handling functions, records and collections to implement business rules into the application.
• Involved in Code Review and User Acceptance Testing (UAT) of the application.
• Created Test plans for Unit Test, Regression Test and reviewed the test cases with the team lead.
• Tested new enhancements and fixed various bugs before Deployment into the Production environment.
• Involved in preparing System documentation such as Technical Specifications, functional specifications, release notes, Unit Test Plan, Data Flow Diagram using MS-Word.
• Involved in preparation of matrix calculation, communicating with quality team and performing quarterly quality reviews.
• Used TOAD, PL/SQL developer tools for faster application development.
• Involved in preparing weekly status reports.

Environment: Oracle 9i, PL/SQL, TOAD, MS Office, Source-control, Pivot tablesmatrix calculations.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Implementation, Maintenance of application.
• Involved in various stages of SDLC like Requirement gathering, analysis, design, Coding, Testing, Quality assurance Documentation, Implementation.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement.
• Involved in creating database objects such as tables, views, synonyms, indexes, sequences and constraints as well as custom packages tailored to business requirements.
• Involved in query tuning for performance issues.
• Made timely changes and fixes to all the modules on reported problems from the database administrator.
• Wrote PL/SQL Stored Procedures, Functions and Packages with extensive use of cursors, sub-queries, complex joins, date functions and string handling functions, records and collections to implement business rules into the application.
• Developed triggers for auditing and error handling.
• Involved in Code Review and User Acceptance Testing (UAT) of the application.
• Tested new enhancements and fixed various bugs before Deployment into the Production environment.
• Used PL/SQL developer tools for faster application development.

Environment: MS SQL Server 2000, PL/SQL, SQL*Plus, MS Office, version-control.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in various stages of SDLC like Requirement gathering, analysis, design, Coding and Unit testing.
• Made timely changes and fixes to all the modules on reported problems by peers.
• Wrote SQL queries to retrieve information from the databases depending on user requirement.
• Involved in creating database objects such as tables, views, indexes, sequences and constraints as well as custom packages tailored to business requirements.
• Wrote PL/SQL Stored Procedures, Functions and Packages with use of cursors, sub-queries, joins, date functions and string handling functions to implement business rules into the application.
• Developed triggers for auditing and error handling.
• Tested new enhancements and fixed various bugs before Deployment into the Production environment.

Environment: MS SQL Server 2000, PL/SQL, SQL*Plus, MS Office, version-control.