PROFESSIONAL SUMMARY:

• 5+ years of total IT experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), Development of client/server and multi tired applications and Data warehouse environments using the Oracle RDBMS, SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux and Implementation of Business Intelligence applications.
• Involved in all phases of software life cycle - Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation and Support
• Strong knowledge in Agile/ Scrum methodologies.
• Excellent experience in Relational Database (RDBMS), Oracle 12c,11g,10g,9i, Microsoft SQL Server, Teradata Load and MultiLoad, SQL, PL/SQL, TOAD.
• Good experience of Performance Analysis and SQL query tuning using Query Optimizer, Indexes, Clusters, SQL Access Advisor, Hints, Explain Plan, and Tk-prof.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Type
• Expert in Extraction, Transformation and Loading (ETL) experience using Oracle and IBM Info sphere DataStage 11.3/ 9.1/8.5/8.1/7.5.
• Expert Level experience in DataStage Client components - DataStage Designer, DataStage Manager, DataStage Director and DataStage Administrator
• Extensively worked on Server Edition, Enterprise Edition (Parallel Extender) and Development of Data Warehouse/Data Mart Applications making use of all stages Aggregator, Sort, Merge, Join, Change Capture, Peek stages in Parallel Extender job.
• Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using DataStage Director, UNIX scripts and hands on experience with scheduling of shell scripts using AUTOSYS/CONTROL-M.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, Materialized Views, PL/SQL tables, Cursors, Nested tables, arrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Strong Knowledge of Data Warehouse architecture in Designing Star Schema, Snow Flake Schema, FACT and Dimensional Tables. Physical and Logical modeling using Erwin.
• Involved in Logical and Physical Design, Backup, Restore, Data Integration and Data Transformation Service and Creating Database Objects (Tables, Index, Triggers, Views, and Store Procedures).
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS:

Tools: TOAD,SQL*PLUS, SQL*NAVIGATOR, SQL DEVELOPER, Putty, IBM Information Server DataStage 9.1/8.7/8.5/8.1

Data Modeling: E-R Modeling, Star and Snowflake Schema Modeling

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/2005, Teradata V2R5.0, DB2 UDB

Languages: C/C++, SQL, PL/SQL and Shell Scripting

Operating System: Unix, Linux, Windows XP,7,8 server

Scheduling Tools: Autosys, Control-M

WORK EXPERIENCE:

Confidential, Parsippany, NJ

Sr. Oracle/ETL Developer

Responsibilities:

• Developing various PL/SQL stored procedures and functions
• Writing PL SQL scripts and used couple of metadata tables to do Data Profiling, Referential Integrity and Data Quality before loading data into staging area.
• Writing scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Developing PL/SQL triggers and master tables for automatic creation of primary keys and foreign keys.
• Development of the Mappings, Lookups, reusable components, Sessions, Workflows
• Coordination with DBA in creating and managing Tables, Indexes, Table spaces, Triggers, DB Links and Privileges
• Developing back-end interfaces using PL/SQL Stored packages, Procedures, Functions, Collections, Object Types, Triggers.
• Developing PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation.
• Responsible for using different types of Stages such as ODBC Connector, Oracle Connector, DB2 Connector, Teradata Connector, Transformer, Join, Sequential File to develop different jobs.
• Developing DataStage Parallel and Sequence Jobs.
• Developed common Jobs, Shared containers and Server Routines which are used across the project in most of the interfaces.
• Created Unix Shell Scripts that take care of end to end automation. Developed UNIX shell Scripts that trigger DataStage jobs, transfer the output files, perform basic validations on file.
• Prepared Unit Test Cases and executing them.
• Fix the defects raised by testing team and maintain the status in HP Quality Center.
• Extensively used SQL tuning techniques to improve the performance of Data Stage Jobs.
• Tuned DataStage transformations and jobs to enhance their performance.
• Provide Post Implementation Support.
• Developed Multi-Instance reusable Datastage jobs.
• Involved in performance tuning by rewriting the queries and modifying existing Datastage jobs.

Environment: ORACLE 10g/11g/12c, Oracle SQL Developer, SQL Navigator, SQL * Loader, SQL*PLUS, IBM InfoSphere 9.1.2, IBM InfoSphere DataStage 8.7v, UNIX shell Script, DB2, Teradata, AQT (for accessing SQL Server and DB2), Office.

Confidential, NYC, NY

Sr. Oracle/ETL Developer

Responsibilities:

• Handling production issues and working on developing new design specifications into ETL coding and mapping standards.
• Translated business requirements into Technical Design and documentation.
• Created Tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and Triggers.
• Enforced database integrity using Primary keys and Foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations.
• Wrote complex SQL queries, generated views for the administrative department.
• Performance tuning of database queries using TKPROF, Explain plan and SQL trace.
• Extensively used Datastage Designer to develop processes for extracting, transforming, integrating and loading data from various sources into the Data Warehouse.
• Created ETL processes composed of multiple Datastage jobs using job sequencer and developed shell scripts to automate the process and tested the processes.
• Extensively worked on different databases like Oracle, DB2 and SQL Server to extract and load the data from one another.
• Used different types of stages like Transformer, CDC, Remove Duplicate, Aggregator, ODBC, Join, Funnel, dataset and Merge for developing different jobs.
• Extensively used Parallel stage like row generator, column generator and Peek Stages for debugging purpose.
• Used the Director and its run-time engine to schedule running the job, testing and debugging its components, and monitoring the resulting executable versions.
• Customized UNIX scripts as required for preprocessing steps and to validate input and output data elements.
• Effectively implemented Partitioning and Parallelism techniques to fully utilize the resources and enhance job performance.
• Designed and developed various jobs for scheduling and running jobs under job sequencer and DataStage Director.
• Extensively implemented import/export utilities for migrating code.
• Attended daily meetings to review the status of the schedule and go through pending issues.
• Coordinated with Release manager and DA to migrate the components from one environment to another environment. Integrated with other Projects, for sharing the table structures and data.

Environment: ORACLE 10g/11g, Oracle SQL Developer, SQL Navigator, SQL * Loader, IBM Websphere Datastage 9.1/8.1, Netezza, DB2, SQL, PL/SQL, UNIX Shell Scripting, Datastage Version Control, MS SQL server, Control M 7.5, RTC.

Confidential, Bloomington, IL

Oracle/ETL Developer

Responsibilities:

• Closely monitored functionality of development and online production servers. Rendered 24-hour on-call, database support services.
• Understanding the requirements and preparing Low Level Design documents and there by developing parallel and sequence jobs.
• Performing Database cloning and using export and import mechanism.
• Performance tuning of SQL and PLSQL Scripts.
• Writing PL/SQL scripts, procedures and packages.
• Performed data loads using SQL*LOADER.
• Tuned SQL and PL/SQL code using Oracle Enterprise Manager Tools and Explain plan.
• Developed Shared containers and Server Routines which are used across the project in most of the interfaces.
• Worked in Data Migration project.
• Involved in Each Phase of project - End to End module.
• Written complex queries to facilitate the supply of data to other teams.
• Responsible for using different types of Stages such as Sequential File, Sort Aggregator, Transformer and ODBC to develop different jobs.
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup File Set, Change Data Capture, Modify, and Aggregator.
• Used DataStage Director for Schedule jobs in production for some of the projects.
• Provide support to Testing Team and fix defects raised in different phases of testing.
• Developed DataStage Parallel and Sequence Jobs.
• Developed UNIX shell Scripts used to validate the files.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Tuned DataStage transformations and jobs to enhance their performance.
• Used Control-M for Scheduling jobs and monitor the same.

Environment: ORACLE 10g, Oracle SQL Developer, SQL * Loader, IBM InfoSphere DataStage 8.1v, UNIX shell Script, Office, Visio.

Confidential

Programmer

Responsibilities:

• Studying the business requirement, preparing the impact analysis document.
• Prepared technical specification document, upon review of the solution developed the solution using Datastage jobs and sequencers.
• Used sequential file stage as the source for most of the source systems.
• Used aggregator, look up, join, merge, dataset, transformer, sequencer, sequential file DB2 bulk load, hashed file stage, surrogate key generator.
• Created DDL statements for new tables, changes to table structure, index changes, and creation of triggers and stored procedures.
• Prepared unit test cases and test plans.
• Executed the test cases, captured the results.
• Supported the system post production and worked in co-ordination with the production support teams to resolve any issues.

Environment: ORACLE 8i/9i, Oracle SQL Developer, DataStage 8.1 (Designer, Director, Manager, Administrator) Enterprise Edition, SQL Server 2005, IBM DB2, MS Visio 2000.