ETL Developer Analyst

ANAND KUMAR

+91-729******* ADDRESS - **, SEA BREEZE FLATS,

Email: *****.*********@*****.*** Thiruvanmiyur,

Chennai -41

ETL Developer

SUMMARY

• ETL developer with around 3 years’ experience in design and development of Data

Integration and Data Warehousing, ETL and Business Intelligence solutions

• Experience across full project life cycles for OLAP, Business Intelligence, ODS,

CRM, Data Warehousing solution development across various verticals such as

Finance, Consumer, Retail, Automobile, Media and Health Sciences

• Expertise in building ETL jobs for MDM

• Worked with global clients like Alpha Bank, Dell, J.C. Penney, Canadian Tire,

American Heart Association and Health Now

• Got two times onsite (Greece) opportunity to work for Alpha Bank through IBM

Hellas

• Won the Most Valued Professional award at InfoTrellis for the year 2010 and 2012

TECHNICAL SKILLS

ETL IBM InfoSphere DataStage 8.x

Profiling Tool IBM InfoSphere Information Analyzer

Data Quality Trillium, IBM Quality Stage

Programming/Scripting C, C++, Java, JavaScript, XML, HTML, Shell Script

Languages

RDBMS DB2 9.x, ORACLE 10g, 11g, Teradata 12.0, Netezza 6.0.8, Microsoft SQL Server

Platform MS Windows Server, Linux, Unix (and derivatives), Windows XP, 7

EDUCATION, CERTIFICATION & TRAINING

• MCA, University of Delhi, India

• InfoSphere Quality Stage - Boot Camp Training by IBM

EMPLOYMENT HISTORY

InfoTrellis India Pvt. Ltd Chennai, India OCT 2010 till

date

Page 1 of 4

ANAND KUMAR

ETL DEVELOPER

KEY PROJECTS

CLIENT: ALPHA BANK, GREECE NOV 2012 –

CURRENT

Role: ETL Developer

Project Description: Business Data Warehouse (BDW) Project is implementation of IBM’s

standard Financial Industry model Data warehouse. The Goal is to provide a centralized

repository of transactional data and compliance to BASEL-III standards. At the core is Netezza

appliance to provide business intelligence and forecasting.

Responsibilities:

• Work with the business to translate functional requirements to technical design.

• Designed extraction patterns to populate customer data mart from data

warehouse(BDW)

• Developed DataStage Jobs and Sequencers for extracting BDW data and load

data mart and summary tables.

• Designed and executed Integration tests for Arrangements and Obligor entities.

• Performance tuning and Balance Optimization on Netezza 9 and DataStage 8.7.

Technologies: Netezza 6.0.8, DataStage 8.7, Aginity workbench

CLIENT: JCPENNEY MAY 2012 – OCT

2012

Role: ETL Developer

Project Description: The Customer Data Integration (CDI) project is a re-architecture of the

current core customer information process. The goal of this project is to provide a single,

complete and accurate enterprise view of customer that enables customer facing applications and

downstream systems like CDW and TQ to have one source of information. At the core of the

system is IBM MDM Server which maintains master operation data for Customer which is

received periodically from CDB System.

Responsibilities:

• Developed Load Strategy for loading MDM and Data warehouse Staging tables

from legacy Consumer Data Repository

• Coded for Jobs and Sequencers to load Customer Data Warehouse

• Developed DataStage Jobs to load Data into MDM Hub from heterogeneous

source systems.

• Analyzed source data across various systems using data IBM InfoSphere

Information Analyzer.

Page 2 of 4

ANAND KUMAR

ETL DEVELOPER

• Fixed issues raised by the QA team

Technologies: Datastage 8.7, Teradata 12, DB2 9.7, PL/SQL, UNIX, Windows

CLIENT: AMERICAN HEART ASSOCIATION JAN 2012 – APRIL

2012

Role: ETL Developer

Project Description: American Heart Association (AHA) is a national voluntary health

agency in the United States that fosters appropriate cardiac care. It has a variety of

people interacting with its network, such as philanthropists, doctors, volunteers and

others. AHA initially used IBM MDM Server 8.0, with two different systems maintaining

customer information, and loading periodic delta updates to MDM. AHA would like to

bring in party information from all sources under a single hub. The objective of the

current project is to leverage customer data integration (CDI) as a core technology to

provide a single authoritative system of record for party data across the enterprise. In a

phased manner, party information from multiple sources would be integrated with MDM

Server using different tools and technologies. This will help AHA to group the most

accurate and timely information about all their customers under a single hub.

Responsibilities:

• Analyzed the Business Requirements, Designed High Level and Detailed ETL

Process Flows

• Performed data profiling to identify possible data issues and coordinated with

Business analyst to validate all requirements

• Developed DataStage jobs to load data into MDM Hub

• Developed jobs to extract MDM data for populating ODS

• Prepared all technical and system specifications documents for all ETL

processes

• Performed unit tests on all processes

• Customized QualityStage Rules for Address and name standardization

Technologies: IBM DataStage v8.5, IBM MDM v9, DB2 9, Oracle 11g, SQL Server

2008, UNIX-Solaris, Windows XP

CLIENT: CANADIAN TIRE CORPORATION JUN 2011 – DEC 2012

Role: ETL Developer

Project Description: Canadian Tire has several inter-related businesses which include

at a high level Canadian Tire Retail, Marks Work Warehouse, Part Source, Petroleum

and Financial Services (Credit Card, Personal Loans, Banking and Insurance) among

others. Based on their business processes and system capabilities a part of the overall

Page 3 of 4

ANAND KUMAR

ETL DEVELOPER

customer data is managed by each division. The objective of this project is to integrate

all customer information from across different channels into a single common hub.

Responsibilities:

• Devised Detailed Design Document for ETL Processes to load data into MDM

hub

• Worked on setting up the cleansing and validation rules for the source system

• Developed DataStage jobs to load MDM hub from three heterogeneous source

systems

• Implemented DataStage jobs to load Landing, Staging and Customer Dimension

in Customer Data warehouse with MDM data

• Customized Quality Stage Rules for Address and name standardization

Technologies: IBM DataStage v8.5, IBM MDM v10, Oracle 11g, Netezza, UNIX,

Windows NT

CLIENT: HEALTH NOW OCT 2010 – APRIL

2011

Role: ETL Developer

Project Description:

The objective of this project was to provide the business compliance across the enterprise by

managing the master copy of the master copy of the ICD Codes into a central repository. This

data is published and shared among the downstream business systems. HealthNow wanted to use

a custom web based interface to access and maintain the ICD referential data. The requirements

included building features to perform partial search, version filtering and date filtering which are

not provided by the RDM product UI.

The customization included SOAP Web Service Request and response conversations and custom

pages design using UI components.

Responsibilities:

• Analyzed the mapping document

• Developed the jobs using datastage

• Created the unit test cases and executed against the jobs

• Worked with XML sources and targets

Technologies: Datastage 8.1, Oracle 11g, Windows XP

Page 4 of 4

Contact this candidate