Michelle Yan

QA Analyst and Software Tester Lead

addi39@r.postjobfree.com

Mobile: 647-***-****, Markham, ON

SUMMARY

A skilled QA Analyst and software tester lead over 12 years’ experience across numerous industry segments including banking services, financial services, capital market and wealth management services

In-depth knowledge and professional expertise of end-to-end traditional SDLC environment as well as Agile (Scrum, Kanban) methodology, and strong hands-on work experience in all aspects of Quality Assurance life cycle and Test Management.

Highly collaboratively with the team, excellent communication skills with the ability to communicate with business users and technical teams effectively.

10+ years of experience in reviewing and analyzing system requirements, design requirements, business requirements, then translating into test plans, test cases, test traceability matrices, use acceptance criteria and automation test scripts

10+ years of hand on experience of testing in different environments such as unit testing (DIT), system integration testing (SIT) and user acceptance testing (UAT) across multiple platforms including Web, Mobile, API, UI applications, Java based applications, Linux OS, host mainframe system, client server Apps.

Extensive experience in performing all types of testing such as baseline testing, regression testing, functional/nonfunctional, smoke, white box & black box, addhoc testing, connectivity testing, end to end testing, acceptance testing, usability testing, user roles testing, configuration test on all variety of platforms (mobile, web, portal frameworks, mainframe).

8 years of solid experience in developing scripts and utilizing automation test tools to assist in optimizing test case execution such as SOAPUI, API Selenium, HP-QTP, POSTMAN, as well as Mainframe testing tools (JCL/TSO/SPF).

Experience with designing test automation frameworks from scratch with Rest Assured automation framework, Selenium, API testing, Cucumber test automation tool and Gherkin scripting language.

Solid knowledge of Devops lifecycle, source control management GitHub, CI/CD pipeline, Jenkins and bitbucket

Highly skilled in research, data analysis, data mining, gap/scope analysis, and delivery high-quality Source Data Analysis Reports and PoC Assessment Reports using Tableau and Excel.

Experience in analyzing and interpreting data, both for data quality issues, and to support management decision making.

Strong experience in writing complex SQL queries & be comfortable with SQL server, IBM DB2 and Oracle with navigating database, joining tables and executing stored procedures

Strong project management skills with depth knowledge of Microsoft Office Suite (Words, Excel, PowerPoint, Visio, Access), as well as cloud base applications such as BOX & JIRA/JIRA Confluence.

Great experience with planning test schedules, estimating test efforts, identifying test scopes, preparing test data, and setup test environment requirements.

Experience with the defect management lifecycle using tools like HP Quality Center testing tool, JIRA defect tracking tool.

Strong ability to identify and raise awareness of issues promptly, and collaborate with business teams and development teams in resolving them quickly.

Proven hands-on experience in authoring, maintaining, executing and documenting test results along with generating defect reports and identifying software problems and causes, and help resolve them.

Acted as subject matter expert (SME), analyze the application bugs, production issues and clients' tickets, and work closely with PM, BA and development team to resolve the issues

Gained knowledge in various testing with online bank web application, wealth management system, online payment management system and Capital market trade industry.

Detail oriented with strong business and data analysis, problem solving skills, customer service and production support skills. A self-starter with the ability to work independently and manage one’s time to meet projects’ goals and deadlines.

TECHNICAL SKILLS

Testing Tools: SAP HCM, SAP SuccessFactors, Mercury Quality Center, QTP, SoapUI, REST, IBM Rational Toolset, Automated testing tools with Selenium WebDriver, C DB2 queries, IBM MQ, SOAPUI, JIRA, & ServiceNow, Gherkin and Cucumber/BBD, JAVA, SQL, GIT, POSTMAN, robot framework, JIRA defect tracking tool, GitHub, CI/CD pipeline, Jenkins

Business/Data Analyst Skills: Gather Requirement, Elicit Requirements, Business Analysis, Risk Analysis, Agile Methodology (Scrum), Project Management, Client Support, Acceptance Criteria, Microsoft Office Suite (Words, Excel, PowerPoint, Visio, Access), UML, & BPMN

Programming Languages: C++, C#, Java, SQL, X/HTML, JavaScript, .NET, Perl, & COBOL, Python, Microsoft Visual Basic.

Database: Oracle, MySQL, SQL Server, & Microsoft Access.

Operating Systems: Linux, Unix, AS/400, Mainframe (z/OS), & Windows 10.

WORK EXPERIENCE

Jan. 2010 – Apr. 2020

QA and Software Tester/BSA

Securities Industry Services (SIS), IBM Canada

SIS is a provider of post trade, back-office clearing and settlement, book of record accounting and other ancillary services for the capital market trading system for major banks and financial institutions in Canada such as TD water house, National Bank and Desjardins Group. During my tenure, I have been wearing multiple hats as QA, software manual/automation tester lead.

Major Accomplishments:

Project 1(Agile/Jira) Corporate Action and Entitlement System Modernization - The migration project developing in Agile environment – from the complex legacy system Mainframe migrating to the FIS’ end-to-end web-based platform ‘Powered by XSP’. Clients: TD Water House and all entitlement system subscribers.

Project 2(Agile/Jira: Internal Transfer Asset movement STP- To build an STP function for internal transfer web/mobile application that was able to support one click function for money and securities real time end to end movement. Client: TD Water House

Project 3(SDLC): Account Transfer Web-Enable project- To Build a web-based/Mobile front-end platform for the mainframe-based application that was accessed from the web browser to connect to the backend mainframe system. Client: TD Water House

Project 4 (SDLC): CDS and DTCC Real Time Trade Clearing Settlement – This project aimed to enhance the batch settlement process to support the real-time settlement process for cash and CDS eligible securities transactions, and also included real-time settlement for the CDS ATON external cash and security transfers. Client: TD Water House

Project 5(SDLC): Multicurrency Processing Enhancements (Host mainframe) – To build the multi-currency processing (MCP) service in order to support our clients to process transactions with more than 40 foreign currencies. Clients: All SIS’s subscribers

Project 6: (Agile/Jira): Entitlement Announcement Vendor Feeds Replacement. To replace the current Fidelity feeds with the CDS and DTC vendor feeds. This project required mapping the Fidelity flat file layout to the CDS SWIFT message layout and DTC XML message layout to ensure the new message integrated with the new web- based platform correctly. Clients: Internal stakeholders

Responsibilities as QA lead in Agile projects:

Successfully acted as both QA and BA roles in our Agile journey and practices, worked closely with Clients, Vendors and Scrum team to successfully deliver the complex project on time within budget.

Studied the customer requirements, trend and finding the business solutions and gaps to address them.

Assisted PO to elaborate user stories by adding detail requirements, story-splitting, adding detail acceptance criteria, building the sprint backlog.

Collaborated closely with team to review, negotiate, and update Acceptance Criteria for all stories in the Product Backlog

Performed risk analysis associated with the proposed solution and reported to the team during scrum meeting.

Analyzed the test coverage for each Sprint, converting real-world user stories into test cases, test matrix and providing insight to test complex functionalities.

Developed and maintained manual test scripts, automation Selenium test scripts and other test tool required such as SOAPUI, POSTMAN, RestAPI to execute test plans and test cases.

Successfully led the team to conduct the all test tasks to ensure each increment tested thoroughly before production promotion.

Verified the proposed solution for a problem/requirement by manual testing from the point of view of the end customer.

Actively participated in Scrum practices and ceremonies including Sprint Planning, Daily Scrum (stand-ups), Sprint Review (demos), and Sprint Retrospective.

Responsibilities as QA lead in SDLC projects:

Successfully leading and mentoring team of 4-6 QA specialists, and coordinating resolution of internal and external issues between QA, Development and Business teams.

Responsible for creating Test Strategy/Master Test Plan, Test Execution Plans, Test Scenario Matrix Design and Test Completion Reports.

Participated in peer reviews of Test Cases, SQL structure, Test Plans and Automation scripting.

Responsible for estimating and planning the test schedules and resources in accordance with project scope and delivery dates.

Planed and conducted functional and regression testing, unit testing, integration testing, performance testing, and user acceptance testing. Ensure delivered solutions are accepted.

Responsible for monitoring the testing progress to ensure testing is completed within testing schedule.

Documented software defects, identify and analyze the document problem, using a bug tracking system.

Responsible for monitoring bugs resolution efforts and track successes, and maintain databases of known test defects.

Under strict planning and scheduling, managed end-to- end testing activities of cross-applications. Testing activities cover all aspects of STLC (Software Life Test Cycle) including Requirements/Design Review, Test Planning, Test Designing, Test Environment Setup, Test Execution, and Test Reporting.

Prioritized and delegate testing and support tickets amongst QA and Client Support teams.

Led weekly defect review meetings and participating in test status meetings.

Led/oversaw the UAT testers and provided support, expertise and direction.

Acted as subject matter expert (SME), analyzed the software defects, production issues and clients' tickets, and work closely with BA and development team to resolve the issues

Provided support and advice for answering internal and external client’s questions.

Apr 2008 – DEC 2009

RBC Financial Group, Toronto

Quality Assurance Analyst

Department: Payments & Wealth Management Technology

Major Accomplishments

GRADS ACH Basic Low Volume - Online Banking Web application (Apr 08- Oct 08)

AML ACH Cross - Border File Format Changes - RBC Express (Sep 08 - Sep 09)

RBC Banking Cards Security Enhancement (Sep 09 - Dec 09)

Responsibilities

Analyzed BRD and SRS documents for the purpose of Test Case creation and execution.

Created test cases and test scripts for the functionality testing according to SRS and Use Cases, inputted test cases into Mercury Quality Centre.

Frequently reviewed the test cases and scripts with the project team ensuring all business requirements have been covered.

Attended Change Request meetings to document changes and implemented procedures to test changes.

Performed Functionality Testing, U&A Testing, Multi-browser Testing, End-to-End Testing and Regression Testing within 2 environments (SDF, IST) over 3 system centers (OCC/QCC and BCCC) for both English and French versions of application.

Tracked and reported defects, analyzed and assigned Severity and Priority Levels for defects, interacted with developers and system analysts to resolve them.

Recorded defects, retested fixed defects and updated defects status.

During testing always considered client impact first even when results were as expected

Assisted in creating and ran Test Execution Status Reports and Defect Status Reports periodically

EDUCATION

Computer Programming & Analysis 2006 -2008

Seneca College, Toronto, Ontario

Bachelor of Business Administration and Economics 1992-1996

Beijing Institute of Economic Management, Beijing, China

Contact this candidate