OBJECTIVE:

• Sr. Software Quality Assurance Consultant /Sr.QA Analyst/QA Specialist

SUMMARY:

• More than ten years’ strong hands - on Quality Assurance (QA) and Software Testing experiences in large and complex commercial IT systems, including Web-based Application, Mobile Device Application, Data warehouse and BI Reporting System, Web Service and Client/Server Application.
• Master Degree in Mechanical Automation Engineering and CSTB, ISTQB Certified Tester with 100% Pass Score.
• Worked in Telecom, Retail, Financial and Insurance industries. Participated complex QA projects including:
• Canadian Tire SAP CAR Customer Activity Repository Project: data migration to Google Cloud Platform
• Aimia Loyalty Program-Information Protect Mobile Application with iOS and Android Devices
• Loyalty Program-Fulfillment Data ETL Process with Walmart, Canadian Tire, Banks: RBC, BMO, NBC
• Telecom Real-Time Charging and Billing Solutions to handle prepaid or postpaid customers’ accounts,
• Roaming charge cross Country board and Tax Calculation cross Canada different Provinces Tax Rate
• Social Media Project-Big Data Exchange with worldwide well known Media: Facebook and Twitter
• Tokenization Security Projects follow Payment Card Industry Data Security Standard (PCI DSS)
• Web Content Accessibility Guide Applications meet WCAG2.0 Guideline
• Doctor’s Billing Applications; Doctor’s Diagnosis Application with Blackberry, Bluetooth
• Confidential Corp E-commerce Foreign Exchange FX/ International Money Remittance System
• Rogers Telecom Expense Management System
• Telecom Mobile Subscribers Analysis Data Warehouse and BI Reporting
• Confidential Agent CRM System and Commission Management System
• Confidential Company Policy Issuing System, Claim Management System
• China Construction Bank Personal Housing, Automobile Mortgage Loan Insurance System
• Proficiency in Automation Test tools Selenium, QTP (HP QuickTest Pro), JMeter and LoadRunnerStrong ability in testing OLAP, Data Warehouse and Business Intelligence(BI) Reporting system (Oracle 11g, IBM Cognos Reports, PowerPlay). Performed thorough testing of Extraction, Transformation, and Loading (ETL) processes in Telecommunication BI reporting system. Good at UNIX and Linux command.Highly motivated, creative, detail and customer oriented professional with excellent documentation, analysis, and troubleshooting skills. Good team player, responsible, strong presentation and communication skills
• Depth understanding of business logic with strong QA Risk Analytical skill plus extensive Error Guessing experience which collected from many large commercial applications; Able to discover many critical and hidden defects in every project, to ensure that products or services meet and exceed customer expectations.
• Extensive QA knowledge and experience on Software Testing Life Cycle (STLC), Bug Life Cycle and Software Development Life Cycle (SDLC), including Water Fall, V-model, Agile(Scrum/Sprint), Rational Unified Process (RUP) and CMMI. Proficient in planning and executing Black Box testing, System Integration Testing (SIT), User Acceptance Testing (UAT), including Functional, Exploratory, Regression, GUI, Database, User Interface, Usability testing, Performance testing and System testing.
• . Design, create, and execute test cases using JMeter based on business scenarios and business logic. Extensively use QTP Keyword Driven, Data Driven and Object Repository for web-based application UI, Function and Regression test Automation. Expertise in Web Service Functional testing via SOA testing tools SoapUI.
• Excellent QA skills in analyzing data model (Entity Relationship Diagram) in large database applications. Able to write complicated SQL queries in test data preparation and test cases development. Proficient in using commercial RDBMS and tools Oracle, MySQL, Microsoft SQL Server, T-SQL, PL/SQL and SQL*Plus.
• Solid QA skills in test and defect management by using QC (HP Mercury Quality Center), HPALM (HP Application Lifecycle Management) to document requirement, test cases, create test result reports and defect reports, in order to manage projects test progress; Well versed in other QA defect management tools such as JIRA and Bugzilla; Expert in Microsoft Office (Excel, PowerPoint).

TECHNICAL SKILLS:

Skills: Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC), Waterfall, V - model, Agile, Scrum, Sprint, XP,Test Driven Development (TDD), Rational Unified Process(RUP), and CMMI Black Box testing, System Integration Testing (SIT), Alpha, Beta, User Acceptance Test (UAT, BAT, PAT), Functional, Exploratory, Regression, GUI, Security, System testing, Manual testing, Automation testing HP Quality Center (QC), JIRA, Postman, HP Quicktest Pro (QTP), Selenium, JMeter, LoadRunner, WSDL, SoapUI MySQL, SQL Plus, SQL Navigator, PL/SQL, SQL, Microsoft SQL Server2000, 2005, Oracle, IBM DB2/400, Big Data, Hadoop, Data Base, Data Warehouse, Cognos, Multi-Dimension Cube, PowerPlay, Putty, TOAD Java, J2EE, HTTP, HTML/CSS, JavaScript, XML, XHTML, PHP, VBScript, FTP, Network UNIX, IBM AIX, Linux, MS-DOS, VMware, IBM WebSphere, Tomcat

PROFESSIONAL EXPERIENCE:

Sr.Software Quality Assurance Consultant

Confidential

Responsibilities:

• Reviewed business requirements discussed, and clarified business requirements details and stories with BA/PM and developers. Used different strategies to prepare testing data including positive data, negative data, boundary value, etc. Followed business requirements wrote test cases covered different combination scenarios.
• Performed Data Validation Testing and run file ingester. Well versed at Linux commands. Accessed testing environment using Cmder as custom console application. Verified the required services were available and present; Run script to start required services; Process different types files via file-ingester. Added testing files using WinSCP tool. Started Consumer to check if the file was parsed correctly and the data was sent to Kafka Data topic. Verified all the resultant records and data on Kafka topic to make sure data’s correctness.
• Used SAP CAR to access database tables. Entered transaction code, entered Table Name for data browser, retrieved all data related to that table or entered some filters to find specific information.
• Performed API Testing, tested Omni-channel Price and Promotion (OPP) and Omni-channel Article Availability (OAA) APIs through POSTMAN. Verified product Price and Promotion data, and product inventory availability.
• Followed business logic and performed Integration Testing, End-to-End Testing, Front-End Testing, and Cloud Integration Testing. Used JMeter to simulate thousand users search hundred products at different stores price, promotion price and inventory, tested APIs performance, analyzed throughput, average response, bottleneck.
• Worked closely with Business Analysts and offshore developing team. Used Jira to manage all test cases and defects. Found many critical and major defects. Actively participated in QA process, helped team to finish testing tasks before deadline, and accelerated team’s testing speed during Agile sprint.

Sr.Software Quality Assurance Consultant

Confidential

Responsibilities:

• Analyzed business requirements, discussed and clarified business requirements details with BA/PM and CTO. Coordinate the whole end to end testing process. Found business requirements’ mistakes, guided front-end, API and back-end developers understand requirements correctly, and prevent further loss of time and money.
• Well versed at API testing, tested all APIs to make sure APIs can seamlessly integrate partners’ products into store or plug products into other e-commerce stores. Used Postman to test all APIs to make sure all APIs work smoothly with back-end logic and front-end request. Designed positive scenarios to fulfill business requests, created all positive data to get through the whole flow. Designed negative scenarios to cover all error handling, prepared negative data to trigger all error messages, also verified boundary data’s correctness.
• Experience with Agile environment, properly estimate sprint tasks’ fulfillment, procedure, and schedule. Strong data-base query ability, found many major existing production issues in short time. Strong bug triage ability found the root cause of defects, and assigned defects to proper coding team. Guided and coordinated offsite front-end team and offsite back-end team finish sprint tasks ahead of schedule and speed up projects.
• Designed test cases, test scenarios, requirement traceability matrix to ensure full coverage; fully implemented all test cases and analyzed test results. Used Jira to document defects and test cases daily, used confluence to manage related documents and results, and used stash to manage automated test cases.
• Performed Application Testing in Different Network Signal Strengths: No Network; Intermittent connectivity; Strong Network Signals Presence. Also performed application testing with various Network Types.
• Tested multiple ETL projects to fulfill related project data transaction with major banks: RBC, BMO, NBC, etc.
• Tested Social Straw application, performed all end to end testing, used Selenium to automate the whole process from create, like, unlike, comment, and delete post from Social Straw to Facebook and Twitter.
• Used JMeter to perform Omnicare whole dynamic billing processes; automated repeated use of RESTful APIs; added regular expression extractor for dynamic values; added Response, XML, and JSON Path Assertion to verify response data; and managed APIs effectively and efficiently. Used JMeter JDBC to access back-end data to verify the data correctness. Created large quantity users to access applications, simulate multiple processes and threads at the same time, analyzed application’s response time, throughout, failure, and bottleneck.
• Used Selenium to automate Omnicare application’s flow, used Maven run the standard build lifecycle (compile, test, deploy), and automated deployment process with Jenkins.
• Tested multi languages (English, French, and Mandarin) projects. Used NVDA tool to test Web Content Accessibility Guide Applications and meet WCAG2.0 Guideline. Found the third-party Google’s WCAG defect.

Environment: Hadoop, Hive, MongoDB, HBase, Solr, Kafka, Storm, Angular, Linux, MySQL 6.0, ODBC 5.0, Java, PHP, HTML/CSS, XML, JavaScript, Tomcat, Firefox, IE, JIRA, Snagit10, Selenium, Maven, Jenkins, JMeter, Xenu, Jing, NVDA

Quality Assurance Analyst (Foreign Exchange and Multicurrency Remittance Testing)

Confidential

Responsibilities:

• Analyzed business requirements, discussed and clarified Foreign Exchange Table default value concept and exchange rate calculation with PM/BA/Developer and CFO; Designed test cases, test scenarios, requirement traceability matrix to ensure full coverage; Fully implemented all test cases and analyzed test results.
• Prepared and created testing data to ensure the remittance procedure follows KYC(Know Your Customer), Dynamic Foreign Compliance rules, FINTRAC (Financial Transactions and Reports Analysis Center of Canada) and FinCEN (Financial Crimes Enforcement Network in the U.S); New registrant of First Global are not on Terrorist or money laundering watch list obey the rules of OFAC (Office of Foreign Assets Control is an agency of the United States Department of Treasury) /OSFI (Office of the Superintendent of Financial Institutions Canada), Anti-Money Laundering and Anti-Terrorist Financing (AML/ATF).
• Designed, created and executed more than 200 functional, regression and UAT test cases; Built positive, negative, and boundary testing data; Coordinated resolution activities across team and provided technical input during work with offshore development team; Created Trans border User Manual and Instruction Demo through Jing and Camtasia for remote international agents and users .
• Executed cross browser testing, operation system and handset testing; Used Selenium to fulfill Money Remittance process automation, created automation test cases to monitor code changes. Found critical defects including, duplicate user registration, Exchange Rate setup, and Base Service Charge record and so on.
• Logged defects in Jira and helped developers to debug and fix; Contributed advice about sur-charge calculation, remittance records pagination, Foreign Exchange Rate setup, agent payout process and so on; Performed appropriate escalation of wrong currency remittance statistic and other foreseen risks in project. Documented testing summary report for management decision making.

Environment: Linux, MySQL 6.0, ODBC 5.0, Java, PHP, HTML/CSS, XML, JavaScript, Tomcat, Firefox, IE, JIRA 3.13.4, Snagit10, Selenium, Xenu, Jing, Camtasia, TeamViewer 8

Sr. QA Analyst, QA Specialist (Database, DW/BI, Back-end Testing)

Confidential

Responsibilities:

• Performed back-end testing by extensively using SQL queries to verify Database correctness according to business workflow; Utilized TOAD to verify and update Database; Inserted records to facilitate testing; Caught Apache server log through Putty for Database Verification and Validation.
• Found SCOA code in Payment Resend module showstopper defect. Detected duplicate calculation of Balance Amount in Invoice Reset Procedure with Outstanding Dispute. Discovered very difficult defect: Invoice Credit Amount reconciles with Dispute mistake using Boundary Value Analysis technique.
• Reproduced defects, communicated with QA manager and developers, assisted with the resolution of problem fixes, validated the fixes provided by the development team, and confirmed the fixes were working properly.
• Used QTP Data Parameterization, Keyword Driven and Checkpoints as script enhancement. Verified Back-End Ban, Invoice Status data with front-end, employed Data-driven and Object Repository QTP techniques to create Dummy Invoice, analyze Ban Status, and build reusable function library.
• Used QC (HP Mercury Quality Center) in test and defect management, effectively planed, executed and managed test requirements, test cases, and defects. Imported requirements and test cases from excel to QC. Created daily and weekly test result reports, defect reports to help manage the whole project test progress.
• Designed test cases, test scenarios by following business procedure. Analyzed project functions and system modules, improved User module function, and offered valuable advices for redesign GUI of Provider module.
• Actively involved in Project STS Agile testing methodology, participated in Daily Stand Up meeting. Involved in User, Provider modules enhancement with Scrum team. Maintained Product Backlog with tasks of the testing team efforts for upcoming tasks. Participated in Sprint planning sessions and review meetings.
• Provided suggestions for current functions based on STS Business Requirement Document, performed Functionality, Integration, User-interface, Usability testing and Regression testing. Used Selenium IDE to monitor customer order process and perform regression test.
• Completed End-to-End Exploration testing for STS project. Discovered in User module two show stopper defects, duplicate orders defect, restaurant location defect, Providers update defect, and many other defects.
• Conducted research and compared load testing tools SoapUI, LoadUI and LoadRunner. Created test suite for Web Service used SoapUI and LoadUI. Tested and analysed application performance under loading.
• Performed test using LoadRunner, created and ran Virtual user script in Load Generators, inserted transactions and parameters, utilized Controller to monitor load test. Performed security test by using Netsparker to analyze and penetrate STS Vulnerability and assisted developer team to improve password security. Used Xenu Link Sleuth to test all modules link and found severity broken links, Store bad local link and Rating orphan files.
• Used HP Mercury Quality Center (QC9.0) extensively for writing and executing test cases, test results maintenance, defect reporting and tracking, and for generating detailed test reports.
• Reviewed Business Requirement Document (BRD) and communicated with Business Analysis and developer to clarify ambiguous content, undefined Pending Deactivation concept and wrong calculation formula.
• Configured the Oracle client to connect to remote Oracle server. Used TOAD for Oracle to draw Entity Relationship Diagram (data model) to analyze Star Schema and all dimension tables relations.
• Designed and executed test cases based on different business scenarios. Used test traceability matrix, extracted large numbers of sample data to verify and cover all dimensions and measures. Performed extensive testing of Extract, Transformation and Loading (ETL) processes. Verified source data were transformed correctly to staging, CRM and SA system.
• Responsible for testing Cognos Reports/Cubes, running complex SQL queries with TOAD against source system to validate and ensure the correctness of data; Detected wrong statistic handset level defects in fact history table and wrong calculation of Pending Deactivation Counts defect.

Environment: Linux, MySQL 6.0, ODBC 5.0, Java, HTML/CSS, XML, JavaScript, Tomcat, Firefox, IE, Toad for MySQL 6.0, Putty 0.60, HP Quality Center(QC) 9.0, JIRA 3.13.4, Snagit10, HP QuickTest Pro(QTP 10.0), Selenium, Eclipse, JUnit; LoadRunner10.0, LoadUI1.5, SOAP, WSDL, SoapUIPro 4.5, Xenu; Windows server 2008, Oracle 11g, Toad for Oracle11, Oracle PL/SQL, UNIX, Shell script, Peoplesoft CRM, IBM Cognos Transformer, Report Studio, PowerPlay.

Software QA Analyst

Confidential

Responsibilities:

• Responsible for testing Telecom COMS application. Involved in gathering of design documents, business requirements and release documents. Participated COMS customized for different request dealer and retailer.
• Proficiency in Personal Credit Card Processing Business Logic, improved and redesigned Credit Check, Credit Card Processing modules for administrator tracking Client Credit Check approve or not, Order approval process, Deposit Payment status. Redesigned Inventory Management modules, and made it easy to track and monitor all the satellite TV installation hardware devices, Receiver, Satellite Dish, Switch, Handset, etc.
• Performed testing of applications to make sure applications worked correctly with different browsers: IE, Chrome, Fire-Fox and Safari. Created application User Manual, Instruction and provided for users, regulated data entry standards, release notes and issued to users.
• Created Satellite TV Availability Database to reduce the wasteful of technician work force, time, gas, and duplicate installation. Improved company reputation, service quality, and saved budget.
• Found WCM Commission Chargeback with bonus calculation mistake, Claim Sales and Installation Commission defects. Executed Team Lead’s Bonus verification, and improved Deposit Management function.

Customer Service Representative (CSR)

Confidential

Responsibilities:

• Served potential customer in the demonstration kiosk at various sites and attended Confidential monthly sales tactics seminars. Introduced Confidential telecommunication products Satellite TV, Home phone, Internet services for customers and advised clients on the different packages that would best suit their needs. Consistently met and exceeded sales goals.

QA Lead, Software QA Analyst

Confidential

Responsibilities:

• Managed the execution of multiple and complex test plans, coordinated with BA, developers and QA team, adjusted test schedule and arranged resources to ensure testing projects meet deadline.
• Followed Software Development Life Cycle (SDLC), QA methodologies, Business Logic, created detailed test scenarios and test cases to validate applications functionality, and significantly increased the test coverage while minimizing number of test cases through Requirement Traceability Matrix.
• Organized testing team to review and analyze Business Requirement Document (BRD). Guided and scheduled QA team to test applications Functionality, Reliability, Usability, Portability, Compatibility and Consistency. Provided daily and weekly test progress reports to manage testing activities.
• Participated in the definition and design of ACS, SCCS and enhancements meetings. Assisted business with defining QA acceptance criteria; participated in the process of generating metrics related to BAT; analyzed test coverage and results; collected issues through Beta, User Acceptance Testing (UAT). Demonstrated the applications to users and provided reviewing and activities to them.
• Lead the responsibility of verifying the applications overall functionality. Meanwhile, interacted with the users to upgrade and support the End-to-End functionality of the website, tested the UI, Database and associated of the applications for various releases to ensure the applications quality. Involved APMS an interactive application with ability to get Online Quote, Bind an Account and print new and renewal Policy by using the different interfaces, Database technology, built and executed complex test cases in Excel.
• Developed Newcomers material and conducted sessions to all new team members covering product architecture, user instruction and testing process.
• Verified Charge Agency Service premium payment transfer with Client Bank Account, Credit Card, Balance, Due Date, Late Payment Charge, etc. Detected many hidden and difficult defects. Reported defects with detailed description and recommendation to resolve defects.
• Analyzed Automobile Premium Input Data and calculated Output data based on business rules and algorithms. Found Automobile Premium Quotation and Policy different Rounding calculation defects and assessed defect impact to business. Discovered New Auto Depreciation defect, Group Discount defect and other defects. Contributed valuable advices to improve applications quality and stopped potential loss for company.
• Executed the testing of China Construction Bank Personal Housing Mortgage Loan, and Personal Automobile Mortgage Loan Insurance System; Tested and Verified different parts of the applications: information collection function; repayment ability and risks analysis; Premium calculation of Performance Guarantee Insurance; Prepayment premium calculation.

Testing Engineer

Confidential

Responsibilities:

• Designed, researched on the structure of metal cutting tool, and designed numerical control fixture and equipment for manufacturing the ball nose end mill. Investigated and analyzed mechanical failures reasons of many kinds of mechanical parts, studied the methods of improving mechanic performance of parts. tested and inspected: High Building’s Frequency; Cable’s Strain of Suspended and Pulled Combination Bridge; Metallic and Non-metallic Materials Acoustic Data under Loading and Stress. Provided real time inspection on the spot and security feasibility analysis.