Sign in

Test Cases Data

Vaughan, ON, Canada
March 27, 2018

Contact this candidate


Vladimir Shur

** ***** **** ****, **** ****, Thornhill ON, L4J 0A1, Canada


Objective: Positions as Senior QA/BA/ QA Lead

Highlights of Qualifications

Over 16 years’ in Business Analysis, Software Quality Assurance and Application Support experience

Experienced in developing systems test plans, test cases and test scripts, scheduling and resource planning

Experienced in business analysis, documenting functional/business requirements and writing use cases, based on information gathering sessions with clients/stakeholders and technical team members

Developed complete testing and business documentation and performed various types of testing: functional, non- functional, regression, integration, system and more.

Co-ordinated User Acceptance testing in the UAT environment for business users prior to Production stage.

Tested applications in Waterfall and Agile development processes

Experienced in creating appropriate test data and automated test scripts

Experienced in projects involves an online application designed for Portfolio management and Customer Access System for the end User

Led teams in QA Projects Testing Onsite /Offshore

Good knowledge and experience in Automation tools and Defect tracking tools

Hands on experience in databases, writing SQL queries, data manipulation

Knowledge and experience of all phases of the Software Development Life Cycle (SDLC)

Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing

Extensive experience with Financial, Health and Business Intelligence (Cognos BI) applications

Excellent analytical and problem-solving skills

Self-motivated team player with proven leadership skills

Technology Profile:

Testing Tools: HP QC/ALM, Jira, QTP/UFT, Silk, TFS, Rational ClearQuest, Test Complete and Loadrunner

Environment: WINDOWS, UNIX, SharePoint, MAINFRAME, XML, Web Services, HL7,

Team Foundation Server, SQL, C/C++, VBScript, Computer Aided Software Engineering (CASE) tools UNIX, Linux, ITIL, HTML, C#, JAVA, XML, NETSCAPE/ iPLANET, ASP, COGNOS BI Reports, SIEBEL CRM, MS-IIS, WebSphere Portal, APACHE, .NET, JCL, ETL, DATA WAREHOUSE Client/Server, MS Visio, MS PowerPoint

Databases: ORACLE, MS SQL Server, MS-Access, SYBASE, DB2, INFORMIX, MySQL

Employment History and Related Experience

Socan, Toronto ON

Senior QA/BA Analyst 03/2017-11/2017

Environment: MS SQL Server, ETL/Data Warehouse. Team Foundation Server (TFS),Cognos BI

Worked across multiple functional projects to understand data usage and implications for data migration.

Assisted in designing, planning and managing the data migration process.

Created Use Cases and Activity Diagrams thus defining the Business Process Model.

Performed source system data analysis to manage source to target data mapping.

Performed migration testing of data in source and target systems using SQL.

Autodata Solutions, London ON 08/2016-02/2017

QA Team Lead

Environment: ETL/Data Warehouse, Web Services, SQL Server, Jira, Dynamics CRM, SaaS, Azure, Mongo

Managed QA Onsite/Offshore QA team for various Autodata projects.

Coordinated meetings with Project Managers to understand projects schedules to set QA priorities.

Created QA estimates, Test Plans and Test Strategies.

Promoted to serve as lead QA tester, overseeing quality-assurance testing and teams for client software and systems development projects. Performed system, regression and data interface testing.

Managed test execution status for all phases in testing process and conducted knowledge transfer sessions.

Facilitated Defect Triage meeting. Informed senior management of risks / issues discovered while testing.

Lead the UAT effort and arrange/facilitate UAT testing sessions.

Ministry of Health and Long-Term Care, Toronto, Canada 09/2015-04/2016

Senior QA

Projects: Self Reporting Initiative (SRI), ItelliHealth (Data Migration)

Environment: ETL/ Data Warehouse/SQL, Cognos, Informatica, SharePoint, Oracle, Toad, Rational ClearQuest

Developed documentation for Ministry SRI and ItelliHealth (data migration) applications.

Developed complex SQL queries for querying data against different data bases for data validation.

Developed ETL test scripts based on technical specifications, design documents and data mappings.

Performed Dimensional and Statistical Analysis and Data Quality Validation in Data Migration.

Extensively tested various Cognos financial reports for data quality.

Cancer Care Ontario, Toronto Canada 11/2014-06/2015

Senior QA/BA Analyst

Project: Ontario Renal Reporting System (ORRS)

Environment: TFS, C#, SQL Server, Data Warehouse, Siebel CRM, DataStage, Agile

Created and executed test cases for various testing such as functional, system, regression, UAT and more.

Defined the processes and procedures required to ensure an acceptable level of application and clinical data. quality and worked well with the business / stakeholders and users to gather and prepare testing requirements.

Tested DataStage jobs for moving the data to multiple databases and transforming the data.

Created Test Strategy & Test Plans, prepared test data for a complete set of Test Cases.

Created SQL scripts and automated programs to verify reports and back end database of all pre-dialysis, acute dialysis and chronic dialysis patients in Ontario.

Reviewed Data Models and Business Requirements Definition (BRD) document for Renal Reporting System.


International Financial Data Services (IFDS), Toronto, ON Canada 09/2004-12/2005 & 06/2014-11/2014

Senior Quality Management Analyst/Business Analyst/Application Support

Project: iWeb plus

Environment: iFast, SharePoint, HP ALM/QC, HP QTP, API, XML, SQL, ETL, Soap UI, BI, Siebel CRM, Agile

Prepared business and testing documentation for Mutual and Segregated Funds complexity for Portfolio management and Customer Access System for the end User using iFast.

Created API XML requests and analyzed response files.

Coordinating the document controls of technical submittals, drawings.

Executed functional, non-functional, integration and regression testing. Logged defects and verified fixes.

Provided testing status report to the project.

Performed integration and implementation of application configuration changes.

Researched, analyzed, tested, debugged applications and provided support to clients.

Ministry of Education Ontario, Toronto ON 03/2014-06/2014

Senior IT Consultant

Environment: .Net, SharePoint, XML, SQL, Visio, HP QC, MS Project, QTP 10.0, COTS, Cognos BI

Project: Enhanced Data Collection.

Developed and documented business rules for Application (EDU) functionality.

Implemented the automation of new and existing testing scripts using Quick Test Pro.

Created used cases, test cases and test scenarios.

Performed functional, regression, performance and security testing and reported defects.

Tested and maintained software applications to ensure compliance with all provincial regulations.

Accenture, Toronto ON 11/2013-02/2014

HL7 integration Analyst/Coordinator

Environment: SharePoint, HL7, EHR, XML, MS SQL Server, .NET, BizTalk, TFS, Agile

Project: WRIS-Wait Time Information System for Cancer Care Ontario.

Provided input into test plan and approach.

Coordinated HL7 integration – prepared HL7 messages and interpreted response.

Manipulated data directly in a database using TSQL queries.

Created test cases, identified, triaged defects and verified defect fixes using TFS.

Tested the solutions in terms of functionality, performance, reliability, stability, documenting and communicating any issues or risks identified during testing.

Performed accessibility testing, used to test the application by different roles to test the access to different kinds of users for different modules/links in the application.

M&T Bank, Buffalo, NY, USA 04/2013-11/2013

Business Analyst/Application Support Analyst

Project: Banking Mobile Application

Environment: SharePoint, .NET, Microsoft CRM, Cognos BI, ETL, RUP, UML, SQL, QTP 10.0, MS PowerPoint

Gathered software and systems requirements from business owners and presented to development staff. The Projects involves an online application designed for Portfolio management and Customer Access System for the end User

Involved in the creation and maintenance of the business requirement documents and use cases.

Created Use-Case Models in various Business Processes.

Consistently provided application and system support for several internal departments.

Developed, coordinated, and maintained process mapping activities and documentation.

Created and executed manual and automated test cases and scripts for functional and non-functional testing, SIT, UAT and more

Coordinated the activities of an offshore development team.

Alberta Health Services, Calgary AB 01/2012-09/2012

Senior Quality Assurance Coordinator/Application Support Analyst

Environment: UNIX, HL7, EHR, Cognos BI, XML, COTS, ETL, Jira, Silk, HP QC/ QTP, MS Dynamics CRM

Project: Clinical Critical Care Information System

Coordinated smoke, security, integration, functional, system, regression, usability, user acceptance, release

testing and managed the defect lifecycle on Jira.

Dedicated in functional testing for MS Dynamics CRM and web-based applications.

Tested Portal Enhancements application integrated with COTS ministry applications.

Interacted with business, development, testing, and project management team.

Conducted risk analysis, verification and validation testing to confirm to industry and government regulations

Reviewed and supported Clinical Data testing process. Installed or deployed the CSC and CCCIS.

Created and updated test scripts for automation testing using Silk Test.

Supported in the entire software development life cycle.

Canadian Tire, Toronto ON 04/2011-10/2011

Senior QA/BA Analyst

Environment: Win 7, .NET, MS SQL Server, HP QC, ETL, DataWarehouse, BI Reports, SharePoint, Team Foundation Server, CASE, SQL, Siebel CRM, MS PowerPoint, POS, Rational ClearQuest, Agile

Project: Canadian Tire’s Loyalty Card Program for Retail stores

Worked in a test environment with a team of Developers, Business Analysts and QA testers.

Participated in gathering the system requirements for several releases of application.

Participated in Evaluation, Functional, Regression, Stress, Load, Integration, Installation, UAT and System Testing for Client / Server, web-based and Front-end GUI s applications.

Davis + Henderson, Toronto ON 02/2010-03/2011

Quality Assurance Product Analyst/Support Analyst

Environment: .NET, HP QC, SQL, TFS, XML, MS CRM, Oracle, ETL, Crystal Reports, SharePoint, QTP

Participated in Data Conversion Testing for Warehouse Management System.

Was involved in Business Workflow analysis, writing Test Plans and Documentation for them.

Supported procurement data entry activities in the project procurement database for all projects.

Designed and executed Test Cases and reported Defects using HP Quality Centre and MS Visual Studio.

Signifi Solutions Inc., Toronto ON 10/2009-12/2009

Senior QA Specialist Team Lead

Environment: .NET, Microsoft SQL Server, Jira, XML, QTP, Web Services, WebSphere, Card readers, Agile

Tested the Signifi specific hardware to insure compatibility and integration with the software applications.

Designed and wrote automation test scripts.

Performed Web Application and Web Services testing using SOAP UI tool.

Involved in Gap, Feasibility and Risk analysis of Vendor / Third Party Tools.

Proposing consolidation of templates.

Aviva Insurance, Toronto, ON Canada 12/2008/-08/2009

Senior QA/BA Consultant

Environment: Web-based, HP QTP, .Net, XML, Guidewire, RUP, UML, BI Reports MS Visio, Linux, CASE, ITIL.

Participated in gathering the system requirements for several releases of application

Performed Functional and Integration tests for Underwriting, Claims and Billing modules.

Validated the policy data and the acceptance of policy data by various peer systems.

Prepared high level and low design documents with class / sequence diagrams.

Ministry of Health and Long-Term Care, Kingston, ON Canada 11/2007-10/2008

Senior System Tester

Environment: Client/Server, Mainframe, TSO/ISPF, JCL, DB2, SQL Queries, Batch Processing, HL7, DW

Projects: THAS Download Systems Response, Update Primary Care Clinical Data Communication Routings

Created test plan, test scenarios and test cases using STS methodology and support system changes.

Executed batch testing in IBM mainframe DB2/IMS test environment.

Debugging the application in TSO and made changes to the values per Test Cases.

Reviewed and analyzed the Use cases.

Performed Gap Analysis.

Honda Financial, Toronto, ON Canada 06/2007-10/2007

Senior Quality Assurance Analyst/Business Analyst

Environment: Client/Server, Mainframe, ETL Batch Processing, HP Quality Centre, HP QTP, MS Visio, SQL

Performed various types of testing: regression, integration and system.

Updated test documentation and logged defects using Quality Center.

Participated in the BRD (Business Requirement Document) review with the QA Team.

Developed Test Plan and Test cases to meet functional requirements.

Navantis Inc, Toronto, ON Canada 10/2006-05/2007 QA Project Lead

Environment: Visual Studio(TFS), .NET, ASP.NET, ADO.NET, VB Script, SQL Queries, SharePoint Complete, QTP, HL7, VBScript, XML, Data Warehouse, ETL, Cognos BI Reports, Client/Server, LoadRunner

Project: Clinical Information System

Responsible for managing software QA for UHN and LHIN.

Supervised onsite QA team of 3 and outsourced testing team in Sri Lanka.

Verified that all the requirements mentioned in Business Requirement Documents are covered.

Provided user access level maintenance and support to enable system availability and reliability.

Cognos Inc (IBM), Ottawa, ON Canada 03/2001/-12/2002 & 05/2004- 09/2004

Senior Quality Assurance Analyst/Lead

Environment: SQL, MS-Access, MS Visio, Windows/Unix/Mainframe, WebSphere Portal, HTML, XML, APACHE, UNIX, iPLANET, ASP, COGNOS BI, MS SQL Server; SYBASE, DB2, ORACLE, ETL, DW, Client/Server

Acquired product knowledge of new Web-Based Cognos products and features.

Led teams in QA Projects and participated in UAT testing.

Martware, Inc. Toronto ON Canada 03/2003-03/2004

Quality Assurance Analyst/Business Analyst

Environment: Java, ORACLE, XML, SQL Queries, C/C++, Web Sphere Portal, MS Visio, WinRunner, LoadRunner

Performed Functional, GUI, Regression and UAT testing of new Stock Market Simulator.

Wrote functional requirements for interactive web sites based on information gathering from stakeholders.

Communicated and documented gaps, risks, anomalies of concern and escalate to manager as required.

Bank of Montreal, Toronto, ON Canada 10/2000- 04/2001 & 02/2006-06/2006

Quality Assurance Analyst

Environment: Client/Server, .Net, SQL Queries, IBM Web Services, Windows XP, Mainframe, Back-end /Front-end.

Tested applications designed for deployment at the Retail Branch level.

Executed Mainframe, System Testing in Software application involves Banking & Credit Cards.


Master’s Degree in Engineering (Communications and Informatics)


Available upon request.

Contact this candidate