SUMMARY

• Around 8 years as an IT Professional with expertise in Requirement Analysis, Development and Implementation of Data warehouse and Data Integration Projects.
• Around8 years of experience in design, development, testing and implementation of Data warehouse, Data Integration Projects using DataStage, Oracle, SQL Server Db2, Teradata and UNIX.
• Worked extensively on DataStage 9.1.2, DataStage 8.5v, DataStage 8.1v, and DataStage 7.5v.
• Experienced in creating High Level and Low level Design.
• Experienced in Designing, Developing, Documenting, Testing of ETL Jobs and mappings in both Sequence jobs and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
• Expertise in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.
• Worked Extensively on Parallel and Sequence Jobs.
• Expertise in creating in Shared Containers.
• Designed and Implemented DataStage Frame work which was used across many Projects.
• Experienced in integration of various data sources (Oracle, DB2, Teradata,Sql Server and Xml) into data staging area.
• Developed Control M jobs to schedule DataStage jobs.
• Experienced in Scheduling jobs through Director.
• Experienced in Scheduling DataStage jobs (Unix Scripts triggering DataStage Jobs) through crontab.
• Establish “Best Practices” and plan for continuous improvement of processes.
• Experienced in creating projects, users and assigning roles to them.
• Converted Complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Worked Extensively on Server Routines.
• Provided to other team members to implement best practices in Data Stage.
• Experienced in creating UNIX shell scripts.
• Expertise in Using HP Quality Center to upload Test cases and maintain Test Results.
• Proficient in writing, implementation and testing of triggers, procedures and functions in PL/SQL and Oracle.

TECHNICAL SKILLS

ETL Tools: DataStage 9.1.2, 8.5v, 8.1v, Ascential DataStage 7.5

Relational Databases: Oracle 8i/9i/10g/11g, DB2 9, Teradata

Development/Productivity Tools: Control - M, HP Quality Center, Unix Shell scripts, Robot

Languages: SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x.

Editing Tools: Adobe Photo Shop CS 6, Note Pad ++

Operating Systems: Linux/UNIX, Windows 95/98/NT/2000

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr. DataStage Consultant

Responsibilities:

• Creating Low Level Design documents by understanding the requirements and there by develop jobs.
• Worked in Data Acquisition project, where we need to extract data from different sources, process the data and generate the files and transfer these files to Target Systems.
• Worked on several change requests, which were created because of production incidents and requirement changes to the code in production environment.
• Involved in Each Phase of project - End to End module.
• 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.
• Deploy the developed code to SIT, Production environments and validate the code.
• Used Robot Scheduling Tool to schedule DataStage jobs.
• Provide Post Implementation Support.

Environment: IBM InfoSphere 9.1.2, IBM InfoSphere DataStage 8.5v, UNIX shell Script, Robot, ORACLE 10g, SQL Developer, DB2,Teradata, AQT (for accessing SQL Server and DB2), Office, Visio.

Confidential, Dallas, TX

DataStage Consultant

Responsibilities:

• Worked on Ecommerce-Dropship project which enables Michael’s Vendors to sell products on Michael’s website.
• Worked on JDA Allocation integration project which takes care of seasonal allocation of items from warehouses to stores.
• Understanding the requirements and preparing Low Level Design documents and there by developing parallel and sequence jobs.
• 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 FTP, Hashed File, 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.
• DataStage Enterprise Edition for parallel processing as part of ETL conversion process integrating multiple source systems.
• Prepared Unit Test Cases and executing them.
• Provide support to Testing Team and fix defects raised in different phases of testing.
• Developing DataStage Parallel and Sequence Jobs.
• Developed UNIX shell Scripts used to validate the files.
• Trained team members in learning DataStage.
• Understand the existing PL/SQL procedures to extract data loaded by People Soft.
• Have Extensive knowledge on creating infotypes and sending to ADP.
• 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.
• Lead team size of 4 - 6 members.
• Used Control-M for Scheduling jobs and monitor the same.
• Provide Post Implementation Support.

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

Confidential

DataStage Consultant

Responsibilities:

• Visited Business and Operations to gather requirements and document the same.
• Participates in Analysis of the Project and prepared technical specifications document.
• Created and populated the data in Data warehouse and Data Marts for the BI Developers to create their reports.
• Worked extensively on DB2.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems.
• Responsible for creating parallel and Sequence Jobs.
• Used DataStage Jobs to extract and customize data from different sources.
• Monitored Test Cases in HP Quality Center, Supplied Comments and close the defects once they are fixed.
• Provided support in different phases of testing.
• Migrating code from one environment to other.
• Used the Data Stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Worked with Data Stage Manager to import/export metadata from database, jobs and routines between Data Stage projects.
• Used multiple stages like SAP ABAP R/3 Extract, Sequential File, Transformer, Aggregator, Join, Lookup, Sort and Filter during ETL Data Quality development.
• Used Data Stage Director to schedule, monitor, cleanup resources and run 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.
• Created many PL/SQL stored procedures and packages while extracting the data from sources into staging area.
• Developed user defined Routines and Transforms by using Data Stage Basic language.
• Used Data Stage Director for controlling and sequencing jobs.
• Used Data Stage Shared Containers, Local Containers for DS jobs.
• Design, build, and manage complex data integration process.
• Used SQL*Loader, and Shell Scripts to import data into data staging area.
• Involved in writing triggers, stored procedures in PL/SQL to extract data from various source systems into Data Staging Area.
• Extensively used ETL to load data from Oracle, SQL Server, and DB2, Flat files to SQL Server.
• Analyze newly converted data to establish a baseline measurement for data quality in data warehouse.

Environment: IBM WebSphere DataStage 8.1v, Db2 9, Shell Scripting, Oracle 9i, HP Quality Centre, Control M, Ms-Access, XML.

Confidential

DataStage Developer

Responsibilities:

• Analyzing the mapping documents, understanding the business requirements.
• Understand the Low Level Design Documents and thereby develop the jobs.
• Data from different source systems was extracted, transformed and loaded into data warehouse tables.
• Responsible for using different types of Stages such as Transformer, Join, Sequential File, Copy, Filter and Aggregator to develop different jobs.
• Developed Parallel and Sequence Jobs.
• Created Shared Containers, Local Containers for DS jobs.
• Used Data Stage Director to schedule, monitor, and run jobs.
• Prepare Unit test cases and execute them.
• Maintain the test cases and test results in Quality Center Tool, Update the defect status as on when required.
• Prepare Unix Scripts and Control M jobs flow.
• Implemented Best practices to optimize the performance.
• Designed ETL Process as per the requirements and documented the Flow using Visio.
• Did Unit testing and tuned for better performance with updates on data ware house tables.
• Provided Post Implementation Support.

Environment: Ascential DataStage 7.5.3, IBM WebSphere DataStage 8.1v, Oracle 9i, HP Quality Centre, UNIX Shell Scripting, SQL, PL/SQL