Test Cases Data

Objective: Software QA Engineer / Analyst / Tester

Summary

* ***** ** ******** ***********, experience with Agile and Waterfall SDLC/STLC methodologies

* ***** ** *** *** complex database application testing on MS SQL Server, Oracle, MySQL

6 years of QA testing on Windows Desktop(C/S), Web(B/S), Mobile app, SaaS, ERP and POS applications

6 years of designing test plans, test scenarios, test cases, test data, and defects finding/tracking, test report

Hands-on experience with automation testing with Java, Selenium, JMeter etc.

Extensive experience with System Integration, GUI, UAT, Regression, Performance, Load testing etc.

Strong technical background and ability to analyze and work with complicated business and technical concepts

Well organized with the ability to prioritize and manage multiple work streams and meet tight deadlines

Professional Experience

QA Engineer March 2014 - Present

SANINCO TECHNOLOGIES INC. Toronto, Canada

Saninco is IT consulting provider, serves in Telecom, Finance and Banking fields.

Project: Load/Performance Test for dealtap.ca Web Server

Played a key role on this external Non-functional Testing project

Recorded test steps and organized sub-requests to simulate daily operation on JMeter as HTTP Requests

Designed Test Plans, set up Threads, Ramp-Up Period, Duration and Timers in the JMeter

Executed On-site Load/Performance Testing for dealtap.ca Web Server

Collected and extracted Testing result data from JMeter Listeners and Web Server Top files

Provided Secondary Treatment for the result data, analyzed result data, and generated Test report for CPU, Memory, Disc I/O, Network performance

Web SaaS Project: APKeeper (Account Payable keeper) – Billing/Invoices Processing application

Worked closely with BA, stakeholders and developers in reviewing BRD and analyzing specified complex functionality and business flow

Created test plans and test scenarios and leaded team to create reusable and independent test cases based on BRD and SDD, ensure software be fully tested and all the requirements of system were met

Took the initiative to prepare more than 5000 varied bills as test data in database to verify business logic and business flow, ensured data to meet scenarios and activate each functional module, meanwhile, boundary be covered

Created own SQL queries, analyzed and tested 80% Programmability Projects in the MySQL database, include Stored Procedures, User-defined Functions, Triggers, and Database Constraints

Developed Automation front-end test cases by Selenium WebDriver and Java JUnit, implemented test cases cross OS/browsers, verified each functional module and business logic works properly, identified and reported defects

Used “Toad for MySQL” to access Database for data verification, modified data for testing

Performed Retest and Regression test to ensure defects were fixed and no new issues been created

Mobile Project: APKeeper (Account Payable keeper)

Tested mobile application cross platforms(Android/iOS), Versions(API 13-22, iOS 4-7) and manufactures

Setup and configured mobile testing environment from ground up for emulators, simulators and real devices

Created user stories based on business requirement and mobile application development

Designed test plans, test data, decision tables, test scenarios and test cases based on the mobile application

Performed Installation, Smoke testing and Function, GUI, Usability, Compatibility, Interruption testing

Logged defects and documented defect reports with JIRA

Project: Load/Performance Test for Just Energy MS SQL Server Database System

Took responsibilities and acted as a key role on Load/Performance Testing, worked with user, analyzed requirement and risk of testing

Efficiently solved conflicts in database in order to generate and insert billions of test data/records in 420 tables. Successfully expanded test data volume to 150% by analyzing Primary Keys, Foreign Keys, constraints in tables with SQL data generator tool

Used complex SQL queries to catch most costly and often used stored procedures in Database. Analyzed stored procedures and provided valid and invalid parameters from relevant tables for positive and negative test cases

Set Config Element in JMeter, such as Counter, JDBC Connection, designed test scenarios and test cases, generated 100,000 Stored Procedures as JDBC Requests and executed in the JMeter

Collected Counter Logs from database server, generated Charts for CPU, Memory, TPS, etc., analyzed and solved abnormal phenomena

Generated Baselines for system performance, studied behaviors of CPU, Response Time, TPS, etc. on multiple users environment

Provided test conclusions based on test results and reasonable inference

Web Project: TEMS (Telecom Expense Management System) for Rogers Communications Inc. – Billing/Invoices Processing application

Performed combination of manual and automation testing on web application

Set up automation testing environment, created data driven framework for multiple conditions search functional, and “Filter” functional by Selenium Web driver, TestNG in eclipse

Created Decision Table/Matrix to improve test efficiency, designed test data in Excel file, test scenarios and test scripts for automation test framework

Designed regression test cases for front-end UI testing, automated these test cases by using Selenium IDE

Maintained and updated test scripts, test data and test suits whenever applicable

Reported and tracked defects within a full defect lifecycle

Environment: Windows, Linux, Android, iOS, My SQL, MS SQL Server, Java, ASP.NET, JavaScript, HTML5, CSS, MS Visual Studio, Selenium IDE/WebDriver, eclipse, TestNG, Junit, JDBC, VMware, PAL, JMeter, JIRA

Sr. QA Analyst January 2013 – March 2014

EZRUN SOFTWARE Toronto, Canada

Ezrun is a software company that provides business solutions designed specifically for advanced Point-Of-Sale (POS) solutions for retail stores, restaurants and Sales & Inventory Management System for wholesale.

Windows C/S Project: Restaurant Management System (POS application)

Worked closely with BA and Developers in Agile environment, collected and analyzed the test basis, decomposed business logics, created flowcharts, identified each data flow

Designed high level end-to-end test cases based on 5 main business requirements in restaurants to verify business flow and logic

Created testing environment for new software and hardware, include installation, set up, trouble shooting

Designed own SQL queries to execute back-end testing on MySQL database

Implemented concrete Unit test, Functional test to verify each feature units in different language environment

Executed Integration tests for system and third party programs, such as drivers for Touch Screen, Payment terminal

Provided root cause analysis for defects, performed Retest and Regression test for the applications were fixed

Documented test procedures, test plans, test data, test cases and defects, provided test reports for management

Environment: Windows 7, Windows server 2008, MySQL, Toad, Visual C++, Excel, SVN, Data Factory, Red Gate MySQL Compare

QA Team Lead May 2008 – July 2010

XINGU TECHNOLOGY LTD. Changle, China

Xingu was a software company founded in 2008 that provides business solutions designed specifically for Sales & Inventory Management System for retail and wholesale.

Web Project: Construction Materials and Supplies Wholesale System (ERP +POS application)

Participated in entire SDLC and STLC on this system. Created QA policies and test procedures

Worked with BA team and Development team, collected and analyzed the test basis, such as business requirement, solution design specifications, detail design document, developed test strategies to ensure system been fully tested

Created Test Environment, such as varied hardware and OS platform, include test data for the test team

Created test scenarios and test cases to verify the Database Transaction ACID properties

Trained test team with analyzed and tested each Database Stored Procedures, User-defined Functions, and Triggers by using different parameters and validated outcome or return values

Conducted and executed Unit test, Functional test, Integration test, Performance test, Compatibility testing for the CRM, Finance/Accounting, Inventory/Warehousing, Product Costing/Pricing, Order Processing modules

Worked with development team, analyzed root causes and provided clues or suggestions for the defects solving

Performed Retest and Regression test for the applications were fixed

Produced testing report and quality assessment for each sub-system, ensured sub-systems were ready to go

Decomposed complex business logic, wrote clear User Manual (Help file), provided training for clients

Environment: Linux, Windows, MySQL, Java EE, JavaScript, HTML, CSS, Toad for MySQL, JDBC, Apache Tomcat, Putty, CVS, MS Office, JIRA

UAT Team Lead July 2007 – May 2008

CHANGLE GENERAL HOSPITAL - IT Department Changle, China

Desktop C/S Project: HIS (Hospital Information System) UAT

Assigned as Representative for the Hospital, built and led a test team, set testing policy, in charge of HIS UAT

Collected specifications from “HIS Contracts for Technology” and generated test requirements, test cases and results

Set up a testing environment to simulate real production, gathered varied real life data, such as invoices, prescriptions, patient files for testing, and guided to input these data into database as test data

Created on-site user stories as test scenarios, such as patients transferred from doctors/departments in the hospital, or transferred from/to another hospital to simulate business flow, and verified data flow in database

Created test process and standards, provided training for team members, mentored test team to executed Functional Testing to make sure business flow and data flow worked properly

Migrated data from old databases to new HIS Data Warehouse as test data, performed ETL testing to make sure data integrity and correctness from data sources to DW, designed SQL queries and executed testing for BI reports

Executed database Performance Testing on data search and data daily/monthly/yearly calculations/reports functions, ensured search and computing time met requirement and data calculated correctly in large volume data

Conducted database Security Testing to ensure system safety and data been recovered in critical unexpected incidents such as power failure, network issues, work stations or server breakdown

Documented test process, results and defects reports. Oversaw test quality, signed off test report for each sub-module and functionality which met requirements, rejected programs for recoding which didn’t meet specifications

Provided suggestions for improving the usability of HIS Use Manual, and trained internal users

Environment: Linux, Windows, Oracle, PL/SQL, Delphi, ODBC, SQL*Load, SQL*Plus, MS Office, Excel, Data Factory

Database Developer May 2004 – July 2007

CHANGLE GENERAL HOSPITAL – IT Department Changle, China

Analyzed HIS business flow, logic and involved in HIS database structure, tables, and front end interface design

Programmed Prescriptions Management Software for Medical Department

Independently designed Human Resources Management Software, upgraded HR system for Hospital

Wrote Salary Management Software, provided new customized functionalities for Finance Department, this software replaced old version which purchased from market

Independently programmed Medical Equipment Management application by Visual FoxPro

Electronics Engineer July 1995 – May 2004

CHANGLE GENERAL HOSPITAL - Medical Equipment Department Changle, China

Collected Medical Devices included computer equipment information before purchasing, created plans and contracts of purchasing for Hospital

Provided inspection, testing and acceptance for new devices such as CT, X-Ray Machine and Ultrasound Scanner etc., generated equipment files for new purchase and write-off

Executed annual inspection, maintained and repaired Medical Equipment, managed maintenance records for each device

Education and Training

NewJob College of Business and Technology (Toronto)

Business Intelligence for MS SQL Server (SSIS/SSAS/SSRS)

Software Automation Testing

2015

2012

Fuzhou University

(Fuzhou, China)

Computer Science

2000

Min River Professional College

(Fuzhou, China)

Electronic Technique

(3-Year Program Diploma)

1995

Reference available upon request

Contact this candidate