PROFESSIONAL SUMMARY:

• Over 7 years of experience in Design, Analysis and development of software applications.
• Around 7 years of experience with 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 the Logical and physical model using Data modeling tool (ERWIN)
• Experience in using scheduling tools like Zena, Autosys, Control M.
• Experience in working withparallel extenderforsplitting bulkdata into subsets to distribute the 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 with planning, architecture, and design of Teradata data warehousing and SQL Optimization.
• Written several Teradata BTEQ scripts to implement the business logic, worked on Tuning and troubleshooting Teradata system at various levels.
• Worked on SQL scripts for applying few transformations and cleansing data.
• Worked with stored procedures to insert and clean data into the data warehouse tables, fired triggers upon completion of load to obtain the log of all the tables loaded with job name and load date.
• Worked on UNIX shell scripts using Kshell for the 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 have unique ability to understand long-term project development issues at all levels and interpersonal skills with strong desire to achieve specified goals within the 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 with 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 the jobs.
• Worked with 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 the data into Dimension and Fact Tables.
• Developed Job Sequences for automating and scheduling the 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 with bulk data sources.
• Working knowledge of mainframe based tools such as File Aid.
• Created Shell scriptsfor scheduling the Datastage jobs using wrappers.
• Used Datastage Director to execute the jobs.
• Worked with 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 the Frame Work Templates and the 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 with 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 the hidden business rules, data types, data anomalies, cardinality and nullability.
• Implemented various strategies forSlowly Changing Dimensionsusing Datastage Server/Parallel jobs using the 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 the Datastage Jobs.
• Extensively designed, developed and implementedParallel Extenderjobs usingParallel Processing (Pipeline and partition)techniques to improve job performance while working with 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 the run statistics of the Jobs and to clear the job logs, job resources.
• Extensively usedDatastage Managerto Export/import Datastage components.
• Involved in Unit Testing for the jobs.
• Created Shell scriptsfor scheduling the Datastage jobs using wrappers.
• Used configuration management tools likeRational Clear Case/Clear Questfor version control andmigration.
• Involved in documenting the Frame Work Templates and the 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 the clients.
• Involved in Designing the 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 the Ascential Datastage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked in the areas of relational database logical design, physical design, and performance tuning of the 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 the data from the sources.
• Create master controlling sequencer jobs using the Datastage Job Sequencer.
• Effectively 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 with 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 the Datastage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the 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 with 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 the Data Marts.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Created source Table definitions in the Datastage jobs by studying the 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.
• I even created Fast Load, Fast Export, Multi Load, BTEQ scripts for Target Database.
• Used the Datastage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Created jobs sequences and job schedules to automate the ETL process.
• Enhanced the job properties for optimizing the 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 the jobs.
• Worked with stages like Sequential file, hash file, Transformer, Aggregator, Sort and others.
• Used Datastage Director to execute the jobs.
• Wrote SQL *Loader script to load Inventory data into custom tables.
• Worked with 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 the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.
• Mapping Data Items from Source Systems to the Target System.
• Used the 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 the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
• Worked with 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.