Project Management

Ravi Kumar Sanjeevi

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

Contact: +91-965-***-****

Objective:

To pursue a challenging Career in I.T. industry in a fast-paced, Multi-

tasking environment with emphasis on Data Ware-Housing techniques and to be

a part of a progressive organization and to contribute to the growth that

gives me a scope to enhance

Experience Summary:

> Having 3+ years of progressive experience in Software Development Life

Cycles with ETL Development, Support & Testing.

> Strong Knowledge on ETL Architecture

> Good understating on DWH Concepts

> Around 3 years of experience in developing ETL using Informatica.

> Having hand on experience on ETL Testing for about 3.7

> Having good understanding of Financial and Mutual funds domain.

> Having hands-on experience with Mercury Quality Center 9.2.

> Having experience in Complete ETL testing life cycle

> Strong knowledge on QTP 9.2

> Ability to clearly understand the objectives and deliver results on

time by working within a team.

> Experienced in communicating with team and technical organization of

varied disciplines.

> Understand new ideas and technical concepts quickly, converting them

into meaningful results.

> Excellent oral and written communication skills. A skilled problem-

solver and an efficient team player.

Professional Experience:

Working as a Software Quality Analyst in Franklin Templeton International

Services, Hyderabad from December 2006 to June 18th 2010 (Soon joining new

a company)

Educational Qualification:

B.E (Electrical and Electronics Engineering) from Anna University in 2006

with an aggregate of 75%

Technical Skills:

Operating Systems Unix, Windows XP/2k

Programming Languages C, C++, VB scripting

ETL Tools Informatica

Job scheduling Tools Control M

Database Oracle 9i, DB2,SQL/PLSQL,TOAD 9

Bug tracking Tools Mercury Quality Center 9.2, JIRA

CM Tools EDR & Share Point

Experience Summary:

# Franklin Templeton, Hyderabad

December 2006 - June 18th 2010

Project: GI-Data Marts Phase II & III

October 2009 to June 18th 2010

Application: Global Image

Technologies: Java, Informatica, Oracle 9i.

Languages: PL/SQL

Description: The Franklin Templeton uses GI extensively for converting the

hard copies of the client trade requests into images along and transferring

the same date along with indexes to Different TA (Transfer Agencies) locate

in 22 locations across the World. GI Data marts are the enhancements of

existing application in order support the new Reporting module for analysis

and auditing purpose.

Roles & Responsibilities:

. Attend Knowledge transfer sessions.

. Understanding the high level business requirements

. Analyzing the application historical data and extracting required data

to support management decisions.

. Developed various Mappings and Transformations using Informatica

Designer

. Extensively used lookup, aggregator, update and router

transformations

. Configured session properties and target options for better

performance

. Performance Tuning of sources, targets, mappings and SQL queries in

transformations

. Conducting KT to QA teams

. Support QA teams for any queries and issues

. Supported the production jobs monitoring still moved to sustain team

. Activity Participated in Sev 3 & Sev 2 calls

. Documenting the issued that were encountered during production support

. Preparing detail issue analysis documents if any

Project: Expressway Phase II

June 2008 to September 2009

Application: SMS & GWS Canada

Technologies: AS 400, Informatica, DB2, Oracle 9i and UNIX

Description: Franklin Templeton is one of the worlds top ten assets

management company. Internally Franklin has started using SMS as their

application for managing Mutual Funds related activities across Canada. SMS

manages around 6 millions account for The Franklin Templeton of Canada and

GWS Canada is a Client interface application developed to view client

account related activities. IPIN is a process of synchronization between

the two applications for Financial Activities

Roles & Responsibilities:

. Involved in the SDS walk throws given by Business

. Attend Knowledge transfer & Training sessions and gain necessary

knowledge.

. Involve in details analysis and designing TSD

. Participated in developing Mapping using Informatica 7x

. Actively Participated in debugging the mappings and data flow

. Supported the production jobs monitoring

. Activity Participated in Sev 3 & Sev 2 calls

. Documenting the issued that were encountered in production support

. Preparing High level issue analysis documents

Project: PDL

July 2007 to May 2008

Application: GID,

Technologies: Java, Informatica, Oracle 9i.

Languages: PL/SQL

Product Load project is multiple owner products (a multi-owner product is a

product, where there are many clients invested within the same product) as

follows:

. U.S. Registered Mutual Funds (Franklin, Templeton, Fiduciary & Mutual

Series -- open end, closed end,

529 plan, variable annuity & institutional mutual funds)

. Canadian Registered Mutual Funds

. European Mutual Funds (SICAV) and OEIC (UK)

The motivation for this project is based on the implementation and the

consolidation of current and historical enterprise product information into

a single source: Global Integrated Database (GID) / Enterprise Warehouse

(EW). Currently, Retail and Institutional product data is being utilized by

various front-end applications such as franklintempleton.com,

franklintempleton.ca and the Global Fact Sheets. This data is being

provided from various source systems such as PMA, Fund station, OneTIS, SMS

and MRD. Looking forward, these applications will look to utilize the

Global Integrated Database / Enterprise Warehouse as the single source of

product data required for the assorted projects and initiatives.

Roles & Responsibilities:

. Involved in the SDS walk throws given by Business

. Attend Knowledge transfer & Training sessions and gain necessary

knowledge.

. Involve in details analysis and designing TSD

. Participated in developing Mapping using Informatica 7x

. Actively Participated in debugging the mappings and data flow

. Supported the production jobs monitoring

. Activity Participated in Sev 3 & Sev 2 calls

. Documenting the issued that were encountered in production support

. Preparing High level issue analysis documents

Project: Expressway Phase I

March 2007 to June 2007

Application: SMS & GWS Canada

Technologies: AS 400, Informatica, DB2, Oracle 9i and UNIX

Description: Franklin Templeton is one of the worlds top ten assets

management company. Internally Franklin has started using SMS as their

application for managing Mutual Funds related activities across Canada. SMS

manages around 6 millions account for The Franklin Templeton of Canada and

GWS Canada is a Client interface application developed to view client

account related activities. IPIN is a process of synchronization between

the two applications for Non-Financial Activities.

DEV Roles & Responsibilities:

. Running Daily batches on SMS.

. Running In Bound and Out Bound jobs on SMS

. Running Informatica Jobs on UNIX

. Validation of data bases

Roles & Responsibilities:

. Involved in the SDS and CSD walk throws with Business

. Attend Knowledge transfer & Training sessions and gain necessary

knowledge.

. Involve in details analysis on TSD and identification of critical

business and test scenarios.

. Preparing test cases as per functional assessment document.

. Involved in preparation, reviewing and execution of the test cases.

. Defect reporting and working closely with EW team and tracking them to

the closure.

Project: Fund launches 2007

December 2006 to February 2007

Application: SMS

Technologies: AS 400 & DB2

Description: The Franklin Templeton of Canada uses an application called

SMS (Share Holder Management System) built on AS400 to manage the fund

transaction of their shared shoulder. When ever New Fund released in the

Canadian market the corresponding new code and back end files are updated

in the system.

DEV Roles & Responsibilities:

. Updating the data base tables with new recordings according to the

Fund Fact sheets.

. Running Daily batches.

QA Roles & Responsibilities:

. Involved in developing Test cases

. Execution of the Test Cases, Test scripts and generating Reports.

. Reporting bugs in Defect management tool (Quality center).

. Coordinated with others to install and test on different

configurations

. Worked closely with Development teams to resolve the issues

. Verification of the defects against stable builds

Achievements:

> Lead for Risk Base Testing Process analysis and Implementation.

> Received applause awards thrice for my performance in various

projects.

Roles & Responsibilities:

Role: Lead

. Understand the Risk management process following in the IT industry

. Conducted an internal survey on Risk management

. Identified the loopholes in the existing process

. Explored the popular models of Risk based Testing models which can

help in rebuilding a better process

. Involved in brainstorm sessions while sharing the Risk based Testing

model with the team

. Designed the Risk assessment templates after collecting feed back from

the available sources

. Identified different parameters and criteria needed to consider for

assigning the rank for each risk factor

Personal Details:

Father Name : S.Chittiyya

Date of Birth : 21st April 1983

Gender : Male

Known Languages : English, Hindi, Telugu, Tamil

Contact this candidate