SUMMARY:

• Around 10 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 noledge of Oracle SQL, PL/SQL, Oracle Forms 6i /9i/10g/Oracle Fusion Middleware 11g, Oracle Reports 6i / 9i/10g.
• 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 noledge in UNIX Shell Scripting.
• Experience wif Large Database query optimizations.
• Experience in using TOAD, PL/SQL Developer and SQL Developer.
• 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 ODI, 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.
• 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 SKILLS

Databases: Oracle 11g/10g/9i/8i, MS-SQL Server 2000/2005, MS Access.

Scripting: SQL, PL/SQL, UNIX Shell Scripting and Python

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, SQL*Loader, MS-Visio, PVCS.

ETL Tool: ODI 11g/10g, Informatica 8.1/7.x

Data Modelling Tools: SQL Developer and ERWin

PROFESSIONAL EXPERIENCE

Snap-on Business Solutions

Confidential

Responsibilities:

• Designed and developed publishing process to migrate and load different feeds.
• 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.
• Responsible for data analysis and data modeling of publishing process.
• Designed and developed publishing process in ODI.
• Extensive querying using SQL* Plus / TOAD/PL/SQL Developer to monitor quality and integrity of data.
• Prepared Data Flow Diagrams and mapping documents 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 and ODI objects: datastores, interfaces, packages, load plans, tables, indexes, constraints, triggers and stored procedures.
• Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.
• 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.
• Resolved functional issues in business processes through enhancements.
• Performed Unit testing for the scripts modified.
• Responsible for writing python scripts to convert and load images to database.
• Developed automating reports by validating converted data.
• Involved in production support and resolved many critical issues by providing emergency cleanup scripts.

Environment: ODI 11g, Oracle 11g, 10g, PL/SQL, TOAD, SQL*Loader, Weblogic, Jython, Python, Solaris, UNIX, SQL Developer.

Confidential

Sr. Oracle Developer

Responsibilities:

• Designed and developed complete rate engine so Policy Center quote/application system could access newly added rating algorithms.
• Involved in database designing, data analysis and data modeling for component responsible.
• 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 and integrity of data.
• Prepared Data Flow Diagrams and mapping documents 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.
• 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.
• Resolved functional issues in business processes through enhancements.
• Performed Unit testing for the scripts modified.
• Involved in Batch Operations.
• Responsible for writing the night batch process using Shell scripts.
• Developed automating reports by validating converted data.
• Involved in production support and resolved many critical issues by providing emergency cleanup scripts.

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

Confidential

Sr. Oracle Developer

Responsibilities:

• Developed and modified complete process of Child support from mainframes database to oracle database.
• 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 and integrity of data.
• Designed application screens in Oracle Forms 10g & 11g.
• Designed and generated Reports in 10g & 11g.
• Modified Java scripts as per technical specifications.
• Prepared Data Flow Diagrams and mapping documents 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.
• 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.
• Resolved functional issues in business processes through enhancements.
• Performed Unit testing for the scripts modified.
• Involved in Batch Operations.
• Responsible for writing the night batch process using Shell scripts.
• Developed automating reports by validating converted data.
• Involved in production support and resolved many critical issues by providing emergency cleanup scripts.

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

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed and modified PL/SQL code for complete process of conversion from mainframes database to oracle database.
• 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 and integrity of data.
• Designed application screens in Oracle Forms 10g & 11g.
• Designed and generated Reports in 10g & 11g.
• Modified Java scripts as per technical specifications.
• Prepared Data Flow Diagrams and mapping documents 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.
• 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.
• Resolved functional issues in business processes through enhancements.
• Performed Unit testing for the scripts modified.
• Involved in Batch Operations.
• Responsible for writing the night batch process using Shell scripts.
• Developed automating reports by validating converted data.
• Involved in production support and resolved many critical issues by providing emergency cleanup scripts.

Environment: Oracle 11g, 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

Sr. Oracle PL/SQL Developer

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 wif 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 wif JSP, Servlets using the Java Struts (MVC) Framework.
• 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.
• Good noledge 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

Oracle Developer

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 wifout 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

Programmer

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 wif 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