Avatar

Ken Horovatin

Data Analyst, Software Tester, and Web Developer

Horovatin Consulting Ltd.

Biography

Ken Horovatin is a life-long learner who is curious about all things science and technology. He has been involved in the computer and technology industries his entire career.

Interests

  • Data Science
  • Software Test Automation
  • Photography

Education

  • Diploma in Electronics Engineering Technology, 1980

    Okanagan College

Skills

Microsoft Windows

90%

Linux

75%

Databases

75%

R

90%

Python

60%

Docker

50%

Statistics

40%

Experience

 
 
 
 
 

Senior Analyst, IT Delivery - Finance

WestJet

Jan 2022 – Present Calgary, Alberta
Responsible for analyzing, testing, and reporting on the quality of internal data migrations.
 
 
 
 
 

Senior QA Analyst

C4i Training & Technology

Dec 2019 – Dec 2021 Calgary, Alberta

Responsibilities include:

  • Analysing
  • Testing
  • Automating
  • Reporting
 
 
 
 
 

QA Data Quality Analyst

Pason Systems Inc.

Mar 2014 – Oct 2019 Calgary, Alberta
Analysis, testing, and reporting on end-to-end data quality.
 
 
 
 
 

QA Automation Specialist

Pason Systems Inc.

Nov 2012 – Feb 2014 Calgary, Alberta

Created automated test scripts for the company's drill rig instrumentation products.

Maintained and extended the in-house test automation framework.

Created and deployed a RESTful web API and database for storing and reporting test automation results using Grails and MySQL.

 
 
 
 
 

Contract QA Analyst

Cenovus Energy

May 2012 – Dec 2012 Calgary, Alberta

Performed performance testing of the company's upgraded JD Edwards, Primavera and Maximo applications using HP Performance Center and HP LoadRunner.

Developed test automation scripts using HP QuickTest Professional on HP Quality Center.

Performed manual testing of various applications in the organization's Information Systems portfolio.

 
 
 
 
 

Co-Owner, Data Analyst, and Web Developer

Horovatin Consulting Ltd.

May 2012 – Present Calgary, Alberta

Formed a company to provide professional software testing and test automation services to industry in Calgary, Alberta.

Expanded to provide expert human resources services and custom salary surveys to Alberta municipalities and businesses in 2018.

Created customized salary surveys for municipalities and municipal organizations in Southern and Central Alberta.

Gathered, cleaned, and analyzed data to produce reports for survey participants and subscribers using R (RStudio) and Excel.

 
 
 
 
 

Software Test Manager

Shaw Communications

Feb 2012 – Apr 2012 Calgary, Alberta

Managed a team of testers working on the next generation of management systems.

Performed staff assignment, scheduling, hiring and performance reviews.

Acted as the test team representative in project planning sessions.

Managed external contractors providing performance testing services.

 
 
 
 
 

Senior QA Analyst

Worldplay (Canada) Inc.

Sep 2010 – Jan 2012 Calgary, Alberta

Tested and reported on the quality of the company's proprietary high-quality, low-bandwidth video encoder.

Introduced pragmatic test practices to an Agile software development environment. Lead tester of the company's leading edge video compression software.

Worked closely with developers, business analysts and other stakeholders to ensure testing met their needs.

 
 
 
 
 

Software Test Consultant

Alberta Electric System Operator (AESO)

Jun 2009 – Oct 2010 Calgary, Alberta

Performed manual and automation-assisted testing of the organization's custom electricity market management software.

Reviewed and revised test plans, test cases and test progress reporting systems.

Responsible for performance tests of an enterprise-wide upgrade of their Oracle database systems.

 
 
 
 
 

SQA Manager

Autodesk Inc.

Mar 2008 – Jan 2009 Calgary, Alberta

Managed a geographically dispersed team of Software QA Engineers testing multiple products to provide timely feedback to project and product management.

Responsible for staff assignment, scheduling and performance reviews.

 
 
 
 
 

Sr QA Developer

Autodesk Inc.

Nov 1999 – Mar 2008 Calgary, Alberta

Implemented test platform virtualization, a change that significantly increased the efficiency and productivity of the software test team using fewer resources.

Developed and maintained test plans, test cases, checklists and procedures that enabled the test team to find important software bugs quickly and efficiently.

Accomplish­ments

Online Courses and Certificates

Robot Framework Test Automation - Level 1 ( Selenium )

Installed and configured the Robot Framework test automation tool, including libraries.

Wrote and executed test automation scripts using Robot Framework and libraries such as Selenium Webdriver and Squish. Created Robot Framework keywords to implement the tests, and wrote tests using Robot Framework's version of the BDD Gherkin syntax.

See certificate

Automate the Boring Stuff with Python Programming

Explored using the Python language to automate tasks including generating and updating Excel spreadsheets, crawling websites to pull information, parsing PDF and Word documents, sending email notifications, and controlling the mouse and keyboard.

Used Python's debugging tools to find bugs in script code.

See certificate

Node with React: Fullstack Web Development

Built and deployed fullstack web apps with NodeJS, React, Redux, Express, and MongoDB.
See certificate

Data Science Specialization

Data Science Specialization Certificate earned through the successful completion of the requisite courses (listed separately).
See certificate

Data Science Capstone

Analyzed a collection of text resources in order to develop a text input prediction model similar to the SwiftKey keyboard application for mobile text entry.
See certificate

Developing Data Products

Developed a ‘Shiny’ web app for visualizing historical data from the Canadian Ice Thickness Program.
See certificate

Practical Machine Learning

Developed a machine learning algorithm to create a model for assessing the quality of a certain category of weight lifting exercise from data gathered from various test subjects.
See certificate

Statistical Inference

In part one, created simulations to compare the exponential distribution in R with the Central Limit Theorm.

In part two, analyzed the standard “Tooth Growth” dataset provided with R.

See certificate

Regression Models

Performed an ANOVA analysis of Motor Trend magazine vehicle data to show the influence of manual versus automatic transmissions on fuel efficiency.
See certificate

Reproducible Research

Created reproducible research documents on two study areas: an analysis of step data produced by a wearable step counter, and a study of storm-related economic and health impacts using NOAA storm data.
See certificate

Exploratory Data Analysis

Learned exploratory techniques for summarizing data, including visualization.
See certificate

Getting and Cleaning Data

Explored ways of obtaining data for analysis. Retrieved data from the web, APIs, databases, and other sources. Tidied gathered data, and learned how to share it.
See certificate

R Programming

Learned how to program in R for effective data analysis. Course covered programming in R, reading data in to R, accessing R packages, writing R functions, debugging and profiling R code, and organizing and commenting R code.
See certificate

The Data Scientist’s Toolbox

Introduction to the main tools and ideas in the data scientist's toolbox.

Covered markdown, version control with git and GitHub, R, and RStudio.

See certificate

Projects

*

Developing Data Products Assignment

Coursera Developing Data Products assignment.

Practical Machine Learning Assignment

Coursera Practical Machine Learning assignment.

Contact