Summary:

• Over 6 years of experience in analysis, design, development, testing, implementation and support of software applications.
• Experience in System Analysis, Backend Programming, Database Design, Schema design.
• Experience in writing complex stored procedures, functions, triggers, static & dynamic ref cursors, exceptions, materialized views and packages.
• Experience in complex PL/SQL statements, SQL*PLUS, table functions, collections.
• Experience in single level & multi-level collections, PL/SQL tables, For All/Bulk Collect/Returning into/Save Exceptions/Autonomous Transactions, Global Temporary Tables.
• Experience in Tuning SQL Queries, Stored Procedures, functions, packages and reports for performance.
• Experience in UNIX Shell Scripting.
• Experience in Oracle Forms.
• Experience in formulating Test Plan, Test Scripts and Test Cases for Functional, System, Integration, UAT, and Regression Testing based on the Design Document and User Requirement Document for the Functional, Security and Performance Testing.
• Experience in UNIX and Windows.
• Strong Analytical skills to understand the business process and Functionality requirements and translate them into system requirement specifications. Developing functional specifications for business process refinement and automation.
• Strong interpersonal and communication skills.

Technical Skills:

RDBMS:

Oracle 9i/10g/11g

Languages:

PL/SQL, SQL, Shell Scripts

Web Technologies:

HTML

Operating Systems:

UNIX, Windows 7/Vista/XP/NT/2000/98

Methodology:

Object Oriented Analysis ,Design, Development

Tools & Utilities:

Import/Export Utility, SQL *Loader, TOAD

EDUCATION:

Bachelor of Technology in Information Technology

Professional Certification:
Oracle Certified Professional: Oracle PL/SQL Developer (OCP)

Work Experience:

Confidential,
Houston, TX July’12 – Present
Title: Oracle Developer

Environment: Oracle 10g, PL/SQL, Windows, UNIX

Responsibilities:

• Involved in analysis, design, development, testing, implementation and documentation.
• Created tables, views and triggers.
• Created complex PL/SQL stored procedures, functions and packages to process large amount data.
• Created Ref Cursors to manage huge volumes of data.
• Improved performance using bulk collect and bulk bindfor mass update.
• Involved in Unit, System, Integrationtesting and implementation.

Confidential,
Scottsdale, AZ Feb’12 – July’12
Title: Oracle PL/SQL Developer

Project: CNA is a leading provider of vehicle service contracts and associated products through automotive dealers nationwide. I have worked on various projects related to claims processing, maintaining data for new types of contracts and maintaining forms and screens according to the user requirements.

Environment: Oracle 10g, PL/SQL, Oracle Forms, Windows, UNIX

Responsibilities:

• Involved in analysis, design, development, testing, implementation and documentation.
• Worked on creating tables, views, stored procedures and triggers.
• Created complex PL/SQL stored procedures, functions and packages to implement business rules across application for integrating data from multiple sources.
• Used Execute Immediate to build dynamic SQL queries.
• Developed and executed UNIX Shell Scripts and moved them to production environment.
• Worked on oracle forms for developing screens for users.
• Involved in Unit, System, Integrationtesting and implementation.

Confidential, Scottsdale, AZ April ‘09 – Jan’12 Title: Oracle PL/SQL Developer

Project 1: Commercial Web Portal June’10 – Jan’12
Our Company develops commercial web portals toserve varied client base nationwide, including various classified modules of Financial, Payment gateway services (credit and debit card system), Marketing, Sales, Mortgage/Real Estate, Automobiles and Transportation.

Environment: Oracle 10g, PL/SQL, Oracle Reports, Windows, UNIX

Responsibilities:

• Worked on creating tables, views, stored procedures and triggers.
• Created complex PL/SQL stored procedures, functions and packages.
• Developed and executed UNIX Shell Scripts and moved them to production environment.
• Involved in Unit, System, Integrationtesting and implementation.

Project 2: Confidential, April’ 09 – May’ 10
Confidential,is an IT Asset management tool designed to keep inventory of all the hardware and software assets in an organization. Its primary function is to keep accountability for the life-cycle management of information technology assets throughout the organization.

Responsibilities:

• Involved in analysis, design, development, testing, implementation and documentation.
• Used UTL_FILE packages to extract the data from flat files and load into Oracle database.
• Involved in tuning PL/SQL applications effectively writing code using collections (PL/SQL tables) for reading (bulk-collect) and adding / updating of data into the database.
• Supported clients in all testing phases throughUAT(User Acceptance Testing).

Confidential, India July’ 06 – Mar’09 Title: Oracle PL/SQL Developer

Project: Customer Inquiry and Adjustments
The Customer Inquiry and Adjustments system (CIA) is the database of record of financial information for AT& T’s Low and Middle Markets (LMM) corporate accounts. CIA provides inquiry and adjustment capability to customer care for bills produced by the SBS, WEFOS, and UB billers.

Responsibilities:

• Involved in analysis, design, development, testing, implementation and documentation.
• Worked on creating tables, views, stored procedures and triggers.
• Created complex PL/SQL stored procedures, functions and packages.
• Used DBMS_PROFILER, DBMS_TRACE to enhance the performance of PL/SQL code.
• Created Materialized Views to increase the query performance.
• Developed and executed UNIX Shell Scripts and moved them to production environment.
• Created Ref Cursors to process huge volumes of data.
• Supervised and assisted in the performance of data mapping exercises.
• Concurrently worked on Software Quality Assurance team to continuously improve the processes and quality systems.
• Involved in Unit, System, Integrationtesting and implementation.
• Participated in installation and User Acceptance Testing.