SUMMARY

• Over 7 years of extensive IT experience in all aspects of Systems Development and complete Project Life Cycle in Oracle PL/SQL including requirements, Analysis, Design, Development, Testing and Implementation.
• Extensively worked in Client - Server application development using Oracle 8.0/8i, 9i, 10/g, PL/SQL and SQL *PLUS, Oracle Forms/ Reports 10g/6i.
• Extensive experience in application data modeling and building data warehouse architecture (Star & Snowflake schemas) and ER Diagrams using Microsoft Visio, Erwin and IBM Rational Rose data modeler tool.
• Extensively worked in PL/SQL for creating stored procedures, clusters, packages, database triggers, exception handlers, cursors, cursor variables.
• Extensively Worked on Oracle Database creation, Table Space management, (Export & Import) Backup, Performance tuning, Tuning Init.ora file.
• Working knowledge of SQL Trace, TK-Prof, Explain Plan, Pro*C, SQL Loader for performance tuning and database optimization.
• Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems
• Experienced in working with many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.
• Expert in maintaining data integrity using various constraints and database triggers.
• Supported DBA to Take Back up, Monitoring Performance and Tuning Activities.
• Extensively used QUEST Tools (TOAD, Navigator) and SQL*PLUS.
• Experienced in Unit testing and Integration Testing with excellent debugging skills.
• Experience using Red Hat Linux, Ubuntu, and Sun Solaris.
• Experienced in developing the UNIX Shell Scripts and PERL Scripts to execute the scripts and manipulate files and directory.
• Controlling Access: Granting and revoking permissions to users, groups and roles on various objects.
• Also involved in exporting and importing of data using utilities like Export, Import, Data Pump Export and Data Pump Import.
• Good team player with strong technical, analytical and people skill for effective software development.
• Communicate complex topics clearly and concisely, both verbally and in writing, tailoring communications to fit the audience.

TECHNICAL SKILLS

Languages: C, C++, Java, SQL, PL/SQL, UNIX shell scripting and Perl scripting.

Databases: Oracle 9i/10g/11g, MS SQL Server 2008, MS Access, DB2Tools SQL * Loader, TOAD, SQL Developer, SQL Tool, SQL Navigator, Developer 2000 (REPORTS 6i/10g, FORMS 6i/10g), SQL*Plus, Discoverer, Power Builder 12, MSBI (SSIS/SSRS/SSAS).

Web Technologies: HTML, CSS, XML, JavaScript.

Web Servers: Tomcat, IIS.

Operating Systems: UNIX, Solaris, Windows 95/2000/NT/XP/Vista/Windows7.

PROFESSIONAL EXPERIENCE

Confidential, Raymond, Ohio

Oracle PL/SQL developer

Responsibilities:

• Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
• Tuned PL/SQL packages to improve performance of the application.
• Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, indexes.
• Improved Performance of Discoverer Reports using Materialized views.
• Developed UNIX Shell Scripts for Autonomous Jobs.
• Developed UNIX Shell Scripts for to run SQL Queries for Auto Reports.
• Writing event driven triggers, functions, and packages as needed.
• Writing SQL queries, Cursors using embedded SQL, PL/SQL.
• Testing and debugging of the applications.
• Implementation and end user training.

Environment: Oracle 9i/11G, Oracle SQL Developer, IBM Clear Quest, IBM Clear Case, Windows 7, SQL * Plus.

Confidential, HOUSTON, TX

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in designing and development of data warehouse for the corporate data repository.
• Created and maintained Database Objects (Tables, Views, Indexes, Sequences, Database triggers, stored procedures).
• Wrote complex SQL queries using joins, sub queries and correlated sub queries for various reports.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Developed SQL* loader scripts to load data in the custom tables.
• Modified existing codes and developed PL/SQL packages to perform certain specialized functions / enhancement on oracle application.
• Developed and optimized SQL queries using TOAD Explain Plan utilities.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN and TKPROF to significantly improve the system response, time and efficiency.
• Run batch jobs for loading database tables from flat files using SQL* Loader.
• Used Version Control tools like Microsoft Visual SourceSafe for Source Control.
• Developed Materialized views and Ref Cursors for reporting purpose.
• Defined indexes on various tables to improve the performance of the queries for reporting purpose.
• AUTONOMOUS TRANSACTION PRAGMA is used in the framework procedures to log the status when error occurs.
• Worked closely with users and developers team to resolve issues in the developed reports.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, SQL* Loader, TOAD, Erwin 7.2, Microsoft Visual SourceSafe, Putty, UNIX, Shell scripts.

Confidential, COLUMBUS, OH

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.
• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.
• Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
• Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, indexes.
• Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.
• Generated Oracle FORMS and REPORTS using Designer 10g.
• Improved Performance of Discoverer Reports using Materialized views.
• Developed UNIX Shell Scripts for Autonomous Jobs.
• Developed UNIX Shell Scripts for to run SQL Queries for Auto Reports.
• Designed, Developed and Tested application in UAT environment and Deployed in Production.
• Provided Productions supports and ongoing user supports for the application.
• Designed Development Documentation and Support Documentations.

Environment: Oracle 10g, Oracle FORMS/REPORTS 10g, Designer10g, TOAD, Oracle Application Server 9i, Discoverer 9i and UNIX Scripting.

Confidential, IL

Oracle Developer

Responsibilities:

• Gathering system requirements through client interactions.
• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Developed procedures, functions and packages to implements the system’s business logic using PL/SQL.
• Extensive use of SQL commands with TOAD environment to create target tables.
• Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Involved in developing forms for data load and generated various reports using oracle forms and reports.
• Perform Migration to Forms and Reports 10g from earlier versions.
• Optimized the performance using PL/SQL table types and record types.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints.
• Analyzed the performance of the SQL queries and created the scripts for indexes.
• Extensively worked in Performance tuning of PL/SQL programs.
• Wrote SQL queries to developed test data for use during test execution.
• Perform Inbound Interface by creating Temporary tables, then Validate data and then Load into Interface Tables by using SQL Loader.
• Use UTL FILE to insert the data into files and stored in appropriate server path.
• Used ETL tools to extract and load data from SQL Server and flat files to Oracle database.
• Coding of documents in XML for data transformation.
• Developed test procedures to Unit test the application.
• Worked on Oracle OLAP tool to produce analytic measures, including time-series calculations, financial models, and forecasts.
• Implemented table and index partitioning of various tables with huge data.
• Provided Post Implementation Technical Support to the users.

Environment: Oracle 10g, SQL, PL/SQL, SQL plus, Oracle AQ, Oracle Forms 10g, Oracle Reports 10g, TOAD,SQL Loader, UTL FILE utility, XML, Performance Tuning, ETL Tools, UNIX, Windows 2000

Confidential

PL/SQL Developer

Responsibilities:

• Requirements gathering, design of the logical flow of the system, preparation of Project Plan and System Requirements Specification (SRS).
• Prepared Program Specifications, Screen Layouts, Project Standards.
• Responsible for designing the Oracle Database using database-modeling tool Erwin.
• Designed and developed different Database Objects (Stored Packages, Procedures, Functions and Triggers) using PL/SQL.
• Used PL/SQL to write the Stored Procedures, Views extensively to get the Monthly, Annual Reports and Audits.
• Used Dynamic SQL statement for run time SQL query processing.
• Wrote various Queries, PL/SQL Stored Procedures and Triggers to augment the application logic.
• Modified existing Interfaces using PL/SQL procedure, triggers and functions in the Human Resources module.
• Involved in developing test plans and strategies, as well as the design, development, and execution of Test Cases.
• Created the conceptual model for the data warehouse using Erwin data modeling tool.
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users, App Dev and Information architects to make sure all the requirements are fully covered.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.

Environment: Oracle 10g, SQL, PL/SQL, SQL Developer 1.5.3, Erwin.

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.
• Preparing technical documents using the functional specifications.
• Building PL/SQL code using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Automated SQL Loader using shell scripting.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application.

Environment: Oracle 8.3, SQL * Plus, TOAD, SQL*Loader, Forms 4.5 & Reports3.0 and Windows 2000 professional, UNIX shell scripting.