PROFESSIONAL SUMMARY:

• PL/SQL and Datastage developer with over 6+ years of extensive experience in Database development, Enhancement and Implementation.
• Expertise in Oracle 9i/10g/11g databases, PL/SQL.
• Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, Indexes, SQL *Plus and TOAD.
• Experience in Performance Tuning and Explain plan, SQL*Loader, DBMS JOB, Utl File, Indexes and Shell scripting.
• Experience with handling very large data files using Oracle SQL*Loader.
• Experience in Performance tuning by implementing different options in Oracle like Partitioning, Oracle Parallel Queries, Materialized Views, Bulk Collects and Collections etc.
• Knowledge in UNIX shell script and Relational database Concepts.
• Good interpersonal and leadership skills, self motivated, an effective problem solver with the ability to work under pressure in fast paced, challenging environments
• Client Server experience includes backend development experience using Oracle, PL/SQL. Procedures, functions and triggers using PL/SQL.
• Providing daily, weekly and monthly status reports to managers

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, UNIX Shell Scripting

Database: Oracle 8i/9i/10g/11gOperating Systems:Windows 7/98/XP/Vista, UNIX

Tools: PL/SQL Developer, TOAD, SQL Loader, SQL *PLUS, iSQL PLUS

Testing Tools: HP Quality Center, Rational Functional Tester

Defect Tracking Tools: JIRA

Source Control: CVS, Subversion

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, Delaware

ORACLE PL/SQL

Responsibilities:

• Perform technical analysis of critical business areas within Bank such as Business Requirements, Production application issues, Feature driven development activities.
• Resolve, communicate and support technical issues, risks with software applications to Business and technology stakeholders of Project.
• Plan, Design, Develop and Manage technology using Oracle, UNIX, Windows.
• Responsible for documentation and audit artifacts as per defined SDLC process.
• Designed and Developed PL/SQL Procedures to support email alerts to customers who did not enroll to Barclay card website after signing to paperless to back to paper.
• Using WINcvs for version control.
• Extensively used for bulk collect to fetch large volumes of data from table.
• Creation of required indexes hints and partitions to improve the performance of complex queries.
• Created Unix Shell Scripts for automating the execution process. Data type mismatch in replication frame work which is used to transfer data from Production to reporting database.
• Creation of database objects like tables, views, Materialized views, using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions on big sized database.
• Support IT/Business team for System Testing / User Acceptance Testing. Closure of defects and regression testing.
• Creating Production Turn Requests and help DBAs / Admin implementing code in production environment.
• Familiar with release management and tag and untag the scripts as per release timings.

Environment: Oracle 10g/11g, UNIX, PL/SQL, UNIX, MS Project Plan, MS Visio, WINCVS version control

Confidential, Richmond, Virginia

Oracle PL/SQL Developer

Responsibilities:

• Analysis of business requirements of the project by studying the Business Requirement Specification document.
• Conduct design walkthroughs and communicate design rationale to people in other disciplines (project managers, developers, business analysts and customers).
• Database capacity planning (data storage) for projects and capacity planning for UNIX storage required.
• Creating Tables, Indexes, Views, Triggers.
• Using Tortoise SVN for version control.
• Designed and Developed data validation, load processes using PL/SQL scripts, Stored Procedures, Functions, and Triggers.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Creation of required indexes hints and partitions to improve the performance of complex queries.
• Created Unix Shell Scripts for automating the execution process.
• Worked on UNIX scripts to transfer files using FTP to all the UNIX servers at one time.
• Creation of database objects like tables, views, Materialized views, using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions on 30 Terabytes sized database.
• Written SQL queries for data Validation
• Support IT/Business team for System Testing / User Acceptance Testing. Closure of defects and regression testing.
• Creating Production Turn Requests and help DBAs / Admin implementing code in production environment.

Environment: Oracle 10g/11g, UNIX, PL/SQL, UNIX, MS Project Plan, MS Visio, MS Virtual Source Safe, Subversion (Configuration Management).

Confidential

Manual QA Testing / PL/SQL Tester.

Responsibilities:

• Worked with Agile team to understand user stories, requirements and acceptance criteria’
• Participated in project - related meetings with Project Manager and Engineers.
• Strong in writing SQL queries and make table queries to profile .
• Developed SQL queries and performed database testing using SQL developer
• Used Oracle as backend database.
• Attended QA meetings in deciding QA Test strategies, defining data requirements for the testing and setting up QA Environment for Testing.
• Tested PL/SQL Procedures that were developed to load the data from temporary tables in staging to target tables in data warehouse.
• Involved in preparing timely test reports and status update documents. Attended Daily Stand Up Meeting.

Confidential

PL/SQL Tester

Responsibilities:

• Worked with Agile team to understand user stories, requirements and acceptance criteria’
• Participated in project-related meetings with Project Manager and Engineers.
• Strong in writing SQL queries and make table queries to profile .
• Developed SQL queries and performed database testing using SQL developer
• Used Oracle as backend database.
• Attended QA meetings in deciding QA Test strategies, defining data requirements for the testing and setting up QA Environment for Testing.
• Tested PL/SQL Procedures that were developed to load the data from temporary tables in staging to target tables in data warehouse.
• Involved in preparing timely test reports and status update documents. Attended Daily Stand Up Meeting.