Test Cases Sql Server

Igor Polansky

*** ********* **. *********, ** M8Y 3G8 Phone: 416-***-**** cell, *********@*****.***

Objective: Seeking a challenging Sr QA Analyst position in dynamic environment

Experience Summary:

15+ years of Software Testing and Quality assurance of large, complex IT applications in Healthcare, Insurance, Investment, Banking, Brokerage, Telecom, Mortgage, Trading, Government Applications

Governance balance of cost, time, and quality, focusing on good testing practices across every QA

Experienced in Defect Management, support all the Defect Life Cycle using different tools through STLC

Practice knowledge in Batch Processes, Data Warehousing and ETL processes testing, J2EE, EJB,

Test process automation with Quick Test Pro v 10.0, HP Quality Center, Silk Test, Empirix, Selenium

Strong Database (Oracle, SQL Server, DB2) testing skills using advanced SQL, PL/SQL, TOAD, WMS

Proficiency in Scheduling, Managing resources and activities in QA Team, System testing methodology

Experience in structured methodologies for development, design, testing, maintenance of applications

SKILLS SUMMARY:

Operating System, Browsers

Win 7, MVS, Tandem, UNIX, Solaris, Linux, z/OS, IE, FF, Safari, Chrome

Languages

C#, .Net, ASP, VB6, C++, Java, COBOL, JCL, SQL, J2EE, Shell scripting, FTP

Database

Access, DB2, Oracle 8.x/10g, SQL Server Enterprise Manager, SQL Query Analyzer, TOAD, Oracle SQL Developer, ETL, Data Warehousing, MDM

Automated Testing Tools

Win Runner, QTP 10.0, HP QC, Load Runner, SilkCentral, InfoPath Forms, Nintex Workflow, Empirix, Selenium, BlazeMeter, MS Project, PowerPoint

Bug Tracking Tools

Test Director, JIRA, Zephyr, BugZilla, PointInsight, SharePoint, GTAG

Web

HTML, XML, .NET, WSDL, SOA, SOAP, Java, ASP, Apache, Ms Dynamics GP, CRM, IBM Websphere v 5.0.2, Capital Market, PeopleSoft, CITRIX, IIS

PROFESSIONAL EXPERIENCE:

Client : UXP Systems, Toronto, ON, Sr. QA Analyst Dec 2014 –Now, Rogers Eclipse Wave3 IPTV Solution Functional, Load and Performance Testing. Windows, Android tablets/phones, iOS phones and iPad testing

Cross platforms tests, Wireshark, Fiddler, PUTTY, for WEB debugging and back end test results analysis

Test Scripts development, SIT testing, Android, iOS devices testing, Axosoft DEFECTS for bugs tracking

Client : Blast Radius, Toronto, ON, Sr. QA Analyst Oct 2013 –Dec 2014, Web and Infrastructure testing

Bombardier Recreational Products Inc. (BRP), WebSphere 5.0.2, Functional, ETL and data reporting testing. Adobe CQ5 Content Management, iOS, Android, Supply Chain Mapping, Agile environment, Ecommerce

BlazMeter, Google Analytics and Webpagetest for Performance tests, Selenium to automate eCommerce

Test Scripts development, MS SQL, Android devices interface testing, Jira/BRAVO for defects tracking

Client : Nurun Inc., Toronto ON April 2013 – Oct 2013, Sr. QA Lead, iCloud based CRM, TD Beanstream, JIRA( Zephyr), Mainframe, JCL, IBM Ecommerce, Web BI Reports, Oracle Dynamics 4.0 CRM, data integrity for Websphere, iOS and Android devices, ETL, Store Mapping, Batch processing, writing complicate SQL Queries.

IBM WCS with credit cards payment. Adobe CQ5 Content Management System (“CMS”), TD Beanstream for payment, TelusCRM Profile Management, Inventory and Order Fulfilment testing, SIT testing, BI testing

Oracle CRM, Customer registration/login, online payment system, UAT testing, coaching/tutoring testers.

Test cases creation execution, test result analysis, Test Automation and defect tracking with JIRA( Zephyr).

Client : Ministry of Health, Ontario (CCIM) (02. 2010 – 03 2013) SR QA Analyst,

InfoPath Forms, Microsoft Dynamics GP, XenApp, BI Reports, ETL/MDM, JSP, HL7v2, XML, Websphere 5.0.2

Projects: MIS, Microsoft (TFS) Team Foundation Server, Service-oriented architecture (SOA) systems testing, PeopleSoft, Material Management System, QHR, back end testing for DB conversion. BR analysis, UAT, Claims processing in multi-tier Web application, AODA specific needs testing, Complicate SQL Queries writing.

End-to-end SDLC, System Integration Test, Non-Functional Test to cover non-functional requirements.

Responsible writing test cases for Computer Aided Dispatch (CAD) software for .NET application

Developed Automation scripts, Risk assessment and Exit Reports to management, release notes.

Client : St Joseph’s Healthcare (05. 2009 – 02.2010) QA Lead, Developing QA team, create BA/QA process.

InfoPath Forms, SharePoint, PointInsight, Java, Websphere, .Net, HL7v2, XML, Ms SQL Server, SOAP UI, Projects: Horizon Surgical Manager, Provider Index, Materials Management (McKesson Healthcare). Data Warehousing, ETL, MDM, Mainframe, JCL, back end tests for DB migration, data integrity Workflow Develop Business&Test Strategy, test scope, milestones, budget and resources for WEB based projects, ETL and DWH.

Reported the bugs, Email notifications to the developers using the SharePoint, PointInsight and BugZilla.

Responsible for People Management in QA Team, providing test track reports, tutoring/training other QA.

SOAPUI / SOA for tracking test cases creation/execution and test automation, AODA related tests

Client : Cancer Care Ontario (07. 2008 – 05.2009) Sr. QA Analyst, Database migration MS SQL to Oracle 10

Project: Colon Cancer Check IM/IT Program, Agile Environment: HP QC 10.0 Test Automation, .Net, HL7, XML

Creating Business Requirements, test plans, test strategy for back end of Electronic Health Record(EHR).

Database testing with TOAD for SQL Server DB tool by writing complicate SQL queries, testing triggers and PL/SQL procedures. SQL Server Management Studio to test Fact and Dimension Tables, ETL, Data mining

Automated Test scripts and scenarios creation, QC, AODA specific needs tests, SQL Queries creation.

Client : ADP - Broadridge (04. 2007 – 06. 2008) Sr. QA Analyst, Wealth, trading systems testing

Broker/Financial adviser – Shareholder Communication application, Multi-layer Environment: Capital Market, SQL Developer, DB data back end tests, Tandem, ETL, Data Warehouse, SQL Queries, BI for Data mining

Creation of Test Strategy to verify AutoSYNC synchronizes Enscribe files and SQL tables, Full SDLC, reports

Test cases for new functionality verification for financial services, trade life cycle. Investments results of trading instrument types-equity, options, web-based, UNIX and client-server multi-tier environment

Test scenarios for stock exchange market, clearing and settlement process, reconciliation, end of day process, brokerage, financial securities on the back end, ETL, Data Warehousing, MDM and Advance SQL.

Client: Royal Bank Financial, (01. 2006 – 03. 2007) QA Lead Project: E-Statements, BA/QA, ETL, Tandem

E-Statements Project - Test Strategy, Master Test Plan, Regression Testing, Nintex Workflow and BugZilla.

Online Mortgage Application – Functional and Regression testing, test data with SQL Navigator, HP QC

The Payment Data Security Standard, financial services, trading security testing, Mainframe, Share Point

Client: MANULIFE Canada, Kitchener, ON (09.2003–12.2005) SR. QA Analyst, Wealth systems testing

Project: RRSP, NRRSP Portfolio Reports Financial Applications, SDLC from RRD cover to defects tracking

Manual testing of Portfolio Reports Financial Applications – test cases execution, results analysis, AS 400

Automation of WEB based Regression functional Test Cases with HP Quality Center, Performance testing

Client: BCE EMERGIS, e-Health Solutions Group, (11.1998– 08.2003) QA Analyst

MedAssure project, Ontario Dental&Drug Benefit Program, Tandem, batch, multi -tier web environment

MedAssure project Test Plan creation/execution (Mainframe, IMS/DB2, ORACLE 8.i, CA 7, Web interface)

LTC drugs coverage for residents registered in the Health Network System, co-payments and deductibles

Performance testing using Load Runner tool, VUgen recording, systems response documents creation

Client: CASCADE - IT Company, Novosibirsk, Russia (1981 – 1998) Team Lead

Organized team efforts for full scale of SDLC on large, complex IT projects

Performed testing of IT products for the development, design, implementation and maintenance

EDUCATION and TRAINING:

2005 CDI Corporation Software Testing Challenges (Certified Software Tester) Toronto, Ontario

1999 Seneca college Systems Analysis & Design (SYS 364 SA) Toronto, Ontario

1976 – 1981 State Technical University, Novosibirsk, Russia

Bc. Degree in Computer Science (Comparative evaluation performed by the University of Toronto)

REFERENCES: available upon request

Contact this candidate