Manager Project

Bhanu Kuna

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

Ph: +1-309-***-****

Summary

I am Informatica Professional, working as a Technology Lead with 8 Years of

IT Experience in Data warehousing. I am proficient in Informatica, MS SQL

Server, Cognos, Oracle, Teradata, Data Modeling using ERWIN, UNIX shell

scripts. Possess strong communication and problem solving skills developed

through a variety of projects. I had gained good experience and domain

knowledge of Banking, Finance, Warranty systems in manufacturing industries

Skills

Business Intelligence : Informatica 8.6/8.1/7.x/6.x/5.x, AbInitio, Cognos.

Languages : SQL, PL/SQL

Databases : MS Sql Server,DB2, Oracle 9i/8i, Teradata.

Operating Systems : Windows NT/2000/XP, UNIX

Reporting Tools : COGNOS 8.3/Cognos 8 BI: Framework

Manager, Analysis Studio, Report Studio, Metric

Studio and

Event Studio.

Profiling : Talend Open Source

Quality related : Manual Testing Procedures.

Data Modeling Tools :Erwin, Autosys

Job Functions : Analysis, Design, Coding, Testing, Documentation and

Application Support, Consulting, Project Management.

Professional Profile

JohnDeere\ YASH Technologies Dec 2010 to Till Date

ETL TechLead

InfoCrossing\WIPRO Jan 2010 to Dec 2010

ETL SPECIALIST

CYMA Systems Oct 2007 to Dec 2009

Systems Analyst

TCS (INDIA) Oct 2005 to Aug 2007

Assistant Systems Engineer

WIPRO (INDIA) Aug 2004 - Sept 2005

Project Engineer

RVM Technologies Jun 2003 - May 2004

ETL Trainer

Educational Qualifications

Education: Bachelor of Engineering in Electronics Engineering, JNT

University, INDIA.

Projects Information

Project 1 : JD ETL Services

Employer : John Deere \YASH Technologies

Designation : ETL Tech Lead

Dates of Employment : Dec 2010 to Till Date

Software used : Informatica 8.6, DB2, Toad, ER Studio and Windows.

Deere & Company is one of the world's most admired businesses. John Deere

best known for our quality agricultural and turf equipment. The world's

leading manufacturer of farm equipment and also lead in forestry equipment

and a major force in Construction Company.

JD ETL services team is providing ETL services internally for different

business departments in Deere like customer handling, account Flex(holds

the information about the customers), details of the machines, Parts.

My Responsibilities:

. Project Management on the technical front at onsite

. Oversee and Schedule Design Review, Code Review, ETL offshore

development and testing efforts.

. Assess technical issues and provide direction on solutions by

providing access to Subject Matter Expertise and technical resources

if required

. Consult with business analysts on ETL needs, tool selection,

source/target system analysis & estimation

. Review of Statement of Work and Requirements.

. Understand/track scope & timelines, by thoroughly analyzing the

requirements

. Identify issues/risks, mitigation plans and track them for closure.

. Support the existing ETL applications, work with business on

enhancements, help business in prioritizing the defects and ensure

resolution and closure of defects.

. Monitor the Enterprise ETL Services mail box and acknowledge the

requests/issues

. Ensure ETL support SLA s are met

. Work with IT Project Manager on resource planning

. Review estimate provided by Tech Canter of India(TCI)/Vendors and

analyze the gaps, discuss the concerns

. Provide detailed level of business requirements to TCI leads

. Assess technical issues and provide direction on solutions by

providing access to Subject Matter Expertise and technical resources

if required

. Support System Testing, Integration Testing and UAT.

Project2 :E1Phase2 DataConversion

Employer : Infocrossing\Wipro

Designation : ETL Specialist

Dates of Employment : Jan 2010 to Dec 2010

Software used : Informatica 8.6, DB2,Talend, ER Studio and

Windows.

The MO Health Net Division (MHD) has identified key goals for the Medicaid

Management Information System (MMIS) to improve system efficiency and

providing the most secure, powerful, and reliable computing platform to

house the critical MMIS data. In reaching these goals Infocrossing

Healthcare Services (IHS) will utilize IBM's DB2 for z/OS version 8.1

Relational Database Management System (RDBMS) which provides the

performance, availability, scalability, and reliability MHD is requesting

with this enhancement. DB2 is the industry standard for mainframe RDBMS.

My Responsibilities:

. Participated in the requirement gathering with the IFOX team SME for

the specific subject area.

. Doing the data analysis and providing the documentation on the

observations.

. Development of mappings for all the phases by using the different

transformations like Expression, Union, filter, router, sequence

generator.

. Development of tasks and workflows and worked in workflow monitor to

monitor the jobs.

. Performance tuning of the mapping and SQL codes written in DB2.

. Extracting the data from VSAM files using Power Exchange

. Conduct rule based data quality analysis by using Talend open source

Profiling tool to understand the data quality issues upfront and

define data correction business rules

. Define conversion specifications during the requirements analysis

phase

. Loading the data into DB2 tables by using Power Exchange

. Preparing FDS and TDS and TUT documentation for specific subject

area and VSAM files.

. Providing the Training for the newjoinees about the architecture and

the system details.

. Maintaining the weekly status of the tasks and challenges by the

team and issue resolving activities.

. Scheduling the meetings with the SMEs and data modelers and active

participation in the team meeting.

Project 3 : Bankers Life and Casualty, Chicago, IL

Employer : CYMA Systems

Designation : Systems Analyst

Dates of Employment : Oct 2007 - Feb 2009

Software used : Informatica Power Center, Oracle 10G, SQL,

ERWIN, Unix.

Description: Bankers Life and Casualty Company is one of the largest and

most respected insurance companies in the United States focused exclusively

on the needs of senior Americans. Bankers' Medicare portfolio is designed

to meet all the Medicare needs of retirees. Bankers services the needs of

seniors through a broad portfolio of quality, competitive insurance

products including long term care, life, annuities and medicare supplement

by understanding the financial needs of seniors by offering assurance to

retirees concerned about rising healthcare costs, and assist policyholders

in managing unexpected medical costs. Medicare Advantage plans are

available to provide a viable alternative to supplement plans and Medicare

Part D Prescription Drug coverage is available in several options designed

specifically to help those with Medicare save money on their prescription

medications.

My Responsibilities:

. Involved in creating Agent Sales Productivity Data Business

Requirements Documents

. Designed source to target mapping to create database design and

structure

. Created and reviewed Informatica mappings,sessions and workflows

. Created test data, test scripts, perform testing and review test

results

. Created metadata repository providing central source of information

for enterprise wide data model and data definition for various subject

area in the company Developed mappings and tuned them for better

performance

. Created re-usable transformations and mapplets that would be used in

all study conversions

. Developed workflows depends on the requirements like batch processing

and sequential by using the tasks

. Performed the Unit Testing which validate the data is mapped correctly

and System testing which provides a qualitative check of overall data

flow up and deposited correctly in Target Tables

. Created and Documented ETL Test Plans, Test Cases, Test Scripts, Test

Procedures, Expected Results, Assumptions and Validations

. Created data sources in Cognos portal and published packages to be

accessed by Report Studio, Analysis Studio, and Query Studio

Project 4 : Risk Early Warning

Employer :Citi Group, Jacksonville.

Designation :Assistant Systems Engineer

Software Used : Informatica, Oracle 9i,Teradata, Unix.

Duration : Oct 2005 - Aug 2007

Scope: REW stands for Risk Early Warning. This project contains all the

information of different types of frauds and fraud handing methods of

credit cards. This project will replace existing REW MIS processes for the

REW organization with a robust, automated analytical reporting solution.

The main objective of this project is to clearly define metric definitions

and to ensure consistent metric understanding across the REW organization.

Responsibilities:

. Initial requirement analysis

. Preparation of ETL design documents

. Creation of graphs using different types of components

. Developed mappings and tuned them for better performance

. Creation of wrapper scripts and post process scripts

. Involved in unit testing and preparation of unit test plans

. Involved in System Integration testing and preparation of SIT plans

. Involved in post implementation production support

Project 5 : CornerStone

Employer : Capital One

Designation : Project Engineer

Software used : AbInitio, Teradata, Oracle, SQL, ERWIN, ControlM, UNIX.

Duration : Aug 2004 to Sept 2005

Cornerstone project is replacing CRS' recoveries SOR, R2, with a new off-

the-shelf product LONDON Bridge Debt Manager. With that, all of CRS'

interface related to recoveries will be replaced. All internal interfaces

will be replaced to utilize Debt Manager's built in interfaces and Capital

One's DDE infrastructure. The purpose of this project is the EIM

Cornerstone Interfaces. It pulls the data from Source system to EIM DDE

for outbound files and put the signal files to Target system. CRS process

will generate a signal file and put it at the specified location on JCAK

for the EIM Cornerstone process

Responsibilities:

. Worked as ETL/BI developer for client CapitalOne - Banking for their

datawarehouse using AbInitio, Teradata and Oracle.

. Worked on the initial Application study,support for the applications and

maintening the application documents and enhancements.

. This project involved extraction from different source systems,

transformation and load programs into Teradata database and file systems.

Mainly involved in job monitoring and bug fixing for the job failures.

. Understanding system environment, load processes and system standards.

. Produce transforming specifications & peer review.

. Performing Testing and reviews, Production Maintenance

Project 6

Employer : RVM Technologies

Designation : ETL Trainer

Dates of Employment : June 2002 - May 2004

Software Used : Informatica, oracle, DB2

Responsibilities: Giving the training for the students in all the

development activities like

. Understanding the entire source systems

. Creating mappings for the application

. Involved in the Unit testing to check the data consistency

. Developed complex aggregate, join, look up transformation rules

(business rules) to generate consolidated (fact/summary) data

identified by dimensions using Informatica ETL (Power Center) tool

. Creating sessions, database connections and batches using Workflow

Manager

. Scheduling and monitored jobs using Workflow Manager Workflow Monitor

. Fixing problems in code during development and maintenance phases and

modify corresponding documentation

(Bhanu Kuna)

Contact this candidate