Andrew McKernan, Developer in Edmonton, AB, Canada
Andrew is available for hire
Hire Andrew

Andrew McKernan

Verified Expert  in Engineering

Bio

After receiving education in computer engineering at the University of Alberta, Andrew worked full-time in the field. More recently, he has decided to pursue freelance work full-time out of a desire for diverse, engaging, and challenging work. Andrew is experienced in web development, mobile apps, and more. In Andrew, you will find a creative developer eager to contribute to the team and company.

Portfolio

Offerd
Python, PostgreSQL, Database Modeling, JavaScript, UI Design, Mendix, AWS...
Anderson Taylor LLC
.NET, JavaScript, ASP.NET, CSS, HTML, Git, GitHub, Visual Studio Development...
Anonymous Company
Python, Python, Django, NumPy, Pandas, Google Cloud Development, HTML, HTML5...

Experience

Availability

Full-time

Preferred Environment

PyCharm, Visual Studio, MacOS, Windows, Linux

The most amazing...

...thing I've developed is Edmonton ICU, an iOS and Android app. The companion API and desktop app allow making updates to the mobile app on the fly.

Work Experience

Lead Software Developer

2022 - 2024
Offerd
  • Independently maintained and updated the system architecture of a Mendix application, handling development of new features, dev ops tasks, and integrations with external tools such as Hubspot.
  • Developed an automated test suite using Cypress, preventing deployment errors and increasing application stability.
  • Utilized Hubspot workflows to update the client's application in real time in response to events in the CRM.
  • Utilized SendGrid's API to seamlessly integrate email notifications and updates into the client's application.
  • Maintained a detailed record of all tasks completed using Jira and Google Sheets.
Technologies: Python, PostgreSQL, Database Modeling, JavaScript, UI Design, Mendix, AWS, HubSpot Development, ArcGIS, ChatGPT, Cypress, SendGrid, SendGrid API, Jira, Google Sheets Development, Front-end, Selenium, Chatbot Development, Amazon S3

.NET Developer

2022 - 2022
Anderson Taylor LLC
  • Utilized the Highcharts data visualization library to create new charts and update existing ones in the client's web portal.
  • Worked with ASP.NET, JavaScript, and CSS to repair issues and add new features to the client's existing web portal.
  • Extensively used Git command line tools to integrate several developers' work into one unified, cohesive code branch.
Technologies: .NET, JavaScript, ASP.NET, CSS, HTML, Git, GitHub, Visual Studio Development, SQL, SQL Server, C#, jQuery, Leadership, Web Development, UI Development, Full-stack, ASP.NET, Bootstrap, ASP.NET MVC, .NET, APIs, REST API, API Development, Windows Development, RESTful Services, API, API Applications, API Connectors, Web Dashboards, UI Design

Data Solution Developer

2022 - 2022
Anonymous Company
  • Developed the full stack of a Django website, allowing customers and internal users to automatically create data processing requests for specific entities.
  • Maintained, fixed, and improved old data processing code, boosting performance significantly and increasing error tolerance.
  • Deployed new software onto Google Cloud and created a new cloud infrastructure, including databases, secret storage, and automated scaling based on demand.
  • Wrote Python scripts to process large files, CSVs, and other similar data to create meaningful statistics.
  • Processed geospatial data into a standardized format and uploaded the said data into client's existing systems for further processing.
Technologies: Python, Python, Django, NumPy, Pandas, Google Cloud Development, HTML, HTML5, JavaScript, Data Engineering, PostgreSQL, SQL, Web Development, Git, Object-relational Mapping (ORM), Django, Full-stack, REST, Server Management, Server Security, Scripting, Software Architecture, Software Design, Leadership, Statistics, Reports, Web Development, Geospatial Data, UI Development, Microservices Development, Python API, Database Modeling, Full-stack, APIs, REST API, API Integration, API Development, Windows Development, RESTful Services, Python Dataclasses, API, API Applications, Python Attrs, API Connectors, Cloud Engineering, Conda, Web Dashboards, UI Design, Front-end

Systems Engineer

2019 - 2021
Interdynamix
  • Created an internal web application for managing inventory and maintaining audit logs using Django and PostgreSQL.
  • Developed internal WebGUI and multiple back-end components for APIs supporting Carbeeza, a car marketplace application, using Spring and Thymeleaf.
  • Ensured internationalization and localization (i18n) were integrated into the back and front end of Carbeeza API.
  • Tracked and responded to bugs using primarily Jira as a reporting tool.
  • Worked with Docker and Kubernetes to allow deployment and communication between various components of the Carbeeza application.
  • Used GitLab CI/CD tools to ensure proper functionality and integration of my code with the rest of the Carbeeza application.
Technologies: Java, Spring, Thymeleaf, Python, Django, Azure, PostgreSQL, Python, HTML, HTML5, APIs, SQL, Docker, Kubernetes, JQL, GitLab CI/CD, Google Cloud Development, Architecture, Integration, REST API, Git, Web Development, Git, Object-relational Mapping (ORM), Django, Full-stack, Spring, REST, Model View ViewModel (MVVM), Model View Controller (MVC), Agile Sprints, CI/CD Pipelines, Scripting, Agile Development, Software Architecture, Software Design, Leadership, Web Development, UI Development, Spring Boot, Python API, Full-stack, Test Automation, API Development, Windows Development, RESTful Services, API, API Applications, Document Parsing, PDF, Web Dashboards, UI Design, Front-end

Software Development Student

2018 - 2018
PCL Construction
  • Developed a job marketplace application PCL Craftlink on iOS and Android platforms in C# using Xamarin.
  • Revamped a UI and back end of internal web application using HTML5, JavaScript, and ASP.NET Razor.
  • Debugged and upgraded features on a progressive web app using React and ASP.NET Web API for back-end calls.
Technologies: Xamarin, C#, React.js, PWA, HTML5, JavaScript, Mobile App Design, Git, Mobile App Design, Mobile Apps, Native Mobile Apps, App Development, Model View ViewModel (MVVM), Android, iOS, Scripting, Web Development, UI Development, Full-stack, ASP.NET, .NET, Windows Development, Web Dashboards, Front-end

Hardware Support

2017 - 2017
Nokia
  • Tested, debugged, and updated a C# data analysis application for the hardware team to analyze failure rates of hardware components.
  • Wrote various Visual Basic for Applications (VBA) scripts for Excel add-ons to aid hardware engineers and automate data visualization of multiple SQL databases.
  • Maintained documentation of all written software through development cycles.
Technologies: C#, Visual Basic, Excel VBA, Excel 365, Git, .NET, .NET, Test Automation, Windows Development

Quality Assurance (QA) Engineer

2016 - 2016
MegaSys Computer Technologies
  • Performed intensive debugging processes and procedures to ensure quality in the MegaSys Telenium Client Suite's various applications.
  • Utilized C#, SQL, XAML, and WPF to develop a database management application for the development team's use.
  • Used Jira reporting software to help report issues and bugs discovered.
Technologies: Manual QA, QA Testing, Software QA, C#, XAML, Windows Presentation Foundation (WPF), SQL, Git, .NET, Test Automation, Windows Development

Commercial Vehicle Sale and Management Platform

A .Net Core and Swift based project. The client had an existing platform written in .Net Framework, but the code was over 10 years old and had significant security vulnerabilities. I modernized the project into .Net Core 8.0, fixed bugs in both the multiple APIs contained within, as well as updated the Swift iOS app and the TypeScript/Angular web application.

Edmonton ICU for Android and iOS

https://play.google.com/store/apps/details?id=com.edmontonezpfcc.EDM_ICU_MOBILE
This Android and iOS application displays information about various intensive care units (ICUs) around Edmonton, Alberta. The app's front end is relatively simple, displaying text, images, and links depending on the location selected. The more exciting aspect of the application is the back end and companion desktop application used by the ICU staff. The desktop application, written using Windows Presentation Foundation (WPF), allows the hospital staff to update the application's content on the fly, adding or updating images, text, or even entire content sections. Meanwhile, the app regularly checks for updates and seamlessly downloads them without even needing an update from the app store.

Round Robin Form Service

A web app for securely distributing communication among a predefined group of individuals. Details are omitted for the confidentiality of the client.

The client oversaw facilitating communication to a small group of specialists but found that certain specialists were contacted disproportionately, causing an uneven distribution of work. This application was created to evenly distribute these work requests among the group of specialists fairly and anonymously. Administrators create and add a set of embedded forms into the application's database, each form linking to a specific recipient's inbox. When end-users log into the site, they automatically get a form based on previously accessed forms. This ensures a fair distribution of requests in the given group and removes any personal bias from the equation. The site was developed using Django.

Django Wedding Website

This Django website facilitates the communication of RSVPs and event information for weddings. The client wanted to use Django over a CMS system like WordPress to allow more freedom to customize every site element to their specifications. I used a CSS library from Pixelarity to reduce the work on the front end and built the rest of the site using Django. I wrote a few functions, allowing the client to download a CSV export of the guests' current status and quickly get an overview of where things were. I used a Vultr Ubuntu virtual machine to deploy the site, using Nginx and Gunicorn. Overall, the website was pretty straightforward, and the client was satisfied with what they received.

SkillsTuneUp.com

http://skillstuneup.com
A website for gathering customer data for analysis and market planning. While the site appears relatively simple to a public user, administrators have access to a wide variety of functions, including monitoring user activity on the site, responding to the site form, and editing much of this content on the fly without any technical knowledge.

Facility Sign-in App

A lightweight Android/iOS application for signing in and out of the building in which the client operates.

Given their large facility, the client had issues with staff leaving and setting the alarm while others were still in the building. They wanted an app available on user devices and on mounted tablets by the entrances to allow users to sign in and out of the building and ensure that no one else was present.

I designed the iOS and Android app and the accompanying back end that handles the sign-in and sign-out. The back end was built using the Django REST framework.

Solo Game Development

https://chrygore.itch.io/
The project URL here contains a link to my itch.io profile, which lists all the games I have released. I have primarily worked with Unity and Pygame and have been rapidly improving my game development skills over the past two years. I performed scripting, graphical asset management, performance optimization, and multi-platform deployment processes through my experience building games. I continue developing games at any given opportunity and am excited to build something that shines soon.
2014 - 2019

Bachelor's Degree in Computer Engineering

University of Alberta - Edmonton, Alberta, Canada

Libraries/APIs

API Development, REST API, Django, jQuery, Python API, React.js, NumPy, Pandas, Xamarin, Xamarin, Node.js, PyQt, Pygame, ArcGIS, SendGrid API

Tools

Git, GitHub, PyCharm, Visual Studio Development, GitLab CI/CD, Postfix, Nginx, Vultr, Git, SQL, Android, Unity SDK, PyInstaller, Presentation Foundation, ChatGPT, SendGrid, Jira, Google Sheets Development

Languages

Python, C#, JavaScript, Python, SQL, .NET, Java, HTML, HTML5, Bash, CSS, C++, Visual Basic, Excel VBA, XAML, JQL, Java Persistence Query Language (JPQL), Swift, TypeScript, SCSS

Frameworks

Django, Django, .NET, Unity, ASP.NET, Spring Boot, Unity2D, Spring, Thymeleaf, ASP.NET, Windows Presentation Foundation (WPF), Flask, Spring, Angular, Unity, Android SDK, Bootstrap, ASP.NET MVC, Cypress, Selenium, .NET Core

Paradigms

REST, API, Object-relational Mapping (ORM), Test Automation, DevOps, Mobile App Design, Cross-Platform, App Development, API, Model View ViewModel (MVVM), Model View Controller (MVC), Design Patterns, Agile Development, Microservices Development, UI Design

Platforms

Windows Development, Linux, Azure, Xamarin, Docker, Kubernetes, Ubuntu, DigitalOcean, Android, iOS, Mobile App Design, MacOS, Cloud Engineering, AWS, Mendix, HubSpot Development

Storage

PostgreSQL, MySQL, SQLite, Google Cloud Development, Database, XML, JSON, SQL Server, Database Modeling, Elasticsearch, Amazon S3

Industry Expertise

Web Development

Other

APIs, Software Development, Web Development, Mobile App Design, QA Testing, Critical Thinking, SSH, Excel 365, Ajax, Web Development, Back-end Developers, Mobile Back-end, Leadership, Software Design, Software Architecture, Scripting, UI Development, API Integration, Full-stack, RESTful Services, Python Dataclasses, API Applications, Python Attrs, Web Dashboards, Front-end, Chatbot Development, PWA, Android, Economic Development, Manual QA, QA Testing, Software QA, Architecture, Integration, Gunicorn, Full-stack, Single-page Applications (SPAs), Data Engineering, Mobile Apps, Native Mobile Apps, HTML Parsing, System Security, System Security, MVP Design, Minimum Viable Product (MVP), Cloud Services, Server Management, Server Security, Agile Sprints, CI/CD Pipelines, SaaS, Reports, Statistics, Geospatial Data, Video Gaming, API Connectors, Document Parsing, Email Parsing, PDF, Conda, Mobile Games, .NET 8, .NET Framework

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring