SUMMARY

• Overall 10+ years of IT experience in Database Analysis, Development, mapping, Testing, Implementation, Documentation and maintenance of software applications.
• Having around 8 years of experience in Oracle SQL, PL/SQL.
• Extensive experience working in database programming with Oracle 9i/10g/11g Systems, SQL, Sql server 2008/2005/2000, TSQL, PL/SQL, SQL*Loader and SQL*Plus, Enforcing data integrity using Integrity constraints & database triggers.
• Proficient PL/SQL Developer - Strong exposure in writing simple and complex SQL queries and creating PL/SQL Procedures, Functions, Packages, Views, SQL queries and Joins for extraction, transformation and loading of data.
• Experienced in advanced PL/SQL concepts such as VArray, Cursors, Bulk Collect and Dynamic SQLs.
• Proficient in creating Oracle objects - Tables (Partitioned & Non-Partitioned), Views, Materialized Views, Triggers, Synonyms, Nested tables and Collections.
• Worked on various Oracle utilities and Application developers such as TOAD, SQL Developer, SQL *PLUS, SQL *Loader.
• Solid understanding of Entity Relationship Design and data modeling. Have experience in Agile Methodology and Hands-on data modeling (Logical and Physical) with Erwin Data Modeler.
• Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, Tkprof, SQL*Trace and Table partitioning.
• Working knowledge on UNIX and Data Warehousing/ETL concepts -Created Shell Scripts for invoking SQL scripts and scheduled jobs on UNIX server using Crontab utility.
• A talent for analyzing problems, developing, simplifying and finding innovative solutions.
• Experience in retrieving data from external data Files and loaded into oracle tables using tools like UTL FILE, SQL*Loader and External Tables.
• Highly experienced in system analysis and translating Software Requirement Specification (SRS) and Business Requirement Specification (BRS) into Technical Specifications and Design.
• Excellent verbal and written communication and interpersonal skills, self-starter, quick learner, mentor other team members and a team player.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities. Able to explain technical concepts and communicate with users.
• Having domain knowledge in Healthcare, BNFS and Retail.

TECHNICAL SKILLS

Languages: Oracle SQL, PL/SQL, Shell Script (UNIX)

Databases: Oracle 9i/10g/11g/12c, MS Access, MS SQL Server 2000/2008, Sybase

Operating Systems: Windows 95/98/XP/NT, UNIX.

Version Control Tool: MS Visual SourceSafe 6.0

Tools: Putty, Toad9.7.2, PL/SQL Developer, RapidSQL, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia-PA

PL/SQL Lead/Senior PL/SQL Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, written packages, functions, stored procedures, triggers, views, materialized views and create and maintain DB Links.
• Responsible for coordinating with Customer to extract business requirements and understand their problems and requirements.
• Resolved customer queries and fixing defects.
• Contributed in design of application/reports thus helping to delivery best tactical solution for Customer’s business needs and Involved in Entity Relationship Design.
• Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Leverage Explain Plan, SQL * Trace and Hints for tuning complex SQL statement.
• Planned implementation of new reports as required for the business users.
• Involved in monthly Deployments of various releases and resolving issues related to delivery; coordinated with Release management team and delivery team.
• Attended review meetings and walkthroughs to discuss the status of the project.
• Analyze and document existing business logic implemented in Oracle Stored Procedures, Functions, and Packages using PL/SQL.

Environment: Oracle database, PL/SQL Developer, MS Visual SourceSafe6.0, Allink Transact, MS Office, MS Windows, JIRA.

Confidential, New York-NY

PL/SQL Lead/Senior PL/SQL Developer

Responsibilities:

• Responsible for coordinating with Customer to extract business requirements and understand their problems and requirements.
• Resolving customer queries, Unit testing and fixing defects.
• Creating databases and schema objects including tables, views, indexes and applied constraints and written functions, stored procedures and triggers and create and maintain DB Links.
• Load data from flat files, external tables and automate scripts to handle the routine data loads using Shell Scripts, perform SQL Tuning, query optimization techniques for better performance.
• Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Analyze and document existing business logic implemented in Oracle Stored Procedures, Functions, and Packages using PL/SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Participate in system testing activities, to include the verification of test scripts, cases, scenarios, and data as well as the execution of system integration testing and system acceptance testing.
• Wrote complex SQL queries including sub queries for faster data retrieval from multiple tables.
• Worked on and implemented SSIS Packages to handle database objects based on requirement.
• Involved in Deployments and resolving issues related to delivery.
• Involved in Performance tuning of existing SQL scripts.
• Attended review meetings and walkthroughs to discuss the status of the project.

Environment: Oracle database, Toad, SQL*Loader, VI Editor, MS Office, MS Windows, SSIS Packages, SQL Server 2008, UNIX, Putty.

Confidential

PL/SQL Lead/Senior PL/SQL Developer

Responsibilities:

• Responsible for coordinating with Customer to extract business requirements and understand their problems and requirements.
• Resolving customer queries and fixing defects.
• Contributed in design of application/reports thus helping to delivery best tactical solution for Customer’s business needs.
• Used AUTONOMOUS TRANSACTION PRAGMA in the procedures to control the transactions.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in the creation of database objects like tables, views, SQL scripts and indexes.
• Worked on and implemented Unix Scripts to handle database objects based on requirement.
• Provided support to developers for coding.
• Involved in Deployments and resolving issues related to delivery
• Attended review meetings and walkthroughs to discuss the status of the project.

Environment: Oracle database, Toad, SQL*Loader, VI Editor, MS Office, MS Windows, Greenplum, Postgre sql, Rapid SQL, UNIX, Putty.

Confidential

PL/SQL Lead/Senior PL/SQL Developer

Responsibilities:

• Coordinated with client to get the requirements.
• Code changes and Performance tuning of existing SQL scripts
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Resolved & provided solution to current issues.
• Assisted team in resolving issues related to the functional and technical problems and to resolve production issues.
• Unit testing and deployment to production.
• Received Team and User appreciation, assisted team, task allocation and mentoring.

Environment: Sybase database, VI Editor, MS Office, MS Windows, Rapid SQL, UNIX, Putty.

Confidential, Atlanta-GA

PL/SQL Lead/Senior PL/SQL Developer

Responsibilities:

• Managed & maintained a data warehouse application with Oracle 10g.
• Created databases and schema objects including tables, indexes and applied constraints, written packages, functions, stored procedures, triggers, views, materialized views and create and maintain DB Links.
• Responsible for coordinating with Customer to extract business requirements and understand their problems and requirements.
• Resolved customer queries and fixing defects.
• Contributed in design of application/reports thus helping to delivery best tactical solution for Customer’s business needs and Involved in Entity Relationship Design.
• Created records, tables, collections (nested tables and varrays) for improving Query performance by reducing context switching.
• Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures.
• Worked on and implemented UNIX shell script to run various batch processes.
• Involved in the creation of database objects like tables, views, Synonyms, stored procedures, functions, packages and indexes.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Leverage Explain Plan, SQL * Trace and Hints for tuning complex SQL statement.
• Worked with Collections, Bulk processing and table Partitioning.
• Planned implementation of new reports as required for the business users.
• Involved in monthly Deployments of various releases and resolving issues related to delivery; coordinated with Release management team and delivery team.
• Attended review meetings and walkthroughs to discuss the status of the project.
• Analyze and document existing business logic implemented in Oracle Stored Procedures, Functions, and Packages using PL/SQL.

Environment: Oracle database, Toad, SQL*Loader, VI Editor, MS Office, MS Windows, UNIX, Putty.

Confidential, Louisville-KY

PL/SQL Lead/Senior PL/SQL Developer

Responsibilities:

• Managed & maintained a data warehouse application with Oracle 10g.
• Responsible for coordinating with Customer to understand their problems and requirements.
• Resolved customer queries and fixing defects.
• Load data from flat files, external tables and automate scripts to handle the routine data loads using Shell Scripts, perform SQL Tuning, query optimization techniques for better performance.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Contributed in design of application/reports thus helping to delivery best tactical solution for Customer’s business needs.
• Maintain production systems managed by Information Technology group, including problem-fixes and upgrades.
• Analyze and document existing business logic implemented in Oracle Stored Procedures, Functions, and Packages using PL/SQL.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Batch loading the data from external resource, Create queries for retrieving data, Performance tuning, Query optimization, Automate batch Jobs/data loads.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQLblocks and procedures.
• Participate in system testing activities, to include the verification of test scripts, cases, scenarios, and data as well as the execution of system integration testing and system acceptance testing.
• Extraction, Transformation and loading of data from flat file, Oracle sources into oracle database.
• Code changes and Performance tuning of existing SQL scripts.
• Resolved & provided solution to current issues.
• Unit testing and deployment to production.
• Team communication, task allocation. Assisted the team to understand the process flow.

Environment: Oracle database, Toad, SQL*Loader, VI Editor, MS Office, MS Windows, UNIX, Putty.

Confidential, Memphis-TN

PL/SQL Developer

Responsibilities:

• Coordinating with client to get the requirements.
• Coordinate with team and client, update daily status reporting to client.
• Code changes and Performance tuning of existing SQL scripts.
• Maintain production systems managed by Information Technology group, including problem-fixes and upgrades.
• Log and track system errors and interact with system vendor technical support.
• Provide regular updates to the Supervisor and/or the Project Manager regarding project status, and milestones achieved.
• Run batch jobs as per requirement.

Environment: Oracle database, Toad, SQL*Loader, VI Editor, MS Office, MS Windows, UNIX, Putty.

Confidential

Software Engineer

Responsibilities:

• Responsibility to look after different processes, their proper functioning/scheduling, Maintaining and viewing of logs involved in having sound system on BOS.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Wrote complex SQL queries including sub queries for faster data retrieval from multiple tables.
• Resolving & providing solution to current issues.
• Performance tuning of existing SQL Scripts.
• Wrote shell scripts to automate loading files into database using crontab, error handling and notification
• Development using shell script and stored procedure involved phases impact analysis, unit test plan, testing.
• Process scheduling and in-house activities. Aborted process correction.
• Understanding the customer requirements for Fact finders/calls & resolve them timely & priority wise.
• Sending current status of the system for the day to clients, Allocating works to team members, work status update, taking team meetings

Environment: Sybase database, T-SQL, VI Editor, MS Office, MS Windows, UNIX Shell Scripting, Putty.