SUMMARY

• Over 8+ years of extensive IT experience in Packages, Stored Procedures, Functions, Exception handling, Dynamic Cursor programs, Data Collections, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Expertise in Data ware house, Application Development and Production Support in Client/Server Environment using Oracle 11g/10g/9i/8.x, SQL, PL/SQL.
• Excellent proficiency in Data Extraction, Transformation and Loading, into Oracle Database.
• Good understanding of Star and Snowflake Schema, Dimensional Modeling and Slowly Changing Dimensions, ETL, Data analysis for ODS, online transactional processing (OLTP) and Data Warehouse / Business Intelligence (BI) - logical/physical, relational and multi-dimensional modeling (Star Schema, Snowflake Schema), optimization, partitioning, archiving and capacity planning.
• Strong in ETL, Data warehousing, Operations Data Store concepts and data marts.
• Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Links and Database Directories.
• Proficient in Oracle utilities and tools - SQL*loader, Export/Import, TOAD, SQL*plus, SQL Developer and SQL Navigator, Oracle Application Express 2.2/3.0
• Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes.
• Implementing and supporting Test and Production environment.
• Comfortable working with Unit Testing, Debugging, and Deployment of Applications.
• Strong experience in Oracle ETL data loading techniques like SSIS, ODI, SQL loader, Copy Command and External tables from various business source environments.
• Implementing and supporting Test and Production environment.
• Extensively worked with database development writing stored procedures, functions, packages, and data base triggers using SQL, PL/SQL.
• SQL Performance Tuning using TKPROF utility, Explain plan and AUTOTRACE.
• Worked extensively with SQL Loader using control files for data ware housing and data loading into database tables.
• Extensively used Oracle Datamoduler for database design and generating ER diagrams.
• Worked on UNIX, Ms-Dos, Windows NT and Windows 95/98/2000/XP operating systems.
• Working on Unix batch scripts and maintenance
• Extensively used TOAD, SQL Developer, PL/SQL Developer.
• Developed Batch programs to the preprocessing for the batch reports and coded customized PL/SQL packages, procedures and database triggers.
• Strong understanding of business processes & interface with IT.
• Worked Clear Case, Releases deployments, Check in and Check outs.
• Strong writing and documentation skills for the management, development and control of documentation and Involved in the end-user training.
• Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and Load testing. Seamlessly migrated the Code from Development to Testing, UAT and Production.
• Ability to work in a team environment and as an individual with strong technical and communication skills, and good zeal in adapting new technologies in a fast paced environment.

TECHNICAL SKILLS

Languages: PL/SQL, C, C++, Java, HTML/DHTML and T-SQL.

Databases: Oracle 8i/9i/10g/11g, MS Access, MS-SQL Server 7/2000/2008R2/2012

Scripting: SQL, PL/SQL, UNIX Shell Scripting, ASP .

Operating Systems: Windows, UNIX, Linux.

Query Tools: TOAD, SQL Developer, SQL Navigator, SQL* Plus, iSQL * Plus

Other Tools: Oracle SQL Developer, Toad, SQL* Loader, Workflow and Win Runner.

PROFESSIONAL EXPERIENCE

Confidential, Addison, TX

Sr. Oracle Developer

Responsibilities:

• Worked extensively on OLTP and Dataware house projects involving Cursors, Ref-cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools etc.
• Wrote complex PL/SQL queries and performed data analysis.
• Worked extensively on performance tuning handling large volume of datasets(>500 million rows).
• Modified and enhanced existing systems to in corporate new functionality and to optimize them for performance.
• Worked extensively on performance tuning and Query Tuning (Generating Plan Table, Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, SQL Trace, TKPROF,AWR and ADDM reports).
• Worked on Data Migration and Data Conversion from sql server, DB2 to Oracle using oracle sql developer, ispirer and various ETL tools like MS SSIS and ODI(Oracle Data Integrator)
• Worked on Database Design, Data Modeling, Migration, and Systems Architecture, Planning, Testing Query Optimization and Trouble Shooting.
• Developed back end interfaces using PL/SQL packages, stored procedures, functions, Object Types, Pipelined functions, Oracle queues and used Collections, Bulk Collects to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
• Designed the PL/SQL Procedures to load data from Flat files and Oracle into the target Oracle database.
• Designed Logical and Physical data, defined relationships, and implemented business rules as constraints for normalization / Demoralization of entities.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Responsible for developing source system logical and physical data model using Erwin and Sybase Power Designer to setup an Oracle ODS and Data marts.
• Designed SSISPackagesto transfer data from non Oracle sources(SQL Server, DB2 and flat files) to Oracle Server using Business Intelligence Development Studio.
• Worked on Oracle Data Integrator (ODI) administration, Topology manager, Designer, Operator and trouble shooting of the packages.
• Worked with the Business analysts and analyzed various sources for requirements gathering, business analysis, testing, metrics and project coordination.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures.
• Used the data load upload functionality of APEX to upload first time data into the database tables.
• Used authorization schemes functionality of APEX to set up security on the screens in the application based on user roles.
• Analysis and design of ETL Processes design documents and detail design documents.
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Prepared Test cases and testing procedures for the database packages and ETL interfaces and packages.

Environment: Oracle 11g,PL/SQL Developer, SSIS, Cognos, ODI(Oracle Data Integrator), MS SQL Server 2008R2, Visual Studio 2008, SQL*Plus, TFS 2010, Windows NT 4.0/2000/XP and UNIX.

Confidential, Tampa, FL

Oracle PL/SQL Developer

Responsibilities:

• Designed and developed the complex Packages, procedures, functions, triggers using SQL and PL/SQL efficiently in loading, validating and cleansing the data
• Worked extensively on tuning of SQL and PL/SQL code using various tools like explain plan, TKPROF, Sql tuning advisor and sql trace to enhance the performance.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Developed interfaces using PL/SQL packages, stored procedures, functions, Object Types, Cursors, Pipelined functions, Oracle queues and used Collections and Bulk Collects.
• Developed triggers, sequences and materialized views. Used various pl/SQL objects for backend and as middle level Data Access Layer between Java and Oracle in OLTP and datawarehouse applications.
• Wrote complex SQL queries using Joins, sub queries and inline views to create reports in SSRS and Cognos.
• Designed and developed a huge database of 120 tables and its data load process from flat files and also designed complex functional views for Payroll application.
• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data Loading Process and Reporting systems.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using SQL*Plus, TOAD.
• Extensively used SQL Loader, UTL FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables.
• Extensively used UTL SMTP and windows blat techniques to develop the monitoring processes to automatically notify the source systems, administrators and users through email alerts on missing feed files, unsuccessful job runs and load status of scheduled load processes and backup jobs.
• Worked on Performance tuning using the Partitioning and indexing concepts (Local and Global indexes on partition tables).
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Worked on Production support for the backend database and reporting applications.
• Involved in importing Source Tables from the different databases.
• Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.

Environment: Oracle 10g/11g,PL/SQL, SQL Loader, Cognos, ODI, SQL*Plus, Windows NT 4.0/2000/XP and UNIX.

Confidential, Buffalo, New York

Oracle PL/SQL Developer

Responsibilities:

• Prepared program Specification for the development of PL/SQL procedures and functions.
• Created Custom Staging Tables to handle import data.
• Created custom triggers, stored procedures, packages and functions to populate different databases.
• Developed SQL* loader scripts to load data in the custom tables.
• Created Batch files for loading database tables from flat files using SQL*loader and other ETL tools like SSIS.
• Created UNIX Shell Scripts for automating the execution process.
• Developed PL /SQL code for updating payment terms.
• Created indexes on tables and Optimizing Stored Procedure queries.
• Design, Development and testing of Reports using SQL*plus.
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Involved in preparing documentation and user support documents.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 9i/10g,PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, UNIX, Windows NT 4.0/2000/XP Windows2000.

Confidential, Louisville, KY

Oracle PL/SQL Developer

Responsibilities:

• Involved in database development by creating Oracle PL/SQL Functions, Stored Procedures, Triggers, and Packages.
• Worked with different types of sub queries (Inline, correlated) and used loops to suit the business logic.
• Written a number of Cursors to select various types of records.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Used the Pragma Exception INIT to name the system exceptions that are raised by the program.
• Extensively involved in coding of the procedures, triggers, and making use of built in packages and libraries.
• Modified existing stored procedures, functions and triggers using Pl/Sql Developer.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Extensively involved in Export (exp) and Import (imp) utilities to move data between different databases and schemas.
• Created various PL/SQL Scripts involving Insert, Sequences, Constraint and Index scripts.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays).
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 9i.
• Designed and developed various reports using Oracle Reports 9i.
• Developed PL/SQL packages using Oracle Standard/ Custom Exceptions.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using SQL*Plus, TOAD.
• Written and edited shell scripts to automate the execution of the procedures.

Environment: Oracle 10g, Oracle 9i, PL/SQL, SQL*LOADER, SQL PLUS, TOAD, Windows NT 4.0/2000, UNIX shell scripting.

Confidential, Milwaukee, WI

Oracle PL/SQL Developer

Responsibilities:

• Developed several Packages, Procedures, Functions and Triggers to use in multiple series of other backend programs using PL/SQL.
• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables for small Business and Consumer Markets (SBCM) customers.
• Written SQL scripts to create database objects like tables, views and sequences.
• Constant monitoring and performance tuning of Oracle10g database, checking the most queries.
• Coded PL/SQL sub-programs and modified the existing PL/SQL program units for customer Contact Employees (CCE’s) relationships.
• Customer Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Developed batch programs using UNIX shell scripts to generate reports daily, weekly & monthly for Customers Markets.
• Created Korn Jobs to perform regular updates to database tables to keep in sync with the data coming from other sources.
• Performed review and analysis of deadlocks and database performance tuning.
• Conducted code walkthrough & internal/peer reviews on application code and other deliverables.
• Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Involved in the continuous enhancements and fixing of production problems.
• Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.

Environment: Oracle 10g/9i, SQL, PLSQL, SQL*Loader, KORN Shell script, Erwin, TOAD, Web Logic, HTML, Java, J2EE, Unix.

Confidential

Database Developer

Responsibilities:

• Gained experience in C & C++ programming on UNIX for RAMINFO Applications and also developed PL/SQL Code for updating the payment terms.
• Interacting with Business users, gathering and analyzing requirements and Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Provided technical solutions in the form of MDD (Minor Development Document) for the Process Change Requests from Business.
• Involved in the design of database schemas and data mapping of client’s databases with DCX’s transactions databases.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Involved in Performance tuning and optimization of SQL queries for data warehouse consisting of many tables with large amount of data.
• Created PL/SQL packages, procedures and functions that extensively used PL/SQL cursors, user defined object types, exception handling. .
• Worked on Business Objects (BO) to deploy various reports onto production. .
• Involved in preparing documentation and user support documents.

Environment: PL/SQL, Oracle 9i, Maestro Scheduler, ERWIN 3.5, AIX UNIX, Windows NT/2000, SQL Navigator, Windows NT/2000/.