Yefim Khaikin

CAREER OBJECTIVE

Work in a company where I can apply all my skills and knowledge to deliver the highest quality. My expertise allows me to be an asset for Automated/Manual Testing Solution Development applications.

PROFILE

18 years of extensive IT experience.

Strong background and hands-on experience in IT Quality Assurance and software development.

Dependable, hard-working, flexible, quick learner

Able to multitask, prioritize duties and meet deadlines under pressure

Worked in Waterfall and Agile environments in verticals such as Financial, Supply Chain, Billing and Insurance at companies such as Canadian Tire, Aviva Insurance Canada and CGI.

TECHNICAL SKILLS

Test Automation tools: QTP (5 years), Ranorex (1+ year), Selenium (3 years), Appium (1 year), Load Runner (1 year), SOAPUI, Runscope, Postman

Experience in Unit, Functional, Integration, System, User Acceptance, Installation, Load and Regression testing for GUI and back end (ETL/DB), automation/manual White/ Black box validation.

3 years experience writing test cases/scenarios in Behavior Driven Development (BDD) style using Selenium and Cucumber to develop automated test scripts.

Project Management tools: HP Quality Center (4 years), JIRA (5 years), Kanbanize SourceTree, Git

Program Languages: Java (10 years), Java Script, VB Script, VB, C/C++/VC++/C# (5 years), Groovy, HTML, XML, SQL

Web service protocols (SOAP, WSDL 2 years), Restful API (JSON)

Data Bases and tools: Oracle 10gi, 11, Microsoft SQL Server 2005, 2008, PostgreSQL, DbVisualizer, SQL Navigator, IBM DB2 Command Editor, Oracle Business Intelligence

OS: Windows 7,8 and 10, Linux/Unix.

5 years experience in an Agile environment

EDUCATION AND CERTIFICATION

B.Sc. in Information Technology. University of Petroleum and Chemistry, Baku, Azerbaijan 1981

Training: UNIX and UNIX shell programming (1995), VC++ and VB programming, 1996

PROFESSIONAL EXPERIENCE

QA Automation Developer, QA Consultants

Toronto, Canada

July 2017- Present

Project: A fully automated on-line system that is tied to the company back office systems as well the direct deposit mechanism with Canadian banks and tracks consulting services, including time and expense tracking, payment and billing modules.

Analysed test requirements and automation feasibility.

Involved in Automation Test Plan Preparation.

Generating Test Scenarios, Test Cases, Test Scripts documentation and test Data collection.

White/Black box Data base validation.

Involved in design, development and environment setup of automation framework

Executed Functional, Integration, System and Regression Testing GUI/db and Reporting defects.

Development Environment: Eclipse, Java, SQL, Selenium WebDriver, Maven, Cucumber, Agile, Windows 7, 8 and 10, SQL Server, Jira.

.

QA Specialist, Crescendo Technology

Toronto, Canada

March 2017 – June 2017

Project: Web on-line Pinnacle Sports Betting System.

Planned, scheduled, monitored and reported on all activities related to projects using Agile-testing methodology.

Developed and executed Test Cases in SOAPUI for Bet Acceptance API (SOAP, REST): Generate Test Values, Create Game, Adjust Line, Place Bet (Straight, Parlay, B2B, Specials). Data (JSON) processing logic was done on Groovy (Java) language.

Developed and executed Regression testing on Runscope: Bets API (B2B and public). Snippet code and scripts were done on JavaScript

Validated data with Postman API Helper functions

White/Black box Validated data on Microsoft SQL server with SQL queries.

Development Environment: Windows 8, SOAPUI, Runscope, Postman, Microsoft SQL Server, Kanbanize, SourceTree, Agile, Java, JavaScript, Groovy, SQL.

QA Engineer, Automation Developer, Audatex

Toronto, Canada

July 2015 – February 2017

Project: Auto shop applications (SAAS) for Insurance industry (Audashop Manager, AudatexData Management and Audatex Insight Plus).

Planned, scheduled, monitored and reported on all activities related to projects using Agile-testing methodology, participated in daily stand-up meetings, status and retrospective meetings.

Create Test Strategy, Plan and framework for Functional and Regression Automation.

Developed and executed Test Cases (manual/automated) for interfaces/ Black box db validation

Maintained QA Stories in JIRA and ensured requirements coverage through traceability to test cases

In Audashop Manager Project developed automated tests suites for modules: Import/Export Estimates, Work Order/Parts/Labour Management (General, Insurance, Line Items, Totals and Payments), Contacts and Reports subsystems. Developed automation testing using Appium automation tool and Selenium for time tracking mobile reporting.

In AudatexData Management project designed test cases for Customer, Insurance Company, Vehicle Make module validation. Validation was done by executing sql queries on PostgreSQL db for verify ETL outputs of data into Data Warehouse/Data mart.

In Audatex Insight Plus project designed test cases for Audashop Work Order estimations Reports in Oracle Business Intelligence based application. Validated Dimensions and Estimation modules. For Audashop Manager to Audatex Insight Plus XML pumping validation implemented automation testing framework and maintained up-to-date the automated scripts used in regression testing.

Automation projects were done on Ranorex tool. Test scripts were written using C#. They were used to test the completion of form fields (Audashop Manager) or XML values (Insight Plus pump) and to verify the correct results were returned from the database.

Automation frameworks for DriverCare (including mobile version) and DataMap projects were done on Selenium. Created Test cases using Element Locators and Webdriver methods (Eclipse, Java). Implemented Page Objects, Data Driven and Hybrid automation frameworks, Cucumber.

Development Environment: Windows 7 and 8, Oracle (11g), BI Reports, SQL Server, PostgreSQL, Jira, Ranorex, Selenium, Cucumber, VBScript, Java, C#, SQL, Agile.

QA Specialist, Automation Developer

Canadian Tire Corporation, Toronto, Canada

May 2013 – May 2015

Project: Automated Regression testing for ETL outputs of large Supply Chain.

Analysed requirements, defined automation test objectives and strategies. Created action driven/data driven QTP framework (Test Functions, Data Access Objects, Utilities, and Reports) integrated with HP QC for Black box testing ETL/db. Executed automated test scripts and analyzed the results.

Accomplishments: created automated solution helped exclude manual testing for large amount of Canadian Tire warehouse data and found discrepancies that could not be discovered with limited runtime test data.

Modified and executed manual and automated test scripts for Web based applications modules using QTP and LoadRunner (Black Box, Functional, Integration, System, Regression and Stress Testing).

Participated in daily the Agile/Scrum stand-up and project status meetings and reviews.

Administrated HP Quality Center for corporation projects, developed program to automate data transformation from project Tracking Software (Jira) and uploaded data to QC, performed Back end data processing by executing SQL Queries for managing information stored in system and user defined fields.

Development Environment: Windows 7 and 8, Oracle (11g), QTP, QC, Jira, VBScript, SQL, Agile.

QA Specialist, Automation Developer, QA Consultants

Mar 2010 - May 2013

Project: Aztech Doors & Windows web site development, January 2013 – May 2013

Planned, designed and managed Functional, Usability, User Acceptance, Compatibility and Security for e-commerce information (credit card) tests. Windows 2000/XP/Vista, IE7/8/9, Firefox, Chrome, Agile

Project: AVIVA Canada Inc., Nov 2011- Oct 2012, Connectivity-Portfolio Automated Transfer System for managing various Broker Management Systems (BMS) to Aviva System

As manual/automation developer I planned, designed and executed Black Box, Functional, SIT, UAT and Automation Regression tests, verified data identification, validation and synchronisation.

Defined and implemented test management and defect tracking procedures.

Development Environment: HP QC 10, QTP 9.5, BMS (TAM, SigXp, PowerBroker), Dashboard (Manager, Underwriter), Agile

Project: PostMedia (“National Post”), Aug 2011 - Nov 2011, Community Newsroom Platform of National Postweb application (subscription, updating credit card information and billing)

Planned, designed scripts and managed tests: Black Box, Functional, Regression, GUI. I run Performance tests, defined and implemented test management and defect tracking. I executed performance diagnostics utilizing varying degrees of load/stress test in order to isolate system lag. I worked closely with project managers, developers to ensure defects are correctly identified, fixed, and incorporated into system builds.

Development Environment: Windows 2000/XP/Vista, Macintosh, IE7/8/9, Firefox, Chrome, Opera browsers, Jira, WebStress, Agile

Project: Canadian Tire, May 2011-Aug 2011, Canadian Tire’s web based Loyalty Program application

Planned, designed and managed tests.

Defined and implemented test management and defect tracking processes and procedures. I performed Black Box, Integration, System tests to ensure all application interfaces and User Acceptance testing. I run Performance tests for Random and Sequence Login, changing private and secure data for Loyalty project bonuses.

Development Environment: Windows 2000/XP/Vista, Macintosh, IE7/8/9, Firefox, Chrome, Opera browsers, HP QC 10

Project: AVIVA Canada Inc., Mar 2010-May 2011, Broker Portal Pilot Hub, Portal Autograph Policy, Portal VIN Validation and HST management implementation

Designed and managed Integration, System, UAT and Regression tests of new/updated processes

Defined and implemented test management and defect tracking processes and procedures

Was responsible to verify ETL outputs of data into Data Warehouse/Data mart.

Created and executed SQL queries for report validation using IBM DB2 Command Editor.

Created scripts for Policies, Claims and other transactions verification

Developed and executed automated scripts using QTP for Regression Testing of Broker Portal Application.

Performed Deployment Verification

Development Environment: AS/400, Broker Portal, DB2, Oracle 9i, Unix (Solaris), Windows 2000/XP, SAP Business Objects XI, HP QC 10, QTP 9.5, LoadRunner, IBM DB2 Command Editor, VBScript.

Java Application Developer (2000 - 2010)

Contractor

I developed a Web based proprietary system for tracking consultant services (QA Consultants), multitier document management system (CMiC), Enterprise Planning platform for application lifecycle optimization (Blueprint Systems), multitier application for GM Canada (McLaren McCann), Broker Management System (CGI), Web Service Business-To-Business Integration System (WowGao Inc.), multi tier Business Management System (Intellectual Alliance Inc.), Management optimization System (J.D.Edwards, PeopleSoft).

Development Environment: Java, JavaScript, VC++, SQL, SOAP, XML

Contact this candidate