Data Software Engineer

Suresh Babu

Mobile: +91-888*******/973-***-**** -Mail:

************@*****.***

~ PROFESSIONAL EXPERIENCE ~

~ IT Specialist ~ BI Infrastructure Management ~ Module lead ~

Objective

To work in a competitive environment that effectively utilizes my

analytical, interpersonal, leadership and organizational skills to conceive

and achieve solutions. The solutions which help the organization in not

only meeting its targets, but also allowing it to grow, thereby, enhancing

my own skills as an individual and as a key player in the organization's

development.

PROFESSIONAL PREAMBLE

< 10 years of total IT Experience in 1.4 years as Developer for e-

learning and 6 years in Data Warehousing.

< Expertise in DataStage HA Administration, Configuration, Environment

setup, Migration, Unidata configuration and Project implementation for

Different Environments.

< Experience in DataStage 7x EE, 8.0 and Mainframe Version, Informatica

6.2, Oracle 8i/9i and Control M scripting.

< Strong hold in Data Warehousing Concepts.

< Good Knowledge in SQL and Basic Unix Administration.

< Proficient in the Design and Development of process required to Extract,

Transform and Load (ETL) data into an integrated Data warehouse. Good

understanding of source to target data mapping, ability to define and

capture Meta data and Business rules associated with the ETL processes.

< Knowledge on Hyperion Essbase smart view Reporting and Administration.

< Knowledge in Data Modeling by using ERwin tool.

< Strong leadership skills with effective communication, team building,

relationship management and analytical skills with proven track record of

managing and setting up of offshore team.

< Knowledge in working on different pricing models from T&M, Fixed Price

Model and Work Package Model.

Tool/Technology

Operating System Windows XP, and Mainframes, Unix(HPUX) and

Linux(RHEL4, 5.3)

Languages C, SQL, PL/SQL, HTML, DHTML, XML and JCL

ETL Informatica 6.2, DataStage 7.x EE and 8.x

Reporting Hyperion Essbase 9.3, cognos 8x

RDBMS Oracle 9.x, Teradata, and DB2

Data Modeling tool ERwin 4.0

Automation Tools Control M

CAREER CONTOUR

Oracle India, Bangalore

Nov'11 till date

Consultant

Assignment : ETL Infrastructure Specialist

Client : OfficeDepot, Roca

Domain : Retail

< Support and maintain DataStage infrastructure on three different versions

of DataStage (v 8.7, V8.1 Enterprise Edition and V7.5 Server Edition).

< Migration from V7.5 to V8.7

< Coordinating with DBAs and network team to defining database connections.

This includes Teradata, Oracle, and SQL Server. Work with network team if

databases are remote and goes through a firewall. Install add-on

connectivity software as necessary for connecting to DataStage.

< Perform review of ETL jobs in application releases to ensure that they

will perform efficiently with the resources available.

< Work with applications to deploy new and modified DataStage jobs to QA

and production once jobs are approved in Teamtrack

< Monitor and process DataStage administration requests via ITG and pages.

< Assist developers and support staff with resolving problems with aborted

jobs, Locked jobs, space problems, large job log files, hung jobs, etc.

< Participate with other technical groups with infrastructure upgrades and

database upgrades. DataStage is dependent on a lot of remote servers and

the network.

< Work with help desk with bugs and deployment problems with the DataStage

client software.

< Develop, maintain and support bridge scripts that allow DataStage jobs to

run under ESP.

< Maintain DataStage standard and naming convention documentation on work-

group file shares and in the Sears Wiki.

< Enforce Best Practices and adherence to ETL standards.

< Perform Periodic DataStage environment health-checks and maintenance of

the DataStage environment.

< Package, support and maintains three versions (V7.5,V8.7 V8.1) of the

DataStage Client software.

Sears Holdings, Pune Apr'10 to

Jun'12

BI Specialist

Assignment : ETL Infrastructure Specialist

Client : Sears Holdings, Chicago

Domain : Retail

< Responsible for Build, maintain, back-up and support the ETL software

environment. This includes DataStage Enterprise Edition, DataStage Grid,

Sun Grid Engine, QualityStage, MetaData Workbench, and Fast Track .

< Support and maintain DataStage infrastructure on three different versions

of DataStage (V8.1 Enterprise Edition, V7.5 Server Edition and V6.0

Server Edition).

< Perform analysis and capacity planning to define 'best in class' ETL

solutions.

< Coordinating with DBAs and network team to defining database connections.

This includes Teradata, Netezza, and SQL Server. Work with network team

if databases are remote and goes through a firewall. Install add-on

connectivity software as necessary for connecting to DataStage.

< Perform review of ETL jobs in application releases to ensure that they

will perform efficiently with the resources available.

< Work with applications to deploy new and modified DataStage jobs to QA

and production once jobs are approved in PACMAN.

< Monitor and process DataStage administration requests via E-mail, PACMAN

and pages.

< Assist developers and support staff with resolving problems with aborted

jobs, Locked jobs, space problems, large job log files, hung jobs, etc.

< Participate with other technical groups with infrastructure upgrades and

database upgrades. DataStage is dependent on a lot of remote servers and

the network.

< Work with help desk with bugs and deployment problems with the DataStage

client software.

< Develop, maintain and support bridge scripts that allow DataStage jobs to

run under Control-M.

< Maintain DataStage standard and naming convention documentation on work-

group file shares and in the Sears Wiki.

< Enforce Best Practices and adherence to ETL standards.

< Perform Periodic DataStage environment health-checks and maintenance of

the DataStage environment.

< Package, support and maintains three versions (V7.5 and V8.1) of the

DataStage Client software.

Mindtree ltd, Bangalore Nov'07 Jan'10

Module Lead

Assignment : DAS

Client : CIT, New Jersey

Domain : BFSI

< Responsible for the infrastructure development and implementation of cost-

effective training and support solutions that are designed to provide

improved productivity, streamlined operations, and faster access to

critical information.

< Implement effective customer satisfaction strategies by identifying and

eliminating the root causes of customer problems.

< Participate in quality assurance procedures, auditing the incidences

replied by the other Agents and provide and adhere to the specific

support levels

< constructive feedback to agents, and adhere to the specific support

levels.

< Responsible for monitoring performance of development, QA, and Production

instance of the system.

< Creating user accounts and granting them appropriate roles and

privileges.

< Trouble shooting and resolving production issues.

Key Achievements:

< Successfully Installed and Configured DataStage 8 Server on Linux (RHEL

4).

< Oracle 10g Configured as Domain Repository.

< Implemented OS level authentication for DataStage users with unique admin

privileges as per security standards.

< Established Oracle, Sql Server, unidata and Sybase connectivity,

Configured plug-ins.

< Migration from DataStage 7.5 HPUX to 8.0 Linux.

< Web services and Xml input and output connectivity.

FIS (Second Foundation), Chandigarh Jun'06 Oct'07

Senior Consultant/Team leader

Assignment : EDWH Citi Bank

Client : IBM Germany

Domain : BFSI

< Identify and define the associated source data elements, including the

formatting of data values and writing transformation to maintain the

special meanings of certain specific data values.

< Map the source data elements to elements Based on Corda Rules.

< Create logic to transform the contents of source data to appropriate

formats in the target.

< Generate the Header file and Trailer file to sum and total data from the

data sources to the target Handoff files.

< Map the source data elements to elements Based on Corda Rules.

< Generate testing will be done to verify that each mapping works, that all

target fields are being appropriately populated, that conversion of

special data takes place, and that special conditions are being handled

appropriately.

CSC, Hyderabad Sep'05 May'06

Software Engineer

Assignment : BCBS RDBMS Conversion

Client : Blue Cross Blue Shield Association

Domain : Insurance

< Identify the elements in DB2 tables that populated.

< Identify and define the associated source data elements, including the

formatting of data values and writing transformation to maintain the

special meanings of certain specific data values.

< Map the source data elements to elements in the target DB2 table

structure.

< Create logic to transform the contents of source data to appropriate

formats in the target db

< Generate the test COBOL code and JCL to migrate data from the data

sources to the target tables in DB2.

< Unit testing will be done to verify that each mapping works, that all

target fields are being appropriately populated, that conversion of

special data takes place, and that special conditions are being handled

appropriately.

DSX software, Bangalore Apr'03 Aug'05

Software Engineer

Assignment : DB Feeds

Client : Deutsche Bank

Domain : BFSI

< Involved Analyzing Source system and designing low level design for the

mappings.

< Involved Data loading Sequence and Populated Data into Staging area and

warehouse with

Business Rules.

< Involved in the Development of Informatica mappings and also tuned them

for better performance.

< Used most of the Transformations such as Source Qualifier, Joiner,

Expression, Aggregator, Lookups, Filters, Stored Procedures, Update

Strategy and Sequence Generator

Schoolnet, Bangalore Mar'02 Jun'03

Multimedia Programmer

Assignment : CBT/WBT

Client : CBSE

Domain : Education

< Involved analyzing and preparing the presentations and designing the

Course.

< Created Several Courses using the above applications.

< Participated in Quality Analysis and maintaining the uniformity in the

design according to specifications.

ACADEMIA

Gulbarga University, Bellary, Karnataka

BE Computer Science

Year: 2000

Contact this candidate