Documentation

TATIANA KADOMTSEVA

*** ****** **., # ***, *******, ON, M4S 3H2

Phone: cell 416-***-****

E-mail: ***********@*****.***

OBJECTIVE

QA Position

TECHNICAL SKILLS

OPERATING SYSTEMS:

Microsoft Windows 7/ XP/Vista/ 2000/NT/98/95, Mainframe TSO, Novell, UNIX, Ab Initio, Nonstop TACL

RELATIONAL DATABASE MANAGEMENT SYSTEMS:

MS SQL Server 6.5/ 7/ 2000, MS Access, 97/ 2000, Oracle 9/10, DB2, TOAD, Universal SQL Editor, AQT

QA MANAGEMENT and AUTOMATED TESTING TOOLS:

HP Quality Center (9, 10, 11), ALM, ClearQuest, Merant, JIRA, Empirix e-Manager 8, BugZilla 2.1.6.3, WinRunner 6.5/7

BUSINESS APPLICATIONS AND COMMUNICATION TOOLS:

MS Office XP/2000, People Soft 7.5, Informatica, Data Stage, Stibo-STEP 7.0, MS Project, SharePoint, Lotus Notes, Clear Case, UltraEdit, COINS, CORE 3.4, MicroStrategy 9, WebFocus 7.6.5

PROGRAMMING LANGUAGES:

T-SQL, Visual Basic 6, JCL, HTML, C++, COBOL

WORK HISTORY

WOLSELEY, ON

QA Consultant Jan 2015 – April 2015

MOHLTC, Kingston/

TELUS Health for MOHLTC, Toronto

QA Consultant Dec 2013 – Dec 2014

BMO, Toronto

Information Management, QA Consultant

April 2013 –Oct 2013

CCO - Cancer Care Ontario, Toronto

QA Consultant Feb 2013- March 2013

SCOTIA BANK, Toronto

Enterprise Data Warehouse, QA Project Team Lead Oct 2011-May 2012

CIBC, Toronto

Wholesale Banking Technology, QA Team Lead June 2010-Sept 2011

Capital Markets Risk Management, QA Project Lead

PWC / BMO, Toronto

Senior QA Analyst Feb 2010-June 2010

Online Brokerage (Nesbitt Burns)

INTACT (ING), Toronto

P&C Insurance, QA Project Team Lead July 2007 - Sept 2009

CIBC, Toronto

Online Brokerage, Senior QA Analyst Sept 2006 – June 2007

MONERIS SOLUTIONS, Toronto

QA/Developer May 2006-Aug 2006

PERIMETER FINANCIAL, Toronto

BA/QA Analyst Jan 2006 - Apr 2006

HEWITT, Toronto

BA/QA Analyst Aug 2005 - Dec 2005

HOOPP’s, Toronto

Senior QA Analyst Apr 2005 - Jul 2005

CIBC, Toronto2003-2005

Wealth Management Technology (Wood Gundy), Test Analyst Aug 2004 - Apr 2005

Customer Information System, Test Analyst Jan 2004 - Jun 2004

Wealth Management Technology (RRSP), Test Analyst May 2003 - Dec 2003

Card Product Division, Test Analyst Jan 2003 - May 2003

KPMG, Toronto

Senior QA Analyst Jan 2001 - Nov 2002

HIGHLIGHTS OF QUALIFICATIONS

14+ years of experience in testing Client-Server and Web based applications

Extensive experience working with databases in conversion projects in Data Warehouse environment (BI-ETL)

Extensive experience in analyzing, defining, and translating business and functional specifications into testing requirements

Deep knowledge of SDLC, PLMC and ability to apply correct testing methodology and techniques to different cycles of testing (SIT, Regression, UAT); experience in an Agile environment

Experience with test analysis, creating test status and defect status reports

Extensive experience in creating of test artifacts such as Test Plans/Strategy, test scripts and Test reports

Strong ability to set priorities, manage and coordinate end to end testing activities for small and large projects

Proven Quality Assurance experience working on large-scale financial projects, which involved working with a 3rd party vendor (CGI, SUNGARD)

EXPERIENCE

WOLSELEY, Ontario

QA Consultant Jan 2015 –April 2015

Project to integrate new IT technologies and Commercial off The Shelf (COTS) 3rd party solutions – to replace Referential Data Management (RDM) from Mainframe to STIBO/STEP with automated ETL process with Data Stage.

RESPONSIBILITIES

Define data requirements for testing, create data, design and execute test cases

Create use cases, develop and maintain test specifications, test cases, test scripts and test data

Perform SIT testing

Perform testing of customized STIBO functionality –update, create, delete objects, verification of correct process in RDM, data validation

Create SQL statements to retrieve and test data after ETL process

Environment: Windows 7, Main Frame AS 400, COBOL, Stibo-STEP MDM 7.0, Data Stage, Jira, SQL-AQT, DB2, SharePoint

MOHLTC, Kingston/

TELUS Health, Toronto

QA Consultant Dec 2013 –Dec 2014

Project to replace Senior Copayment Program with new one based on MOHLTC and MOF requirements

RESPONSIBILITIES

• Liaising with business users and technical people to analyse business and technical requirements

• Run Nonstop TACL batches to update DB tables

Create test strategies, define test approach and guidelines for testing process

Define data requirements for testing, create data, design and execute test cases

Writing complex SQL queries to be used in testing

Testing of reports generated with WebFocus - to integrate new IT technologies and Commercial off The Shelf (COTS) 3rd party solutions

Track and prioritize defects, participate in release decisions and establish measures of test efficiency, effectiveness and product readiness (QC and QlearQuest)

Environment: Windows 7, ALM-HP Quality Center 11, QlearQuest, SQL-AQT, DB2, TACL- NonStop, COBOL,Clear Case, WebFocus

BMO, Toronto

Information Management April 2013 –Oct 2013

QA Consultant

BI Enterprise Data Warehouse - LRM project: Data transition from Data Acquisition layer of EDW to SAP BA.

RESPONSIBILITIES

• Liaising with business users and technical people to analyse requirements for ETL

Create test strategies, define test approach and guidelines for testing process

Create use cases, develop and maintain test specifications, test cases, test scripts and test data

Define data requirements for testing, create data (if required), develop test cases

Perform SIT testing

Code implementation in QA server, run butches, shell scripts execution to split vector files to serial files and load data into DB2 tables

Create complex SQL queries to be used in testing

Verification of business and transformation rules through data migration from EDW to SAP objects

track and prioritize defects, participate in release decisions and establish measures of test efficiency, effectiveness and product readiness

Environment: Windows 7, HP Quality Center 10, SQL-AQT, DB2, UNIX, Ab Initio, SharePoint, MicroStrategy9

CCO - Cancer Care Ontario, Toronto

QA Consultant Jan 2013- March 2013

BI Enterprise Data Warehouse

Testing of MicroStrategy9 reports –UAT

Project to integrate new IT technologies and Commercial off The Shelf (COTS) 3rd party solutions

RESPONSIBILITIES

Develop test plans and test cases that meet project objectives and user’s expectation

Create SQL statements to retrieve and test data

Functional verification of business and transformation rules in Front End applications

Environment: Windows 7, HP Quality Center 10, Oracle, TOAD, MicroStrategy9, Jira

SCOTIA BANK, Toronto

Enterprise Data Warehouse, QA Project Lead Oct 2011- May 2012

BI -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 -

Project to integrate new IT technologies and Commercial off The Shelf (COTS) 3rd party solutions

RESPONSIBILITIES

• Liaising with Business users and technical people to analyse requirements for ETL

Define data cleansing requirements

Create test strategies, define test approach and guidelines for testing process

Create use cases, develop and maintain test specifications, test cases, test scripts and test data

Develop test plans and test cases that meet project objectives and user’s expectation

Download EBCDIC files into UltraEdit to use for testing

Create complex SQL queries to be used in testing

Functional verification of business and transformation rules through data migration

Perform SIT testing

Attend project meetings to report on status of testing, communicate issues, implement QA standards and policies and communicate QA schedule

Support of UAT testing for business users

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

CIBC, Toronto

Wholesale Banking Technology, QA Team Lead June 2010-Sept 2011

Risk Strategic Initiative project – testing of feeds (financial derivatives) from different trading systems (WSS, Optex, Murex, XTrader, Calypso) send to SUNGARD

RESPONSIBILITIES

Identify the test strategy, test approach and guidelines for testing process of different feeds

Create test plans and test scenario to meet project objectives

Estimation of testing efforts and assigning responsibilities for team

Defect management with HP QC, generation of daily defect report, lead daily defect meeting

Supervision for 5 junior and intermediate testers

Attend project meetings to report on status of testing, communicate issues, implement QA standards and policies, and communicate QA schedule

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

Capital Markets Risk Management, QA Project Lead

BI

Projects: Incremental Risk Charge Standardized Calculation, Simple Securitized Products Standardized Calculation, Market Data for Enhanced Risk Measures –UAT cycle

RESPONSIBILITIES

Worked closely with Market Data Management team to select data for UAT testing

Identified the test strategy, test approach and guidelines for testing process based on business documentation

Created test plans to meet project objectives

Created 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 schedule

Provided test matrixes and test completion reports

Generated daily reports for Incremental Risk Charge Calculation, analyzed numbers using Excel Pivot tables, distributed results among business users

Created operational manuals to describe full process from data selection till report analysis for end users

Environment: Windows 2000/XP, Oracle, n-tier Java/Oracle environment,SQL 8, Excel 2003, HP Quality Center 10, SharePoint

PWC / BMO, Toronto

Online Brokerage (Nesbitt Burns), Senior QA Analyst Feb 2010- June2010

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

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 implemented

Testing of GUI for Portfolio asset allocation page, index and equity research pages, orders placement

Verified Lipper’s information for Mutual funds at the back end - created and ran SQL queries in TOAD

Logged identified defects into HP quality Center and followed up to insure defects are fixed and can be closed

UAT testing with business users

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

INTACT (ING), Toronto

P&C Insurance, Senior QA Analyst/ QA Project Lead July 2007 – Nov 2009

BI Enterprise Data Warehouse ETL

The focus of testing: ETL, data transfers, data feeds, data mapping, functional verification of the business and transformation rules through data migration, data validation, UAT

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 requirements

Analyzed requirements for replacement of the multiple sources of reporting to external organizations and internal business units with Data Warehouse as the source

Identified the test strategy and test approach, guidelines for testing process

Developed test plans and business test cases that meet project objectives and user’s expectation

Created SQL statements to retrieve and test data after migration

track and prioritize defects, participate in release decisions and establish measures of test efficiency, effectiveness and product readiness. Conducted defect meetings and meetings with audit people

Support of business users in UAT

Environment: Windows 2000/XP, SQL, Informatica, Java, n-tier Java/Oracle environment, Toad for Oracle 9.6.1.1, Rational ClearQuest, ClearCase, Lotus Notes, Oracle 10g

CIBC, Toronto

Online Brokerage, Senior QA Analyst Sept 2006 – June 2007

New additional functionalities for Web based Brokerage applications

RESPONSIBILITIES

Development of System Integration test plan for new release, determine test data requirements and resource estimates for brokerage front end application

Preparation of test scripts and perform functional, non-functional and regression test execution

Data validation in ADP (Back Office) and online verification of correct information

Browser testing (different combinations of browsers and OS)

Bug tracking with EMPIRIX e-Manager Enterprise and Mercury Quality Center 9

Providing leadership support and training for the younger team members

Environnent: Windows 2000/XP/Vista, Java, Mainframe -ADP, Internet Explorer, JIRA, Empirix e-Manager Enterprise 8, Mercury Quality Center 9, SharePoint

MONERIS SOLUTIONS, Toronto

QA/Developer May 2006-Aug 2006

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).

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

Environment: Windows XP, UNIX, Oracle, n-tier Java/Oracle environment, MS SQL 2000, Mercury Quality Center 9, Informatica

PERIMETER FINANCIAL, Toronto

BA/QA Analyst Jan 2006 - Apr 2006

ABACUS ENHANCEMENT PROJECT – New additional functionalities in Web based application for financial derivatives and trading room activities

RESPONSIBILITIES

Development of test plan and test cases (SIT, Regression, UAT cycles)

Testing of business functionality and usability, performance load/stress and benchmarking testing

Bug tracking in Bugzilla

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

HEWITT, Toronto

BA/QA Analyst Aug 2005 - Dec 2005

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

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

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

HOOPP’s, Toronto

Senior QA Analyst Apr 2005 - Jul 2005

DATA CONVERSION PROJECT (ETL) -BI

Conversion of old database currently residing in the mainframe system to the new SQL environment

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)

Environment: Windows 2000, MS SQL 2000, TestDirector 7.6 (now HPQC)

CIBC, Toronto 2003-2005

Wealth Management Technology (Wood Gundy), Test Analyst Sep 2004 - Apr 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 database environment with PortfolioPlus Web based front-end application (3rd party vendor – SUNGARD)-. Project to integrate new IT technologies and Commercial off The Shelf (COTS) 3rd party solutions

RESPONSIBILITIES

Development of detailed test plan and work schedule coordination (UAT)

Development and execution of SQL queries to verify correct data conversion

Data validation at the Back Office and online verification of accurate conversion

Preparation and execution of test scripts for different business scenario

Bug tracking with EMPIRIX e-Manager Enterprise

Supervision for intermediate testers

Environment: Windows 2000, Mainframe, DB2, MS SQL Server 2000; PortfolioPlus, FI, RMS; Empirix e-Manager Enterprise 8

Customer Information System, Test Analyst Feb 2004 - Jun 2004

CUSTOMER INFORMATION EXCHANGE and ENHANCEMENT PROJECT – New additional functionalities in Customer Information Management System

RESPONSIBILITIES

Preparation of input files and execution of business functional test cases on Mainframe to ensure correct business process (Regression, UAT)

Online validation of customer information in COINS along with verification of reply messages and batch reports

Bug tracking with BUG Collector (Web) and INFOMAN (Mainframe)

Supervision for coop students

Environment: Windows 2000/NT; Mainframe TSO, JCL, DB2; COINS, CIE Test Tool, BUG Collector

Wealth Management Technology (RRSP), Test Analyst May 2003 - Dec 2003

RRSP DATA CONVERSION PROJECT (ETL) -Conversion of RRSP data (DISA and GIC’s accounts) currently residing in the Mainframe to new database environment (3rd party vendor –CGI).

RESPONSIBILITIES

Development of business cross-reference test matrix to ensure full test coverage according requirements

Data validation and verification of accurate customer conversion along with associated plans and assets in CORE 3.4 against COINS

Bug tracking with Merant

Environment: Windows 2000/NT; Mainframe, TSO, DB2; CORE 3.4, COINS, IDEA, MERANT

Card Product Division, Test Analyst Jan 2003 - May 2003

DATA VALIDATION TESTING for Data Warehouse to ensure Data Marts contain correct data after conversion from mainframe to SQL Server–

-Development and execution of SQL statements, verification against source files on mainframe, bug tracking

Environment: Windows 2000/NT, Mainframe, TSO; MS SQL Server 2000, Oracle 9, MS Access 97/2000, Toad, TestDirector 7

KPMG, Toronto

Senior QA Analyst Jan 2001 - Nov 2002

PROJECTS:

PEAT-Commercial off The Shelf 3rd party solutions (COTS)– an integrated system built on combined

Web-based and client-server architecture with People Soft (version 7.5) and Oracle (8.1).

Budgeting and reporting - Financial reporting tool used to produce the Firm’s financial statements, and prepare various financial analyses using the Retrieve MS Excel functionality.

Environment: MS Windows NT/2000, Novell; MS Office 97/2000; People Soft 7.5, Citrix; Oracle 8.1, MS Access 97/2000, Visual Basic, HTML; Crystal Reports, WinRunner 7

EDUCATION

Certificate in Quality Assurance, “Information Technology Alliance Academy”, Toronto, 1999

Master in Geography, Moscow State University

REFERENCES: Available upon request.

Contact this candidate