Management Data

Purnima Gottipati

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

Cell: 312-***-****

Executive Summary

. 8 + years of extensive Quality Analyst & Lead experience in data

warehouse testing, manual and automated testing of Web, client/server and

different relational databases.

. Good functional knowledge and extensive testing experience in Retail,

Real Time Trading and Financial Industry.

. Experience with Trading and Financial projects related to Asset

Management, CCARS, MDM & Basel.

. Good knowledge of Comprehensive Capital Analysis & Reporting (CCAR) and

Capital Planning

. Expertise in MDM (Master data Management). Implemented test strategies to

test different services available through MDM.

. Experienced in business knowledge of Credit Data Warehouse, Capital

Calculation and Reporting (BASEL).

. Extensively worked with business users to understand requirements and

prepared RTM (Requirement traceability Matrix).

. Worked on Test Reports and Defect analysis sheet preparations

. Expertise working on Offshore-Onsite model and worked as team lead for

different work streams.

. Earned reputation for meeting demanding deadlines and delivering critical

solutions on various levels of Quality Assurance.

. Specialized in writing Test Plans, Test Strategy, Test Scripts, Test

cases, Test designs and creation of Test data.

. Highly skilled in documenting the Test Metrics, Defect analysis reports

and Coordinated between IT and UAT team during UAT Testing.

. Good experience in QA Methodologies like Software Development Life Cycle

(SDLC).

. Diversified experience in testing Client Server, Web based applications

and C++, .Net and JAVA designed systems.

. Excellent experience doing backend testing using SQL Server, Oracle,

Sybase, Teradata & Netezza.

. Profound knowledge of web services testing using Service Oriented

Architecture tools SOAP UI.

. Extensive experience in Functional Testing, Database Testing, System

Testing, Regression Testing, Smoke Testing, compatibility Testing, Black

box testing and creation of test cases for User Acceptance Testing(UAT) .

. A self and quick learner and can learn new technologies very fast.

Relevant Experience

. Skilled in UNIX / Perl scripting for automation.

. Worked with various technologies such as DB2, SQL Server, Oracle, Sybase,

TeraData, and Flat Files, MDM.

. Proficient in Microsoft Excel, Word for documenting test documents and

defects tracking reports.

. Familiarity with Java, .Net, XML.

. Worked in extensive agile methodology projects.

Certifications and Training

. Designing and Implementing Databases with Microsoft Sql Server 2000

. Developing and Implementing Windows-based Applications with Microsoft

Visual basic.NET and Microsoft Visual Studio.NET (Microsoft Certified

Professional MCP ID # 3641940)

. Soft skills training from C&K Management Hyderabad

. Technical Training Programme from CMC Limited Hyderabad

Project Experience

BMO Financial Group Chicago, IL

Work Stream Test lead.

Comprehensive Capital Analysis & Reporting (CCAR) and Capital Planning

Aug 12 - Present

The Federal Reserve has issued a statement regarding its capital

assessments and stress testing information collection form FR Y-14. This

statement proposes revision of its information collection, effective

September 30, 2012, to expand and enhance the data items previously

selected. It also proposes a new reporting schedule to summarize the

information from the collected data. The proposal includes Annual (FR Y-

14A), Quarterly (FR Y-14Q), and Monthly (FR Y-14M) data collection and

schedules.

BMO Financial Corp Consolidated (BFC) is one amongst the bank holding

companies' (BHC's) that are required to participate in CCAR 2013 and as a

consequence to submit the information collection report FR Y-14 on an

annual, quarterly and monthly basis. CCARS project will provide data

extracts to the Firm-Wide Stress Testing (FWST) initiative to support the

FR Y-14A requirements.

Responsibilities

. Validating the CCARS data model to meet the high level business/test

requirements of FRY and Stress test tables

. Validating the ETL specifications to meet the business/test

requirements

. Preparing ETL test cases in Quality Center Test Plan

. Preparing End to End ETL Test cases from Source to Landing, Staging

and FRY14 and Stress tables.

. Creation of data files, query files for the test cases

. Assign the work stream tasks to resources and responsible for on time

completion of test results reports.

. Executing the ETL test cases and SQL test scripts in Quality Center

Test Lab

. Addressing any testing issues faced by the test team. This includes

test data, business requirements and non-functional aspects

. Performing Functional/Integration testing (ETL)

. Execution of reconciliation reports for FRY outbound.

. Coordinate the test manager for Commercial work stream for daily

status call and defect calls

. Adopting the test cases for change requests.

. Performed quick smoke test for counts and balances during code

migrations.

. Participate in Process Improvement efforts.

. Developing of Functional Automation scripts

. Participation in Monthly and weekly status reporting.

. Participate in requirement Analysis meeting with Business Analysts

Environments: Quality Center10, Aginity Workbench for Netezza

3.0.791.17119, Excel

BMO Financial Group Chicago, IL

UAT Lead

Asset Management, U.S and Canada, Portfolio Accounting Jan 12

- July 12

Portfolio accounting project in the U.S. is to migrate and convert M&I's

(IMC), Harris (HIM) and BMO Canada Asset Management legacy current

Portfolio Accounting and Investment Performance Measurement systems to

single SimCorp Dimension (SCD) application, along with integrating overall

business processes, procedures and workflows. The SimCorp Dimension system

platform will be an ASP solution (not BMO Harris-hosted), and will include

all key Investment Operations, Portfolio Accounting and Performance

Measurement functional modules to meet the business needs.

SimCorp Dimension (SCD) is an integrated, single database, investment

management system that provides intelligent and customized workflows across

the entire organization through Straight-Through-Process.

Responsibilities

. Coordinates LOB, BAs, EI, SCD, 3rd Party Vendor and other resources

in testing

. Following ISO and CMMI standards approached the testing for IMC

release.

. Review and provide input to the Test Strategy and Test Plans

. Identify technical risks and dependencies and assisted with Test

Calendar creation

. Planning, Organizing and leading Testing and Point of

coordination/contact for test execution

. Based on 'Detailed Requirement Specification' (DRS) document prepared

test cases.

. Writing and executing SIT and UAT test cases and attended SIT/QAT,

UAT, Performance, End to End, and Parallel kick off meetings.

. Involved in smoke testing, Functional testing (includes executing and

writing positive test cases and negative test case).

. Used Quality Center as a test case management tool and for

traceability matrix.

. Based on the Business Scenario's created test bed, to validate the

test cases.

. Interacted with business users( LOB's) and responsible for preparing

test data for entering MacGregor XIP equity trades in to different

portfolios in SCD (portfolio accounting system).

. Responsible for testing the batch job process from Macgregor OMS to

SCD and Reconciliation with different custodians to portfolio

accounting system.

. Assigned severity and priority while opening the issues found during

the testing.

. Retested and resolved incidents/issues that are assigned for

verification before closing or reassigned to development team.

. Logged, tracked and reported incidents found in all testing phases

through Quality center. Participated and provide input into daily

status meetings, attended weekly project meetings and all major test

gate meetings.

. Provide input for Share Point folder structure, and store test

results, test cases/scripts, business scenarios and Traceability

Matrix on SharePoint

Environments: Quality Center10, SimCorp 5.1, .Net, Macgregor XIP, Bloomberg

AIM, IDC, Excel

The Northern Trust Bank, Chicago, IL

Nov 10 -Dec 11

Lead / Test Coordinator

Client & Account Master Data Management (CADS-MDM)

CADS-MDM project focuses on building and installing a foundational

infrastructure that would provide a single point of truth for core client

and account data. IBM's Info Sphere - Master Data Management solution will

be installed, configured and deployed as this single point of truth or

master data management server. Northern Trust client and account data that

are shared and used by several of the applications, given this solution,

will acquire access to the master data from a single source.

Feeding into this core data management database will be client and

account information coming from various source applications across the

business areas like Banking,Trust,Mutual Funds & Brokerage.Data originating

from these source systems/applications will go through ETL processing via

IIS - Data Stage and Quality Stage which will apply appropriate business

logic and matching rules to the incoming data. The output of this ETL

processing will be customer data that has been aggregated and/or

transformed which will then be loaded into MDM where the data is stored as

master data - the single point of truth of customer and account

information. MDM also provides a Data Steward UI, where the data steward

can review and collapse the data.

Responsibilities:

. Involved in business requirement meetings and planning to estimate the

requirements and scope of testing.

. Defined the technological scope needed for testing the MDM

functionalities and Services.

. Worked with the Test Manger for creating the Test Strategy by

providing the inputs in regard to technical aspects.

. Created Test plan and was part of resource hiring and task

allocations.

. Defined test approach for each module and effectively involved in End

to End system testing requirements.

. Verified all the tools required and quick learner in using the IVT

processor and Messaging Queue clients.

. Worked on the MDM core functionality test scripts - validation of data

flow to master record through MDM services.

. As a team lead / coordinator reviewed the test scripts and test

approaches of the team and provided inputs required.

. Had overall expertise on each module as a part of coordination and

point of contact for test team.

. Mocking of sample Xml files to call MDM web services for validating

the output through response Xml's & Notifications.

. Performed manual and automated test procedures for functional testing

of Web services using SoapUI.

. Used Quality center for Test scripts and defect rising.

. Played key role in getting the tasks delivered on time. Conducted

requirements walkthrough meetings for test team, review of test

scripts and delivered the Test Result Summary for Drop runs.

Environment: Rapid SQL 7.3.3, Linux, Share Point, IBM Info Sphere

Information Server (Data stage 8.5/7.5), Quality Stage / MDM, XML

validator,Soap UI, Messaging Queue Client, DSUI, Quality Center.

The Northern Trust Bank, Chicago, IL

Apr 09 - Nov 10

Senior QA Analyst / Coordinator

Basel II Project

The purpose of Basel II is to create an international Standard that banking

regulators can use when creating regulations about how much capital banks

need to put aside to guard against the types of financial and operational

risks banks face.

Northern Trust (NT) is required to adopt the Basel II advanced approaches.

In doing so NT had implemented a rigorous methodology for assessing,

monitoring and reporting its credit risk.

According to regulators in spite of Northern Trust's exceptional asset

quality over the years and very strong credit culture its management

information process lacks transparency and adequate controls. The Basel II

regulations require that we create a system of stronger risk measurement,

management and reporting.

The objective of the project is to provide a controlled, automated,

centralized IT architecture database where Basel II credit risk regulatory

capital is derived from data source system extracts which feed to a

calculation (and reporting) engine which calculates and reports regulatory

capital .The end result is a consistent, timely, accurate, and automated

mechanism that provides the required data with appropriate control,

governance and integrity.

Responsibilities:

. Involved in gathering requirements, participated in activities for

defining the scope of testing.

. Resource allocation and co-ordination of requirements walkthroughs

between data analyst and QA team.

. Prepared Requirement Traceability Matrix (RTM).

. Developed and executed automated report templates like Drop report,

Error report with SQL scripts.

. Co-orientated between different work streams - Data warehouse team,

ULEI, Reporting & Algo for creation of the integrated test scripts.

. Have driven the team for better test approaches and appropriate tools

to be used like beyond compare, compare templates etc.

. Involved in testing the data in System Test, System Integration, UAT

environments.

. Wrote SQL queries to validate the output of the Reports using Rapid

SQL.

. Logged defects using Mercury Quality Center and played key role in

coordinating with the dev team in trouble-shooting, for quicker

turnaround time on defect resolutions.

. Performed offshore coordination and Test result update Report

summarization.

. Played key role in gathering the Test Results from various streams and

prepared consolidated Test Reports and assisted the Program Test

Manager.

. Co-ordinate with the UAT team members during script preparation and

execution. Played internal coordinator role between the IT test team

and UAT test team.

. Worked for different releases and gathered appropriate Test results

from each Release to the next and worked on the approved change

request (Defects) from one release to another.

. Key-role in SIT and UAT role and participated in Production kick-off

meetings as a

Test Co-coordinator.

Environment: Oracle, UNIX, Mercury Quality Center, Rapid SQL 7.3.3, Share

Point, Business Objects XI R2/6, Beyond Compare 3.1.3, IBM Info Sphere

Information Server (Data stage 8.5/7.5)

McDonald's, Oakbrook, IL

Mar 07 - Feb 09

Senior QA Analyst

Marketing Analytics System 1.5/1.6

The Marketing Analytics System will edit/validate and cleanse daily Point

of Sales (POS) data received from McDonald's stores around the world. The

cleansed data will be sent back to McDonald's Global Data Warehouse on

daily basis for reporting purposes. On a weekly basis, the Marketing

Analytics system will process the daily POS data accumulated for the

current week. The weekly processing will aggregate the daily POS data and

then apply baseline calculations along with other A Nielsen fact and

subtotal calculations. The enhanced sales data will then be sent to

McDonald's Global Data Warehouse on a Country-by-Country basis. This system

is intended to handle POS data from all of McDonald's stores data.

Several Operational reports will be developed for monitoring the Marketing

Analytics system. This includes Exception reports as well as Service Level

Agreements (SLA) reports. Exception Notifications will be forwarded to the

appropriate departments for analysis and resolution of the issues.

Transaction Details Analysis (TDA)

Understanding McDonalds customers' purchase patterns will help set product

priorities (choose between potential launches, advertising, merchandising,

pricing) and identify opportunities for building sales (average check) and

profit. To achieve this TDA needs insight of Transaction details to examine

the behavior of the customer visiting a McDonald's restaurant during the

day. Therefore the Business Insight departments of France and Europe

develop a system to be able to do this analysis i.e. TDA.

Responsibilities:

. I was responsible for cooperating the company's Process Department in

QA Activities.

. As a QA Analyst involved in Analyzing Business and System Requirements

and performed all the activities and deliverables.

. Preparation of System Test Plan, Test cases, Bug reports etc.

. Prepare Quality documentation and attend Project meetings with

Developers & BAs.

. Supporting the Implementation and Support department in resolving the

issues at client end.

. Take active part in Track Review meeting with the Development Lead and

BA's.

. Perform End-To-End testing with developers based on deadlines.

. Developed UNIX shell scripts for extracting and formatting data from

the output for manual testing.

. Executed shell scripts to run the ETL jobs and also for Archival of

test files.

. Run Perl scripts to test data accuracy and find file mismatch.

. Development & Execution of queries to validate the data flow to the

target table.

. Validated in UNIX the File archival process.

. Perform Functional Testing, regression testing MA 1.5/1.6 and TDA.

. Managed the testing process, schedule batch tests, log and track

defects using Quality Center.

. Quick test on the resolved issues and updating the Defect database for

tracking purposes.

Environment: Java, J2ee, Accentual Data Stage Enterprise Edition,

TeraData, Oracle 9i/8i, PL/SQL, UNIX, Rational Clear Quest, Micro strategy.

Quality center 9.1

.

Sierra Atlantic Software Services Ltd. Lisle, IL

Mar 04 - Jan 07

QA Analyst & Tester

Nshore Project Management Tool

Sierra is A ERP based company .The product Nshore a project management tool

with features like workflows, deliverable driven projects, extended

resource management, multi-site project management, multi-level

organization structure, invoicing, portfolio management, earned value

management. All the process management can be handled within the product

and is easily accessible web application with highly secured features.

Responsibilities

. Analyzed systems design specifications and developed test plans, test

cases to cover overall quality assurance testing

. Played co-ordination role for defects tracking between test team and

development team.

. Involved in both manual and automated testing. Performed black box

testing including smoke, regression, integration and functional

testing.

. Performed web test using Quickest Pro for checking page contents,

broken links, web objects, frames and tables. Parameterize the scripts

to run the scripts using varying form data

. Initiate, coordinate and implement the QA Process and SOA

Methodologies.

. Used Test Director for Defect Tracking and Test Management.

. Involved in verification and validating the test cases/scripts.

. Performed Regression testing using QTP and Performance testing using

Load Runner.

. Performed load testing using Load Runner and measured the response

time under peak load conditions.

. Extensively used Quality center, for test planning, bug tracking and

reporting

. To review the test results by validating the web services output in

XML.

Environment: SQL server 2000, c-sharp, VB.NET, ADO.NET, ASP.NET, Java,

Web Services, WSDL, XML, Windows NT, Virtual Network Computing, Quality

center .

Education

Bachelors of Computer application

Masters in Information Technology (M S I T), National Institute Of

Technology (REC) Warangal, India.

Technologies

ETL Tool : IBM InfoSphere Information Server, Micro

strategy, Informatica.

OLAP Tools : Business Objects 4.1/5.0/5.1

Programming : Java (1.2), J2ee, Visual Basic 5.0/6.0, SQL, PL/SQL,

Basic, HTML, DHTML

Scripting : TSL, UNIX Shell Script, Java Script, VBScript, Perl

script

Databases : Oracle 7.X/8.0/8i/9i, SQL Server 6.5/7.0, DB2 UDB,

Teradata, MS-SQL Server

2000, MS-Access, Sybase

GUI Tools : Toad, Rapid SQL, PL SQL Developer 5.0.1 and Microsoft

SQL Enterprise Manager.

OS : Win 98/ NT/2000/XP, MS-DOS, UNIX, Linux

Testing Tools : QuickTestPro8.0/8.2, SOAP UI (Web Services), HP

Quality Center 9.1

Web Technologies: Web Services, WSDL, ASP.net, XML

Contact this candidate