SUMMARY

• Over 7 years of experience in Design, Analysis and development of software applications.
• Around 7 years of experience wif ETL Tool like IBM Infosphere Information Server and over 1 Year Experience in IBM Datastage 8.5.
• Good Knowledge on Datastage client components - Datastage Director, Datastage Manager, Datastage Designer and Datastage Administrator.
• Developed efficient jobs for data extraction/transformation/loading (ETL) from different sources to a target data warehouse.
• Strong Knowledge on Data warehousing Basics and relational database management Systems and Dimensional modeling (Star schema and Snowflake schema).
• Implemented Slowly Changing Dimension phenomenon while building Data Warehouses.
• Deep understanding of OLTP, OLAP and data warehousing environment and tuning both kind of systems for peak performance.
• Experience in handling COMPLEX VERSION Of IMS,VSAM & GDG files using CFF Stage
• Exposure in designing and developing teh Logical and physical model using Data modeling tool (ERWIN)
• Experience in using scheduling tools like Zena, Autosys, Control M.
• Experience in working wifparallel extenderforsplitting bulkdata into subsets to distribute teh data to all available processors to achievebest job performance.
• Good working knowledge on utilizing variousTeradata Tools and Utilities (BTEQ, Fast Export, Multi Load, Fast load, TPUMP).
• Experienced wif planning, architecture, and design of Teradata data warehousing and SQL Optimization.
• Written several Teradata BTEQ scripts to implement teh business logic, worked on Tuning and troubleshooting Teradata system at various levels.
• Worked on SQL scripts for applying few transformations and cleansing data.
• Worked wif stored procedures to insert and clean data into teh data warehouse tables, fired triggers upon completion of load to obtain teh log of all teh tables loaded wif job name and load date.
• Worked on UNIX shell scripts using Kshell for teh Scheduling sessions, automation of processes, pre and post session scripts.
• Experience in web technologies like HTML and JavaScript.
• Ability to solve complex technical problems and has unique ability to understand long-term project development issues at all levels and interpersonal skills wif strong desire to achieve specified goals wifin teh given time frame.

TECHNICAL SKILLS

Languages: C, C++, Unix Shell Programming, SQL, PL/SQL

Operating Systems: Unix, Windows, Aix (IBM)

Database and Tools & Oracle Tools: Oracle 9i,10g, SQL Server 2000, DB2,SQL*Plus, TOAD, SQL*Loader, Designer 2000, Developer 2000,Teradata V2R6

Web Technologies: HTML, JavaScript

ETL Tools: Ascential DataStage 8.0,7.5.1,7.5,7.1

Data Modeling Tools & Scheduling Tools: Erwin,Zena, Autosys,Control M professional experience

PROFESSIONAL EXPERIENCE

Confidential, Addison, TX

Application Developer

Responsibilities:

• Developed ETL jobs to load data from GDG, DB2 databases, flat files, CSV files to Target warehouse, and experience wif high volume databases on Mainframes Legacy Systems.
• Datastage 8.5 was used to transform a variety of financial transaction files from different product platforms into standardized data mart.
• Experience in handling COMPLEX VERSION Of IMS files using CFF Stage.
• Performed Column Analysis, Primary Key Analysis, Foreign Key Analysis and Cross Domain Analysis using IBM Information Analyzer.
• Optimized SQL Queries for maximum performance.
• Used Datastage Designer 8.5 to develop teh jobs.
• Worked wif stages like Z/os, Complex Flat File, and Transformer, Aggregator, Join, Sort, Surrogate key generator and others.
• Designed and developed jobs using Datastage/Qualitystage for loading teh data into Dimension and Fact Tables.
• Developed Job Sequences for automating and scheduling teh Datastage Jobs.
• Experience in generating and interpreting mapping documentation, and translating into detailed design specifications using ETL code.
• Extensively designed, developed and implementedParallel Extenderjobs usingParallel Processing (Pipeline and partition)techniques to improve job performance while working wif bulk data sources.
• Working knowledge of mainframe based tools such as File Aid.
• Created Shell scriptsfor scheduling teh Datastage jobs using wrappers.
• Used Datastage Director to execute teh jobs.
• Worked wif Datastage to migrate jobs from 8.1 to 8.5 and Datastage components.
• Experienced in developing test plans for data warehouse solutions.
• Involved in documenting teh Frame Work Templates and teh process of developing jobs using Templates.

Environment: IBM Datastage 8.1/8.5 (Director, Designer), PL/SQL, IBM DB2, Oracle, Mainframes, UNIX.

Confidential: Hoboken, NJ

Datastage Developer

Responsibilities:

• Involved wif Business users and ETL Leads from different teams to implementETL Frame WorkusingDatastage Server/Parallel combination of jobs.
• Extracted data from various sources likeOracle Database,XML, Flat Files, .CSV filesand loaded to target warehouse.
• Used Column Analysis results to understand teh hidden business rules, data types, data anomalies, cardinality and nullability.
• Implemented various strategies forSlowly Changing Dimensionsusing Datastage Server/Parallel jobs using teh Frame Work approach.
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Filter, Dataset, Lookup file Set, Remove Duplicates, Change Data Capture,Switch,Modify, and Aggregator.
• Involved in developingDatastage Designer Server and Parallel jobs for Extracting, Cleansing, Transforming, and Integrating/Loading Data into Corporate Data Warehouse (CDW).
• Developed Job Sequences for automating and scheduling teh Datastage Jobs.
• Extensively designed, developed and implementedParallel Extenderjobs usingParallel Processing (Pipeline and partition)techniques to improve job performance while working wif bulk data sources.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata ) and SQL * Plus, SQL * Loader (Oracle).
• Used Teradata Parallel Transporter to load data from various sources.
• Extensively usedDatastage Directorto Monitor and check teh run statistics of teh Jobs and to clear teh job logs, job resources.
• Extensively usedDatastage Managerto Export/import Datastage components.
• Involved in Unit Testing for teh jobs.
• Created Shell scriptsfor scheduling teh Datastage jobs using wrappers.
• Used configuration management tools likeRational Clear Case/Clear Questfor version control andmigration.
• Involved in documenting teh Frame Work Templates and teh process of developing jobs using Templates.

Environment: Ascential Datastage8.0/7.5.1(Server/Parallel Extender),Oracle10g,Teradata,UNIX Shell Scripting, Windows NT/2000, Clear Case/Clear Quest, IBM AIX 5.2, Autosys.

Confidential: Chicago, Illinois

Datastage Developer

Responsibilities:

• Involved in meetings to gather information and requirements from teh clients.
• Involved in Designing teh ETL process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
• Gathered information from different data warehouse systems and loaded into Database using Fast Load, Fast Export, Multi Load, Bteq and UNIX shell scripts.
• Used teh Ascential Datastage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked in teh areas of relational database logical design, physical design, and performance tuning of teh RDBMS.
• Worked extensively on different types of stages like Sequential file, ODBC, Hashed File, Aggregator, Transformer, Merge, Join, Lookup, Sort and Containers (Server, Parallel) for developing job.
• Used Parallel Extender for parallel processing for improving performance when extracting teh data from teh sources.
• Create master controlling sequencer jobs using teh Datastage Job Sequencer.
• TEMPEffectively used Datastage Manager to Import/Export projects from development server to production server.
• Written K shell Scripts for getting data from systems to Data Warehousing system.
• Extensively used ETL to load data from Oracle 10g, XML files and Complex Flat files.
• Responsible for trouble shooting, identifying and resolving data problems, Worked wif analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Created Fast Load, Fast Export, Multi Load, Tpump, BTEQ scripts for Target Database.
• 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 (on an ad hoc or scheduled basis).
• Scheduled jobs dependencies using Control-M Scheduler.
• Implemented Unit, Functionality, Performance and Stress testing on Mappings and created Testing Documents.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.

Environment: Ascential Datastage 7.5.1 (Manager, Designer, Director), Teradata V2R6, Tools & Utilities (BTEQ, Fast Export, Multi Load, Fast load, TPUMP), DB2, Windows 2000/NT, Unix, Control-M Scheduling.

Confidential: Cypress, CA

Datastage Developer

Responsibilities:

• Involved in designing and development of data warehouse environment.
• Translation of Business processes / rules into Datastage Jobs for populating Data marts.
• Extensively worked wif Datastage Designer for developing various server jobs and parallel jobs using Sequential file, Hashed file, ODBC and Transformer stages.
• Designed Datastage ETL jobs for extracting data from heterogeneous source systems transform and finally load into teh Data Marts.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Created source Table definitions in teh Datastage jobs by studying teh data sources.
• Created re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects.
• Tuned Datastage transformations and jobs to enhance their performance.
• Used PL/SQL stored procedures in Oracle for extracting as well as writing data.
• me even created Fast Load, Fast Export, Multi Load, BTEQ scripts for Target Database.
• 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 on an ad hoc or scheduled basis.
• Created jobs sequences and job schedules to automate teh ETL process.
• Enhanced teh job properties for optimizing teh Datastage jobs.
• Experienced in developing test plans used in validation of data warehouse solutions.

Environment: Ascential Datastage 7.5 (Designer, Director, Manager),Windows NT,Sql s Teradata Tools & Utilities (BTEQ, Fast Export, Multi Load, Fast load), Sql Server, PL/SQL, UNIX, Sequential Files, .csv files, XML Files.

Confidential: Hartford, CT

Datastage Developer

Responsibilities:

• Developed ETL jobs to load data from SQL Server, DB2 databases, flat files to Target warehouse.
• Datastage 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 Datastage Designer to develop teh jobs.
• Worked wif stages like Sequential file, hash file, Transformer, Aggregator, Sort and others.
• Used Datastage Director to execute teh jobs.
• Wrote SQL *Loader script to load Inventory data into custom tables.
• Worked wif Datastage Manager to export/import Datastage components.
• Experienced in developing test plans for data warehouse solutions.

Environment: Ascential Datastage 7.1 (Director, Designer, Manager), PL/SQL, IBM DB2, SQL*Loader, SQL Server 2000, Windows NT.

Confidential

ETL Developer

Responsibilities:

• Involved in creating entity relational and dimensional relational data models using Data modeling tool Erwin.
• Designing teh Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.
• Mapping Data Items from Source Systems to teh Target System.
• Used teh Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked on programs for scheduling Data loading and transformations using Data Stage from legacy system to Oracle 9i using SQL* Loader and PL/SQL.
• Designing and Developing PL/SQL Procedures, functions, and packages to create Summary tables.
• Used teh Data Stage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions (on an ad hoc or scheduled basis).
• Worked wif Datastage Manager for importing metadata from jobs, new job Categories and creating new data elements.
• Developing Shell Scripts to automate file manipulation and data loading procedures.

Environment: Datastage 7.0 (Manager, Designer, Director), ERWIN, Oracle 9i, PL/SQL, SQL* Loader, SQL Server 2000, Windows NT 4.0, UNIX.