Educational Qualifications :

• M.E(Computer Science & Engg.)

Profile and Experience:
I have 7 + years of experience in IT including 4+ years in Business applications using Teradata Utilities, Informatica ETL Tool with Oracle and Teradata. Presently I am working in IBM. Additionally, I have had @ 7 years in Non-IT (Insdustrial & Lecturing)
The Clients that I have associated so far include ABN AMRO (La Salle Bank, Chicago) Reinsurance Group of America (St. Louis) & the Teradata clients like International Hotels Group (IHG), Stations Casinos & Frontier Communications (New York), Aditya Birla Financial Services Group (India) and Vodafone India withdomain experience in Insurance, Banking, Communication, and Hospitality.
IT Career History:

Date

Position

Confidential,NJ

June 2010 - Present

Teradata- ApplicationDeveloper

Confidential

Sep 2009 – May 2010

Module Lead

Confidential,Pune

Sep\'2007 - Mar\'2009

Technical Consultant

Confidential,Mumbai

Nov\' 2006 - Sep\'2007

ETL Developer

Confidential

Mar\'2005 - Oct\'2006

Business Analyst

Primary Area of expertise
Currently practicing in development and production in Teradata Data warehousing solutions through Analysis, Design & Development with Teradata Utilities mostly with FLOAD, BTEQ (ETL Scripts using Teradata SQL/Unix ) ,MLOAD, TPUMP, TPT & earlier worked on Informatica Tools (Informatica 8.6, 8.1.1, 7.x, 6.x) with Oracle
Skill Sets:

UNIX, Windows

ETL Tools & Scripting Language

Informatica Power Center 8.1.1,7.x,6.x ,UNIX Shell Scripting

Data Modeling

ERWin

RDBMS

Teradata Version 12, Oracle 9.i,

Tools and Utilities

SQL Assistant, MLOAD/TPUMP/FLOAD, SQL Developer, TOAD & Business supporting tools WinSCP, Ultra Edit , HP Service Desk, Putty, Lotus Notes

My Latest Project:
Confidential,Period : June 2010 (from)
Industry : Communication
Project Name : Downstream ETL & SAS Applicaton Reporting
Project Type : Development & maintenance
Environment : Teradata 12, SQL Assistant, TOAD, Erwin,
Role : Lead
Responsible for:
1. Managed Rapid Respnse Team for User\'s adhoc request (Teradata) both from Managerial and Executive
level across 23 Circles(Remedy Tool).
2. Understanding Requirement and write Teradata Report queries and optimization.
3. Interacted with Operations Team for gathering requirement for Data mapping & other work products to
eventually arrive at the BRS Documents.
4. Developed ETL Codes and done UAT test cases.

• Provided Report Manual and Operational Manual to Operation Team.
• Interaction with Data Modular during (Account Adjustment Enhancements) in Communication System

Teradata LDM.

Confidential,Period : Sep. 2009– May 2010
Industry : Insurance
Project Name : ABFSG - Common Technology Platform
Project Type : Building EDW
Environment : Teradata 12, SQL Assistant, TOAD, BODI/BOXI, Erwin
Role : Module Lead
Responsible for:

• Study/Analyze the Business (SRS, SOW, Solution Architect) from Clients. Interact with different

Source Systems of Business Users (Ingenium, Channel Management System, Receipt Writer System,
Compass, e-Cams, Micro Insurance) during Extraction of their DB2, Oracle Sources.

• Handled the environmental issues while deploying the Teradata 12(Client), BODI/BOXI (Client) and

their connectivity with Teradata Server. Played a role as a Liaison between the Teradata and the Aditya
Birla Common Technology for creation of Teradata Hierarchy/objects as per the Teradata Standards,
with respect to their three Line of Business (BSLI, BSLAMC, BSDL).
3. Analyze OLTP Layer across the different Source Systems for building Reports from Teradata DB (ODS).
Develop/Unit Testing the MLOAD/BTEQ/Batch Scripts from Landing to Staging, ETL Mapping for
Target DWH.Study/Analyze the Business (SRS, SOW, Solution Architect) from the Client.

Project experience in Teradata:
Confidential,Period : Jan. 2009– April 2009
Industry : Hospitality
Project Name : IHG ETL Migration Oracle to Teradata
Project Type : Migration & Development
Environment : Informatica Power Center 8.6, Oracle, UNIX
Role : Module Lead

Responsible for:

• . IHG\'s ETL Workflow process migration to offshore development environment & its estimation.
• . Retrofitting the Workflow process and all of its objects to the Teradata Standard and unit test the

mappings
3. Team meetings, development activity on a daily basis to the onsite personal and weekly conference
call with the Client.
4. Ensuring the IHG Oracle Sources, Oracle SQL, mapping, mapplets, Target & session properties
after migration to Teradata, meet the data type, coding standards profoundly, technical issues
resolved internally, ETL Run book, log queries that require onsite support.

• . Preparing the Unit test case and review the unit test for mappings with the test data.

Confidential,Period : Jun\'2008 – Dec\'2008
Industry : Hospitality & Gaming
Project Name : Active Enterprise Datawarehousing for Stations Casinos
Project Type : Development
Environment : Informatica Power Exchange 8.6, Teradata Utilities MLOAD, Teradata 12
Role : TEAM Member/Module Lead

Responsible for:

• . Understanding the LDM and its subject area like Financial, Food & Beverage, Offer, MyPlay and

LMS Mappings. Escalate the connectivity issues for AS 400 Systems, gaps in the specification,
particularly the mapping Tables, columns, its data type, precision with respect to the database
physical objects and the columns not mapped.

• . Development of mappings for all the subject area in the Stations Casinos (Hotels & Beverages,

MyPlay to name a few)

• . Update the query log on a daily basis and develop the ETL mappings based on the strategies LS1/

LS2, conforming to the Informatica coding standards.

• . Unit Test & ensuring active data warehouse realization with the Teradata TPUMP on Insert/

Updates for the Source AS400 Systems updates gets reflected in the Targets and updates the results
in Unit test document.

• . Weekly update the Consultant Workbook.
• . Coordinated effort among Team members in resolving issues, helping peers on connectivity;

resolve the Informatica errors, Teradata errors.

Confidential,Period : Mar\'2008 – Jun\'2008
Industry : Administration & Resource Planning
Project Name : Teradata Integrated Resource Management Module (TIRM)
Project Type : Development
Environment : Informatica Power Exchange 8.6, Teradata Utilities MLOAD,
FLOAD, TPUMP, Teradata Database
Role : TEAM LEAD
Responsible for:

• . Understanding the Requirements from the client, their daily activity Report Formats
• . Identifying the required entities, its relations and provide the estimates in the Analysis phase

considering the environmental support, Resource availability in Design, Development and Test
phases and prepare the project plan.

• . Delegate the task based on the functional and practice for developing the LDM, fully normalized

PDM for Teradata, ETL (Informatica/Teradata), and Report Design during development and Test/
Review phase.

• . Managed ETL Team, Teradata Service Team and Report Team
• . Developing the ETL Design, Mapping Specification Documents, and Coordinating among the

practice to support for their requirements.

• . Periodic Client meeting/presentation on the project progress and deliverables.
• . Submitting the Report and the Final presentation.

Confidential,Period : October 2007 – December2007
Industry : Communication
Project Name : Account Adjustment - Enhancing call center Reporting
Project Type : Development
Environment : Informatica Power Center 8.1.1, Teradata
Role : Technical Consultant

Responsible for:

• . Development of the Account Adjustment workflow process to load the new tables that are created

to normalize with the existing DWH.

• . Analyzed the mapping specifications, Gap & impact analysis for the design and development of

mappings for additional requirement.

• . Prepared the Unit test case and unit test for the new mappings with test data.
• . Understanding the modification of BTEQ Scripts for onetime loading in this project.

Confidential,Period : Nov’ 2006 – Sep’2007
Industry : Insurance
Project Name : Electronic Data Processing module in IRA – Administration Application
Project Type : Development and Maintenance
Environment : Informatica Power Center 7.1.2, Oracle 9i
Role : ETL Developer

Responsible for:

• . Creating Informatica Repository, Users and Folders (Repository objects)
• . Worked with multiple repositories on demand, Database cleanups.
• . Analyzed mapping specifications. Gap and impact analysis for design and development of

mappings for additional requirements.

• . Utilized HP Service Desk, which is a worldwide Job assignment tool, to manage Change Requests

and updating their status.

• . Developed new mappings for companies like IRISH, CHANNEL LIFE, SCOTTISH WIDOWS,

AXA and enhancement and maintenance of the mappings for UK and South African Insurance
companies like ALTRISK, DISCOVERY, and UK companies HSBC, Guardian, Easy Life.
Project experience:
Confidential,Period : March 2005 – October 2006
Industry : Banking Service
Project Name : Analytic Data Mart (DWH)
Project Type : Development and Maintenance
Environment : Informatica PowerCenter 7.1
Role : Business Analyst

Responsible for:
1. Backend maintenance/development support given to the client’s ADM Data mart for
their Marketing Intelligence purpose.
2. Developed, maintained their mappings, workflow strategy
3. Fully mentored on mapping design, Impact Analysis, workflow logic, and scheduling.
Performed unit and integration testing.

Training/Certification History:

Teradata Physical Implementation V2R5

2007

Pune

Classroom

Teradata SQL V2R5

2007

Pune

Classroom

Teradata Advanced SQL V2R5

2007

Pune

Classroom

Teradata Application Developer

2009

Pune

Classroom

Teradata Parallel Transporter

2008

Pune

Classroom

Informatica

2005

Mumbai

Classroom