SUMMARY:

• Over 6+ years of experience in IT industry especially in client/server business systems and Decision support Systems (DSS) analysis, design, development, Testing and implementation.
• Over 5 years of ETL/Datastage tool experience using IBM InfoSphere Information Server Version (Ver8/7), Quality Stage, ,DatastageManager,Datastage Director and DataStage Administrator and DataStageParallel Extender.
• Experience in implementing Netezza, DB2, DB2/UDB, Oracle 10.2 / 9i / 8i / 8.0, SQL Server, PL/SQL, and SQL*Plus database applications.
• Developed the Source-Target Mapping for the Dimensions and Fact Tables.
• Extensively used Parallel Extender to load data into data warehouse with different techniques like Pipeline and Partition in MPP environment.
• Used Datastage Enterprise Edition/Parallel Extender stages like Datasets, Sort, Lookup, Change Capture, Funnel, Row Generator stages in accomplishing the ETL Coding.
• Conducted detailed data analysis / reporting using IBM WebsphereInformation Analyzer for the multiple sources from various systems
• Excellent experience in TERADATA Utilities: BTEQ, Fastload, Multiload, Fastexport
• Used ETL Tool, to create jobs for extracting the data from different databases, flat files & Mainframe files.
• Extensively Implemented Error Handling Concepts, Testing, Debugging skills and Performance tuning of targets, sources, transformation logics.
• Experience in all Testing Phases: Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
• Experience in Data Modeling, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Strong skills in analysis Coding using SQL and PL/SQL, Developing, Writing Unix Shell Scripts and code/script testing.
• Expertise in Data warehousing and Data migration.
• Extensive experience in Shell Scripting
• Extensive experience in data modeling using Erwin tool.
• Extensive experience in loading high volumes of data.

Certification: "IBM Certified Solution Developer - InfoSphere DataStage v 8.5"

• ETLTools: Data Stage Enterprise Edition 8.1/7.5.2/7.5/7.1 , Quality Stage 8.1, 7.1, Information Analyzer
• Data Modeling Tools: Erwin 3.5.2/4.0, Visio 2003
• Databases: Oracle 10g/9i/8i, MS SQL Server 7.0/6.5, SQL Server 2005, Sybase12/11.9/10, DB2 UDB V9, Teradata V2R3/V2R4.1,MS Access 2000/97, Netezza 6.0
• Tools: SQL*Plus, SQL*Loader, Version Control , SQL Squirrel, Control- M
• Operating Systems: IBM AIX 5.2/4.Linux , Solaris
• Programming: SQL, PL/SQL, Unix Shell Scripting
• Languages: SQL, PL/SQL, C, C++ , BASIC
• CM Tools: Clear Case, Clear Quest.

MAJOR ASSIGNMENTS:

Confidential, San Antonio, TX May 2012 - Till Date DataStage Developer
Responsibilities:

• Involved in the migration of the jobs from DB2 to Netezza.
• Extensively used Aginity for running and test the SQL queries.
• Good hands on experience with Datastage 8.1.
• Used DataStage Netezza Enterprise stage to load data, utilizing the available processors to achieve job performance, configuration management of system resources in Orchestrate environment.
• Used Netezza Enterprise stage for doing loads into Netezza Database.
• Extensively used Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator.
• Written SQL and PLSQL procedures to facilitate coding.
• Worked extensively on UNIX.
• Participated in source to target mapping design document, prepared system requirement documents based on data model and source target mapping documents.
• Identify business rules for data migration and perform data administration through data models and metadata.
• Scheduled various ETL Batch processes using Control-M

Environment: Datastage 8.1, Netezza 6.0, SQL, Db2, Linux, Control- M

Confidential, Lyndhurst, NJ June 2011 - May2012
DataStage Developer 
Responsibilities:

• Involved in understanding the scope of application, present schema, data model and defining relationship within and between groups of data.
• Good hands on exp with Datastage 8.0.
• Used DataStage Parallel Extender to load data, utilizing the available processors to achieve job performance, configuration management of system resources in Orchestrate environment.
• Worked on programs for scheduling Data loading and transformations using DataStage from legacy system to Oracle 10g using SQL* Loader and PL/SQL.
• Extensively used Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator from various database DB2 Enterprise, Oracle Enterprise.
• Written SQL and PLSQL procedures to facilitate coding.
• Worked extensively on UNIX.
• Built several Custom operators, Wrapper Operators to meet complex business transformation requirements.
• Participated in source to target mapping design document, prepared system requirement documents based on data model and source target mapping documents.
• Identify business rules for data migration and perform data administration through data models and metadata.
• Optimized Query Performance, Session Performance and Reliability.
• Scheduled various ETL Batch processes using AUTOSYS 4.5
• Used various stages of Quality stage like standardize stage, survive stage, format convert, transfer and unjoin stages.

Environment: Ascential DataStage 7.5.1, 8.1, SQL, Db2 v9/8.2,Metastage, Quality Stage 7.5, Oracle 10g SQL, IBM AIX4.3, Erwin 4.1, IBM AIX 4.3, AUTOSYS, Clear Case.

• Involved in performance tuning of the ETL process and performed the data warehouse testing
• Designed the complete Decision Support System by creating different types of reports for trend analysis using filters, conditions and calculations
• Applying normalization concepts and understand the trade-offs between different schema designs
• Extensively used IPC, Link Pratitioner and Link Collector in improving the performance.
• Extensively used ETL Tool to load data from DB2 to Oracle Database.
• Developed PL/SQL procedures that will take all the files sent by Source system as input and will insert data into target tables in the required format, data transfer is done on monthly basis.
• Worked with DataStage Manager for importing metadata from repository, new job Categories & creating new data elements
• Involved in analyzing scope of application, defining relationship within & between groups of data, star schema, etc.
• Used DataStage Manager for managing DataStage repository (view and edit), define custom routines & transforms, Import and export items between different DataStage systems or exchange metadata with other data warehousing tools.
• Identifying required dimensions and facts for the schema from the source systems
• Create new projects in DataStage through Administrator, assigning proper and permissions to DataStage users, setting up the Environment variables to help with performance tuning.
• Reporting was done using Cognos Reporting tools

Environment: Ascential DataStage 8.1 (Designer, Director, Administrator), Ascential Parallel Extender, QualityStage, , Oracle 9i, SQL Server , PL/SQL, Windows 2007, ERwin and UNIX, Cognos, MS Project, MS Visio

Responsibilities:

• Involved in design and development of Parallel and Server Jobs.
• Actively participated in business meetings with the business users in order to gather the business requirements.
• Developed the Technical Design and Unit Test Plans for Projects
• Created process flow diagrams using Microsoft VISIO.
• Developed the audit component to ensure the ftp source file has properly landed in the landing zone.
• Involved in the development of Common Error Management to capture and handle the error records
• Developed job sequence and implemented restart ability using various checkpoints.
• Extensively worked on DataStage Director, DataStage Manager and knowledge of DataStage Administrator.
• Developed various DataStage jobs in Enterprise Edition (parallel Extender) using DataStage Designer.
• Used various stages like transformer, funnel, lookup, join, merge, remove duplicates, change capture, filter, aggregator etc.
• Written Unix Shell Script for scheduling DataStage jobs, to handle Error Management and Audit Management.

Environment: Ascential DataStage 7.5.1, Oracle 9i, SQL Server2000, TOAD, SQL, PL/SQL, Erwin 4.x, AIX-UNIX 5.2, Autosys, Microsoft Visio and Windows 2000.

Confidential, Hartford, CT April 2008 - Feb 2009
DataStage Developer
Responsibilities:

• Attended development phase meetings for Business Analysis and Requirements Gathering.
• Created DataStage jobs, batches and job sequences.
• Developed Architecture for building a Data warehouse by using data modeling tool ERwin.
• Used DB2 EE stage for doing loads into DB2 UDB Database and to load large volumes of data into Teradata V2R4 using Teradata Fast Export, Multi Load, and T-Pump.
• Designed and Developed PL/SQL Procedures, functions, and packages.
• Worked with DataStage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Wrote shell scripts for Data Acquisition as a part of ETL process.
• Created jobs and analyzed scope of application, defining relationship within & between groups of data, star schema and more.
• Identified suitable dimensions and facts table for schema.
• Created and loaded data warehouse tables like dimensional, fact and aggregate tables using Ascential DataStage.
• Used Job Control routines and Transform functions in the process of designing the job.
• Scheduled the jobs via the Autosys.
• Wrote Extensive UNIX scripts for running the DataStage jobs.
• Tuned DataStage jobs to enhance their performance.

Environment: Ascential DataStage 7.5.1, PL/SQL, Teradata V2R4, Windows NT, UNIX, DB2 Erwin, Autosys.

Confidential, India July 2006 - April 2008 
DataStage developer

Responsibilities:

• Extracted the data stored in different databases and loaded into Oracle system.
• Involved in the creation of jobs using DataStage designer and used Director to validate, schedule, run and monitor the DataStage jobs.
• Involved in designing the procedures for getting the data from all system to Data Warehousing system.
• Information stored in table definition and is entered using DataStage manager.
• Extensively used ETL Tool to load data from DB2 to Oracle Database.
• Exporting the universe to the repository to make resources available to the users.
• Created the reports using the universes as the main Data providers and writing the complex queries including sub queries, unions, joins, intersects and aliases.

Environment: Ascential DataStage 7.5.1, Oracle 8i/9i, SQL, PL/SQL, Windows NT.