PROFESSIONAL SUMMARY

• Datastage/ETL Developer with over five years of work experience in Information Technology, with expertise in business intelligence and data warehousing.
• Participated in all aspects of a systems development life cycle within teh development team (Analysis, Design, Development, Test, QAT, Implementation and Production Support).
• Extensively worked on designing and administrating Datastage jobs in V 8.7/8.5/8.1, worked in detail with different stages in Datastage like Transformer, Lookup, Merge, Join, Funnel, Aggregator, Change Data Capture, and successfully ran jobs from medium to high complexity levels.
• Worked in teh Migration of jobs from 8.7 to 9.1 and halped with testing of jobs in Dev
• Worked with Data modeler and Business analyst in gathering business rules.
• Helped functional team in writing up of source to target mapping documents.
• Worked closely with teh business systems analyst to develop teh tables. Used Erwin tool to convert from logical to physical data model.
• Knowledge in logical database designing (Schema building) and physical database designing (OFA standard) of Oracle databases.
• Familiar with Enterprise wide Data warehouse Architecture & Expertise in Ralph KIMBALL methodology and good in warehousing concepts Star Schema, Snow Flake and identification of KPI, Dimensions and Facts
• Hands on configuration and support of Data Stage development to support high throughput in production environments.
• Adept at running Datastage director, viewing job logs, finding errors and fixing them in given time.
• Worked on shell scripts in UNIX, executed them. Also worked with scheduling tools like Tivoli scheduler, crontab utility.
• TEMPHas extracted data from various databases like SQL Server, Oracle, Teradata and DB2. And worked on multi - Terabyte Performed exporting and importing of jobs to and fro to various environments.
• Strong noledge on SQL, Stored Procedures, Functions, Triggers.

TECHNICAL SUMMARY

ETL : Confidential Information Server 9.1, Data Stage 8.7/8.5/8.1

Operating Systems: Confidential AIX, DG UNIX. Windows XP/Windows 7, Linux

Database: Oracle 10g/9i., Teradata, SQL Server 2005/2008, DB2

Database Tools: Toad 8.6.1, Teradata SQL Assistant, Squirrel

Scheduling Tools: Control M 8.0, Cron tab utility, Autosys 11.3

Languages: Shell Scripts (Bourn), SQL, PL/SQL.XML, Java

Other Tools: Erwin 8.2, HPQC, Microsoft Visio 2007, Microsoft Office 2010, Clear Case, ITIM, ClearQuest

PROFESSIONAL EXPERIENCE

Confidential, Hoffman Estates IL

Sr. Analyst

Responsibilities:

• Worked in teh RES team and developed several Staging Jobs, Fact Jobs and Metrics
• Worked with requirement analyst to identify, develop business requirements, and transform it into technical requirements.
• Implemented Aggregate, Filter, Join, Lookup, Rank and Update Strategy transformations.
• Extensively worked with DataStage 8.5 - Designer and Director to load data from source extract files to warehouse.
• Worked on teh Hadoop to load teh data to DS or write data to teh Files on Hadoop Cluster.
• Worked with promotion of Jobs to QA, UAT and Production.
• Worked on several tickets to resolve production issues.
• Created Datastage jobs to load data from sequential files, CSV, Flat files and DB2
• Cleansed, Standardize data using Quality stage.
• Worked towards optimal performance when using Stages like LOOKUP, JOIN, and MERGE.
• Designed and developed DataStage jobs for Loading Staging Data from different sources like Flat files, DB2 into Data Warehouse applying business rules which consists data loads, data cleansing, and data massaging.
• Used teh Datastage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions
• Created Shared Container to simplify teh Datastage Design, and used it as a common job component throughout teh project.
• Worked with Metadata Workbench, Import and Export of Datastage jobs using Datastage tools functionality.
• Created Parameters and Parameter sets where necessary.
• Tuned DataStage jobs for better performance by creating Datastage Hash files for staging teh data and lookups.
• Created job docs for several batch jobs dat are scheduled in Control M and provided production support for teh monitoring and rescheduling of jobs when needed.
• Mentor offshore resources for design of teh jobs and coordinate Development efforts.
• Scheduled teh server jobs using DataStage Director, which are controlled by Datastage engine and also for monitoring and performance statistics of each stage.
• Performed functional testing for new release enhancements.
• Participated actively in teh team meetings with teh developers offshore and onsite.
• Developed Parallel jobs using Parallel stages like Merge, Join, Lookup, Transformer (Parallel), Funnel, Dataset.

Environment: Information server - Datastage 8.5, SVN, DB2, Control M 8.0, Teradata, Redhat Linux, and Windows 7

Confidential, Chicago IL

Datastage Developer

Responsibilities:

• Worked in teh ADW team and developed several Staging Jobs, Fact Jobs and Metrics
• Worked with requirement analyst to identify, develop business requirements, and transform it into technical requirements.
• Implemented Aggregate, Filter, Join, Lookup, Rank and Update Strategy transformations.
• Extensively worked with DataStage 8.7 - Designer and Director to load data from source extract files to warehouse.
• Worked on migration of existing jobs in 8.7 to 9.1 and did testing against those for compatibility with databases and flat files.
• Worked with different accounts in Confidential and developed jobs in more generic and reusable architecture standards.
• Worked with promotion of Jobs to QA, UAT and Production.
• Worked with JRunner, and master Sequence Jobs.
• Worked on several tickets to resolve production issues.
• Created Datastage jobs to load data from sequential files, CSV, Flat files and DB2
• Cleansed, Standardize data using Quality stage.
• Worked towards optimal performance when using Stages like LOOKUP, JOIN, and MERGE.
• Designed and developed DataStage jobs for Loading Staging Data from different sources like Flat files, DB2 into Data Warehouse applying business rules which consists data loads, data cleansing, and data massaging.
• Used teh Datastage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions
• Created Shared Container to simplify teh Datastage Design, and used it as a common job component throughout teh project.
• Worked with Metadata Workbench, Import and Export of Datastage jobs using Datastage tools functionality.
• Created Parameters and Parameter sets where necessary.
• Tuned DataStage jobs for better performance by creating DataStage Hash files for staging teh data and lookups.
• Mentor offshore resources for design of teh jobs and coordinate Development efforts.
• Scheduled teh server jobs using DataStage Director, which are controlled by DataStage engine and also for monitoring and performance statistics of each stage.
• Performed functional testing for new release enhancements.
• Participated actively in teh team meetings with teh developers offshore and onsite.
• Developed Parallel jobs using Parallel stages like Merge, Join, Lookup, Transformer (Parallel), Funnel, Dataset.

Environment: Information server - Datastage 9.1, 8.7, Clear Case, DB2, Linux, UNIX AIX and Windows 7

Confidential, Atlanta, GA

ETL Datastage Developer

Responsibilities:

• Extensively involved in teh data migration team to build teh Re-usable Datastage job templates, common parameter sets, common Datastage job containers, SQL extract procedures and common re-usable shell scripts.
• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Provide teh staging solutions for Data validation and Cleansing with PL/SQL and Datastage ETL jobs.
• Implemented Aggregate, Filter, Join, Lookup, Rank and Update Strategy transformations.
• Extensively worked with DataStage 8.1 - Designer and Director to load data from source extract files to warehouse.
• Created Datastage jobs to load data from sequential files, CSV, Flat files, SQL Server and Oracle.
• Cleansed, Standardize data using Quality stage.
• Developed various jobs using ORA OCI, ODBC, Aggregator, Sequential file stages.
• Worked towards optimal performance when using Stages like LOOKUP, JOIN, and MERGE.
• Designed and developed DataStage jobs for Loading Staging Data from different sources like Oracle, SQL Server DB into Data Warehouse applying business rules which consists data loads, data cleansing, and data massaging.
• Used teh Datastage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions
• Created Shared Container to simplify teh Datastage Design, and used it as a common job component through out teh project.
• Worked with Metadata Workbench, Import and Export of Datastage jobs using Datastage tools functionality.
• Created Parameters and Parameter sets where necessary.
• Tuned DataStage jobs for better performance by creating DataStage Hash files for staging teh data and lookups.
• Scheduled teh server jobs using DataStage Director, which are controlled by DataStage engine and also for monitoring and performance statistics of each stage.
• Performed functional testing for new release enhancements.
• Participated actively in teh team meetings with teh developers for bug reviews.
• Developed Shell Scripts to automate file manipulation and data loading procedures.
• Developed Parallel jobs using Parallel stages like Merge, Join, Lookup, Transformer
• (Parallel), Funnel, Dataset, Oracle Enterprise Stage.
• Writing PL/SQL procedures for processing business logic in database .Tuning of SQL queries for better performance.

Environment: Information server - Datastage 8.1, SAP ECC, SQL Server, DB2, Oracle 10g, UNIX AIX and Windows 7, PL/SQL,ORACLE Data Integrator