Data Project

SEKHAR.K

Mobile No: +91-963*******

E-Mail:*****.****@*****.***

SUMMARY:

. 3+ Years of Experience in Development of various projects and domains.

. Extensive Experience in ETL Tool IBM Webshpere Datastage8.0.1 and

Ascential Datastage 7.5.2.

. Understanding the business rules completely and implementing the data

transformation and methodology.

. Hands on experience in Tuning Jobs process identifying and resolve

performance.

. Knowledge on Data warehouse concepts like Data warehouse Architecture,

Star schema, Snowflake schema, Data Marts, Dimension and Fact tables.

. Diverse background with fast learning skills and creative analytical

abilities with good technical skills.

. A versatile, determined & extremely self-motivated individual who

thrives on meeting tight deadlines and is comfortable in a pressurized

environment. Broad technical awareness with the ability to communicate

at all levels.

TECHNICAL EXPERTISE:

ETL Tools : IBM Websphere Datastage 8.0.1, Datastage 7.5.2x.

Databases : Oracle 9i, SQL/PLSQL.

Operating Systems : Windows 2003/XP, UNIX.

Third Party Tools : Putty.

WORK HISTORY:

> Working as an ETL Consultant in Polaris Software Solutions, Bangalore

from Feb 2009 to till date.

> Worked as an ETL Developer Marney Technologies, Bangalore from Feb

2007 to Jan 2009.

ACADAMIC PROFILE:

. Bsc computers (Bachelor of Computer Science) from Nagarjuna

University.

PROJECT #1

Project Name : Insurance Mart

Client : Orange Services ltd

Period : Sep 09 to Till Date

Role : ETL-Developer

Environment : IBM Webshpere Datastage 8.0.1, Oracle 9i, UNIX and

Windows NT

Project Description:

US is specialized in home, auto, farm and business

insurance. The data was not an integrated data. There are multiple

disparate sources for information about the company's products, customers

and distribution channels. I was engaged in extraction, cleansing,

transformation, integration and loading of data into warehouse (oracle

tables).

Responsibilities:

V Involved in Designing Data Stage Jobs using Data Stage Parallel

Extender, Supporting all phases of the ETL process such as

implementing Source to Target.

V Created jobs to move data from Source to Staging Area and

Staging Area to Warehouse.

V Designed jobs using different parallel job stages such as Join, Lookup,

Filter, Dataset, Remove Duplicates, Modify, and Aggregator.

V Used Data Stage Manager to export and import the Projects and

Components.

V Used Data Stage Director to execute and monitor the jobs.

PROJECT #2

Project Name : DWH-M

Client : Kasikorn Bank, Thailand

Period : Feb 09 to Aug 09

Role : ETL-Developer

Environment : Ascential Data stage 7.5.2x, Oracle 9i, DB2, putty,

Windows XP & UNIX

Project Description:

The Kasikorn Bank is one of the leading banks

in Thailand by providing a Wide Range customer - driven banking services.

Mobilizes local and external financial resources through current, saving

and fixed term deposits. Provides short, medium and long-term commercial

credit in the form of overdrafts, term loans. Provides housing, mortgage

loans, investment loans, Personal Loans, credit card and safe-deposit

lockers etc.

The bank's initial goal is to pool data from all the locations and

integrate at the central location and build the capability to analyze the

business (present and history) depending on various criteria, while the

ultimate goal is to offer effective and additional services to customers.

This Migration project deals with building EDW by integrating historical

data from DWH and on-going data from different legacy systems. This DWH-M

can be used to generate granular, aggregate level reports which can be used

by the managers and users which helps the organization to analyze and track

the vital business dimensions.

Responsibilities:

. Working on Data Stage Designer - for Extracting Source

Transactional Database and transforming and then load into Target

Database.

. Used Sequential file, DB2, Join, Sort, Lookup, transformer, file

set, dataset, change capture, filter, modify for designing the

jobs in the Data Stage Designer.

. Involved in Performance Tuning, process identifying and resolve

performance Issues.

. Used Data Stage Director for running and monitoring the jobs.

. Worked with Data Stage Manager for Export & Import Jobs.

. Created Data Stage sequences to run multiple jobs.

. Involved in Unit Testing and System testing.

PROJECT #3

Project Name : Data warehouse Support

Client : Cisco Inc.

Period : May 08 to Jan 09

Role : ETL-Developer

Environment : Datastage 7.5.2, Oracle 9i, AIX64bit and Windows XP

Project Description:

The Cisco Data Warehouse (CDW), now the

Enterprise Data Warehouse (EDW), has evolved through an Enterprise

Architecture initiative to enable subscribing systems to report consistent

numbers as recipients of data from the EDW. This initiative is ERBI -

Enterprise Reporting Business Intelligence, which enables reporting

applications to receive "Single Source of Truth" (SSOT) measures from EDW.

Data warehouses can enable subscribing systems to report consistent numbers

only if they are all pointing to the data warehouse.

CISCO Data Warehouse can be broadly divided into 6 different tracks, which

are as listed below.

1. CDW Common

2. Finance

3. Marketing

4. Internal

5. Customer & Sales

6. Product & Services

Enterprise Data Warehouse (EDW), refreshes 3 times a day, from order

management information from Oracle ERP source systems.

Contribution

As a team member, was responsible for

. Maintenance and Support.

Responsibilities:

V Major part of Data Stage includes Transformation such as, Lookup

and sequence generator.

V Analyzing the Source, Designing Expressions, Filters.

V Created and Monitored Batches using Ascential Data Stage 7.5

V Re-Scheduling the batches in case of stopped it for resolving

issues

PROJECT #4

Project Name : CRM

Client : Eritel, Eritrea

Period : Feb 07 to April 08

Role : ETL-Developer

Environment : Data Stage 7.0 server editions, Oracle 8i, Telnet,

Windows XP.

Description: Eritel provides national level Telecommunication services

and offers local fixed line telephone services, domestic long distance

services, international voice services, and data transmission services, as

well as other value-added services such as the provision of Internet access

and mobile phone networks. Similarly, the supply, manufacture, installation

and servicing of telecommunications and broadcasting equipment. CRM enables

an insight into the current and future financial situation/needs based on

the information received from the Data Warehouse and an effort to expand

telecommunications services to the rural and remote parts of the country.

Responsibilities:

. Creating the Server jobs based on the requirements using DataStage.

. Created mappings Using Data Stage Designer from source to Staging and

staging to target Data Warehouse.

. Integrated Sources from Oracle and Flat Files

. Improved performance using Hash files, link partitioner, link

collector.

. Creating the Hashed files for lookups.

. Involved in Unit testing.

Contact this candidate