SUMMARY

• Over 12 years of experience in Design, Modeling, Analysis, Development, Testing and Implementation of Data Warehouse/Data Mart Applications and Client/Server Applications on Windows and UNIX platforms.
• Over 10 years of extensive experience in ETL tool DataStage EE 7.5, IBM Information Server 8.0/8.1/8.5/9.1/11.5 , IBM Websphere Information Analyzer 8.0; extensive experience with both DataStage Parallel and Server Editions.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers.
• Excellent knowledge in Extraction, Cleansing and Modification of data from/to various Data Sources like Flat Files, EBCDIC files and Comma Delimited files (.csv), XML files and Databases like DB2, Teradata, Oracle etc
• Extensively used IBM Websphere Information Analyzer 8.0 to analyze the source data and to provide recommendations for the target database, such as primary keys, foreign keys, and table splits, normalization and views of the data.
• Used WebSphere Information Analyzer to assess the quality of the data by identifying inconsistencies, redundancies and anomalies in the data at the column, table and cross - table level.
• Strong knowledge in OLTP/OLAP Systems, Normalized (OLTP), Denormalized (DW and ODS) models, Dimensional Strategies, Surrogate Key, Star schema, Snowflake schema and Ralph Kimball Methodology.
• Experience in UNIX Shell Programming (Korn and Born) for ETL Job Scheduling, File Manipulation, files FTP, Email Notifications etc.
• Developed DataStage Routines, Functions, and Transforms using DataStage BASIC. Used Stage Variables, Constraints in DataStage jobs.
• Developed Functions, Stored Procedures, Packages, Triggers using SQL, PL/SQL. Also created Normal and Materialized Views.
• Experience in Evolving Strategies and developing Architecture for building a Data warehouse using data modeling tool ERWin.
• Quick learner, efficient, self-motivated and success oriented. Excellent written and communication skills and ability to work independently.

TECHNICAL SKILLS

ETL Tools: DataStage EE 7.5, IBM Information Server 8.0/8.1/8.5/9.1/11.5 , IBM Websphere Information Analyzer 8.0, Quality Stage, Informatica Powercenter 9.1.

Version Control: PVCS Dimensions, ClearCase, CVS.

Scheduling Tools: Control M, Autosys

OLAP Tools: Crystal Reports, Business Objects, OBIEE

Programming Languages: SQL, PL/SQL, Shell Scripting, Perl.

Databases: Oracle 11i /10g/9.0i, DB2 9/10,Teradata 12.0, Sybase, SQL Server

Data Modeling Tools: ERWin 4.0.

Operating Systems: UNIX AIX 5L, Sun Solaris 2.x, HP, Windows 95/98/2000/NT.

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer / Lead

Responsibilities:

• Analyzing the requirements, functional specifications and identifying the source data to be moved to the DW.
• Involved in conducting design sessions and reviews.
• Designed the ETL jobs using IBM Information Server 8.5 to Extract, Transform and load the data into Staging and then into DB2 DataBase .
• Developed common jobs to be used in other objects for making the loading process less complex.
• Used DataStage Job sequencer and Control Mto schedule and run the jobs and send the feedback via email.
• Designed and developed complex transformations in DataStage to do multiple look-ups when loading the incoming source data.
• Used Built-in Functions and Routines for extraction, transformation and loading of the data.
• Extensively used the various Partitioning Methods like Hash, Entire, Auto, Same, Round Robin to increase the Job Performance.
• Various Performance Tuning techniques used to improve the load.
• Parameterized UNIX scripts were developed for running the jobs. These scripts were scheduled in Control M.
• Extensively worked in the Performance Tuning of ETL Procedures and processes, tuning the SQL used in Transformations.
• Was responsible for code move, Exporting and Importing from and to DEV, UAT and PROD.

Environment: IBM Information Server 8.7, UNIX Linux, Korn Shell Scripting, DB2, Oracle, Control M, Git.

Confidential, Mclean, VA

Sr. ETL Developer

Responsibilities:

• Analyzing the requirements, functional specifications and identifying the source data to be moved to the API Tables.
• Involved in conducting design sessions and reviews.
• Designed the ETL jobs using IBM Information Server 8.5 to Extract, Transform and load the data into Staging and then into Oracle Database.
• Developed common jobs to be used in other objects for making the loading process less complex.
• Used DataStage Job sequencer to schedule and run the jobs and send the feedback via email.
• Designed and developed complex transformations in DataStage to do multiple look-ups when loading the incoming source data.
• Used Built-in Functions and Routines for extraction, transformation and loading of the data.
• Extensively used the various Partitioning Methods like Hash, Entire, Auto, Same, Round Robin to increase the Job Performance.
• Various Performance Tuning techniques used to improve the load.
• Parameterized UNIX scripts were developed for running the jobs. These scripts were scheduled in Autosys.
• Extensively worked in the Performance Tuning of ETL Procedures and processes, tuning the SQL used in Transformations.
• Was responsible for code move, Exporting and Importing from and to DEV, UAT and PROD.
• Worked on Autosys scheduling for all the Batch processes.
• Responsible for UNIT, System and Integration testing. Developed Test scripts, Test plan and Test Data.

Environment: IBM Information Server 8.5/9.1, DB2 10, Oracle 11i, PL/SQL, SQL*Loader, UNIX IBM AIX, Korn Shell Scripting, Rapid SQL, Autosys, ClearCase, Informatica Powercenter 9.1.

Confidential, Sunnyvale, CA

ETL Tech Lead

Responsibilities:

• Created Datastage Parallel jobs using Designer and extracted data from various sources, transformed data according to the requirement and loaded into target Oracle10g database.
• Analyzed business requirements and developed metadata mappings. Involved in preparing high level and detailed design documents.
• Involved in analyzing and understanding metadata and data.
• Extensively did the Data Quality Checks on the source data.
• Created mapping document for the source to target mapping for the ETL development.
• Populated Type I and Type II slowly changing dimension tables from several operational source files.
• Extensively worked with DataStage Designer for developing various jobs in formatting the data from different sources, cleansing the data, summarizing, aggregating, transforming and finally loading the data into the data warehouse.
• Extensively wrote Custom routines, Transformations and Validated ETL designs as per the business requirements.
• Used Datastage Designer for creating new job categories, metadata definitions, and data elements, import/export of projects, jobs and Datastage components, viewing and editing the contents of the repository as well as writing routines.
• Used Datastage Director to schedule, validate, run and monitor the resulting executable versions.
• Extensively worked with Teradata RDBMS to store and retrieve data regardless of low-level operating system.
• Performed ETL performance tuning on Datastage jobs to increase the ETL process speed and for better performance.
• Designed and developed stored procedures, SQL statements using PL/SQL and SQL.
• Used ABAP SAP R/3 stage to extract data from SAP database and load it into the Data Warehouse.

Environment: Infosphere Information server 8.1(Datastage, Designer, Director), Oracle10g SAP R/3, SQL, PL/SQL, SQL*Loader, IBM AIX 5.9

Confidential, Parsippany, NJ

ETL Tech Lead

Responsibilities:

• Created Datastage Parallel jobs using Designer and extracted data from various sources like SAP, Sybase, Flat Files, transformed data according to the requirements and loaded into targets like Sybase and Flat Files.
• Analyzed business requirements and develop metadata mappings. Involved in preparing high level and detailed design documents.
• Involved in analyzing and understanding metadata and data. .
• Extensively did the Data Quality Checks on the source data.
• Created mapping document for the source to target mapping for the ETL development.
• Extensively worked with DataStage Designer for developing various jobs in formatting the data from different sources, cleansing the data, summarizing, aggregating, transforming and finally loading the data into the target systems.
• Worked on R outines, Transformations and Validated ETL designs as per the business requirements.
• Used Datastage Designer for creating new job categories, metadata definitions, and data elements, import/export of projects, jobs and datastage components, viewing and editing the contents of the repository as well as writing routines.
• Used Datastage Director and its run-time engine to schedule, validate, run and monitor the resulting executable versions.
• Defined reference lookups and aggregations, external procedures and update transformations according to the business rules.
• Performed ETL performance tuning on datastage jobs to increase the ETL process speed and for better performance.
• Provided On call support to the Production Application System. Used Unix Shell Scripts and Autosys to automate the process.
• Involved in Integration testing, Co-ordination of the development activities and the implementation of the modules in production.
• Involved in Onsite & Offshore Coordination.

Environment: Infosphere Information server 8.1(Datastage, Designer, Director),Sybase, SAP R/3, IBM AIX 5.9, Autosys, Shell Scripting, PVCS.

Confidential, Sunnyvale, CA

ETL Tech Lead

Responsibilities:

• Created Datastage Parallel jobs using Designer and extracted data from various sources, transformed data according to the requirement and loaded into target Oracle10g database.
• Analyzed business requirements and developed metadata mappings. Involved in preparing high level and detailed design documents.
• Involved in analyzing and understanding metadata and data.
• Extensively did the Data Quality Checks on the source data.
• Created mapping document for the source to target mapping for the ETL development.
• Populated Type I and Type II slowly changing dimension tables from several operational source files.
• Extensively worked with DataStage Designer for developing various jobs in formatting the data from different sources, cleansing the data, summarizing, aggregating, transforming and finally loading the data into the data warehouse.
• Extensively wrote Custom routines, Transformations and Validated ETL designs as per the business requirements.
• Used Datastage Designer for creating new job categories, metadata definitions, and data elements, import/export of projects, jobs and Datastage components, viewing and editing the contents of the repository as well as writing routines.
• Used Datastage Director to schedule, validate, run and monitor the resulting executable versions.
• Extensively worked with Teradata RDBMS to store and retrieve data regardless of low-level operating system.
• Performed ETL performance tuning on Datastage jobs to increase the ETL process speed and for better performance.
• Designed and developed stored procedures, SQL statements using PL/SQL and SQL.
• Used ABAP SAP R/3 stage to extract data from SAP database and load it into the Data Warehouse.

Environment: Infosphere Information server 8.1(Datastage, Designer, Director), Oracle10g SAP R/3, SQL, PL/SQL, SQL*Loader, IBM AIX 5.9