Jie Song Cell Phone: 647-***-****

Email: acwsop@r.postjobfree.com

Objective

Software QA Analyst

Summary

7+ years of software related working experience on Web-based Applications in Bank, Telecom and Education domain

5+ years of experience on Web, Mobile and Tablet Applications Testing on various platforms and versions on Emulators and Devices

3+ years of hand-on data ETL testing in MySQL, Microsoft SQL Server, Oracle DBMSs

2 years automation testing on web applications with Selenium WebDriver, Appium, Eclipse

1 year Accessibility testing on Mobile Application

Experience working in Agile and Waterfall development methodologies

Good understanding of Software Testing Life Cycle (STLC) within Software Development Life Cycle (SDLC)

Excellent skills in creating test plans, test scenarios, test cases, and reporting defects

Solid experience in performing of various kinds of testing: Functional testing, Regression testing, System Integration testing and UAT

In-depth experience working with JAVA, UNIX/Linux environment

Sound experience of HPQC, Clearcase, Confluence

Self-starter and team player with excellent communication, problem solving skills, interpersonal skills and a good aptitude for learning new knowledge

Work Experiences

DawninfoTek Inc. Apr, 2016 – Present

Mobile QA Analyst

Project #1: Mutual Fund Bundle for Scotia Bank Online Banking and Mobile Banking

Responsibilities:

Communicated frequently with project manager, developers, BA and configuration management team about test strategy, test plan, defects, and setting up test environment.

Performed Mobile Applications testing across all major platforms (IOS, Android, Blackberry, and Windows) and mobile browsers.

Performed Smoke, GUI, functional, regression testing, cross browsers, cross OS platforms.

Performed extensive functional, interrupt, usability, installation, un-installation and network testing.

Used Putty (UNIX environment) catching log and monitoring testing process, analyzed and located the defects.

Applied different black box testing, including equivalence partitioning, boundary value analysis, state transition, decision table, use case, and traceability matrix to ensure test full coverage.

Documented the whole Mobile testing process including environment, proxy setting etc. for company.

Project #2: DynaTrace Performance Tuning for Scotia Bank Online Banking and Mobile Banking

Responsibilities:

Gathered required documentation, logs necessary for the performance tuning.

Used PuTTY, WinSCP catch log and providing payload to developers by analyzing logs.

Recorded actions from Mobile and Web app as real users for developing scripts, then modify, enhance the scripts and perform the configuration in VuGen (Loadrunner).

Designed scenarios for load test in Controller based on the end user usage pattern on Loadrunner.

Helped to provide application improvement suggestion.

Verified the performance issues have been fixed by the tools which used on the discovery session.

Performed manual tests both on Mobile and Web to get the page end-to-end performance data and end user experience.

Saninco Technologies Inc. Oct, 2013 – Apr, 2016

Automation QA Analyst (Web / Mobile)

Project #1: Telecom Expense Management System (TEMS) for Rogers Communications Inc.

Responsibilities:

Worked with web-based JAVA application, created test plans, test scenarios, and test cases based on thoroughly understanding of the business requirements and the logical process.

Deployed and set up applications, built network labs (Windows, MySQL database, Putty) with VMware to prepare test environment.

Used Selenium WebDriver, TestNG, JAVA, and Eclipse for creating and executing test scripts for functionality testing of the web application.

Performed compatibility testing cross different browsers, such as IE, Chrome, Mozilla Firefox and Safari and cross different platforms/OS, such as Windows XP, Windows 7, Windows 10 and MAC OS X.

Performed automated regression test to verify the new functionality and tracked the bugs accordingly using HPQC, and generated various reports for the quality of Management.

Developed and documented testing artifacts including detailed test cases.

Worked within Agile methodology, familiar with sprint, scrum, and stand meeting working process.

Project #2: Awards System for Photo Contest

Responsibilities:

Performed automation testing on Awards System which composed of web application on Windows, and native application on Android and IOS platforms.

Implemented Selenium Grid to carry out testing on multiple OS/browsers. Hands on skills with Page Object Model (POM).

Configured JDK, Maven, Appium, Eclipse, TestNG/Junit and set up SDK, AVD, XCode with both Windows and OS X, updated Maven settings to resolve dependencies.

Scripted with Java MobileWebDriver interface, Selenium API to automate mobile Native app, to identify app elements using different locators including image, text (OCR), web identification or native object spy, and to perform automated actions and verifications on various app modules.

Used JDBC to connect to database and perform data validation testing; Used JXL and Apache POI to manipulate Excel sheets and implement data driven test cases.

Performed Functional, Compatibility, Localization, Usability, Regression testing and managed defects in Jira.

Sanyuan Digital Software Inc. July, 2009 – Jun, 2012

ETL QA Analyst

Project #1: Online Banking for ICBC (Industrial and Commercial Bank of China)

Responsibilities:

Proposed data model change based on the requirement changes and reviewed the data model prepared by DAs.

Reviewed Technical Specification Documents (TSD) and mapping documents to capture the build and transformation of the data flow.

Prepared Source Extract Specification document (SES) to agree on the details such as layout/availability timing/location of the file.

Participated TSD and Mapping review session with whole team including ETL and QA team to walk them through the business requirements.

Designed SIT/E2E test planning, test cases and executed test cases.

Contributed to database testing for purpose of data consistency between source and target with Oracle database.

Wrote defect reports and tracked defects status to make sure the quality of testing process.

Project #2: Revenue Recognition system and Billing system for CMCC (China Mobile Communications Corporation)

Responsibilities:

Participated various ETL process including Data Extractions, Transformations and Loading rules

based on business requirements.

Created Test Cases and developed Tractability Matrix and Test Coverage reports.

Followed Mapping rules and Test Scripts created by developer verifying data correctness.

Troubleshoot and implement existing code.

Performed backend database testing. Created SQL query to access data from database tables,

compared result with BRD, verified integrity of the application between source and target.

Analyzed all errors generated by and fixed those errors in data collection.

Online Educational School of Shaanxi Education Institute Jul, 2006 – Jun, 2009

QA Tester / Technical liaison

Project #1: Online Learning System

Responsibilities:

Responsible for production design and final review, experienced version1.1 to version 3.1 three major releases, more than 20 minor releases.

Coordinated between teaching departments and development team for resolving issues, and interacted with coworkers to ensure overall quality of the software.

Analyzed system design specifications and created Test Plans, developed Test Scenarios and Test Cases to cover overall quality assurance testing.

Performed system integration testing, regression testing and UAT testing.

Documents work in Issue Management System for tracking and reporting, and provided accurate evaluation of software quality and reliability to the manager.

Created training materials of APP for train-the-trainer and end-user training sessions.

Project #2: Students Grade Management System

Responsibilities:

Gathered Requirements, designed and developed on the Enterprise Data Warehouse for Online Educational School.

Used ETL tool running on UNIX environments. Identified customer needs, analyzed requirements, participated on the architecture and design of the data warehouse.

Led the Integration process including ETL design, identify source systems, created mappings between sources and targets, developed and implemented workflow processes.

Analyzed, developed and implemented batch ETL processes, continuous flow ETL processes and MS Excel data set upload facilities.

Performed the data extract, transform, and load with Oracle, SQL Server sources, and Oracle, SQL Server targets.

Skills

Proficient in Selenium WebDriver, Appium, Java, Eclipse, XCode, SQL Server, Oracle, IBM Cognos, HP QC, SOAP UI, Loadrunner, Jmeter, Microsoft tools, UNIX, HTML, Confluence.

Education

Diploma for Software Quality Assurance 2011 – 2012, Canada

New Job College of Business and Technology

Training of IBM Cognos 2008 – 2009, China

Avtech Institute of Technology

Master of Online Education 2003 – 2006, China

Sichuan Normal University

Bachelor of Education 1999 – 2003, China

Shanxi Normal University

Contact this candidate