SUMMARY

• 8 years of experience in the field of information technology, proven ability to leverage technology to improve business processes, with special expertise in requirements analysis, database development, debugging, problem solving and user support.
• Proficient in Database/Infrastructure support, monitoring and performance tuning, data modeling, development of stored procedures, packages, triggers etc.

• Proficient in writing SQL queries in Oracle proprietary standard.
• Very strong in writing simple and complex SQL queries using DML, DDL, Table joins, Group functions, Grouping sets (Cube, Rollup), Grouping functions, Analytical functions, Connect by for hierarchical queries, Partition by clause towards Reports and Application development.
• Sound knowledge and experience in data extraction using sql.
• Extensively experience in designing and developing pl/sql subprograms.
• Implemented packages to achieve modularity, easier application design, information hiding, and better performance.
• Developed PL/SQL procedures for business rule validations, applying transformations, interfaces to UI screens, and for processing data.
• Explored Bulk Loading and Batch Processing features of PL/SQL.
• Proficient in using Cursors, Ref - Cursors, Table Functions, Functions, Collections, SQL Types and Sequences.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Worked on performance tuning of many applications. The most successful project decreased run time of the SQL package for application with complex data extraction from multiple large tables from 5 hours to 10 minutes.
• Sound knowledge and experience in developing Triggers on various database events.
• Effectively made use of Bulk Collect, Multi Table inserts, Merge, PL/SQL tables & Nested tables.
• Made use some of the oracle standard packages such as DBMS OUTPUT, DBMS ALTER, DBMS MVIEW, DBMS DDL, UTL FILE etc..,
• Proficient in Query optimization using cost based optimization techniques using explain plan, TKPROF, Auto trace & SQL Trace.
• Proficient in tuning PL/SQL programs using DBMS PROFILER.
• Proficient in creating and managing Indexes, optimizer Hints, Table Partitions, Initialization parameters and instance tuning.
• Proficient in automating administration tasks and applying data patches using, SQLPLUS scripts, shell scripts in Korn, bash and c shells.
• Experience in development of Web-based Application using Apache Struts Framework.
• Experience in development of Client-Server application using JSP.
• Experience in development of Web-based Application using tool My Eclipse.
• Proficiency in wide range of servers like Web logic and Tomcat.
• Experience and Knowledge in using SQL Programmer, Toad, SQL Developer, Clear Case, PVCS,VSS, Putty.
• Self-motivated, resourceful and result oriented Team Player.
• Having good communication and interpersonal skills, a clear understanding of business rules and the ability to work well as a part of project team.

TECHNICAL SKILLS:

Database Environment: Oracle 8i, 9i, 10g and 11g, SQL and PL/SQL

Operating Systems: Linux, UNIX and Windows XP.

Languages: SQL, PL/SQL, HTML, Shell Scripting, Java

Server side Programming: Servlets, JSP and J2EE..

Tools: /Utilities/IDE SQL*Plus, SQL*Loader, Toad, SQL DeveloperVisual Source Safe,PVCS,Eclipse3.3

Version Control Systems: CVS, SVN and Subversion.

Scripting: UNIX shell scripting

Industries: Finance, Insurance, Educational, Health and B2B Solutions

PROFESSIONAL EXPERIENCE

Confidential, Camp Hill, PA

Sr. PL/SQL Developer

Responsibilities:

• Writing stored procedures under tight schedules for successful production data-fixing.
• Analyzing the AWR reports with DBA's and SQL tuning to maximize performance Tune.
• Reviewing requirements in the JIRA for production issues and provides time estimates for task completion.
• Created database reports to get open enrollment and enrolled list reports weekly, monthly and yearly
• Fine-tuned SQL queries using functional indexes, hints for maximum efficiency and performance.
• Developed both inbound and outbound interfaces to load data into targeted database and extract data from database to flat files.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, SQL*plus, SQL*Loader, Shell Scripting, Informatica, PVCS Tracker, PVCS Version Manager, JIRA, TOAD, PL/SQL Developer tool and BMC tool.

Confidential, Nashville, TN

Sr. PL/SQL Developer

Responsibilities:

• Verify in the db and fixing UI issues by running each students' individual or organization score reports and providing to Customer.
• Import Customers, User, Organizations, Schools and Student data into the data base using SQL*Loader, Plsql dev tool and Little Informatica.
• Write the complex quires to find out and fix the various issues on behalf of the production support.
• Developed Perl & Unix scripts to automate frequent reports for the users
• Used DDL and DML to writing triggers, stored procedures to check the test sessions entry and student result verification
• Old packages are enhanced/modified as and when new requirements come across.
• Implementation of new packages as per requirements.
• Ad-hoc scripts update daily with a report.
• Analyze information to determine, recommend and plan installation of a new system or modification of an existing system.

Environment: Oracle 9i/ 10g/ 11g, SQL, PL/SQL, SQL*Loader, Informatica power center, SQL Developer, SQL Navigator, TOAD, UNIX/LINUX, Windows.

Confidential, PA

Sr. PL/SQL Developer

Responsibilities:

• Creating Oracle objects like tables, types, context, packages, procedures and functions to Add, Maintain, Updates and Deactivates Firms, Desk, Users that can View, Modify and Trade.
• Automated sql loader using shell scripting.
• Reviewed the UI validations and added required validations to the packages to ensure the ideal data population into the tables.
• Involved in development, enhancement and maintenance of PL/SQL interfaces such as defining packages, developing procedures and functions.
• Develop the Shell scripts to automate the finance billing file
• Defined Views and Materialized views for simplifying reporting queries and performance
• Performed Query optimization and PL/SQL tuning to maximize performance
• Developed PL /SQL code for updating payment terms
• Developed TOAD, SQL*loader scripts to load data in the custom tables.

Environment: SQL, PL/SQL, SQL*plus, SQL*Loader, Oracle 9i/10g/11g, java, Shell Scripting, Informatica. Toad, BMC sql developer tool, Sales force for issues.

Confidential, Parsippany, NJ

Sr. PL/SQL Developer

Responsibilities:

• Responsible for Development, Enhancement, Support and Maintenance of the aCAT, pCAT and CDF applications
• Effectively Re-factored existing Code/Design and various Process to meet the system specifications and fit into weekly, Monthly and Quarterly cycle windows leaving certain amount of Buffer to investigate or re-run when necessary
• Made use of advanced features such as Analytical Functions, Model Clause and Table Functions, Multi table inserts of 10G to improve Efficiency, Readability and maintainability of Code
• Effectively made changes to DATA-MODEL to support various weekly and Ad-Hoc reports by gaining significant increase in performance
• Defined Views and Materialized views for simplifying reporting queries and performance also effectively made use of Query re-write where that change in view or objects has a significant impact on downstream system
• Performed Query optimization and PL/SQL tuning to maximize performance

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, SQL*plus, SQL*Loader, Windows XP, Shell Scripting, Informatica, PVCS Tracker, PVCS Version Manager.

Confidential, Boston, MA

PL/SQL Developer

Responsibilities:

• Responsible for tracking requirements by interacting with business team
• Enhancement of Logical and Physical models to in corporate new features
• Involved in development, enhancement and maintenance of PL/SQL interfaces such as defining packages, developing procedures and functions.
• Defined Views and Materialized views for simplifying reporting queries and performance
• Performed Query optimization and PL/SQL tuning to maximize performance
• Made changes in the existing data model and system for new enhancements
• Created rerun able shell scripts for meta data creation and maintenance
• Supported nightly builds and deployments and also part of 24/7 support team
• Responsibly followed build and release process
• Prepared test data, test cases

Environment: Oracle 8i/9i, SQL, PL/SQL, Shell Script, Toad, Clear Case, Web logic, SQL*loader, Unix Shell scripts, Oracle 9i, Unix, Windows, PVCS Tracker, PVCS Version Manager.

Confidential

PL/SQL Developer

RESPONSIBILITIES:

• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing
• Performing the tests on the newly coded procedures and documenting the same.
• Writing technical documents using the functional specifications
• Writing PL/SQL code using the technical and functional specifications
• Creating Oracle objects like tables, types, context, packages, procedures and functions.
• Automated sql loader using shell scripting
• Involved in Development of the Server side applications.
• Understanding the requirements using functional documents and client specified documents
• Optimized the queries to improve the performance of the application

Environment: ORACLE 8i, PL/SQL, Developer 2000, Java, Servlets, JSP, Struts, JDBC, UNIX, SQL*loader, Unix Shell scripts, Oracle 9i, Unix, Windows, PVCS Tracker, PVCS Version Manager