Data Warehouse Quality Assurance
Resume:
TATIANA KADOMTSEVA
*** ******* **., *********, **, V2A 7Z6
Phone: cell 416-***-****
E-mail: ***********@*****.***
PROFESSIONAL HIGHLIGHTS
22+ 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, BAT/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)
Producing test results reports, providing feedback during test plans with peers, and troubleshooting/ analyzing experience
A dedicated team player with a proven track record of hitting deadlines; strong verbal, written communication, interpersonal and negotiation skills
TECHNICAL SKILLS
OPERATING SYSTEMS:
Microsoft Windows 7/ XP/Vista/ 2000/NT/98/95, Mainframe TSO, Novell, UNIX, Nonstop TACL
RELATIONAL DATABASE MANAGEMENT SYSTEMS:
MS SQL Server 6.5/ 7/ 2000, MS SQL Server Management Studio 2008/ 2012/2014, MS Access, 97/ 2000, Oracle 9/10, DB2, SYBASE, TOAD, Universal SQL Editor, AQT
QA MANAGEMENT and AUTOMATED TESTING TOOLS:
HP Quality Center (9, 10, 11), ALM 11/12, ClearQuest, JIRA, TITUS, Microsoft Azure DevOps
BUSINESS APPLICATIONS AND COMMUNICATION TOOLS:
MS Office XP/2000,2010, People Soft 7.5, Informatica Cloud, Ab Initio, Data Stage, Stibo-STEP 7.0, MS Project, SharePoint, Lotus Notes, Clear Case, UltraEdit, MicroStrategy 9, WebFocus 7.6.5
PROGRAMMING LANGUAGES:
T-SQL, Visual Basic 6, JCL, HTML
PROFESSIONAL EXPERIENCE
MCAP (Paradigm Quest), Toronto
BI Enterprise Data Warehouse, Mortgage application management; migration to new environment
QA Consultant
Feb 2020 – April 2024
January 2018—November 2018
Develop test plans and test cases that meet project objectives and user’s expectation.
Participating in Sprint planning sessions and daily Scrums
Design test cases to test migration of data into new application
Read XML files to confirm correct logic of business was applied.
Data validation with SQL including validating test cases and managing test data
Defect management, daily reports producing, test plan development reviews.
Stakeholders engaged during this project to review requirements.
Testing of WEB portals for brokers and customers
Determine appropriate test coverage using a risk-based approach.
Test case results presented and analyzed via screen shots and table dumps.
Support production environment
Technical Environment: Windows 10, JIRA, SQL Server Management Studio 17.3, XML, DevOps, RUBI, Microsoft Azure DevOps
FIS Global, Toronto
Mutual Funds Management for CIBC, RBC, BMO
QA Analyst
November 2018-January 2020
April 2017- December 2017
Participating in Sprint planning sessions and daily Scrums
Work (lead) with offshore team
Implement test plans for assigned testing areas and test cases
Run batch jobs in UNIX to load or extract data from flat files to Data Base
Create test data using XML files
Create test cases with TSQL - to retrieve data for testing after ETL, execute test cases
API testing
Determine appropriate test coverage using a risk-based approach
Test case results presented and analyzed via screen shots and table dumps
Defects tracking in JIRA
Technical Environment: Windows 7/10, UNIX, SYBASE, XML, SQL, JIRA, Clear Case, TITUS
Manulife, Toronto
Valuation System Transformation project with Cloud Based Architecture and Data Warehouse
QA Analyst
January 2016—December 2016
Project Description: Valuation System Transformation project, with Cloud Based Architecture, and Data Warehouse to establish an optimized, consistent and streamlined valuation environment with an aim to provide more reliable and robust core reporting.
Requirements and test plan walkthroughs -carrying out static testing
Implement test plans for assigned testing areas including maintenance of test cases
Mask data – run SSIS packages with SQL to mask and unmask data
Create test cases with complex SQL statements (joins, multiple conditions, functions) to retrieve
data for testing after ETL
Determine appropriate test coverage using a risk-based approach with team lead
Test case results presented and analyzed via screen shots and table dumps
Run INFORMATICA CLOUD jobs to populate tables
Data validation with SQL including validating test cases and managing test data
Test data created using the application under test, SQL, and automation tools
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Technical Environment: Windows 7, SQL Server 2012/2014, Data Warehousing, Informatica Cloud, HP AML, Data Governance, ERWIN
QAC (QA Consultants), Toronto
Source, Toyota Canada
QA Consultant
May 2015 – December 2015
Project Description: New Web project to implement a partnership between Toyota Canada and Aeroplan
Participating in Sprint planning sessions and defining acceptance criteria
Develop and Implement test plans for assigned testing areas including maintenance of test cases
Perform Functionality Testing-all the links in web pages, database connection, forms used in the web pages
Perform usability testing, cookie testing, interface, compatibility and security testing
Create SQL statements to retrieve and test data after ETL process including validating test cases and managing test data
Estimation of testing efforts
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
BAT testing based on business scenario
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Testing of SSRS reports
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Defect management with ALM, generation of daily defect report
Technical Environment: Windows 7, SQL Server Management Studio, Excel 2013, SQL, ALM, SharePoint, Web Services, Jmeter
WOLSELEY, Ontario
COTS Project
QA Consultant
January 2015 –April 2015
Project Description: 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.
participating in Sprint planning sessions and defining acceptance criteria
Implementing test plans for assigned testing areas including maintenance of test cases during an agile project
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Technical 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
SIT Project
QA Consultant
December 2013 – December 2014
Project Description: Senior Income Testing – HNS Individual deductibles
Liaising with business users and developers to analyze business and technical requirements
Develop test plans and test cases that meet project objectives and user’s expectation
Define data requirements, create data, design and execute test cases based on ‘Use case’ specification
Run Nonstop TACL batches to update DB tables
Create SQL statements to retrieve and test data, including validating test cases and managing test data
Testing of reports generated with WebFocus
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Non-functional testing
BAT test plan development and testing of reports using business users scenario
Defect management in QC and QlearQuest
Technical Environment: Windows 7, ALM-HP Quality Center 11, IBM Rational QlearQuest, SQL-AQT, DB2, TACL- NonStop, WebFocus, ER studio
BMO (ADASTRA), Toronto
BI Enterprise Data Warehouse
QA Consultant
April 2013 – October 2013
Project Description: LRM project: Data transition from Data Acquisition layer of EDW to SAP BA.
Liaising with business users and technical people to analyze requirements
Implement test plans for assigned testing areas including maintenance of test cases
Define data requirements for testing, create data (if required), develop test cases
Code implementation in QA server, shell scripts execution to split vector files to serial files and load data into DB2 tables
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
BAT test plan development, assist end users in BAT testing, defect investigation
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Create SQL statements to retrieve and test data
Verification of business and transformation rules through data migration from EDW to SAP objects
Technical Environment: Windows 7, ALM 10, SQL-AQT, DB2, UNIX, Ab Initio
CCO - Cancer Care Ontario, Toronto
BI Enterprise Data Warehouse
QA Consultant
January 2013—March 2013
Project Description: Testing of MicroStrategy9 reports
Develop test plans and test cases that meet project objectives and user’s expectation
Create SQL statements to retrieve and test data
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
BAT -Functional verification of business and transformation rules in Front End applications
Technical Environment: Windows 7, HP Quality Center 10, SQL Server 2008, TOAD, MicroStrategy9, JIRA
SCOTIA BANK, Toronto
Personal Line of Credit
QA Analyst
October 2011—May 2012
Project Description: 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
Liaising with Business users and technical people to analyze requirements for ETL
Define data cleansing requirements
Create test strategies, define test approach and guidelines for testing process
Develop test plans and test cases that meet project objectives and user’s expectation
Create SQL statements to retrieve and test data
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
SSRS reports testing
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Functional verification of business and transformation rules through data migration
Attend project meetings to report on status of testing, communicate issues, implement QA standards and policies and communicate QA schedule
Technical Environment: Windows 2000/XP, UNIX, DB2, Universal SQL Editor, UltraEdit, HP Quality Center 10, Informatica, Lotus Notes, QTP
CIBC, Toronto
Wholesale Banking Technology, Risk Strategic Initiative project
QA Team Lead
June 2010—September 2011
Project Description: testing of financial derivatives (XML files) from different trading systems (WSS, Optex, Murex, XTrader, Calypso) send to SUNGARD
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
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Risk data aggregation and internal risk reporting
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Attend project meetings to report on status of testing, communicate issues, implement QA standards and policies, and communicate QA schedule
Technical Environment: Windows 2000/XP, SQL 8, Excel 2003, SQL 8, QTP, HP Quality Center 11
Capital Markets Risk Management,
BI Projects: Incremental Risk Charge Standardized Calculation, Simple Securitized Products Standardized Calculation, Market Data for Enhanced Risk Measures
Worked closely with Market Data Management team to select data for BAT 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
Risk data aggregation and internal risk reporting
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 business users
Technical Environment: Windows 2000/XP, SQL 8, Excel 2003, HP Quality Center 10
PWC / BMO, Toronto
Online Brokerage (Nesbitt Burns)
QA Analyst
February 2010—May 2010
Project Description: Retail portfolio management system – application for managing financial portfolio and online trading
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
participating in Sprint planning sessions and defining acceptance criteria
creating and executing test plans for assigned testing areas including maintenance of test cases during an agile project
Testing of GUI for Portfolio asset allocation page, index and equity research pages, orders placement
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
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 closed
Technical Environment: Windows 2000/XP, HP Quality Center 10, SQL, QTP, Toad, Oracle 10g, Java
INTACT (ING), Toronto - P&C Insurance
BI Enterprise Data Warehouse ETL
Senior QA Analyst
July 2007 – November 2009
Project Description: BI Enterprise Data Warehouse
Developed test plans and business test cases that meet project objectives and user’s expectation
participating in Sprint planning sessions and defining acceptance criteria for performance reports testing
Created SQL statements to retrieve and test data after migration
Logged 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 reports
Conducted defect meetings and meetings with audit people
Data Warehouse feeds to Insurance Bureau Canada
Replacement of old mainframe source systems with the new one with Data Warehouse as the source
Integration of Operational Data Store (HUB) and Enterprise Data Warehouse (EDW) as two components of the central repository
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Testing of SSRS reports
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
The focus of testing is integrated functionality for Upload/Download data transfers, ETL, data mapping, functional verification of the business and transformation rules through data migration, data validation
The tools for Extract, Transformation and Load (ETL) are Oracle PL/SQL and Informatica
Liaising with Business users and technical people to analyze 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
Technical Environment: Windows 2000/XP, SQL, Toad for Oracle 9.6.1.1, Rational ClearQuest, Lotus Notes, Oracle 10g, Informatica, Java
CIBC, Toronto
Online Brokerage
Senior QA Analyst
September 2006 – June 2007
Project Description: New additional functionalities for Web based Brokerage applications
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)
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Bug tracking with EMPIRIX e-Manager Enterprise and Mercury Quality Center 9
Providing leadership support and training for the younger team members
Environment: Windows 2000/XP/Vista, Java, Mainframe -ADP, Internet Explorer, Empiric e-Manager Enterprise 8, Mercury Quality Center 9
MONERIS SOLUTIONS, Toronto
NABE BI conversion Project
QA Analyst
May 2006—August 2006
Project Description: 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).
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)
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Data validation, log and retesting of defects encountered during the testing process
Technical Environment: Windows XP, UNIX, MS SQL 2000, Mercury Quality Center 9, WebFocus reports
PERIMETER FINANCIAL, Toronto
ABACUS ENHANCEMENT PROJECT
QA Analyst
January 2006—April 2006
Project Description: New additional functionalities in Web based application for financial derivatives and trading room activities
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
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Technical Environment: Windows XP, Internet Explorer, BugZilla 2.1.6.3, Java
HEWITT, Toronto
ANNUAL TAX REPORTING PROJECT
BA/QA Analyst
August 2005—December 2005
Project Description: Tax adjustments for the different pension plans of HOOPP employees
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
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Technical Environment: Windows XP, Mainframe TSO, JCL, DB2, SQL, Crystal Reports; Lotus Notes
HOOPP’s, Toronto
DATA CONVERSION PROJECT (ETL)
Senior QA Analyst
April 2005—July 2005
Project Description: BI Conversion of old database currently residing in the mainframe system to the new SQL environment
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)
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Data validation, log and retesting of defects encountered during the testing process (TestDirector)
Technical Environment: Windows 2000, MS SQL 2000, TestDirector 7.6
CIBC, Toronto
Portfolio Management System Conversion Projects
Test Analyst
January 2003—March 2005
Project Description: 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).
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
Defect management, daily reports producing, and consulted with peers to provide feedback during test plan reviews
Stakeholders engaged during this project to review requirements
Test data created using the application under test, SQL, and automation tools
Data validation with SQL including validating test cases and managing test data
Test case results presented and analyzed via screen shots and table dumps
Determine appropriate test coverage using a risk-based approach with team lead
Assisted project lead with defect management including problem resolution, identification of impact/severity and recommendations on deferral
Supervision for intermediate testers
Technical Environment: Windows 2000, Mainframe, DB2, MS SQL Server 2000; PortfolioPlus, FI, RMS; Empiric e-Manager Enterprise 8
Customer Information System,
Test Analyst
CUSTOMER INFORMATION EXCHANGE ENHANCEMENT PROJECT – New additional functionalities in Customer Information Management System
Preparation of input files and execution of business functional test cases on Mainframe and trough CIE Test Tool 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
Technical Environment: Windows 2000/NT;
Contact this candidate