Andrew Colp

Experience

• 

  Wawanesa Insurance (via Kelly Services)

  Aug 2006 - Oct 2007

  Quality Assurance Analyst

  • Worked extensively with business documentation to plan test cases.• Designed, executed and evaluated tests using Quality Center application.• Logged defects in a centralized tracking tool.• Worked on functional and data conversion test teams for an insurance solution software project and helped develop and execute test cases for a Corporate Intranet project.• Ran database queries with PL/SQL to compare data before and after its conversion from the legacy system to the new program. Show less

• 

  EISI

  Jan 2008 - Jan 2010

  Quality Assurance Specialist

  • Executed test plans according to established processes, demonstrating the ability to handle multiple projects simultaneously and continuously deliver on deadlines.• Analyzed requirement documents in order to create accurate and streamlined testing checklists.• Logged and verified defects. Gained a reputation for high quality bug entry.• Led the QA effort on some smaller projects.• Created templates in Word for department documents, including the Quality Assurance Test Report (QATR). Show less

• 

  Zywave (formerly EISI)

  Jan 2010 - Feb 2013

  • Owned the quality assurance effort for the Profiles Premium family of products.• Managed and mentored a team of new QA analysts, helping them to get quickly up to speed on the product line, and training them in the correct use of tools and processes.• Provided QA estimates to project management, acted as QA representative in project meetings, and handled resourcing of team members.• First point of contact for Tier 3 support, troubleshooting production issues and escalating them as appropriate.• Worked closely with development team in problem resolution.• Oversaw the switch to a new set of tools, including JIRA and Confluence, and the adoption of new testing techniques, including Selenium-based automation testing.• Communicated with integration partners and clients.• Deployed builds to QA test environments.• In addition to management responsibilities, continued to act as the primary tester on some projects while offering support to team members leading other projects. Show less • QA lead for successful projects in both waterfall and agile environments.• Executed test checklists across QA, UAT, Pre-Prod, and Production environments.• Wide-range of testing experience: regression, acceptance, calculation, data conversion, black box, browser compatibility, iPad compatibility, and more.• Found, logged, and verified issues. Worked with several bug tracking systems, including Test Track Pro and JIRA. • Prepared quality assurance test reports at regular intervals and upon project completion.• Analyzed business requirements in order to provide testing estimates, identify any potential design issues, and create test plans with full coverage.• During a period of organizational change, was moved over to work on different product line and was able to become proficient very quickly. Was subsequently able to switch between product lines to meet changing business demands. Show less

  • Senior Quality Assurance Analyst, Team Lead

    Aug 2012 - Feb 2013

  • Intermediate Quality Assurance Specialist

    Jan 2010 - Aug 2012
• 

  Apptius Computer Solutions

  Apr 2013 - Dec 2019

  Consultant, Quality Assurance

  Client: The North West Company (via Solvera Solutions) (January 2019 – December 2019)• Wrote and executed queries in SQL Server to verify that data was being correctly converted from an existing retail item management system to a new system and to ensure that data integrity was being maintained.Client: The Property Registry (April 2014 – December 2018)• Lead IT QA tester for three externally facing modern web applications built using an Ember.js front-end and a REST API back-end.• Provided QA for a project that converted an IBM mainframe accessed via terminal emulation software to a modern desktop application backed by a relational SQL database.• Tested several projects aimed at integrating existing web applications with newer web applications and systems, including the conversion of legacy applications from a DB2 database to a SQL database in order to integrate with a new accounting system.• Performed browser compatibility testing using BrowserStack, developed automated test scripts with TestComplete, logged issues using JIRA, and wrote SQL scripts to query and create test dataClient: Friesen's Corporation (January 2014 – April 2014)• Providing QA for a new version of a design and management web application for high school yearbooks developed following an agile methodology.Client: Worker's Compensation Board of Manitoba (April 2013 – December 2013)• Performed Integration and System testing for a JEE thin-client application running on WebSphere.• Wrote and executed test cases based on User Interface Specifications and System Use Cases following the Rational Unified Process (RUP) methodology.• Developed SQL queries with Toad for SQL Server to retrieve suitable test data and verify database updates were being made as expected. Show less

• 

  Solvera Solutions

  Jan 2020 - now

  Senior Consultant

  Client: The North West Company (January 2020 – Present)• Tested a series of Android apps developed for handheld personal data terminals (PDTs) to replace an existing suite of Windows CE apps• Used JIRA to log defects and prepared and executed test cases in Zephyr for JIRA.