Ryan Picanco

CarFax

December 2019 - Present

Senior Software Engineer I joined a team at CarFax that quickly took ownership of the back end data pipeline powering the Used Car Listings on CarFax's website. My role on this team was one of technical leadership and guidance.

I was then tasked with leading a team to design and build a template powered multi-tenant cloud-based PDF Data Extraction pipeline. This product would go on to replace other third party tools that had costs in the millions of dollars per year, reducing the cost by 3-4 orders of magnitude. London, Ontario | https://www.carfax.com/

Autodata Solutions Inc

December 2011 - December 2019

Senior Web Developer My first role at Autodata was maintaining a large and complex Web Application using ExtJS as it's UI and a Java server using the Spring Framework. General Motors uses this application to create and manage it's Vehicle Incentives and comes with a suite of Web Services used to query this data.

After a couple of years, I was moved to several project teams, creating a vast array of web and data transformation applications spanning from Vehicle Conifugrators to REST based Image Compositing services. London, Ontario | http://www.autodata.net

Frank Cowan Company

October 2010 - November 2011

Application Developer The first thing I did upon starting at Frank Cowan was to create a code formatting standard as well as correcting all 13,000 compiler warnings, followed by automating the build process, greatly reducing the number of manual steps to release the application I was responsible for.

I then went on to fix a design flaw that decreased the response time of every request by 30%. Princeton, Ontario | http://www.frankcowan.com/

TVWorks Canada

January 2007 - June 2010

Systems Integration Specialist I began my time at TVWorks testing both Linux server components and client components on Set-top Boxes assuring that all products were in working order before releasing them to partners.

I then took on the role of administering and reporting on the custom Automated Testing Framework (ATF)’s continuous integration environment for the client products.

I implemented a Stability Testing Framework in PHP that would run sanity tests periodically on our server components and generate uptime graphs, giving us early notice of server failures.

This framework became the inspiration for a Java based testing framework which would replace their custom "ATF" framework, providing a platform for people to write functional and integration tests that would run against a live environment. London, Ontario http://www.tvworks.com/

Phoenix Interactive

Jan 2006 - April 2006

Quality Assurance Tester (Co-Op) At Phoenix Interactive, I performed testing of client software on various ATM models for different clients, ensuring that the product functioned as intended. To ease that task I developed an ATM Log parser in C#, reducing the amount of time taken up by looking through logs for specific messages. London, Ontario | http://www.phoenix-interactive.com/

Scotiabank

May 2005 - August 2005

Database Administrator (Co-Op) At my first Co-Op position, my main responsibility was writing SQL queries to work with new software components and index tables appropriately. I also developed an application to ease the promotion of DTS Packages from one testing environment to another. Stratford, Ontario

Fanshawe College

2003 - 2006

Computer Programmer Analyst We were mainly taught C++ development, but I dabbled in C# and Java as well. I worked on a team to develop a multi-player RPG using C++ and DirectX for graphics. London, Ontario

Strathroy District Collegiate Institute

1999 - 2003

Ontario Secondary School Diploma I graduated High School while participating in Software Development competitions against other schools solving ACSL style problems. I was also awarded the school's science award for my grade in my Physics class. Strathroy, Ontario