SUMMARY:

• A seasoned EDW professional with broad experience in evaluating, building, managing and optimizing ETL solutions for medium to global enterprises. Proven experience in matching Teradata, DataStage capabilities, content, knowledge and process management needs of an enterprise. I have a total of eleven years of experience in building and delivering business applications including 8 years of Teradata and DataStage practice.
• Over 10 years of experience in Design, Development and Implementation in Data warehouse as an ETL developer. Worked in all the phases of Data Warehousing life cycle and Data marts using Data Stage (Ver 11.3/8.7/8.1/8.0 ), designing and developing jobs using IBM WebSphere DataStage Designer, DataStage Manager, DataStage Director and DataStage Administrator.
• Over 7 years’ experience in DataStage 11.5/ 8.7/8.1/8.0, Teradata 15.10, Teradata 13/13.10/12 (Teradata SQL assistance and Bteq using Linux/AIX OS), Teradata, DB2 9.7, Viewpoint, .
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Worked extensively on different stages like Transformer, Aggregator, Merge, Join, Copy, Lookup, Lookup File set, Filter, Change Capture, Column Generator, Dataset stages for Data cleansing and Data Transformation.
• 3 years of experience on Teradata Load Utilities Fast Export, Fast Load, Multiload, BTEQ and Tpump. Coded complex scripts for the Teradata Utilities and finely tuned the queries to enhance performance. Good experience with advanced SQL utilities.
• 6 months’ work experience on SAP Redwood scheduler, CA7 mainframes, MKS integrity, GIT eye, SAS.
• 2 years of experience on implementation of client-server application using Microsoft technologies like VB.NET, ADO.NET
• 3 years of experience on the Crystal XI Business Objects, Crystal Reports 10.
• Experience in development of complex Stored Procedures, Views,
• Triggers, Joins like database objects in MS SQL Server (2005&2008), SSIS, DTS.
• Worked on Macola ERP package (OE, IM, BOM, GL, PO, AP).
• Experience in XML related technologies: DOM, XSLT and XPath
• Executive level support for data warehouse projects like SDW and EDW.
• Experience in SAP iDocs and Stages for SAP R/3(like ABAP extract pack, iDoc Extract pack, iDoc load pack, Pack for SAP R/3).

SKILL:

IBM Web: Sphere DataStage and Quality stage designer and director (11.3/9./8.0/8.1/8.7 ) and administrator client Teradata 12/13.0/13.10, Business objects XI, Crystal Reports 10.0, Crystal reports 9.0, Macola ERP package, Good knowledge on SAP IDOC s, Logical, Physical Database Design and Modeling, Microsoft SQL Server 2005, 2000, SSIS, DTS, Linux/Unix shell programming, AIX,VB.NET,ADO.NET, C, C++, Java

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Migrated datastage from 8.5 to 11.5, as part of migration worked on the following tasks.
• Migrated shell scripts from AIX to Lunix platform and modified the db2 connections for new platform.
• Converted OSH shell scripts to Datastage Jobs.
• Working on CDW replatform code fixes for the datastage jobs. Changing database connection on the jobs, redesign server jobs to parallel jobs.
• Worked with custom operators like datecloseOp which works like CDC. Converted OSH script to Datastage jobs.
• Created JIL’s and tested autosys jobs for new platform.
• Worked on GIT source code maintaince also coordinated with multiple teams for code migration and deployment.
• Worked on SAS ( Data quality reports).
• Created the tickets for Lower and prod environments.
• Working with different teams Security,Unix support and DBA.
• Provided production support after migration. Like DCU ( Data correction units ) for data mismatched tables.

Confidential

Senior Teradata Developer

Environment: Teradata 15.10,Erwin for LDM data modeler, CVS ( version control ).

Responsibilities:

• Designed document and LDM/PDM for the project.
• Worked on Erwin to build the LDM process for the project.
• Developed Bteq/Fasload scripts as per requirements.
• Automation of the complete process.
• Tested and get signoff from business.
• Prepared production migration document and worked with support team.

Confidential

ETL Datastage support lead

Environment: IBM Websphere DataStage (11.3), Quality stage designer, Director (11.3), administrator client, DB2, Oracle11g, Cognos Reports AIX systems, CA7, MKS, XML Stage, MDM.

Responsibilities:

• Assessed requirements for completeness and accuracy and determined if requirements are actionable for ETL team.
• Identified, recommend and implemented ETL process and architecture improvements.
• Support and enhancements on ETL jobs.
• Established best practice and standard for ETL process documents.
• Designed ETL architecture and architecture documents.
• Defined and implemented ETL development standards and procedures.
• Troubleshoot and implement existing code.
• Analyzed all errors generated by Datastage and fixed those errors in data collection.
• Generated and supported SQL scripts for SIT and UAT.
• Designed restart-ability through ETL processes.
• Performance tuning and optimizing the existing mappings.
• Implement automation, audit and alert strategies throughout ETL processes.
• Supported and troubleshooted product ETL related issue.
• Worked on enhancements and releases related to project.
• Production support and offshore team coordination.
• Worked on PRM’s on issues related to XML stage.
• Prepared design documents for Cognos reports.

Confidential

ETL Datastage and Teradata Technical lead

Environment: IBM WebSphere DataStage, Quality stage designer, Director (8.7), administrator client, Teradata 13.10, Linux, AIX systems, Micro Strategy, SAP Redwood scheduler.

Responsibilities:

• Prepared proof of concept requirements / technical design documents and test cases.
• Worked with development team on some of complex datastage job and sequences.
• Prepared process metadata flow for the project, meaning define the ETL flow for the complete project.
• Worked on the optimization of complex quires. (examples: avoiding the product jobs and proper index jobs, using collect stats)
• Scheduled the project using SAP Redwood scheduler (creating job definition, jlinks for error log, and events for Micro strategy subscriptions).

Confidential

Senior ETL Datastage and Teradata Programmer Analyst

Responsibilities:

• Involved in Business requirement analysis, data modeling reviews and discussions.
• Built Unix shell scripts to cleanup datasets, environment variables and parameters, data file names based on the BOA’s Infosphere Information Server Development Guide
• Created parallel jobs, exception handling following the operational standards such as job auditing and monitoring.
• Imported metadata from Teradata/SQL SERVER/AS400 and modified the metadata containing multiple record types when necessary.
• Identified common fields and determined which common fields can be used as match key based on the source file layouts.
• Build DataStage Merge jobs to process input interface feeds from different upstream mainframe sources and generate output interface feeds to a downstream application by extensively using Sequential flat files, Copy Stage, surrogate key, Transformer, Merge, Funnel, Join, Aggregator, Change Capture, Filter and Sub-Routine.
• Migrated the existing 8.1 Datastage to 8.7 environment.
• Developed Teradata bteq scripts in AIX and created sequences to run the bteq scripts.
• Created Datastage sequencer project that can trigger the Microstrategy subscriptions.
• Created setup.rc files in Unix in project level environment.
• Developed Korn shell scripts to kick off the Sequencer jobs.
• Built out complete project from Staging →CDC → LOAD → PDM →PL specific jobs for the different model of Sales projects.
• Leading the IBM offshore team in the ETL process and Metadata Management
• Created test plans and test scripts for unit testing and integration testing.
• Provided the release notes and assisted DataStage Administrators during all DEV/UAT/DSR/PROD projects creations.
• Solved foreign language character issues and managed working with IBM basis team.
• Surrogate key issues.
• Node configuration issues like changing jobs from 1 node configuration to 2 node configuration.
• Resolved many issues with 8.1 to 8.7 migrations.

Environment: IBM InfoSphere Information Server 8.7, Business Glossary, Information Analyzer, Fast Track, DataStage, Teradata 13/14, SQLServer, AIX, Putty.

Confidential

Senior ETL Datastage and Teradata Programmer analyst

Responsibilities:

• Prepared the setup for datastage environment.
• Worked on Teradata (13.10) scripts to populate the data into EDW.
• Developed datastage jobs (8.7 version)

Confidential

Senior ETL Datastage and Teradata Developer

Environment: IBM WebSphere DataStage, Quality stage designer, Director (8.0/8.1), administrator client, Teradata 12/13.0/13.10, Linux, AIX systems, Micro Strategy, Teradata administrator 13.0

Responsibilities:

• Developed DataStage jobs, sequences, routines, shell scripts for Bteq and scheduled jobs.
• Developed jobs using various stages ODBC connector, Teradata connector, BW open hub source, sequential flat files, datasets, joins, lookup, Transform, job activity, routine activity, join, duplicate and various stages.
• Prepared environment variables on project level using administrator client.
• Worked on different source system like SAP, Macola (ERP), Microsiga(ERP), PRMS (AS400-ERP)
• Worked on different source databases like BW for SAP (using BW open hub stage), Macola /Microsiga (SQL server 2005), PRMS (DB2).
• Written SQL based business mapping using Teradata SQL assistance and Bteq scripts on various places like DataStage (Teradata connector), Linux Batch shell script and views for Micro Strategy reports.
• Worked on different subject areas on sales like Sales, Budget, Forecast, Dispute management & Safety management.
• Designed flow based diagrams for EDW.
• Performance tuning of SQL tables based on explain plan and collect statistics.
• Worked on migration of DataStage projects within multiple environments.

Confidential

Senior ETL Datastage and Teradata Developer

Environment: IBM Websphere Data Stage, Quality stage designer, director (8.1), administrator client, Teradata 12.0, Crontab Linux, Teradata administrator.

Responsibilities:

• Enhancements on the business logic and refreshing the data and testing data.
• Performance tuning on SQL to reduce spool space when dealing with large amount of data in Teradata.
• Developed DataStage jobs, sequences and scheduled jobs using Crontab Linux.
• Worked on creating views on Teradata for Micro Strategy reports.
• Worked with different source system like Ivara (SQL Server 2005), Infinity (SQL Server 2005) and sequential flat files.
• Worked on scheduling crontab.
• Preparing support documents, issue log documents and incident management to help in team.

Confidential

.NET / SQLSERVER Developer

Environment: VB.NET, Business objects, SQL Server 2008, Macola ERP.

Responsibilities:

• Conducted Strategic planning and road map for end to end migration.
• Developed surrounding applications using Visual studio 2003, .NET and SQL Server 2005.
• Developed almost 50 Business Objects Reports.
• Worked with business directly to prepare functional specifications of the applications and also prepared based on the existing Pascal applications.
• Providing presentations regarding the surrounding applications about the existing functionality and new features and getting approval for development.