Testing Manager

RICHARD XIA 647-***-**** abqgbc@r.postjobfree.com Toronto ON

OBJECTIVE: QA AUTOMATION TEST LEAD/ANALYST

SUMMERY OF WORK EXPERIENCEOver 8 years of Hands-on Expert experience in automation development, scripting and Manual testing of web applicationsStrong Programming Experience in QTP and LoadRunner - VBscript, and VB(.net,VBA, Macro), C and JavaSolid Object Oriented software development experience in Java/J2ee, C#.net, C/C++, python, SQL and shell Script Professional experience in Architecting Automation Testing Framework including Keyword, Data Driven and Hybrid FrameworkExperience in creating automation tools to integrate HP QC and QTP/LR by using AOM and OTA technologies Experience in administering, maintaining and developing HP ALM/QC testing management serverRestructured/Maintained existing Testing Framework and trouble shootingExperience in creating automation tool with nice UI(client) to batch manage QTP scripts(in QC) including scheduling Multi-test sets, configuring scripts run settings, custom backup and upload, sending email testing results automaticallyExperience in Insurance, Finance, Banking, CRM, Health and E-Commerce n-tier web based ApplicationsExpertise in Automation Test effort estimation, Test Plans, Test Scripts, and other documentationsProfessional experience in database back-end testing on Oracle 9i/10g DBA, DB2, SQL Server 2000/2005 and MySqlExperience of Full Software Development Life Cycle(SDLC) of complex projects Scripting experience in Performance, Load and Stress testing with LoadRunner Extensive Experience in Websphere & Weblogic, and Windows 2000/XP/2003/2008, Unix/Linux/Redhat/Ubuntu.Solid Knowledge in Software QA Testing Methodology, RUP and Agile MethodologiesProfessional experience with testing tools: QTP, Quality Centre/ALM, LoadRunner, JIRA, and BugzillaExperience in Integration, Functional, Regression, Compatibility, Stress, and Load Testing using Black Box and White Box methods for Web-based applicationsAbility to manage a small testing team in building team work environment and motivating individualsBe resourceful and proactive in working independently without supervisionStrong abilities to conquer new technologies and tools, effective communication skill and strong team-work spirit

WORK EXPERIENCE

Automation Test Lead/Architect/Developer

Genworth Financial Canada (TCS), Toronto Jan 2012 – up to NowLed /Architected/Designed/implemented successfully Large-scale cutting-edge Data Driven Test Automation Framework of HP ALM/QC-QTP centralized Dev/test pattern available for multiple applications for multi-user development from scratchDeveloped automation test strategy and automation test plan as required Provided effort estimate of automation test development in HP-QC/ALM –QTP interactive environment Created a whole bunch of other automation development and testing artifacts like customized reporting testing tool, customized automation testing scheduler rather than HP QC/ALM built-in features from scratchIdentified candidates to be automated from existing test cases or created test cases for automation from test scenarios to be automated Administered/Developed/Maintained HP ALM/QC 11 and provided consultations and solutions to issues occurred to HP QC/ALM users Provided and generated daily real time customized project reports (testing progress, bug report, execution status report, with bar/pie charts in MS Excel sheets) upon management requests using HP ALM OTA and Excel VBAEffectively tracked and managed defects in HP QC/ALM timely provided project testing cycle reports from HP QC/ALM including defect and execution status timely everyday upon requestsSuccessfully built Automation Testing Regression Package with run duration of 2.5 hours, which is scheduled to run against designated testing environment everyday in fully unattended mode and automatically email testing results to the specified team members including IT/QA manager, test lead, and senior QA analysts Provided knowledge transfer, mentorship and training for junior members on Automation testing and scripting and effective usage of HP QC/ALM(up to 11)Hands-on Created from scratch 8 function libraries(2000LOC or so), 3 frequently used recovery scenarios, 100 QTP reusable actions for the AUT, and maintained Object Repository, configuration file from HP ALMDesigned Test database and table structures in which all testing data are savedCreated and implemented Test Database synchronization mechanism in VBAReported application errors or Debugged and fixed scripts or framework functions based on Daily Scheduled Run Task testing result reportsPresented automation activities and status in weekly Automation team meeting and monthly project meeting

Sr. QA Automation Developer/Analyst/ Consultant/System Engineer

Bank of ING Direct Canada (TCS), Toronto Feb 2011 – Dec 2011

Project 1. TPW; Project 2. DAWT (Enrolment; Account info; Client Information; Open account; Login )

Environment: Windows XP Java/J2EE, Oracle, Websphere, Solaris, QC/AML 11, QTP 11.0, IE7, FireFoxCreated Data Driven Automation Testing Framework and common function library using VBscript in QTPHands-on Automated 113 manual test cases of regression testing (running 6 hours 15 min)Proven robust scripts running 4-10 months for daily regression testingCreated ‘ScreenCaptureHtmlRes.vbs’ light add-in to generate Customized HTML Report with custom expected screen shotsProvided automation strategy and risk estimationMaintained and restructured the testing framework to improve scripts execution performance and efficiencyCreated User Interface automation tool in VB(named by HPQC Automator) to batch manage QTP scripts (saved in QC) And that greatly improved automation process, efficiency and reliabilityScheduled run of Multi-test sets in remote hosts, batch configured scripts’ run settings, customized backup and upload of QTP scripts between QC and Local machine, and sent email testing results of each test set automatically by using HPQC AutomatorProvided effective and best solutions to all toughest issues for the whole team during daily automation development activities Created automated tool(s) for the QA manager and manual tester to assist in reviewing technical documents efficientlyDiscovered unique reliable solution to automate French test cases for French version ApplicationsCreated 5 frequently used recovery scenariosProvided consultation/mentorship/knowledge transfer and automation best practices to automation testers/coworkersSuccessfully automated the most complicated/challenging and business critical scenarios test cases Successfully created with team fully automated regression testing pack running up to 11 hours Real time communicated issues/variances/defects and job progress status to QA manager

Sr. QA Automation Developer/Analyst/ Lead Consultant Sep 2010-Feb 2011

Travelex Canada (UK based company), Toronto

Global Payment Aliance Project for Bank Rakuten Japan

Environment: Windows XP Java/J2EE, Oracle, Weblogic, Solaris, QC, JIRA, QTP 10.0, IE6/IE7/IE8Reviewed user manual and QA documents and understood application business flow Created Keyword Driven Testing Framework and utility function libarySuccessfully automated most complicated/challenging and business critical scenarios among all the automation tasks of AUTCreated infrastructure library functions and Application level library functions from scratch in VBscriptHave built 163 automation testing scripts(running 5 hours), 65 reusable library functions of 1,900 LOC Successfully created fully automated regression testing pack of up to 5 hours already in use for daily regression testingDeveloped/debugged test scripts for the assigned test cases and scenarios in the existing Keyword Driven Automation Testing framework in Vbscript-QTPInvented compact Add-in to the Testing Framework to make the existing testing Framework extensible and strongerProvided consultation/mentorship/knowledge transfer to automation testers/coworkers Provided solutions to technical hardship issues in QTP scripting environmentBuilt smart robust scripts with strong run-time error/exception handling abilityCreated self-adaptive scripts to automatically adapt to challenging/unstable/changing QA testing environments.Real time communicated issues/variances/defects and job progress status to QA manager/developer/automation technical leadCreated tool with UI in VBA(macro) to batch manage QTP scripts in QC, including backup in local machine and upload to QC, scheduling, and updating run setting using AOM and OTABuilt reusable library functions in VBscript in QTP for AUT in pursuit of full coverage Exhaustive testing with high reusability and maintainability within the automation testing framework Scripted by Combined Object repository and descriptive programming techniques. Maintained and merged object repositoryBuilt automation scripts documentation real time help subsystem using Excel VBA(macro) to guide non-automation testers running automation scripts flexibly and effectivelyCreated useful effective tool using Excel VBA(macro) to assist in merging Object Repositories and remove redundant objects/Keywords

Sr QA Automation Analyst/Engineer Nov 2007 – Apr 2010, Toronto

Web CRM Project

Environment: Windows XP/2003 Server, web services, IIS 6.0, SQL Server 2005, ASP.net, .Net Framework 2.0/3.5, IE 6.0/7.0/8.0, FireFox 3, QTP, LoadRunner, QC 9.0, bugzilla, Subversion, VMware WorkStation 6.5Reviewed BRD and manual functional test cases in QC and estimated automation effortsCreated and architected Keyword Driven Testing Framework and infrastructure function library in QTP/VBscriptDesigned and developed automation test scripts from scratch in QTP-VbscriptCreated/debugged directly 105 robust smart scripts stored in QC for end to end regression testingIdentified issues or fixed script failures after each automation regression testing for every single new build/releaseRaised tickets in QC once issues verified as defects which caused failures to scripts Found out workarounds for unconventional objects which cannot be captured or assigned values via regular approachesScheduled and Executed Regression Automation pack for new builds and versions in HP Mercury QCImproved automation process by restructuring Testing framework and created automation tool in VB using both OTA and AOMDeveloped automated test scripts using VuGen in LoadRunnerEnhanced Vuser Scripts by Parameterization, adding Transaction Points and Rendezvous PointsPerformed manual or automated correlation to handle dynamic response values.Designed various scenarios as per business requirements using Controller in LoadRunnerSet Monitors in Controller for real time monitoring performance data changing graphs as definedExecuted load and stress testing in LoadRunner Analyzed results identified bottlenecks of the system and estimated risks and issues using LR Analysis tool, and generated performance testing reports Communicated with manual testers or BAs to ensure each automation script works the way as business requiredCoordinated automation work activities within the testing team Supervised junior automation testers on VB scripting, debugging in QTPDocumented automation results, conducted analysis and generated automation testing report summary

Merchant Payment Gateway System

Environment: Windows, IIS, Visual Studio 2005, SQL Server2005, C#.net, ASP.NET, HTML, LoadRunner, QTP, Quality CenterPrepared Test Plan according to the business requirementsCreated detailed automation strategy and estimated automation development effortsCreated 65 proven reliable reusable scripts from scratch in Testing Framework in QTP-VBscript within aggressive timelineCreated 23 reusable utility functions in VBscript in QTP to promote automation tasksScheduled and executed automated test scripts by creating external script management tools in VB using AOM and OAT techBuilt and maintained and debugged automated sanity pack and regression test suitesIdentified and report product deficiencies by analyzing automation testing resultsExtensively used SQL Queries for data handling in back end testing.Designed Test Scenarios using Controller in LoadRunnerExecuted Performance Testing under different load conditions Using LoadRunner to observe the behavior of AUTPerformed Performance, Stress and Load testing using LoadRunner from QCAnalyzed testing results and Graphs like Throughput, Hits per second and Transaction Response Time to identify/isolate problems and system performance bottlenecks.Administered QC, and customized and supported for current automation project in multiple QA environments as needed Timely communicated issues and problems and made recommendations to development team by analyzing automation regression testing results

Online Healthcare System

Environment: Windows 2000/XP/2003 server, JAVA/J2EE, SERVLET/JSP, EJB, HTML, SQL Server 2005/Oracle 9i. Websphere 6.0, Quality Center, QTP 8.2, Bugzilla, SQL developer, ToadInteracted with BAs, Developers, QA analysts and SME to work on the BRD Provided strategy, planning and estimation of ongoing project automation effortDeveloped/debugged hands-on 49 automated test scripts for new and regression test cases in existing testing frameworkCreated 35 infrastructure library functions from scratch using VBScriptTook an ownership in implementing reliable automation process for fully automated regression testing packageMaintained automation test scripts per UI changes/change request/defect fixes deployment in QTP/QC integrated environment Conducted root cause analysis to failures and provided accurate reasons and solutions/fixes/recommendationsCreated and Enhanced Vugen scripts and executed load and stress testing in LoadRunner Analyzed results using LR analysis tool, identified bottlenecks of the system and estimated risks and issues Wrote SQL Queries and performed database testing in Management Studio Created integrated utility tool in VB using AOM and OAT techs as well as Object Oriented Programming concept to schedule automation scripts in an unattended mode on remote hosts

QA Automation Analyst/Tester Nov 2005 – Oct 2007

Qlogitek Inc., Toronto

Online Banking System Project

Environment: Windows 2000/XP/Server 2003, UNIX, Websphere, JAVA/J2EE, EJB, JSP, SQL Server/Oracle, DB2, QTP, LoadRunner, TestDirectorCollaborated with other Automation engineer and implemented Data Driven Automation Framework using QTPCreated 39 infrastructure library functions in VBscript in QTP for the testing frameworkCreated Automation Test Strategy and Test PlansDeveloped/debugged automation testing package(57 scripts) in Vbscript in QTP from scratch by combined using Object repository and Descriptive Programming with runtime Error Handling, Script Debugging, and Database Created utility tool in VB(macro) to set up environment to schedule continuous test run using AOMFixed scripts or raised tickets after completing run of automation testing package in TestDirectorMentored and knowledge transfer to Jr. Testers on QTP Identified automation candidates from manual functional test cases and prioritized based on business needs and complexityCreated/ enhanced scripts according to the defined business scenarios using LoadRunner Designed and scheduled scripts execution and executed load testing and stress testing Analyzed and documented results using LR Analysis tool and reported bottlenecks, risks and issues Executed SQL scripts and wrote SQL queries for manual back-end testing Communicated with BAs and client support to guarantee automation development as required

Online Shopping Retailing System

Environment: LAMP, Windows NT/2000/XP, IE 6.0/7.0, FireFox 3.5, Test Director 8.0, Bugzilla, Subversion, LoadRunner 7.8, QTP 7.5Reviewed software requirement specifications and developed testing requirementsDeveloped/debugged 46 automated test scripts in QTP Data Driven Testing Framework for the assigned test cases and scenariosCreated infrastructure library functions and application level library functions from scratch in VBScriptCreated automated scripts for cross browser compatibility testing(for firefox)Provided consultation/mentorship/knowledge transfer to QA tester/colleagueWrote performance testing requirements with peak and critical traffic situations. Created LoadRunner scripts and enhanced corresponding to designed business scenarios Analyzed results Using LoadRunner Analysis tool and identified bottlenecks after completion of load and stress testing Used Bugzilla for tracking defects Documented results and provided advice on tuning up the system. Performed Functional, Performance, Security, UAT, Compatibility and Regression Testing Developed SQL Query scripts and Performed database Integrity Testing Assisted in manual testing of functionality upon requestGenerated reports and documents for the entire Test Process and Test Results using TestDirector

Java Developer & QA tester 2000-2003

Institute of Software R&D in ZUT (Hangzhou, China)

Online Banking Management System

Environment: QTP, Loadrunner, Test Director7.2, Java/J2EE, Tuxedo,Weblogic, Oracle 8i, DB2,Unix, Windows 2000/NT/ XP, Mainframe, IE5.0, JDBC,Java applet, XML, HTML

Medical Health Insurance System

Environment: TD 7.6, UNIX/ windows 2000/NT/XP, SQL Server 7, Oracle 8i, Java/J2EE, JSP/SERVLET, HTML, XML, JDBC, Weblogic, Apache Http Server, JbuilderX

Web Medicare Management System

Environment: Windows 2000/NT, Http Apache, SQL Server 7, Oracle, Weblogic, C++, JAVA/J2EE, JSP, JMS, XML.

Certification: IBM WebSphere Application Server, Network Deployment V6.1, Core Administration

Education & TrainingBS Beijing University of Aeronautics and Astronautics, Aerospace Power Engineering(Accredited by WES)Training on CSTE(Internal Training course 30hrs)Training on Oracle 9i DBA (Internal training course 40hrs)

References upon request

Contact this candidate