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

RDBMS: Oracle 11g/10g/9i/8i

Oracle Tools: SQL * Loader, TOAD,PL/SQL Developer, SQL Developer, SQL Tool, SQL Navigator, Developer 2000 (REPORTS 6i/9i /10g, FORMS 6i/9i/10g), SQL*Plus, Discoverer

ETL Tools: Informatica Power Center 8.6.X

Data Modeling Tools: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003, Oracle Designer 10.1.2.3

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

Programming: Unix Shell Scripting, Perl Programming, XML

Languages: C, C++,Java, HTML,XMLPro*C

Environment: Sun Solaris 2.6/2.7/2.8/5.10/8.0 , Red Hat Linux, Windows NT/ 95/ 98/ 2000/ XP,MS DOS 6.22

PROFESSIONAL EXPERIENCE

Confidential, Raymond, Ohio

Oracle PL/SQL developer

Responsibilities:

• Involved in development of process using SQL* LOADER, PL/SQL Programming.
• Extensively used tools like SQL PLUS, SQL Developer, Toad and PL/SQL developer for programming purposes.
• Worked on shell scripting to kick off the SQL Loader control files to load the data into database/multi environments for existing application usage.
• Responsible for development, implementation and Support of various RDBMS (oracle) based IT projects specially related to ETL, Data warehousing, and Data marts, reporting. Various batch jobs.
• Worked closely with business and product group to enhance functionality of pre-paid platform to implement various clients requirement.
• Worked with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure, played liaison role with customers as well with other business segments
• Total Responsibility for all development and implementation of Database (Oracle RDBMS), work that includes OLTP.
• Involved in Performance tuning of complex queries.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
• Tuned database SQL statements and procedures by monitoring run times and system statistics.
• Responsible of Provisioning, Storage Management, Patching and Validation and Diagnostics.
• Developed and implemented ETL Components based on the filter rules to obtain needed data from different source systems for calculating required metrics using Informatica Power center.
• Hands as well sound Knowledge of ORACLE RDBMS, extensive SQL, PL SQL, DB physical modeling, Data analysis.
• OLTP reporting using analytical quires, Reports. Excel pivoting.
• Prepared test Scenarios and Test cases in Rational Quality Manager and involved in unit testing of mappings, system testing and user acceptance testing.
• Defect Tracking and reports are done by Rational Quality Manager.

Environment: Oracle 11g, Oracle Application Servers, PL/SQL, OLTP, Windows 8, SQL*LOADER, TOAD, UNIX Shell Scripting, Oracle SQL Developer, SQL*Plus, OLAP, OLTP, SQL Server Integration Services (SSIS) 2005/2008, SQL Server Reporting Services (SSRS) 2008, MS SQL Server 2008 R2, Rational Quality Manager.

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.
• Analyzed data, designed and developedOracle FORMS 10g queries, layout, report triggers, parameter form, data modelsetc.
• Modified existing codes and developed PL/SQL packages to perform certain specialized functions / enhancement on oracle application.
• Worked on various tables to create Indexes to improve query performance.
• 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.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• 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.
• Worked closely with users and developers team to resolve issues in the developed reports.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, SQL* Loader, Oracle FORMS, 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 Oracle Apex Application from Scratch.
• Created documentation, design and implemented rich user interfaces using Oracle Apex.
• 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 and developed different reports using Pro*C.
• 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, Pro*C, Oracle APEX, Oracle Application Server 9i, Discoverer 9i and UNIX Scripting.

Confidential, IL

Oracle Developer

Responsibilities:

• Gathering system requirements through client interactions.
• Created documentation, design and implemented rich user interfaces using Oracle Apex.
• Created database objects like Tables, Indexes, Sequences and Views etc.
• 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, Oracle APEX,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.
• Developed related PowerBuilder Objects like(windows, datawindows, UserObjects ) and Database Objects like ( Stored Procedures, Packages, functions, Tables etc) using PL/SQL programming.
• 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/11g, PowerBuilder, SQL * LOADER, OLAP, Toad, MS-Windows, Clear case, UNIX Shell Scripting.

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.