Data Management

Krishna Rao

Cell: ***

*** ****

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

Profile

. 9 + Years of Total IT experience

. 7 Years on ETL/DW Technologies

. 3 Years in Production Support experience

. 3 Years of Asset Management - Investment portfolio management

applications

Summary:

. Over 9 years of IT experience in all phases of software development life

cycle including analysis, design, development, testing, implementation,

production support in various domains such as Healthcare, Insurance,

Finance etc.

. ETL: 7 years of ETL experience using Informatica Power Center

8.6/7.1/6.1, Power Mart 6.1/5.x, Power Exchange, Power Analyzer, Data

Stage 7.5 and Microsoft SSIS 2005.

. Scheduling Tools: Have strong experience on CA Autosys Scheduler Console.

. Business Intelligence: 3 years of BI experience in Business Objects

6.5/6.0, Crystal reports.

. Database: Have experience on Oracle, Teradata, DB2, MS SQL Server,MS

Access

. Data Modeling: Have experience on data model design (star and snow flake

schemas) using Erwin and ETL procedures to load data from different

sources into data marts and data warehouse using stage, dimension and

fact mappings.

. FTP Tools: Expertise on various File transfer applications such as Putty,

Gentran Integration Suite and Smart Term

. Strong experience on development of Informatica mappings, workflows and

data stage jobs.

. Have experience on Unix Shell scripts to implement pre, post session

commands and JIL scripts with autosys for scheduling tasks.

. Investment Management Systems: Extensive experience on Asset Management -

Portfolio management applications -Eagle PACE data hub (Eagle Data Model)

and STAR.

. Have very strong functional domain experience on financial investment

asset classes such as Equities and Fixed Income processing, Trade Order

Life cycle and Securities process (SMF).

. Production Support: Expertise as Production support analyst for asset

management operations on Eagle PACE Data warehouse, STAR accounting

applications that includes Scheduler, Workflow manager, Message Center

and ETL tool - Informatica.

. Have experience on Level 2, Level 3 and data steward on call support

rotation basis for Eagle Pace data warehouse and down stream systems to

monitor various data feed and batch loads in order to meet SLAs.

. Incase of production issues, tracking them with incident numbers and

provide root cause analysis of issue to development team and notifies to

user groups.

. Co-coordination of Release Management activities for implementation and

change request run books with DBAs, UNIX, windows admin teams and with

other support groups.

Education:

. Bachelors in computer science

Technical Skills:

ETL Tools Informatica Power Center, PowerMart, Power Exchange,

Power Analyzer, Data Stage 7.5 and SSIS 2005

Investment Eagle 6.1, 9.1.PACE and STAR, Message Center

Management Systems

Scheduling Tools CA Autosys Scheduler Console, Tivoli, Control M

OLAP Tools EaglePACE reporting, Business Objects 6.5/6.0/5.1,

Crystal reports.

Databases Oracle 10g/9i/8i/8.x, Teradata V2R5/V2R4, DB2, MS SQL

Server 2000/2005, MS Access 7.0/2000

Operating System Windows 98/NT/2000/XP, Vista and UNIX

Languages C, C++, SQL, PL/SQL and UNIX shell script, XML

GUI Tools Autosys Scheduler 4.5, Visual Basic 6.0

FTP Tools Gentran Integration Suite, SmartTerm, Putty

Professional Experience:

TIAA-CREF, Charlotte, USA

Nov 2007 to till date

Asset Management Strategic IT Implementation and Operations

Senior Informatica/Developer -Production support analyst

TIAA-CREF asset management strategic IT implementation and Operations

project includes different phases of development and investment operations

support .TIAA has Eagle PACE as Investment Portfolio Management data

warehouse and STAR as accounting system. Eagle data hub receives Equity

trades from LVTS and Fixed Income trades from Charles River Development

(CRD) Trading Order Systems. STAR accounting application process the cash

and positions for trades and sent confirms back to middle office team in

order to sell or buy securities. Eagle PACE dataware house needs data from

different vendors on daily basis for various data feeds for Benchmark,

holdings, analytics and ratings from different vendors like factset,

Goldman, State Street and Bloomberg. The processed data will be sending to

different down stream systems for Reconciliation and Portfolio performance

reporting team.

Responsibilities:

. Involved in analysis, design, implementation, maintenance and scheduling

various operational pace, star events and informatica workflows.

. Worked with transformations such as Lookup, Union, Expression, Joiner,

Aggregator, Sorter, Filter, Router, Sequence generator, update strategy

etc to apply the business logic to load data into target and flat files.

. Involved in creation of JIL files for Autosys Scheduler to implement

Informatica workflow scheduling tasks.

. Involved in trouble shooting production issues related to data migration

and data integration.

. Tuned mappings, sessions and SQL scripts when doing complex data loads

for better performance.

. Extensively used Informatica debugger to fix the data issues

. Run adhoc events in PACE, STAR, Autosys, Informatica workflows as per

user requests and provide analysis in case of issues.

. Involved in providing datasteward implementation and operations support

for securities, trading and performance reporting.

. Involved in defect tracking with incidents using service now an incident

management system for production and test environment issues.

. Involved in support XML file transfer configurations using Gentran FTP

tool to send and receive released security files to CRD, and trade input

files and export for informatica workflows.

Environment: Eagle 6.0, 9.1.3 PACE, and STAR, Message Center, Informatica

8.1.1/7.1.3, Oracle 9i, 10g, UNIX, Autosys 4.5, Gentran Integration Suite

FTP.

HSBC - New York, USA.

July 2007 - Oct' 2007

Eagle Implementation for HSBC Investments

Eagle PACE Advanced Reports consultant

HSBC Investments developed the concept of Distributed funds management,

managing funds in the geographic regions closest to the market within the

mandate. Investors are notifying or aware of performance returns that are

affected by market fluctuations. To analyze the market values of

Investments by clients' three categories of reports GEM Month End, High

Yield Month End and Short Duration reports are being developed by EAGLE

PACE reports that have Summary, Profit Gain Loss, Transactions and Income

of portfolios for specific accounts or entities.

Responsibilities:

. Creation of Reports. (Eagle PACE OLAP and Advanced)

. Analyzing & understanding Report specification.

. Building Field Attributes - Database, rollup, derived, advanced etc.

. Developing component rules - Source rule, Field rule, - Grouping &

Filters & Date rules. Developing PACE Report Rules & Profiles.

Environment: Eagle PACE Advanced Reports 7.0, Oracle 9i, MS-Access -2000

Wells Fargo (Wachovia Corporation Bank) Charlotte, USA

Oct'2005- May2007

Wachovia Info Delivery Information

Senior Informatica Developer

Wachovia Info Delivery Information module is an integrated analytic

business solution designed to increase the value of Wachovia Corporation by

enabling clients of Wachovia to business strategy decisions by providing

the Monthly and adhoc reports to take the business decisions. Data is

extracted from different Data sources for Wachovia securities (CMG) and

recruiting and General Banking Group (GBG).

Responsibilities:

. Involved in Analysis, design of HR warehouse implementation delivery

warehouse.

. Involved in the preparation of high-level design for warehouse design of

Capital Management Group of Wachovia Securities.

. Created Informatica mappings and workflows for CMG data warehouse.

. Created crystal dashboard reports for monthly and quarterly employee

reports.

. Design Test plan and Involved in ETL system testing.

Environment: Informatica 8x/7.5, Crystal Reports 10, Oracle 9i, and MS-

Access 2000

PeopleSoft Corporation Inc, Pleasanton, USA.

May 2005 to Sept 2005

EPM 8.9 (Mozart Release)

BI/DW Consultant

PeopleSoft Enterprise Performance Management (EPM) is a comprehensive,

integrated analytic business solution designed to increase the value of

organizations by enabling people to business strategy decisions. Data is

extracted from normalized PeopleSoft and non-PeopleSoft transaction

processor's source tables and transformed into the operational warehouse

staging (OWS) staging tables.

Responsibilities

. Involved in Analyzing, Data mapping and development of Data Stage Jobs

for HCM warehouse.

. Involved in the development of OWS Jobs(Staging Jobs,both Server and

Sequencer Jobs)

. Involved in the development of complicated Dimension and Fact Jobs.

. Used most of the Stages in Data stage, such as the DRS Stage, Hash File

Stage, Transformer Stage, Merger Stage, IPC Stage, Pivot Stage, Shared

Containers etc.

. Design Test plan and Involved in system testing, and data integrity.

. Involved in testing HCM Module in HP Itanium platform.

Environment: Ascential Data stage 7.5, SQL server2000, HP Itanium platform.

Honeywell, Ricmond, USA

Feb 2005 to Apr'2005

Customer Profitability Data mart

Data Warehouse Developer

The objective is to develop a Customer Profitability Data mart for

Aerospace. Customer profitability data mart will provide data on different

discounts (off and on invoice), net price, pocket price, pocket margin at

customer, product level .The data mart will enable the business users to

analyze the data for different components of price waterfall model at

customer, product, and segment level.

Responsibilities:

. Involved in Data Model requirements gathering.

. Understanding user and business requirements.

. Preparing the test plan and test cases for ETL and reporting.

. Preparing the Sourcing and Target definitions, creating oracle scripts

for test data.

. Creation and publishing Business Objects reports using Web Intelligence

and Broadcast Agent.

Environment: Informatica 6.2, Oracle 9i, Businessobjects6.1, Windows NT.

Honeywell, Richmond, USA

Dec'2004-Jan'2005

AES Sourcing Data Mart

DW Informatica Developer

Scope of the project involves the development of procurement reports giving

the performance of suppliers, buyers, commodities at site, SBE, SBU level.

The project will involve developing reports for nineteen AES sites with the

facility to roll up the reports at SBE, SBU level. Project will involve

development of sourcing/procurement data mart. The data mart will have the

procurement data for nineteen AES sites...

Responsibilities:

. Creation of various classes, objects, dimensions and measures using BO.

. Creation and extensive integrity and cardinality checks on

classes/Resolving join problems.

. Preparing the test plan and test cases for ETL.

Environment: Informatica 6.2, Oracle9i, Businessobjects6.1, Windows NT.

Honeywell, Bangalore, USA

Sept'2004-Nov'2004

R&O Capacity Planning

DW Informatica Developer

The R&O data warehouse will provide data on workload for R&O shop in future

period, available resources, number of technicians needed to handle the

load, overtime required to meet work load, number of extra technicians to

complete the shop load. Data warehouse will provide the visibility to the

management team to enable them to make strategic decisions resulting in

improved performance for R&O shop.

Responsibilities

. Understanding user and business requirements.

. Creation of various classes, objects, dimensions and measures.

. Creation and extensive integrity and cardinality checks on

classes/Resolving join problems.

. Creation and publishing Business Objects reports using Web Intelligence

and Broadcast Agent.

Environment: Informatica 6.2, Oracle9i, Businessobjects6.1.

Symantek, Bangalore, India

Jan'2004 - Aug' 2004

Marketing Data warehouse

BI BO Developer

The main objective of MDH project is maintaining the reporting activities

of BPR (Business Planning and Reporting). To identify the future business

processes and data and this information is then used to map business

requirements to Siebel product functionality in order to determine the

configuration, integrations and potential product extensions required.

Responsibilities:

. Analyzed the existing database

. Created reports using Business objects

. Created low level design documents for the reports

. Involved in the unit testing of the reports

Environment: Oracle8i, Businessobjects5.1, Windows NT.

McHugh, Bangalore, India.

Jun'2003 - Dec'2003

Sales Analysis System

BI BO Developer

Allergen is the leading maker of eye care, skin care and prescription-based

pharmaceutical products. The company's eye care products include

medications, surgical equipment, contact lens cleaners, and intraocular

lenses (used to replace the eye's natural lens during cataract surgery).

The company's skin care products include treatments for acne and psoriasis.

Sales outside the U.S. make up nearly half of Allergen Inc's revenues.

Responsibilities:

. Responsible for scheduling Jobs and preparing technical documentation

. Designed and developed aggregator, joiner, look up, Filter, Router

transformation rules to generate consolidated data identified by

dimensions using Informatica ETL tool.

. Maintained stored definitions, transformation rules and targets

definitions using Informatica repository manager.

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

Environment : Informatica Powermart V5.1, Oracle 8i

G.E Enterprise Ltd. Bangalore, India

Aug'2002 - May'2003

Insurance Data warehousing

Informatica Developer

The client Gano Excel, Malaysia with a turn over of US $ 20 million, whose

Principal business segment is its Health care Insurance Products that are

the extracts of quality Mushrooms. They have branches in around 14

countries all over the world. GE Enterprise is an investment company, which

takes care of individual's investment. This facilitates GE Enterprise to

know who will be their target company for the investment

Responsibilities:

. Involved in importing source/target tables from respective databases and

created mappings using Informatica designer tool.

. Analyzing the Source, Designing Expressions, Filters.

. Creating Mappings, Transformations and SCDs.

. Used various transformations using Informatica power mart.

. Created sessions and batches and scheduling them using Informatica server

manager.

. Setting target load plan in the designer to load data into master/detail

tables.

Environment: Informatica Power Mart V5.1, Oracle, Window NT.

1. Production Planning System (Visual Basic6.0, Oracle 7.3)

(Nov'2001 - May'2002)

2. Order Grouping System (Visual Basic6.0, Oracle 7.3)

(May'2001 - Oct'2001)

3. Import and Export System (HTML, Java script, Oracle)

(Dec'2000 - Apr'2001)

Responsibilities:

. Developed code for several businesses process screens developed in VB.

. Developed many reports for production domains and accounts domain by

using crystal reports and data reports.

. Developed Script programming for customer logon screen and new customer

sign up screen (registration).

. Table creations for customer master, Product master.

. Developed home page of the site with PhotoShop, Flash, HTML and Java

script.

. Developed servlet programming for Member logon screen and new Member sign

up screen (registration).

. Created Reports like Daily, Monthly Reports.

Contact this candidate