TATIANA KADOMTSEVA

*** ****** **., # *** *****: cell 416-***-****

Toronto, ON, M4S 3H2 E-mail: abqhkt@r.postjobfree.com

OBJECTIVE

Position of QA Analyst

TECHNICAL SKILLS

OPERATING SYSTEMS: Microsoft Windows 7/ XP/Vista/ 2000/NT/98/95, Mainframe TSO,

Novell, UNIX, MS-DOS 6

RELATIONAL DATABASE MANAGEMENT SYSTEM:

MS SQL Server 6.5/ 7/ 2000, MS Access, 97/ 2000, Oracle 9/10,

DB2, TOAD, Universal SQL Editor

QA MANAGEMENT and AUTOMATED TESTING TOOLS:

HP Quality Center (9, 10, 11), ClearQuest, Merant, JIRA,

Empirix e-Manager 8, BugZilla 2.1.6.3, QTP 11, WinRunner 6.5/7

BUSINESS APPLICATIONS AND COMMUNICATION TOOLS:

MS Office XP/2000, People Soft 7.5, Informatica,WebSphere,

Lotus Notes, Clear Case, UltraEdit, COINS, CORE 3.4, IDEA

PROGRAMMING LANGUAGES: T-SQL, Visual Basic 6, JCL, HTML,C++,Visual Studio

WORK HISTORY

1. SCOTIA BANK, Toronto

Enterprise Data Warehouse QA Project Lead Oct 2011- May 2012

2. CIBC, Toronto

Wholesale Banking Technology QA Team Lead June 2010-Sept 2011

Capital Markets Risk Management QA Project Lead

3. PWC / BMO, Toronto QA Analyst Feb 2010- June 2010

Online Brokerage (Nesbitt Burns)

5. INTACT (ING), Toronto Senior QA Analyst June 2007 – Nov 2009

P&C Insurance /QA Project Lead

6. CIBC, Toronto

Online Brokerage Senior QA Analyst Sept 2006 – June 2007

7. MONERIS SOLUTIONS, Toronto QA/Developer May 2006-Aug 2006

8. PERIMETER FINANCIAL, Toronto BA/QA Analyst Jan 2006 - Apr 2006

9. HEWITT, Toronto BA/QA Analyst Aug 2005 - Dec 2005

10. HOOPP’s, Toronto Senior QA Analyst Apr 2005 - Jul 2005

11. CIBC, Toronto Test Analyst 2003-2005

Wealth Management Technology (Wood Gundy) Sep 2004 - Apr 2005

Customer Information System Feb 2004 - Jun 2004

Wealth Management Technology (RRSP) May 2003 - Dec 2003

Card Product Division Jan 2003 - May 2003

12. KPMG, Toronto Senior QA Analyst Jan 2001 - Nov 2002

HIGHLIGHTS OF QUALIFICATIONS

14 years of experience in testing Client-Server and Web based applicationsExtensive experience working with databases in conversion projects

in Data Warehouse environment (BI, ETL, Informatica)Extensive experience to analyze, define, and translate business and functional specifications into

testing requirementsDeep knowledge of Software Development Life Cycle (SDLC) and ability to apply correct

testing methodology and techniques to different cycles of testing (SIT, Regression, UAT)Experience with agile/ iterative software development life cycle methodologiesExtensive experience in creating of test artifacts such as Test Plans/Strategy, test scripts and Test reportsStrong ability to set up priorities, manage and coordinate end to end testing activities for small

and large projectsProven Quality Assurance experience working on large-scale financial projects, which

involved working with a 3rd party vendor (CGI, SUNGARD)

EXPERIENCE

SCOTIA BANK, Toronto October 2011-May 2012

Enterprise Data Warehouse

Unsecured Scotiabank Personal Line of Credit-acquire the required data from host mainframe systems,

transform and load them into Data Marts tables(Staging layer – Integration layer- Access layer)

EXPERIAN -back end testing and implementation of new SAS software for reports from Equifax

Environment: Windows 2000/XP,UNIX, DB2, Universal SQL Editor, UltraEdit, HP Quality Center 10,

Informatica, Lotus Notes

RESPONSIBILITIES

Liaising with Business users and technical people to analyse requirements for ETL Define data cleansing requirementsCreate test strategies, define test approach and guidelines for testing process Develop test plans and test cases that meet project objectives and user’s expectationCreate SQL statements to retrieve and test data Functional verification of business and transformation rules through data migrationAttend project meetings to report on status of testing, communicate issues, implement

QA standards and policies and communicate QA schedule

CIBC, Toronto

Wholesale Banking Technology March 2011-September 2011

Risk Strategic Initiative project – testing of feeds (financial derivatives) from different trading systems

(WSS, Optex, Murex, XTrader, Calypso) send to SUNGARD

Environment: Windows 2000/XP, SQL 8, Excel 2003, SQL 8,QTP, HP Quality Center 11

RESPONSIBILITIES Identify the test strategy, test approach and guidelines for testing process of different feedsCreate test plans and test scenario to meet project objectives

Estimation of testing efforts and assigning responsibilities for teamDefect management with HP QC, generation of daily defect report, lead daily defect meetingSupervision for 5 junior and intermediate testersAttend project meetings to report on status of testing, communicate issues, implement

QA standards and policies, and communicate QA schedule

CIBC, Toronto

Capital Markets Risk Management June 2010-Jan 2011

BI

Projects: Incremental Risk Charge Standardized Calculation,

Simple Securitized Products Standardized Calculation,

Market Data for Enhanced Risk Measures

Environment: Windows 2000/XP, SQL 8, Excel 2003, HP Quality Center 10

RESPONSIBILITIES Worked closely with Market Data Management team to select data for UAT testingIdentified the test strategy, test approach and guidelines for testing process based on business documentationCreated test plans to meet project objectivesCreated business test cases, created and ran SQL queries to check correct calculations

of Incremental Risk, Securitized Products calculations and issued warnings according business logic and rules Logged identified defects into HP quality Center and followed up to insure defects are fixed and can be closed, provided test completion reports Attend project meetings to report on status of testing, communicate issues, implement QA standards and policies, and communicate QA scheduleProvided test matrixes and test completion reports Generated daily reports for Incremental Risk Charge Calculation, analyzed numbers using Excel Pivot tables, distributed results among business usersCreated operational manuals to describe full process from data selection till report analysis for end users

PWC / BMO, Toronto Feb 2010- June 2010

Nesbitt Burns

Retail portfolio management system – application for managing financial portfolio and online trading

Environment: Windows 2000/XP, HP Quality Center, SQL, QTP, Toad, Oracle 10g, Java

RESPONSIBILITIES Worked closely with Business Analysts and developers to analyze gaps in business requirements and update existing test cases for regression cycle after new components were implementedTesting of GUI for Portfolio asset allocation page, index and equity research pages, orders placementVerified Lipper’s information for Mutual funds at the back end - created and ran SQL queries in TOADLogged identified defects into HP quality Center and followed up to insure defects are fixed and can be closed

INTACT (ING), Toronto July 2007 – November, 2009

Property and casualty (P&C) insurance

BI

Data Warehouse feed to Insurance Bureau Canada

The focus of testing is integrated functionality for Upload/Download data transfers, formats,

data mapping and business/harmonization rules, functional verification of the business and

transformation rules through data migration.

OPUS

Replacement of old mainframe Claim systems with the new one as source for Data Warehouse

The tools for Extract, Transformation and Load (ETL) are Oracle PL/SQL and Informatica

Broker Performance Reports

to replace existing mainframe source for Broker Performance Reports with

Data Warehouse as the source

Policy and Premiums project

The project to integrate Operational Data Store (HUB) and Enterprise Data Warehouse (EDW) as two components of the central repository .

HUB databases are used for storing all transactional data from online systems and

creating operational reports. EDW is populated for creating analytical data marts.

The tools for Extract, Transformation and Load (ETL) are Oracle PL/SQL and Informatica.

Environment: Windows 2000/XP, SQL, Toad for Oracle 9.6.1.1, Rational ClearQuest,

Lotus Notes, Oracle 10g, Informatica, Java

RESPONSIBILITIES

Liaising with Business users and technical people to analyse requirements for replacement of old

mainframe system with the new one as a data source Worked closely with Business analysts to analyze data harmonization rules through data migration and to define data cleansing requirementsAnalyzed requirements for replacement of the multiple sources of reporting to external organizations and internal business units with Data Warehouse as the sourceIdentified the test strategy and test approach, guidelines for testing process Developed test plans and business test cases that meet project objectives and user’s expectationCreated SQL statements to retrieve and test data after migrationLogged defects identified by team (4-5 people) into ClearQuest and followed up to insure defects are fixed and can be closed (defect coordination), created Defect reportsConducted defect meetings and meetings with audit peopleSupervision for team from 4-5 people

CIBC, Toronto

Internet Channel Technology - Online Brokerage, Portfolio Management

September 2006 – July 2007

New additional functionalities for Web based Brokerage applications

Environment: Windows 2000/XP/Vista, Java, Mainframe -ADP, Internet Explorer,

Empirix e-Manager Enterprise 8, Mercury Quality Center 9

RESPONSIBILITIESDevelopment of System Integration test plan for new release, determine test data requirements and

resource estimates for brokerage front end applicationPreparation of test scripts and perform functional, non-functional and regression test execution Data validation in ADP (Back Office) and online verification of correct informationBrowser testing (different combinations of browsers and OS)Bug tracking with EMPIRIX e-Manager Enterprise and Mercury Quality Center 9Providing leadership support and training for the younger team members

MONERIS SOLUTIONS, Toronto May 2006 – August 2006

QA Analyst /Developer

NABE BI conversion PROJECT – the implementation of new North American backend system (NABE)

for processing of debit and credit RBC cards transactions (daily and monthly loads)

and replacement of current Moneris data mart databases sourced

from existing backend systems with a single Moneris Data Mart (MDM).

Environment: Windows XP, UNIX, MS SQL 2000; Mercury Quality Center 9

RESPONSIBILITIES Setup of QA environment in SQL server – create tables, create and execute stored procedures to populate tables (daily and monthly loads), develop scripts to validate data (SIT and regression testing)Creating of test documentation (data mapping, test cases, traceability matrix)Data validation, log and retesting of defects encountered during the testing process

PERIMETER FINANCIAL Inc., Toronto January 2006 – April 2006

ABACUS ENHANCEMENT PROJECT – New additional functionalities in Web based

application for financial derivatives and trading room activities

Environment: Windows XP, Internet Explorer, BugZilla 2.1.6.3, Java

RESPONSIBILITIES Development of test plan and test cases (SIT, Regression, UAT cycles)Testing of business functionality and usability, performance load/stress and benchmarking testing

HEWITT, Toronto August 2005- December 2005

ANNUAL TAX REPORTING PROJECT – Tax adjustments for the different pension plans of HOOPP employees

Environment: Windows XP, Mainframe TSO, JCL, DB2, SQL, Crystal Reports; Lotus Notes

RESPONSIBILITIES Development of business test matrix to validate real results against expected according business requirements

Creating of test plans and test scenario, testing of TAX reports

HOOPP’s (Hospitals of Ontario Pension Plans), Toronto April 2005 –July 2005

DATA CONVERSION PROJECT (ETL) -BI

Conversion of old database currently residing in the mainframe system

to the new SQL environment

Environment: Windows 2000, MS SQL 2000; TestDirector 7.6

RESPONSIBILITIES Development and execution of test scripts– SQL queries- according new business rules to verify

correct transformation and load of old data to the new database (Regression, UAT)Data validation, log and retesting of defects encountered during the testing process (TestDirector)

CIBC, Toronto

Wood Gundy (Wealth Management Technology) September 2004 – April 2005

PORTFOLIO MANAGEMENT SYSTEM CONVERSION PROJECT –

Conversion of Financial Indicator (FI) and Relationship Management System

(RMS) portfolio data (shares and bonds) currently residing in the 2 different databases (DB2)

to the new Portfolio Management system consolidated SQL

Contact this candidate