SUMMARY

• Over 6 years of extensive Data Warehousing experience on Extraction, Transformation and Loading (ETL) processes using IBM Information Server DataStage 8.1/8.0.1.
• Participated and contributed in multiple Design discussions. Also worked on preparing Low Level Design documents and Control Plans/Run books.
• Used DataStage Director to validate, schedule and run DataStage jobs
• Developed number of DataStage ETL jobs based on business requirements using various DataStage Stages as Copy, Modify, Aggregator, Filter, Funnel, Join, Lookup, Merge, Datasets, Sequential files and Transformer etc.
• Skilled in Database programming for Data Warehouses (Schemas), Experienced in Star Schema modeling, and Snowflake modeling, proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon.
• DesignedDataStageJobs to extract data from XML files using XML input stage, Used XML transformer stage to cleanse and transform the data to load it into the Data Mart.
• Designed Datastage jobs using MQ stage. Strong skills in creating reusable components like shared containers and local containers.
• Expertise in dealing with different databases such as Teradata, Oracle, SQL Server.
• Created complex stored procedures, views in Teradata for data extraction and loading.
• Have good knowledge of the scheduling tool Autosys.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team

TECHNICAL SKILLS

Languages: PL/SQL, SQL,UNIX shell and XML

Operating Systems: Windows 7/vista/2000/2003, MS - DOS, UNIX, Sun Solaris and Linux.

Databases: Oracle 11g/10g/9i/8.x/7x, SQL Server 2000/2005, Teradata.

ETL Tools: IBM Infosphere DataStage /8.0.1/8.1 (Parallel Extender).

Data Modeling Tools & Scheduling Tools: Toad and Autosys.

Reporting Tool: Business Objects, Cognos

PROFESSIONAL EXPERIENCE

Confidential

Sr. DataStage and Teradata Developer

Responsibilities:

• Understand the application.
• Prepared High level design and low level Design like Functional Specification, Source to Target Mapping sheet.
• Used Teradata in developing the view and stored procedure for extracting the data.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Target tables and Files.
• Played the lead role at offshore
• Tuned data stage jobs for better performance.
• SIT/PRT/PROD Warranty support for the same.

Environment: IBM information Server 8.1, Data Stage 8.1(Designer, Administrator, Director), Visio, Windows XP, UNIX AIX, Teradata V2R5, Toad.

Confidential

Sr. Developer

Responsibilities:

• Played the role of a business analyst.
• Understand the application.
• Prepared High level design and low level Design like the functional specification document and source to target mapping document.
• Involved in giving technical solution.
• Used Teradata in developing the view and stored procedure for extracting the data and analyzing the data.

Environment: IBM information Server 8.1, Data Stage 8.1(Designer, Administrator, Director), Visio, Excel, Word, Windows XP, UNIX AIX, Teradata V2R5, Toad.

Confidential

Sr. Datastage and Teradata Developer

Responsibilities:

• Understand the application.
• Prepared High level design and low level Design.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Target tables and Files.
• Used Teradata in developing the view and stored procedure for extracting the data.
• Played the lead role at offshore
• Tuned data stage jobs for better performance.
• SIT/PRT/PROD Warranty support for TD Evolution.

Environment: IBM information Server 8.1, Data Stage 8.1(Designer, Administrator, Director), Visio, Windows XP, UNIX AIX, Teradata V2R5, Toad.

Confidential

Sr. Datastage Developer

Responsibilities:

• Played as lead in offshore
• Involved in running the jobs and checking the issues and performance and solving them.

Environment: IBM information Server 8.1, Data Stage 8.1(Designer, Administrator, Director), Visio, Windows XP, UNIX AIX, Teradata V2R5, Toad.

Confidential

Sr. Datastage Developer

Responsibilities:

• Understand the application.
• Involved in identifying the data inputs from various source systems depending upon the business requirement.
• Prepared High level design and low level Design.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Target tables and Files.
• Played the lead role at offshore
• Tuned data stage jobs for better performance.
• SIT/PRT/PROD Warranty support for Audt Log.

Environment: IBM information Server 8.1, Data Stage 8.1(Designer, Administrator, Director), Visio, Windows XP, UNIX AIX, Teradata V2R5, Toad.

Confidential

Senior Datastage Developer

Responsibilities:

• Understand the application.
• Involved in identifying the data inputs from various source systems depending upon the business requirement.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different stages of Data Stage.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into transaction tables.
• Parameterized Data Stage jobs to allow portability and flexibility during runtime.
• Played the role of onsite coordinator
• Tuned data stage jobs for better performance.
• SIT/PRT/PROD Warranty support for Audt Log.

Environment: IBM information Server 8.1, Data Stage 8.1(Designer, Administrator, Director), Visio, Windows XP, UNIX AIX, Teradata V2R5, Toad.

Confidential

Datastage Developer

Responsibilities:

• Understand the application.
• Involved in identifying the data inputs from various source systems depending upon the business requirement.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different stages of Data Stage.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into transaction tables.
• Parameterized Data Stage jobs to allow portability and flexibility during runtime.
• Played the role of onsite coordinator
• Tuned data stage jobs for better performance.
• SIT/PRT/PROD Warranty support.

Environment: IBM information Server 8.1, Data Stage 8.1(Designer, Administrator, Director), Visio, Windows XP, UNIX AIX, Teradata V2R5, Toad.

Confidential

Datastage Developer

Responsibilities:

• Understand the application.
• Involved in identifying the data inputs from various source systems depending upon the business requirement.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different stages of Data Stage.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into transaction tables.
• Parameterized Data Stage jobs to allow portability and flexibility during runtime.
• Played the role of onsite coordinator
• Tuned data stage jobs for better performance.
• SIT/PRT/PROD Warranty support.

Environment: IBM information Server 8.0, Data Stage 8.0(Designer, Administrator, Director), Visio, Windows XP, UNIX AIX, Teradata V2R5, Toad.

Confidential

Datastage Developer

Responsibilities:

• Understand the application.
• Involved in identifying the data inputs from various source systems depending upon the business requirement.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different stages of Data Stage.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into transaction tables.
• Parameterized Data Stage jobs to allow portability and flexibility during runtime.
• Tuned data stage jobs for better performance.
• SIT/PRT/PROD Warranty support from offshore.

Environment: IBM information Server 8.0, Data Stage 8.0(Designer, Administrator, Director), Visio, Windows XP, UNIX AIX, Teradata V2R5, Toad.

Confidential

Developer

Responsibilities:

• Involved in developing Universe and Reports.
• Involved in Unit Testing of the Reports developed.
• Monitoring and fixing the issues on a daily basis
• Preparing Technical Design Document and Unit Test Case Document.

Environment: Business Objects, SQL Server 2005, Windows XP.

Confidential

Developer

Responsibilities:

• Involved in developing the tool for Cognos part.
• Involved in creating template that provides the features of Cognos.
• Preparing Technical Design Document.

Environment: Cognos, Business Objects, Visual Basic, SQL Server 2005.