Quality Assurance Sql Server

Alex Malashenko ** Cedarcroft Blvd., Toronto, ON, M2R

2Z4

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

Phone: 647-***-**** 647-***-****

PROFILE

A Senior System Quality Assurance Analyst with over 7 years of

experience in financial, insurance, retail, and software development

industries

Exceptional analytical, design and problem solving skills

SKILLS

. Black Box testing of Client/Server, Web based, Mainframe and Multi-

tier applications

. White Box testing.

. System Functional/Integration, Regression, User Acceptance (UAT),

Interface Compatibility (GUI) testing.

. Creation of Test Plans, Test Scenarios, Test Cases, and other QA

documents based on use cases and other business related and

development design materials

. Practical experience in implementation of various QA methodologies

such as Bottom Up, Top Down and Equivalence Partitioning

. Utilization of Water Fall and Rational Unified Process (RUP)

approaches to Software Development Life Cycle (SDLC)

. Test management tools: HP Quality Center 11.0, MS Application

Center Test, Jira, Rational Test Manager 2003

. Automated testing tools: HP QuickTest Professional 10.0, Selenium

IDE, WD.

. Defect tracking tools: Rational ClearQuest and Test Director (Web

Based); TestTrack Pro

. Performance, Stress and Load testing tools: Rational Performance

Tester, LoadRunner, WebLoad, QA Load

. Programming Skills at Testing Level: Java, JavaScript, HTML, XML,

VB.NET, SQA Basic, VB, C++, C#, Ajax, Soap, Unix Shell Scripting

. Environments:: Windows 7/XP/2K/NT Server/3.1, Unix(Sun Solaris)

. Databases: SQL Server 7.0/2005; Data Warehouse; Oracle 8i/9i/11g,

DB2

Other tools and applications: MS. Visual Studio/.NET applications, Team

Foundation Server, Toad for Oracle, MS. Office Suite (MS Visio, Project,

Access, Excel, Word)

PROFESSIONAL EXPERIENCE:

Senior Quality Assurance Analyst

2010 Sep - 2014 Mar

Wirecard Payment Solutions, Toronto

Projects: Transaction Processing Acquirer integration, Chargeback system,

PCI DSS compliance.

. Performed full QA Analysis and testing of multiple projects that

included Web-based applications

. Developed test plans, test scenarios and test scripts for

performance and load testing, based on project specific test

approach

. Performed analysis and review performance and load testing

. Created test scenarios and test scripts by utilizing different

QA methodologies specifically suitable to each application

. Performed System, Integration, Regression and User Acceptance

(UAT), Security and GUI testing for all projects by executing

different types of test cases using live test data

. Wrote and executed SQL queries to validate the application

functionality with the database tables and VSAM files, using MS

Query Analyzer, MS Enterprise Manager, Management Facility

(QMF), BMC and FileAid

. Was involved in post production Application Support by working

closely with End Users

Environment: MS. Visual Studio/.NET applications, Team Foundation Server,

UNIX, DB2, SQL Server, FTP, VPN, PVCS

Senior Quality Assurance Tester/Analyst

2008 Jan - 2010 Aug

RJA Global technology, Vaughn, ON.

Projects: Taxi video surveillance software and GPS based taxi advertisement

system.

. Was involved in all QA processes during complete Software Life

Cycle

. Analyzed Business Requirements Documents, Development Design

Documents and created Test plan, Test Scenarios, Manual and

Automated Test cases/scripts for complex Web-based and Client-

Server application

. Prepared test data for all types of testing

. Performed various types of testing: GUI, System functional,

Integration, Regression Load, Performance, Stress, and

Security by executing self created test cases/scripts

. Handled initial research, evaluation and comparison of the

following testing tools:

Tester; Mercury's WinRunner and LoadRunner, Selenium IDE,

Selenium WD.

. Worked closely with developers and performed some Unit Testing

(White Box)

. Created SQL queries to validate data on SQL Server

. Prepared sign-off documentation for UAT and was overseeing Users

Acceptance Testing procedures

. Mentored junior QA staff with best QA methods and practices

Environment: Windows 2003/XP, Java, SQL, SQL Server

Senior Quality Assurance Tester

2007 Apr - 2007 Dec

Strategic Connections Inc. - Toronto, ON

Projects: GM OneSource Lead Consolidation and Distribution System. GM

Certified Internet Dealer

Program.

. Performed analysis and review of automotive dealership lead life

cycle process, including lead consolidation, lead distribution

and lead contact management

. Suggested the test strategies and test approaches based on

analysis of the business requirements

. Created test plans, test matrices and test cases by utilizing

different QA methodologies specifically suitable to each

application

. Performed Functional, Integration, Regression and GUI testing

using back-end manipulated data and live test data

. Was responsible for monthly code-drop and hotfix production

testing

. Provided UAT group with full support including UAT data

preparation and UAT test cases reviews

. Prepared and executed complex SQL queries within Data Warehouse

environment to validate the integrity of OneSource Reporting

system

. Created and edited XML templates using XMLSpy Editor to simulate

various dealership lead scenarios, as well as validated XML

files upon XML schemas

. Prepared set of end-user and technical instructions for back-end

processes and jobs in order to simulate lead consolidation and

distribution flow

Environment: Data Warehouse, C#.NET, SQL Server 2005, Java, FTP, XML,

XMLSpy Editor, Dragnet Defect Tracking Tool

Quality Assurance Tester

2006 Oct - 2007 Apr

Aviva Insurance, Toronto

. Created test plans, test matrices and test cases by utilizing

different QA methodologies specifically suitable to each

application

. Performed Functional, Integration, Regression and GUI testing

using back-end manipulated data and live test data

. Was responsible for monthly code-drop and hotfix production

testing

. Provided UAT group with full support including UAT data

preparation and UAT test cases reviews

. Prepared and executed complex SQL queries within Data Warehouse

environment to validate the integrity of OneSource Reporting

system

. Created and edited XML templates using XMLSpy Editor to simulate

various dealership lead scenarios, as well as validated XML

files upon XML schemas

. Prepared set of end-user and technical instructions for back-end

processes and jobs in order to simulate lead consolidation and

distribution flow

Environment: Data Warehouse, C#.NET, SQL Server 2005, FTP, XML

Java Developer / Tester

2001 - 2005 PlusMicro,

Karaganda, Kazakhstan

. Prepared set of end-user and technical instructions for back-end

processes and jobs in order to simulate lead consolidation and

distribution flow

. Developed a set of dynamic WEB-pages (using HTML, CSS,

JavaScript, MySQL, Tomcat), for Customer Relationship

Management System. For a WEB-application displaying some objects

on the map, developed persistence tier, to put and extract the

information about these objects from the database to show them

on the WEB-pages.

. Performed full QA Analysis and testing of multiple projects that

included Web-based, Mainframe and Multi-tier applications.

. Developed test plans based on project specific test approach.

. Created test scenarios and test scripts specifically suitable to

each application.

. Performed System, Integration, Regression and User Acceptance

(UAT), Security and GUI testing for all projects by executing

different types of test cases using live test data.

. Wrote and executed SQL queries to validate the application

functionality with the database tables using MS Query Analyzer,

MSSQL Enterprise Manager

[pic]

Environment: Java, UNIX, DB2, SQL Server, FTP, XML

Education:

. Diploma in the software quality assurance tester

2006 Canadian Technology College, Canada

. Bachelor of computer science

1987 - 1992 Novosibirsk Electrical Engineering Institute - Novosibirsk,

Russia

References

Available upon request.

Contact this candidate