SUMMARY

• Over 8 years of experience in designing, modeling, creating and maintaining Oracle database applications.
• Expertise in using Oracle 9i /10g/11g databases
• Excellent skills in writing PL/SQL Stored Procedures, Functions, Triggers, Packages and Fine - Tuning them.
• Extensive knowledge in design and modeling database
• Extensively used QUEST Tools (TOAD, PL/SQL developer), SQL*PLUS and SQL *Loader.
• Good knowledge of BI Logic through QlikView
• Knowledge on DBA activities such as Performance Tuning, Backup and Recovery.
• Expertise in developing UNIX Shell scripts (Korn shell).
• Expertise in using Oracle VPD’s, Context, XML types, SQL Analytical functions
• Expertise in using advanced pl/sql Object types
• Knowledge on J-Publisher to implement the Java/Oracle interface with Oracle Object types.
• Good Knowledge on SQL Performance Tuning & PL/SQL Tuning via explain plan.
• Good knowledge on Hashing mechanism via dbms crypto oracle built in package.
• Good knowledge on Table Partitioning & Index maintenance.
• Excellent analytical skills, self-motivated, team player with effective communication and leadership qualities.

TECHNICAL SKILLS

RDBMS: ORACLE 11g/10g

Languages: SQL, PL/SQL, Unix Shell Scripting

Environment: Windows 2000/ XP/ NT, Linux & UNIX

Utilities: SQL* Loader, J-publisher, expdp, impdp

IDE: TOAD, PL/SQL DEVELOPER

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

PL/SQL Developer

Responsibilities:

• Extensively involved in the Design and Documentation.
• Extensively used SQL*LOADER to load data from flat files
• Extensively involved in Mathematical analysis and Load forecasting algorithms.
• Extensively involved in Costing & Structuring calculations.
• Extensively used regression functions to forecast the load.
• Extensively used collection / PL-SQL Objects to enhance the performance.
• Created External Tables to load data from flat files where one to many and many to one relation exists between the flat files and Database tables.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Extensively used Objects, types & built API’s on backend to interface with UI.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Developed Korn Shell scripts to automate Ingestion Process.

Environment: Oracle Database 11g, TOAD, PL/SQL developer, SQL*Loader.

Confidential, VA

PL/SQL Developer

Responsibilities:

• Extensively involved in the Design and Documentation.
• Extensively used SQL*LOADER to load data from flat files obtained from TTS and ALBRIDGE on daily basis.
• Created External Tables to load data from flat files where one to many and many to one relations exists between the flat files and Back office Database tables.
• Involved in Gap Analysis between TTS and ALBRIDGE.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Developed Korn Shell scripts to automate Ingestion Process.
• Developed control files for SQL* Loader and PL/SQL scripts for Data Extraction/Transformation/Loading (ETL) and loading data into interface Tables from different systems and validating the data.
• Developed complex SQL queries using Joins, nested queries, in line Views, in built Packages, Functions and clauses.
• Performed PL/SQL code reviews for maintaining standards and to identify inefficient SQL statements.

Environment: Oracle Database 11g, PL/SQL Developer, SQL*Plus, TOAD, SQL*Loader, Windows Server 2003, UNIX

Confidential, Richardson, Texas

Oracle Developer

Responsibilities:

• Extensively involved in the Design and Documentation.
• Extensively involved in Complex Costing calculations.
• Extensively used regression functions to forecast the load.
• Extensively used collection / PL-SQL Objects to enhance the performance.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Extensively used Objects, types & built API’s on backend to interface with UI.
• Developed Korn Shell scripts & Pl/sql Jobs to schedule and automate the jobs.
• Extensively used Explain plan to figure out the cause for poor performing queries.
• Implemented Hash mechanism to speed up the process flow.
• In process of implementing Clustering on tables to boost up the performance.
• Used XML with in PL/SQL.

Environment: Oracle Database 10g, UNIX shell scripting, Siebel CRM Application, Sun Solaris, TOAD.

Confidential

Oracle Developer

Responsibilities:

• Developed and modified database procedures, functions, packages to enhance and improve functionality using PL/SQL.
• Extensively worked with DDL and DML commands and was also responsible for creating tables, enforcing Constraints.
• Inserted and updated log tables for each transaction on any table using triggers.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Interacted with business analysts to develop modeling techniques and re-structuring strategies.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Involved in debugging and Tuning the PL/SQL code, tuning queries and optimization of the Oracle database.
• Created external tables to transfer .csv files to tables and from tables to .csv using the standard package utl file.
• Performed subsequent alterations using SQL, PLSQL to make any changes on adhoc requirements.
• Performed Data Extraction, Data Transformation and Data Loading (ETL).

Environment: Oracle Database 10g, SQL * Plus, SQL * Loader, SQL Developer, Oracle Discoverer10g

Confidential

SQL Server Developer

Responsibilities:

• Installation and Configuration of SQL Server 2008.
• Incorporated business logic using stored procedures and functions.
• Used DB export/import and SQL Loader utilities to transfer data from the main DB to the reporting DB. Performed validation, extraction of multi field values and populating it in application tables.
• Developed various queries using views, correlated sub queries, joins, merge and grouping/ aggregation functionality.
• Executed complex queries and subqueries to update and insert data into the database.
• Designed Conceptual Data Model and Physical Data Model using Erwin.
• Worked with slowly changing Dimensions (Type 1 and 2).
• Involved in creating procedures using Dynamic SQL.
• Worked with isolation levels- read committed, read uncommitted, repeatable read and serializable to enhance security.
• Used Export/Import Wizard to transfer large chunks of data from various sources.
• Created a DB with normalized tables, with one-to-many cardinality.

Environment: SQL Server 2005/2008 Enterprise Edition, MS SQL Server Management Studio, Erwin Data Modeler, MS PowerPoint, MS Excel