SUMMARY

• More than eightyears of experience in ETL using Datastage (Ver.11.3/9.1/8.5/8.1/7.5) client components, Datastagedesigner, Datastagemanagerand Datastage director.
• Experienced in building data warehouses and data marts using Datastage8/7.5.2 (datastage enterprise edition).
• Developed efficient jobs for data extraction/transformation/loading (ETL) fromdifferent sources to a target data warehouse.
• Experience working with Teradata and Oracle databases.
• Strong knowledge ofdata warehousing basics and relational database management systems and dimensional modeling (star schema and snowflake schema).
• Proficient at developing server jobs, parallel jobs and shared containers.
• Experience with various stages such as Aggregator, Filter, Merge, Hash, Sort, Transformer,Lookup, Change Capture Stage, Pivot, Join and Remove duplicates.
• Used datastage designer to develop the process for extracting, cleansing,transforming, integrating and loading data into the data mart database
• Experienced in performance tuning.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Oracle, flatfiles, csv files and xml files.
• Strong inclination for finishing jobs beforeproject deadlines. Flexible and versatile enough to adapt to the changing environments.

TECHNICAL SKILLS

• ETL Tools IBM Info Sphere DataStage (8.1/8.5/9.1/11.3)
• Ascential DataStage(7.5)
• Operating Systems Windows 95/98/2000/2003
• Windows NT
• UNIX
• Sun Solaris
• AIX 5.2
• Databases Oracle 11g
• SQL Server 2000
• DB2 UDB
• Teradata12
• Languages Unix Shell Programming
• SQL
• PL/SQL
• SQL ToolsTeradata
• SQLAssistant
• TOAD for Oracle
• Scheduling tools Confidential

PROFESSIONAL EXPERIENCE

DataStage Develope

Confidential, Austin, TX

Responsibilities:

• Designed Datastage jobs for extracting the data from various source systems, transformed and loaded data into the data warehouse.
• Worked with stages like Transformer, Aggregator, Lookup, Join, Sort, Funnel and others.
• Used Datastagedesigner 11.3 to develop the jobs.
• Created Sequencers to sequentially execute designed jobs.
• Worked with the Datastagedirector to run jobs and check logs.
• Involved in design review meetings with the business users, DBA and data architects.
• Mapped data items from source systems to the target system.
• Extracted data from various sources performed data transformations and loaded into the target database.
• Performed the unit testing for jobs developed to ensure that it met the requirements.
• Involved in designing the ETL process to extract data from Oracle and loaded into the target Oracle databases by applying business logic on transformations for data cleansing and insertion of records.

Environment: IBM InfoSphere DataStage 11.3, Oracle 11g, UNIX, Flat files, SQL,Microsoft Visio and

Confidential

DataStage Developer

Responsibilities:

• Designed ETL jobs for extracting data from heterogeneous source systems and designed the automated job runs to automate the ETL process.
• Used the IBM information server designer to transform the data through multiple stages and prepared documentation.
• Worked with stages like Transformer, Aggregator, Lookup, Join,Sort, Surrogatekey Generator, SCD and others.
• Used different partitioning methods like Auto, Hash, Same and Entire etc.
• Involved in creating UTP and system test plans for debugging and testing the entire system.
• Extracted data from various sources performed data transformations and loaded into the target database.
• Optimized SQL queries for maximum performance.
• Scheduled the job using shell script and Confidential utility.

Environment: IBM InfoSphere DataStage 9.1, IBM DB2, UNIX, Flat files, SQL and Confidential

DataStage Developer

Confidential, San Francisco, CA

Responsibilities:

• Developed ETL jobs to load data from DB2 databases, and flat files and CSV files to target warehouse.
• DataStage 8.5 was used to transform a variety of financial transaction files from different product platforms into standardized data mart.
• Optimized SQL queries for maximum performance.
• Used Datastagedesigner 8.5 to develop the jobs.
• Analyzed, designed, developed, implemented and maintained parallel jobs using the Enterprise edition of Datastage.
• Developed parallel jobs using various development/debug stages (Peek stage, Head and Tail Stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort and Merge, Funnel and Remove Duplicate Stage)
• Worked within a team to populate type I and type II slowly changing dimension tables from several operational source files.
• Created Sequencers to sequentially execute the designed jobs.
• Generated and interpreted mapping documentation and translated into detailed design specifications using the ETL code.
• Used Datastagedirector to execute the jobs.
• Performed the unit testing for jobs developed to ensure that it meets the requirements.
• Involved in coding, unit and functional testing and debugging.

Environment: IBM DataStage 8.5 (Director, Designer), SQL, IBM DB2, UNIX and Teradata.

DataStage Developer

Confidential, San Roman, CA

Responsibilities:

• Designed datastage jobs for extracting data from various source systems, transform and loading data into the data marts.
• Extracted the source data from Oracle tables, MS SQL server and loaded data into Teradata.
• Worked on different partitioning methods (Entire, Hash, Range) and collection methods (order and sort merge) in processing the sequential data.
• Extensively used Datastagetools like Datastagedesigner, Datastagedirector for developing jobs and viewed log files for execution errors.
• Optimized datastage jobs and SQL scripts to reduce run - time.
• Migrated data from flat files and Oracle into the Oracle data warehouse.
• Worked with the Datastagemanager to export and import Metadata and datastage jobs.
• Implemented UNIX scripts to copy files among different servers and to datastage jobs.
• Involved in the preparation of Confidential JIL scripts to schedule the jobs.
• Involved in creating UTP and system test plans for debugging and testing theentire system.

Environment:IBM Information Server 8.1, DataStage 7.5, IBM AIX5.2, Oracle 9i/10g, MS SQL ServerTeradata,SQL, UNIX, Putty and Confidential

Datastage Developer

Confidential,San Antonio, TX

Responsibilities:

• Translated business requirements into physical data warehouse and datamarts and developed datastage jobs to populate data into them.
• Extensively used Datastage designer to design jobs with various stages, like Join, Lookup, Change Capture, Filter, Funnel, Copy, Sort, File set, Sequential File, Data set, Oracle Enterprise, Teradata, Merge, Aggregator, and remove duplicate stages.
• Created the Job Sequences to control the flow of jobs.
• Worked with the Datastagemanager to export and import jobs, metadata and implemented routines and transformations.
• Worked with the Datastagedirector to run jobs and check logs.
• Worked with the business users to test and match the results against source system’s and re-load data, if any mismatch is found.
• Involved in design review meetings with business users, DBA and data architects.
• Worked with UNIX shell scripts to process and copy flat files among different servers and to invoke SQL scripts and Datastage jobs.

Environment:Datastage 7.5, DB2, Oracle8i/9i, Flat files, SQL, UNIX, Autosys4.5 and IBM AIX

ETL Developer

Confidential

Responsibilities:

• Designed the target schema definition and Extraction, Transformation and Loading (ETL) using datastage.
• Mappeddata items from Source Systems to the Target System.
• Used the Datastagedesigner to develop processes for extracting, cleansing, transforming, integrating and loading data into the data warehouse database.
• Worked on programs for scheduling data loading and transformations using DataStage from legacy system to Oracle 9i using SQL* Loader
• Used the Datastagedirector and its run-time engine to schedule running the solution, testing and debugging its components and monitored the resulting executable versions (on an ad hoc or scheduled basis).
• Worked with the Datastagemanager for importing metadata from jobs, new job categories and created new data elements.

Environment:Datastage 7.5(Manager, Designer, Director), Oracle 9i, SQL* Loader, SQL Server 2000Windows NT 4.0, UNIX