Project Health Care

Shyam Shankar C P

Email: *****.*********@*****.***

Ph: +91-998*******

Career Objective:

It is said, "Find a job you like and you add five days to every week!" I

believe in this and would like to work in a positive and enriching

environment. I am a hard worker with a positive attitude and I aspire to

prove and improve my knowledge in Data warehousing.

Experience Summary:

> 5.5 years of experience in Business Intelligence and ETL.

> Experience in Leading a Team

> Experience in developing BTEQs, Mappings and Job Chains.

> Experience on debugging errors and solving.

> Experience in translating business requirements into technical

specifications for new enhancements to existing Application

> Identify, qualify and resolve client issues in a timely manner.

> Experience in resolving load failure issues quickly

Software Expertise:

Tools Informatica 9.5.1,

Teradata, Cognos 8.4.1,

Cronacle

OS UNIX

Career History:

> Oct 2008 to April 2013: Worked at TATA Consultancy Services

Ltd, Bangalore.

> May 2013 to till date: Working at Accenture, Bangalore

Certifications:

> Green Belt Certified

> Core Java Certified

Project Details:

Project #1.

Title : RTS (Support)

Client : A leading Health Care

Manufacture Globally.

Platform : UNIX, Windows

Tools : Informatica,

Teradata, Cognos, Cronacle

Duration : January 2009- June 2010

Description:

The main objective of RTS project is to provide

support to EDW Modules and Enhancement of EDW code. EDW mainly holds the

end-user required data to all the levels of the users. In the EDW

Architecture data get loaded based on user requirement at both detail level

and summary level for providing the scalability and performance of hardware

resources.

Role:

> Work with Business Analysts to translate business requirements into

technical specifications for new enhancements to existing Application.

> Use Informatica Power Center Client Tools to create mappings. Use

Debugger to test and fix bugs in the mappings.

> Create BTEQs (SQL Scripts) and UNIX job scripts for scheduling jobs in

Redwood Cronacle.

> Use Teradata SQL Assistant to validate data.

> Identify, qualify and resolve client issues in a timely manner.

> Resolve load failure issues quickly

Project #2.

Title : Development

Client : A leading Health Care

Manufacturer Globally.

Platform : UNIX, Windows

Tools : Informatica,

Teradata, Cronacle

Duration : July 2010- April 2011

Description:

The purpose of this project is to develop an application that loads the

Indirect Costs incurred to the client while manufacturing various Health

Care Apparatus from various origins globally.

Role:

> Developed the BTEQ scripts and run the scripts using Shell to load

data at Teradata Databases ( EDW)

> Scheduled the developed scripts and Informatica objects using

redwood Cronacle scheduler

> Extensively worked on Informatica Power center Client Tools with

Informatica Power Centre V.8.6

. Designer for developing various Mappings using Transformations.

. Workflow Manger for developing various Sessions and Workflows.

. Workflow Monitor to run and monitor workflows.

Project #3.

Title : Performance

Tuning

Client : A leading Health Care

Manufacturer Globally.

Platform : UNIX, Windows

Tools : Teradata,

Cronacle

Duration : April 2011- August 2011

Description

As a part of this project, I had to implement query banding in the BTEQs. I

had to also identify the queries which were consuming high resources and

with the help of architects, tune the query, test it and move the code to

Production

Role:

> Implement query banding

> Identify the bad queries which were causing major performance issues

> Create and test the queries

> Move the code to Production and validate

Project #4.

Title : Development

Client : A leading Health Care

Manufacturer Globally.

Platform : UNIX, Windows

Tools : Teradata,

Cronacle, informatica

Duration : August 2011- February 2012

Description:

As a part of this project, I had to archive the data of an application as

the application was getting retired. I was working as the offshore lead for

this team.

Role:

> Lead the team and help them in their daily activities

> Create the mappings and UNIX scripts for exporting the data from

Teradata

> Create a re-usable UNIX script that would take the filenames as

parameters and would FTP them to a different server.

> Get the files back from the server and validate them by loading back

to Teradata through mappings.

Project #5.

Title :

Development/Enhancement

Client : A leading Health Care

Manufacturer Globally.

Platform : UNIX, Windows

Tools : Teradata,

Cronacle, informatica

Duration : Ongoing

Description:

As a part of this project I had to retire certain data flows and implement

new hierarchy changes. I am the offshore lead for this project.

Role:

> Lead the team and help them in their daily activities

> Analyse the code and prepare the impact analysis document.

> Create the mappings and BTEQ scripts based on the requirements

> Make sure the code is moved to meet the deadlines

Educational Qualification:

> B. Tech Degree in Computer Science Engineering from Amrita

School of Engineering, Bangalore (CGPA - 6.74)

Extra-curricular:

> Organized cultural events in the office.

> Organized fests in the college.

> Participated in many cultural events and won many prizes.

> Member of a dance troop.

Personal Information:

Gender : Male

Date of Birth : 13th April 1987

Hobbies and Interests : Football, Cricket,

Gaming.

Contact this candidate