Sireesha Kondamuri

Ph: 804-***-****

Email:abl26m@r.postjobfree.com

. Having 14 years of experience in IT industry out of which 12 years of

experience in Data Warehousing environment. Has domain expertise in

Health Care, Finance, Sales, and Insurance & Mortgage. Extensive Project

Management experience, Project Management methodologies ( Agile,

KANBAN&SDLC) and project Integration. Worked extensively on ETL and Data

Modeling Tools. Well-versed with CMM Level 5 Quality processes.

EDUCATIONAL QUALIFICATION

Title of the Degree College/University Year of Passing

with Branch

B.Tech Computers Sri Venkateswara 1998

Science University, Tirupati

TECHNICAL SKILLS

Title Skill

Hardware IBM ES-3090, Pentium IV

Operating Systems UNIX, MVS/ESA, MS-Windows 95/NT/XPs, DOS

Languages PL/SQL, VB 6.0, C, C++, Java, SQL, COBOL, CICS,

JCL

Databases Oracle, MS-Access, DB2,Tera Data, VSAM

GUI Visual Basic 6.0, Developer 6.0,Flex

Case Tools Erwin

Tools & Utilities Data Warehousing Tools(Informatica, Data stage,

Cognos ), $Universe, Control-M,Mercury Quality

Center, Alliance Remedy, VSS, TOAD, MF-Revolve

2000, MKS,LIVE LINK, Putty, SSH,PVCS, Project

Status Tracker(PST),CLARITY, Clear Case, JIRA

Domain Knowledge Health Care, Finance, Sales, Insurance&

Mortgage

KNOWLEDGE

. SCRUM MASTER Certified(SCM) professional.

. ITIL FOUNDATION Certified in IT Service Management.

. ITIL INTERMEDIATE Certified in IT Service Operations.

. PMP Education Certified from PROXALT which is a Global R.E.P. of PMI.

. Certified on GEGDC Governance Program with 87% score.

. Trained on Digital Enterprise Solutions.

. Extensive knowledge in the design of a wide range of systems.

. Thorough knowledge of the principles and practices of System

Development Methodologies.

. Hands-on experience in managing large-scale systems and setting up

teams to accomplish the needs of process reengineering.

. Extensive business analysis and advanced business analysis skills to

satisfy the business needs of the user.

. Experienced in project presentation and documentation to all levels

of management.

. Detailed knowledge of AGILE & KANBAN methodologies.

. Implemented KANBAN Agile RTS Model in GE-Corporate Account.

. Hands-on experience with relational database management systems.

. Hands-on experience with Six Sigma Processes implementation

. Good Exposure in executing Basel II Compliance programs

. Hands-on experience with PMI's PMBOK Processes.

. Hands-on experience in using Project Status Tracker (PST) and CLARITY

as a project portfolio management tool.

. Project Management experience with SEI's Capability Maturity Model

(CMM) level 3.

. Extensive Project Management experience, Project Management

methodology and project Integration.

. Experience insetting up PMOs and Project Management processes and

best practices.

. Experience in Release Management Processes

. Comprehensive experience in the complete system development life cycle

methodology (SDLC).

. Excellent oral and written communication skills.

WORK EXPERIENCE:

Client International Finance

Corporation (IFC) - World

Bank Group, D.C, U.S.A

Company Tata America International

Corporation (TCS)

Role Project Manager

Duration May '14- Till Date

Client GE Corporate, CT, U.S.A

Company Tech Mahindra

Role Project Manager

Duration Oct '13- Mar '14

Client I3 Solutions

Company LogicaTech Inc, VA, U.S.A

Role Project Manager

Duration Jan '09 - Mar '12

Client HTSE, U.K

Company HSBC Global Technology

Role Project Leader/Project Manager

Duration Apr '08 - Sep '08

Client CISCO Systems, Inc., CA, U.S.A

Company Satyam Computer Services Ltd. / Cognizant

Technology Solutions

Role Project Leader/Project Manager/Informatica Administrator

Duration Jul'05 -Mar'08

Client GE Home Finance, St.Paul, Minnesota, U.S.A

Company Satyam Computer Services Ltd

Role Informatica Administrator

Duration Mar'05 -Jun '05

Client CREDIT SUISSE FIRST BOSTON, New York, U.S.A

Company Satyam Computer Services Ltd

Role Developer

Duration Oct'04 -Feb '05

Client GE-Power Systems, Schenectady, U.S.A

Company Satyam Computer Services Ltd

Role Data Modeler / Project Leader

Duration Oct'03 - Sep '04

Client Venkateswara Hatcheries

Company Data Matrix Solutions

Role DBA/DATA WAREHOUSE consultant

Duration Jun'02 - Jul'03

Client Aetna Inc.

Company Data Matrix Solutions

Role DBA/DATA WAREHOUSE consultant

Duration Apr '01-May '02

Client American International Group Inc., NC, USA

Company Data Matrix Solutions

Role S/W Consultant

Duration Sep '00 to Feb '01

Client TESCO-U.K.

Company Data Matrix Solutions

Role Developer

Duration Dec '99-Aug '00

Client CRS INFO Pvt. Ltd.

Company Data Matrix Solutions

Role Developer

Duration Feb '99 - Nov'99

PROJECT DETAILS:

12. Project Name :Advisory Services Operational

Portal(ASOP)

Client International Finance Corporation-WORLD BANK

Group

Role Project Manager

Duration May '14 - Till Date

Team Size Project Team size :17

Environment Java, Flex, Oracle, Informatica, JIRA,

Remedy, CLARITY

PROJECT DESCRIPTION:

IFC supports private sector development both by investing and by providing

advisory services. Much of IFC's advisory services work is conducted

through Regional / BLL staff managed by IFC but funded through a

combination of IFC and partnerships with donor governments and other

multilateral institutions. IFC's advisory services have been managed by

their regional/BLL resources and their advisory work is organized into four

business lines: Access to Finance (Integrated Budgeting and Information

Solutions-IBIS), Investment Climate, Public-Private Partnerships

Transaction Advisory and Sustainable Business Advisory. The lifecycle of an

Advisory Services Project consists of various stages such as Concept

Development, Pre-implementation, Implementation (Preparation),

Implementation (Execution), Implementation (Completion), Post

Implementation.

ROLES AND RESPONSIBILITIES IN A PROJECT:

. Preparation of SOW,Project Estimation and Project Management Plans

of both ASOP and IBIS Developmental and Support Activities.

. Implemented to follow Project Management process groups across the

whole life cycle of the project.

. Risk assessment and management, problem solving, personnel

supervision, change management.

. Conducting weekly status discussions with clients and Business Team.

. Defects tracking thru JIRA tool.

. Perform Integrated Change Control.

. Implemented Approved Changes.

. Problem Management including Incidents management reporting and

follow up.

. Responsible for managing Release Processes.

. Maintaining all the Quality Process Documentation in Centralized

location - Clear Case.

. Responsible to share the ASOP & IBIS Applications Support metrics on

monthly and quarterly basis to measure the efficiency.

. Responsible to share the ASOP & IBIS Weekly Status Report with the

client.

. Responsible to take care of monthly billing and invoices of the

entire team.

. Resource Management Activities.

11. Project Name :GE CORP DW-RTS

Client GE CORPORATE

Role Project Manager

Duration Oct '13 - Mar '14

Team Size Project Team size :12

Environment Informatica, Unix, Oracle, PUTTY

PROJECT DESCRIPTION:

GE Corporate is the central business of GE for all corporate decision taken

in terms of finance and procurement of goods and services for all GE

Businesses. GE Transportation, Shared Services, Energy Management and

Release Management are some of the groups existing in

GE Corporate. GE Shared services are currently maintaining several data

marts related to their businesses. Currently they are running applications

on 9.1.0 Informatica with HF6. BICOE Informatica Admin team provides 24*7

on call support for all Production activities and for any planned or

unplanned environment outage support activities for all environments. The

OIC team engages the Informatica admin team through the escalation matrix

shared by the Informatica admin team for the on call support availability.

ROLES AND RESPONSIBILITIES IN A PROJECT:

. Preparation of Production Support Implementation plan.

. Involving in Incident Management, Release Management, Change

Management and Configuration Management.

. Responsible for Risk Management and Issue Management.

. Implemented KANBAN AGILE RTS production support Model.

. Conducting Weekly Status discussions with the client.

. Publishing the Weekly Status Report to all the Project Stakeholders

on

Weekly-basis.

. Maintaining all the Quality Process documentation in GE-Libraries.

. Generating the metrics and reports thru ticketing tool GE Service-

Now.

. Responsible for implementing Tech-Upgrade across all the GE Corp

Environments such as Transportation, Shared Services and Energy

Management.

. Responsible for implementing OS Level Upgrade across all the GE Corp

environments such as Transportation, Shared Services and Energy

Management.

. Responsible for migrating the Oracle DB on Exadata.

. Implementation of using Reusable Components such as Query Tool while

migrating the INFA objects from one environment into another

environment.

. Responsible for autogenerated metrics by scheduling a code to

execute daily in

GE-Corp environment which gives a deep details like CPU summary,

Load Average and Memory utilized on the UNIX machines where

Informatica is configured. This report helps the Business to

estimate the allocations on up coming projects/smooth delivery of

the existing code with out any hops on the servers.

10. Project Name : Logicatech Datawarehouse

Client I3 Solutions

Role Project Manager

Duration Jan '09- Mar '12

Team Size Project Team size :15

Environment Informatica, Unix, Oracle, MKS, PUTTY,SQL

Server

PROJECT DESCRIPTION:

Logicatech Datawarehouse is a system where it stores the consolidated

information of Healthcare, Finance and Policies Administration.

Logicatech is having conformed dimensions like Employee, Department and

Calendar dimensions. Healthcare Datamart provides access to data to

proactively identify patterns and trends associated with employee illness

to assist the business in mitigating expense associate with health care

expenditures and time away from work. Finance Data which is present in

Logicatech facilitates Finance users to report payroll data by employee

wise. Policies Administration is the revamping of their existing policy

administration application. The old application had evolved in bits and

pieces to accommodate companies acquired by Financial Assurance. The new

web application is a secure B2C web-application developed keeping in mind

future expansion. The customers can access their detailed policy

information using the application. It is also used by the agents and their

managers to access policy details of their clients. A back-end job receives

the regular data feeds from various legacy mainframe systems which get

processed and stored in the SQL Server database to be accessed by the

application.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

. Preparation of Project Estimation and Project Management Plans

. Involved in all phases of project life cycle including Requirement

Analysis, Design, Coding and testing.

. Followed Agile Methodolgy and played one of the roles as Scrum

Master.

. Followed Project Management process groups across the whole life

cycle of the project.

. Risk assessment and management, problem solving, personnel

supervision, change management.

. Perform unit testing and functional testing.

. Detailed peer review of each and every phase.

. Conducting weekly status discussions with client.

. Defects tracking thru Quality Center.

. Perform Integrated Change Control.

. Implemented Approved Changes.

. Problem Management including Incidents management reporting and

follow up.

. Responsible for managing Release Processes.

. Driving Defect Prevention meetings.

. Maintaining all the Quality Process Documentation in Centralized

system called MKS.

. Project Scheduling and Tracking the progress

9. Project Name : U.K. Data Warehouse

Client HTSE(HSBC Technology Services Europe)

Role Project Leader/Project Manager

Duration Apr '08 - Sep '08

Team Size Project Team size :7

Environment Data stage, Unix, DB2,MKS,PUTTY

PROJECT DESCRIPTION:

The objective of Mortgage data mart is to provide improved access to

mortgage information within the warehouse and provide a single source

of the truth that will enable tier 2 reporting via Cognos query studio

a new mortgage Datamart will be developed. PLM is the primary source

system for Mortgage Data Mart.

Basel2 GCDM:

A revised Accord (Basel II), and complementary European Directive

which will form the basis for implementation in the UK, are planned to

come into effect from 31st December 2006. It provides for alternative

methodologies of varying sophistication for the calculation of credit risk

related capital requirements, and requires that the methodologies adopted

be aligned to the management of that business. The Group Limits, Exposure

and Activity Management (GLEAM) system, which is part of the Credit and

Financial Systems-Strategic Development Programmed (CFS-SDP), will deliver

the requirements of the Basel II accord in respect of credit risk

exposures. The project team is involved in preparation/amendment of the MIF

(Monthly Interface File) to be sent to GCDM (Gleam Credit Data Mart).

ROLES AND RESPONSIBILITIES IN THE PROJECT:

. Preparation of Project Estimation Plans

. Preparation of Project Plan

. Involved in all phases of project life cycle including Requirement

Analysis, Design, Coding and testing.

. Detailed peer review of each and every phase

. Conducting weekly status discussions with client

. Defects tracking thru Quality Center

. Problem Management including Incidents management reporting and

follow up

. Driving Defect Prevention meetings among the whole 30 members team in

ensuring the code implementation with Zero defects free

. Maintaining all the Quality Process Documentation in Centralized

system called MKS

8. Project Name : Informatica Upgradation from

7.1.2 version to 8.1.1 version

Client Linksys, A division of CISCO Systems,

Inc.,CA,U.S.A

Role Project Leader /Project Manager/Informatica

Administrator

Duration Aug '2007 - Mar'2008

Team Size Project Team size :2

Environment Informatica 7.1,Unix,Oracle,LIVE LINK,

Mercury Quality Center

PROJECT DESCRIPTION:

LDW integration platform upgraded from Informatica power center 7.1.2 to

8.1.1 SP4 version within the schedule and it's driven from offshore.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

. Analyze the current version of informatica 7.1.2 installation set up

. Design the detailed steps to upgrade to informatica 8.1.1

. Preparation of Project Plan

. Involved in all phases of project life cycle including Requirement

Analysis, Design, Coding and testing.

. Responsible for Capacity Management for the upgradation.

. Leading the INFRA team in implementing the tasks

. Perform unit testing and functional testing

. Detailed review of each and every activity

. Install 8.1.1 client binaries

. Apply service pack SP4

. Creating accounts on Informatica 8.1.1 repository and granting the

suitable privileges

. Administer Folders

. Responsible for upgradation Service Level Agreements

. Acted as a steward for the upgraded platform

. Problem Management including Incidents management reporting and

follow up

. Responsible for managing the Release processes such as Plan, Build,

Test,Prepare & Deploy

. Mentoring the team

. Maintaining all the Quality Process Documentation in Centralized

system called LIVELINK

7. Project Name : LINKSYS DATA WAREHOUSE

Client Linksys, A division of CISCO Systems,

Inc.,CA, U.S.A

Role Project Leader /Project Manager

Duration Feb '2006 - Aug '2007

Team Size Project :9

Environment Informatica 7.1,Seibel Analytics, Unix,

Oracle, PL/SQL,LIVE LINK, $Universe,

MercuryQualityCenter, TOAD, PUTTY,SSH

PROJECT DESCRIPTION:

Linksys Datawarehouse is a system where it stores the consolidated

information of finance, Sales, Forecast and Consumer. LDW is having

conformed dimensions like Product, Customer and time dimensions which

consists of information about Linksys products, customer and calendar.

Finance Data which is present in LDW facilitates Finance users to report

base margin data by customer, product and time and to report summary data

by Sales Channel/ Theatre /Customer, Product Group/BU/SKU and Receivables

and Inventory (Detail).Forecast Data facilitates users to report the

Forecasting data by customer, product SKU, Organization and Day levels. It

captures the Actual and forecast fact with granularity at SKU, Organization

and Day level. Sales data facilitates sales users to report the sales data

by customer, product and time.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

. Understanding the requirements

. Involved in all phases of the project life cycle including

Requirement Analysis, Design, Coding and testing.

. Performing Unit Testing & Functional Testing.

. Migration of ETLobjects from DEV to UAT and UAT to PROD environments.

. Maintaining both development and production environments

. Monitoring the production runs and resolving the issues (if any)

. Preparing the required change in architecture level initiative

documents for implementation by Infra team

. Performing the impact analysis at ETL level in LDW if any changes

going to take place in database level

. Responsible for Incident management across the LDW integrated platform

. Responsible for Data management across the LDW integrated platform

. Responsible for managing the Release processes such as

Plan,Build,Test,Prepare and Deploy

. Conducting Phase wise review/local governance meetings

. Responsible for representing the team in Customer Governance Meetings

. Maintaining all the Quality Process Documentation in Centralized

system called LIVELINK

. Implementation of LINKSYS POC on $universe tool by interacting with $U

team.

. Mentoring the team.

6. Project Name : EDW-Marketing

Client CISCO Systems, Inc., CA,USA

Role Project Leader

Duration Jul'2005 -Jan'2006

Team Size Project :4

Environment PL/SQL,BO,UNIX,LIVE LINK,TOAD

PROJECT DESCRIPTION:

EDW-Marketing is an application which campaigns about the CISCO Products

through City Tours and Webinars. It stores about contacts information that

are showing interesting in buying the CISCO Products .Worked on the

enhancement activities such as

Integrating Marketing Universe layer for US Campaign information and

EMEA/APAC/JAPAN to provide a robust reporting for Campaign effectiveness.

To Design a new measure to determine number of new contacts for Key code or

a Program as part of its response.

To provide a metric to identify the dispersion of the responses within a

Seminar venue.

Enriching the Contact Dimension by adding Job Title Class to the existing

Dimension at the aggregate layer level of Seminar & EMEA Modules

ROLES AND RESPONSIBILITIES IN THE PROJECT:

. Analyzing of Existing system for new proposed changes.

. Designing the Data Architecture for New Measures.

. Extraction, Transforming & Loading the data through PL/SQL Procedures

and Packages.

. Migrating the Packages from Dev Environment to Test Environment.

. Unit Testing & Functional Testing.

. Providing Support to Production Team in fixing the Post Production

Issues.

. Created UProcs in Dollar Universe ($U) Environment.

. Maintaining the entire version controlled Documents in PVCS

(Configuration Management Tool).

. Creating all the Quality Process Documentation and maintaining in LIVE

LINK through which globally all the users can access.

. Internally maintaining all the Quality Process Documents

. Attending Weekly Status Meetings to present the current status of

Project to PM.

. Capturing the Quality Metrics & Project Management Index (PMI)

Metrics.

. Presenting QMS Presentation on Monthly Basis.

. Mentoring the Team Members in order to deliver the tasks within the

schedule.

. Conducting the Phase wise Review Meetings

. Responsible for preparation of Data Migration/Release document for the

Release into Production environment

. Approving, Invoicing and Confirming the Marketing Team Members Time

Sheets through Time Sheet Management System Tool

5. Project Name : GE Home Finance

Client GE Home Finance, St.Paul, Minnesota, U.S.A

Role Informatica Administrator

Duration Mar'2005 -June '2005

Team Size Project :4

Environment Informatica 7.1, SQL Server, Toad, Oracle

9i, UNIX, WS-FTP pro.

PROJECT DESCRIPTION:

GE Home Finance is a leading well branded Firm which provides Mortgages.

Mortgage Flex System is one of the systems which contains the information

about Funded, Withdrawn and denied applications

ROLES AND RESPONSIBILITIES IN THE PROJECT:

. Interacting with Users and understanding the requirements

. Preparation of Technical Design documents.

. Involved in Design and development of application.

. Involved in Unit Testing and Debugging.

. Involved in UAT.

. Involved in implementation of the application

. Responsible for preparation of Data Migration/Release document for the

Release into Production environment

. Testing the Processes in Production Environment.

. Resolving Production Issues.

4.

Client CREDIT SUISSE FIRST BOSTON, New York, U.S.A

Role Developer

Duration Oct'2004 -Feb '2005

Team Size Project :6

Environment Informatica, Toad, Control-M, Oracle 9i, UNIX

PROJECT DESCRIPTION:

Credit Suisse First Boston (CSFB) is a leading global investment bank

serving institutional, corporate, government and high net worth clients.

It's a base business unit of Zurich based, Credit-Suisse group a leading

global financial services company.

CSFB has undertaken the Opera initiative that makes sure that CSFB complies

with the BASEL II accord for Risk Management by the year 2005. Opera is a

system that would enable data to be shared globally and that is flexible

enough to take on new areas of business and be able to respond to changing

customer needs. This Project involves the extraction of data from different

systems of CSFB like Prime Brokerage System, Mortgages, New York Open

Trades, OTC Trades, Securities; and then cleansing / transforming the data

andloading it into a common database system called Opera from which the

Business Managers would be able to generate reports. Data is collected on a

daily basis from the CSFB systems across the world and is processed at the

New York location.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

. Gathering the requirements

. Preparation of Design documents.

. Involved in Design and development of application.

. Involved in Validation of the data with respect to requirements.

. Involved in UAT

. Involved in implementation of the application

. Responsible for preparation of Data Migration/Release document for the

Release into Production environment

. Involved with Production Support team in resolving the tickets.

3. Project Name : EP Finance-Gas Turbines Gen2

Client GE-Power Systems,Schenectady, U.S.A

Role Data Modeler / Project Leader

Duration Feb'2004 - Sep'2004

Team Size Project :3

Environment ERWIN, Informatica, BO, Toad, Oracle 9i

PROJECT DESCRIPTION:

EP-Finance Gas Turbines Data Ware House is to provide the Inventory Finance

team with the ability to easily work/sort/drilldown/report on various

financial metrics: inventory balances and make-up, material variances, and

material and labor input, to name a few. The objective also includes

providing information relative to the physical inventory reconciliation and

analysis that will provide a more concise reconciliation and reduce the

cycle time. Current methods do not provide a rapid 'snap shot' capability.

Meeting this objective would allow Inventory Finance to better answer

management's requests.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

. Coming up with folder creations based on number of data marts.

. Coming up with reusable transformations.

. Coming up with reusable mapplets.

. Coming up with reusable stored procedures.

. Came up with performance standards.

. Template creation for volume testing as well as for functionality

testing.

Effective Client Communication

. Requirement Analysis

. Translation of Requirements into technical specification

. Logical & Physical Design of Data Model.

. Responsible for preparation of Data Migration/Release document for the

Release into Production environment

2. Project Name : Health Care Data Mart

Client GE-Power Systems, Schenectady, U.S.A

Role Data Modeler/ ETL Designer/Project Leader

Duration Oct'2003 - Feb'2004

Team Size Project :7

Environment ERWIN, Informatica, BO, Toad, Oracle 9i

PROJECT DESCRIPTION:

GEPS Health Care needs access to data to proactively identify patterns and

trends associated with employee illness to assist the business in

mitigating expense associate with health care expenditures and time away

from work.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Effective Client Communication

. Requirement Analysis

. Translation of Requirements into technical specification

. Logical & Physical Design of Data Model.

. Responsible for preparation of Data Migration/Release document for the

Release into Production environment

1.

Company Data Matrix Solutions

Role Developer/DBA/DATA WAREHOUSE consultant

Duration Feb 1999 -Jul 2003

Contact this candidate