SUMMARY

• Over 6 years of Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using IBM Data Stage 8.7/8.5/8.1/7.5 (Info Sphere Information Server, Web Sphere, Ascential Data Stage) and Quality Stage.
• Experienced in Software Development Life Cycle (SDLC) & developing technical documentation in various stages of SDLC.
• Experienced in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• Expertise in Relational Database Modeling and Dimensional Modeling - Star schema, Snow-Flake schema, and hands on experience in data modeling tools Erwin / Microsoft Visio.
• Expert in working with DataStage Manager, Designer, Administrator and Director.
• Expert in designing server jobs using various types of stages such as Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Extensive experience in parallel jobs using different processing stages such asTransformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply, Remove Duplicates, Filter, Dataset, Complex flat files, Modify, XML.
• Optimized DataStage jobs utilizing parallelism, partitioning and pipelining features of Parallel Extender.
• Involved in Documentation of ETL process following the standard naming conventions used in DataStage.
• Worked with various databases such as DB2, SQL Server,PL/SQL,Oracle, Teradata,XMLand MS-Access into data staging area.
• Proficient in writing, implementation and testing of views, triggers, procedures and functions inPL/SQLandOracle.
• Extensive experience in Scheduling the Data Stage jobs using Control M, TWS scheduling, Autosys.
• Extensive experience inUnit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT)andPerformance Testing.
• Experience with version control software such as SVN, GIT.
• Excellent communication and interpersonal skills, problem solving skills, flexible, self-direct and good team player.

TECHNICAL SKILLS

ETL: IBM Infosphere DataStage 8.7/8.5/8.1, Ascential DataStage 7.5

Operating Systems: UNIX/ LINUX, Windows XP/2000/2003/NT

Languages: SQL, PL/SQL, SQL *Plus, UNIX Shell Scripting, C, C++, C#, ASP.NET, Java

Data Modeling Tools: Erwin, Star Schema Modeling, Snowflakes Modeling, Fact and Dimension

Database: Oracle 9i/10g/11g, DB2, Teradatav2r6, Sybase, MS SQL Server 2000/2008r2

Oracle Utilities: SQL*Loader, SQL Trace, Explain Plan.

Design/Development Tools: Java, NetBeans IDE 7.2.1, Visual Studio 2010

PROFESSIONAL EXPERIENCE

Confidential, Roseland, NJ

Sr. Datastage Developer

Responsibilities:

• Identified business needs, interacted with Business Analysts to gather the requirements and participated in their implementation.
• Used Datastage Designer to develop process for extracting, cleansing, transformation, integrating and loading data into Data Marts.
• Imported metadata from repository, created new job categories, routines and data elements.
• Designed and developed jobs using Datastage Designer as per the mapping specifications using appropriate stages.
• Developed parallel jobs using various Development/debug stages (Peek stage, Row generator stage, Column generator stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Execute performance tuning of ETL loads and SQL queries for large volumes of data processing.
• Used Join/Merge/Lookup Stages to replicate integration logic basing on the volumes of the data.
• Extensively used most of the other parallel stages like Column Generator, Modify, Funnel, Filter, Switch, Aggregator, Transformer Stages, Column Import, and Column Export.
• Extensively developed the Routines and Job Sequence for the ETL jobs.
• Created source table definitions in the DataStage Repository
• Perform tuned long running ETL jobs after conversion, with appropriate Partitions, Partition keys, Sorting and correct parameter settings.
• Worked with TOAD to interact with Oracle and used SQL Trace and Explain Plan to improve the performance of the PL/SQL programs
• Extensively used Autosys for scheduling and automating the month end job flow.
• Participated in daily Scrum meeting and created monthly working sprint tasks using JIRA.
• Worked on many defects with respect to code issues, dependency issues and resolved efficiently and performed production support for existing system.
• Performed Unit Testing, Integration Testing and User Acceptance Testing (UAT) for every code change and enhancement.

Environment: IBM Information Server (Datastage) 8.7/8.5, Oracle11g, SQL*Loader, Erwin 4.1, Clear Case Oracle11g, SYBASE, AIX UNIX, TOAD, Putty, Autosys Windows XP, SVN.

Confidential, NJ

DataStage Developer

Responsibilities:

• Involved in analysis, planning, design, development and implementation phases of projects using IBM Info Sphere software (Quality Stage v8.0, Web Service, information analyzer, Profile Stage, WISD of IIS 8.0)
• Developed ETL process (Extraction, Transformation and Loading of data).
• Worked on full Software Development Life-cycle from Requirements through Development, Testing, and Implementation.
• Used Dataset and File Set Stages depending on the requirement and layout for parallelism of data.
• Extensively used various stages such as Remove Duplicates, File Set, CFF, External Target Sort, Copy, External Source, Transformer, sequential, Oracle, Aggregator, Join, Merge, Lookup, Funnel, Data Set, Modify, Filter, Change Capture, Change Apply, Head, Tail, Sample, Surrogate Key.
• Implemented Before/After job routines to perform specific tasks.
• Widely used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used the DataStage Director and its run time engine to schedule running the solutions, testing and debugging its components and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Used parallel extender jobs for better performance using stages such as Merge, Join, Sort, Lookup and Transformer with different sources files complex flat files, XML files.
• Optimized job performance by carrying out performance Tuning.
• Used Toad/SQL Developer to interact with Database and validate data by using join and case statements.
• Created queries to compare data between two databases to make sure data is accurate.
• Scheduled Datastage jobs using Autosys Scheduling tool.
• Extensively used Control M for scheduling nightly batch jobs.
• Extensively used version control system, such as SVN.
• Closely worked with testing team to fix the code issues.

Environment: IBM Datastage 8.1, Oracle 9i/10g, SQL Loader, Windows 7, SQL developer, Erwin, Unix, Korn Shell, Autosys, Toad, SVN Tortoise.

Confidential, Franklin Lakes, NJ

ETL Developer

Responsibilities:

• Involved in Dimensional modeling of the Data warehouse to design the business process, data representation, dimensions and fact tables using Erwin.
• Involved in designing TRD (Technical Requirements document), and mapping documents.
• Used IBM Datastage Designer to develop jobs for extracting, cleaning, transforming and loading data into data marts/data warehouse.
• Developed several jobs toimprove performanceby reducing runtime using different partitioning techniques.
• Extensively used different stages of DataStage Designer such as Join, Merge, Lookup, Funnel, Copy, Filter, Aggregator, and Sort.
• Used different Stages to develop the server jobs using Sequential File, ODBC, Transformer, Aggregator, Hashed-File,FTP Plug-in.
• Designed DataStage jobs using Quality Stage7.5 for data cleansing & data standardization Process. Implemented Survive stage & Match Stage for data patterns & data definitions.
• Staged the data coming from various environments in staging area before coming into Data Mart.
• Used PLSQL Collections and features like Bulk collect and bulk binding.
• Used SVN Tortoise control version for synchronizing the up gradations.
• Created batch jobs for the data cleansing and generation of summarized reports.
• Scheduling the Jobs on Control M, Crontab, job scheduler

Environment: Ascential DataStage7.5/EE, MS SQL server 2008 r2, Teradata, Oracle 10g, PL/SQL, Toad, UNIX, Control M, Crontab, SQL Developer, Putty.

Confidential, Boston, MA

ETL Application Developer

Responsibilities:

• Involved in Design, Data mapping and Development of ETL jobs that supports Superfusion EDW process.
• Extensively used Data Stage 7.5 (Parallel Extender) to build fact tables for sales at item and transaction levels.
• Developed ETL jobs in Data Stage 7.5 (Parallel Extender) to build various dimension tables as part of Data Mart build.
• Created high and low level design documents and process flow diagrams in Microsoft Visio.
• Involved in conceptual and logical data modeling.
• Developed job routines, shared containers, Buildop operators to meet complex business transformations.
• Designed several Datastage PX using Sequential file stage, sort, lookup, join, merge, remove duplicate, filter, change capture, etc... And Custom Buildop operators.
• Developed Datastage server jobs using Hash files, Link Collector/Practitioner stages, sort, Aggregator, etc. Used CoSort to externally sort the data.
• Involved in Unit, system and integration testing. Prepared the SQL scripts to load the test data in to QA sandboxes.
• Used shell script for error tracing, file validation, email notification, and to run & schedule the jobs in Autosys 4.5.

Environment: IBM Data Stage 7.5, IBM AIX, DB2 UDB 9.5, ERwin4.1, MQC, Shell Scripting, Autosys4.5, RCS, Putty, Toad, Microsoft Office, Microsoft Visio 2003, SAS.