Andrew Judd's Resume
Click here to view a PDF version of my resume.
Key Sections
Icepets.com
Owner
2014-Present
- Leads a team of artists, moderators and administrators
- Manage and maintain the web and database servers
- Works towards improving user experience and satisfaction
- Developed new features for continual site growth
- In the process of recoding the entire site using the Laravel framework and VueJs
SPS Commerce, Brampton, Ontario
Senior Database Engineer
2016-Present
- Followed scrum methodology for software development
- Simplified an overly complicated SSIS process by breaking it into modular pieces
- Developed migration utilities to support the move of our applications into the cloud (AWS)
- Mentored a co-worker in order to expand on their existing skillset
- Ensured code quality through code reviews and pull requests
- Ensured best practices are followed by the development team
ToolBox Solutions, Brampton, Ontario
Senior Database Developer
2013-2016
- Followed scrum methodology for software development
- Scrum Master for a team of up to 10 developers
- Developed custom sales based reports (backend)
- Developed generic SSIS patterns for use in a common solution
- Performance tuned long-running queries
- Developed convenience scripts to reduce the amount of manual effort required
- Developed custom-script components that are used to help distribute a workload on a server
Database Developer
2012-2013
- Followed scrum methodology for software development
- Scrum Master for a team of 7 developers
- Developed custom sales based reports (backend)
- Developed SSIS packages to load data from various POS data sources into a form usable for sales reports
- Built and queried SSAS cubes for reporting purposes
- Developed convenience scripts to reduce the amount of manual effort required
.NET Developer
2010-2012
- Developed custom sales based reports (front end, middle tier and backend)
- Followed scrum methodology for software development
- Used ASP.NET, C#.NET, SQL Server 2008
- Developed SSIS packages to load data from various POS data sources into a form usable for sales reports
Environment Canada, Toronto, Ontario
2009
Software Developer Co-op Student
- Nominated Co-op Student of the Year 2009
- Worked alongside another Co-op student to port an existing application to a new server
- Worked with clients to determine the requirements for a system to keep electronic copies of images in a database
- Created the image database and a web user interface to provide the clients with an easy way of accessing the images
- Modified the jUpload open-source application in order to allow for filename validation
- Used MapServer and the OpenLayers javascript library to provide the clients with a "Google Maps" style of map
- Learned and used Coldfusion in order to implement required functionality for the web applications
- Analyzed web metrics to determine the number of downloads of specific web pages
- Created an automatic renaming script which allowed other Co-op students to complete their job of renaming files more efficiently
Toronto Transit Commission (TTC), Toronto, Ontario
2008
Programmer/Developer Co-op Student
- Developed help screens for the WheelTrans Ride online trip booking application (to be used with screen reading applications)
- Worked with clients to determine and develop the business requirements and to develop the required functions of a new application to track safety deficiencies
- Learned and used ASP.NET, C#.NET and VB.NET in order to implement required functionality
- Worked collaboratively with another Co-op Student in order to complete all of the specifications and programming required in order to meet the deadlines
CIBC, Toronto, Ontario
2007
Test Analyst Co-op Student
- Executed test cases in order to verify that the Business Banking application was working as expected
- Tested defects thoroughly in order to determine their root cause
- Logged defects as they arose throughout the testing cycle
- Learned the CIBC Enterprise Testing Methodology (CETM)
- Implemented the CETM by creating test case templates (test cases which take in parameters)
- Created JavaScript applications which allowed testers to modify various banking files
- Created AutoIT scripts which allowed testers to effectively use Mercury Quality Center
Amgen Canada, Mississauga, Ontario
2006
Information Services Summer Student
- Updated and provided technical support for Amgen's new Intranet site using Plumtree software
- Learned and used SQL to analyze a discrepancy between SQL reports
- Developed Test Cases to support the new functionality of the Scientific Affairs Data Management (SADMS) system
- Worked co-operatively with external consultants on a design document through JAD sessions for the SADMS system
- Gathered Requirements from the SADMS business users and modified the traceability matrix as required
University of Guelph 2005 - 2010
Guelph, Ontario
Bachelor of Science - Major in Computing and Information Science (Co-op)
Degree - Co-op
St. Thomas Aquinas Secondary School 2005
Brampton, Ontario
Ontario Secondary School Diploma with honours
Awards: Ontario Scholar, Grade 11 and Grade 12 Computer Science Award
- Microsoft Certified Technology Specialist: SQL Server 2008, Business Intelligence and Maintenance
- Technology Specialist: .NET Framework 3.5, ASP.NET Application Development
-
Application Programming:
- C
- C++
- C#.NET
- Java
- Visual Basic
- VB.NET
-
Database Programming:
- SQL - MySQL and T-SQL
- SQL Server Analysis Services (SSAS)
- SQL Server Integration Services (SSIS)
-
Scripting:
- AutoIT
- Batch
- Bash
- Powershell
-
Web Programming:
- ASP.NET
- Cascading Style Sheets (CSS)
- Coldfusion
- JavaScript
- PHP
-
Other Programming Tools:
- OpenGL
- SSDT (SQL Server Data Tools)
-
Source Control Tools:
- IBM Rational ClearCase
- Git
- Subversion
- Team Foundation Server
-
Operating Systems:
- Microsoft Windows
- Max OSX
- Linux
-
Testing Packages
- J-Unit
- Mercury Quality Center
- PMD
-
Frameworks:
-
Other Tools:
- Plumtree
- MapServer
- Microsoft Office
- Toastmasters
- Camping
- Board Games
- Baseball - visiting major league baseball parks
- Recreational Sports - Baseball, Volleyball, Ultimate Frisbee