SUMMARY:

Around 7 years of total experience in analysis, design, development, and testing of business applications in web based, Client/Server architectures.

• Hands-on experience in writing Packages, Stored procedures, Functions, and Database Triggers using SQL and PL/SQL.
• Excellent working and conceptual knowledge of Oracle SQL, PL/SQL, Oracle Forms 6i /9i, Oracle Reports 6i / 9i.
• Knowledge of C/C++, Java, UNIX Shell Scripting and HTML.
• Expert in Oracle database. Used Oracle Forms and Reports as GUI for Oracle Applications and development of high performance technical solutions to meet the challenging business demands to the clients.
• Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
• Have knowledge in UNIX Shell Scripting.
• Experience with Large Database query optimizations.
• Experience in using TOAD and SQL Navigator.
• Experience in data analysis, data modeling, system analysis and requirements management, business process modeling in Finance, Banking and Insurance industries.
• Experience in Data warehousing ETL Tools Informatica and DTS.
• Extensive experience in using Cursors for processing of data.
• Experience in creating Materialized Views. Tuning and optimizing current and new applications utilizing DBMS packages, and enhancing performance through regeneration and rebuild of indexes and creation of views.
• Analyze data quality and report the anomalies to business users using TOAD.
• Expertise in JAVA, J2EE, EJB, Servlets, JSP, JMS, XML, JNDI, JDBC, RMI on UNIX and NT.
• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle (SDLC).
• Excellent analytical and communication skills that are required to work effectively in the field of applications development and maintenance.

TECHNICAL EXPERTISE:

Databases : Oracle 10g/9i/8i, MS-SQL Server 2000/2005, MS Access. Scripting : SQL, PL/SQL, and UNIX Shell Scripting Languages : C, C++, Java, XML, Perl and Visual Basic Query Tools : TOAD, SQL Navigator, and SQL* PLUS Development Tools : Oracle Forms5/6/ 6i / 9i and 10g, Oracle Reports 6i/9i/10g Operating Systems : Windows 2k3/2k/XP, UNIX Sun Solaris4/5/7/8, LINUX, HP-UX Other Tools : Toad, Discoverer 9i, SQL*Loader, MS-Visio, PVCS. ETL Tool : Informatica 8.1/7.x

EDUCATION: Bachelors in Computer Applications

PROFESSIONAL EXPERIENCE:

Confidential, Princeton-NJ November 07-Present Sr. Oracle PL/SQL Developer - Conversion Team Confidential is State child support system in New Jersey. Worked in Confidential conversion team. Responsible in converting the present and history data from mainframes to Oracle database. Complete conversion is done through PL/SQL code and Java scripts.

• Developed and modified PL/SQL code for complete process of conversion from mainframes database to oracle database.
• Modified Java scripts as per technical specifications.
• Prepared Data Flow Diagrams for existing PL/SQL code.
• Involved in coding of data extraction scripts as per technical specifications.
• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.
• Resolved functional issues in business processes through enhancements.
• Performed Unit testing for the scripts modified.

Environment: Oracle 10g, 9i, OAS 9i (Oracle Application Server), PL/SQL, TOAD, Forms 9i, Reports 9i, SQL*Loader, SQL Server 2000/2005, J2EE (JSP, Servlet, JDBC, Beans, DAO, MVC/STRUTS, EJB, RMI UNIX, WINDOWS, HP 9000 server HP-UX

Confidential, Charlotte-NC February 07 - September 07 Sr. Oracle PL/SQL Developer Confidential is one of the world's largest financial institutions, serving individual consumers, small businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. During this project different applications were developed for novice users at front office and made it simple for them to retrieve different kind of data from database without having more technical knowledge. The employees could generate and display reports easily. The project at BofA involved maintaining a data warehouse to improve overall quality and productivity of existing processes by analyzing their business activities. I was involved in creating and maintaining databases in Oracle and also performed the ETL operations to build and maintain the data warehouse.

Responsibilities:

• Created and managed many objects in large Oracle Databases containing millions of records.
• Coded and debugged the Stored Procedures, Packages and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Extensive querying using SQL* Plus / TOAD to monitor quality & integrity of data.
• Involved in Extraction, Transformation and Loading (ETL) of data using Informatica PowerCenter 8.1.1/7.1.
• Extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with the use of Cursors, REF Cursors and loops.
• Designed and developed forms and Reports using Oracle Forms 9i and Reports 9i.
• Created database objects like tables, views, synonyms, indexes, and sequences.
• Developed GUI screens using the Oracle Forms and the User Reports using Oracle Forms.
• Developed PL/SQL procedures and functions to migrate data between Oracle Databases.
• Loaded and unloaded data sets from or to Oracle Databases using TOAD.
• Used JDBC to access data from database servers.
• Developed User Interfaces with JSP, Servlets using the Java Struts (MVC) Framework.
• Responsible for writing the night batch process using Shell scripts and run them using Cron Job.
• Used shell scripting to change and modify data.
• Integrated, tested, debugged and implemented application systems.
• Tuning of SQL statements using EXPLAIN PLAN to improve the performance.
• Experience in Performance Tuning & Optimization of SQL statements.
• Optimized SQL statements and PL/SQL blocks by analyzing the execute plans and statistics of SQL statements and created and modified some Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways.
• Good knowledge of business logic in financial sector including Statement processing.

Environment: Oracle 10g, 9i, OAS 9i (Oracle Application Server), PL/SQL, TOAD, Forms 9i, Reports 9i, SQL*Loader, SQL Server 2000/2005, J2EE (JSP, Servlet, JDBC, Beans, DAO, MVC/STRUTS, EJB, RMI UNIX, WINDOWS, HP 9000 server HP-UX.

Confidential, Indianapolis, IN February 06 - January 07 Oracle Developer Confidential is a leading, innovation-driven corporation committed to developing a growing portfolio of best-in-class and first-in-class pharmaceutical products that help people live longer, healthier and more active lives. Our team was responsible for creation of new interface tables, Pl/SQL scripts for creating new objects, Creating new user-friendly screens and reports.

Responsibilities:

• Coordinated with business users to collect the requirements.
• Involved with writing the specifications and analyze the code and design document.
• Designing the data entry forms.
• Worked on logical and physical data modeling.
• Created PL/SQL stored procedures, functions, and packages for moving the data from staging area to data mart.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Involved in End to End Software Development Life Cycle.
• Worked extensively in tuning SQL statements to optimize the performance.
• Involved in Unit testing and Integration System testing.
• Developed J2EE(MVC, Servlet, Beans, JSP,JDBC) application to store messages in Oracle database for message conversion using Tomcat web server and WebSphere application server

Environment: Windows, Oracle 9i, PL/SQL, SQL* Loader, SQL*PLUS, Mercury Interactive Load Runner 7, Visual Basic and J2EE(MVC, Servlet, Beans, JSP,JDBC).

Confidential, Atlanta, GA April 05 - January 06 Oracle Developer Confidential is the largest communications holding company in the United States. Operating globally under the AT&T brand, AT&T is recognized as the leading worldwide provider of IP-based communications services to businesses and the leading U.S. provider of wireless, high speed Internet access, local and long distance voice, and directory publishing and advertising services.

Responsibilities:

• Creating Stored Program Units in the Functions, Triggers and procedures for implementing complex database intensive business rules .
• Managing tables, indexes, constraints, views sequences, synonyms and stored program units.
• Created Bourne Shell scripts and Bash Shell Scripts for automating tasks as well as for creating extracts.
• Written PL/SQL cursors for transaction processing.
• Implemented triggers based on the business rules.
• Written Queries for the management in the form of stored procedures and packages.
• Implemented logical backup of the structures with the help of EXPORT utility.
• Tuning the SQL Queries for better performance.
• Develop & debug PL/SQL, Create Execute and Optimize SQL queries while providing an interactive community to support the user experience by using TOAD.
• Worked on different Core/J2EE Design Patterns such as Singleton, DAO, DVO, Business Delegate, Service Locator for the implementation.

Environment: Oracle 9i/8i, Solaris 5.8, Windows, HP 9000 HP-UX SQL Developer, Oracle Developer 2000, TOAD and J2EE(MVC, Servlet, Beans, JSP,JDBC)..

Confidential, April 03 - March 05 Oracle Developer Confidential is a leading Construction company in Middle East. During projects in Diplomat our team was responsible in developing the applications and maintaining the database for material and man power.

Responsibilities:

• To prepare the Database depending on the functional requirement document.
• Design staging database (source and target), develop ER diagrams (Physical and Logical using ER win) and translate them into Database objects.
• To develop Oracle Forms and Oracle Reports depending on the functional requirement document.
• To develop SQL Scripts, Stored Procedures, Functions, Database Triggers and Packages using SQL and PL/SQL to cover the functionality as per the functional requirement document.
• Involved in the development of shell scripts.
• Performed tuning of the SQL queries using Explain Plan.
• To prepare test cases for testing the new requirements without affecting the functionality of the system.
• To test the new developments depending on the test cases.
• To prepare the documents for the new developments.

Environment: Oracle 9i/8i, PL/SQL, Forms 6.0, Reports 6.0, ERwin, SQL*Loader, SQL Server 2000, T-SQL, UNIX (Sun Solaris), Windows.

Confidential, August 01 - March 03 Programmer

Confidential is one of the India's largest financial institutions, serving individual consumers, small businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. Responsibilities:

• Handling the requests according to the user specifications.
• Created various tables. Views, Indexes, and sequences.
• Created grants of roles and privileges to the users.
• Develop SQL* Loader scripts for data extraction and transformation.
• Evaluated the data quality using developed Pl/SQL stored procedures and UNIX shell scripts.
• Wrote a number of control files to load data into oracle tables using SQL* Loader.
• Analyzed current procedures, recommended and implemented improvements as needed.
• Monitored daily activities and troubleshooting.
• Performed programming debug, Unit and Integration testing.
• Worked with the clients and the development team throughout the project life cycle and confirmed all documents.

Environment: Windows, UNIX Oracle 8i, Erwin 3.5, PL/SQL, SQL*Loader