Kevin is available for hire
Hire KevinKevin Gordon
Verified Expert in Engineering
Software Developer
Mississauga, ON, Canada
Toptal member since April 25, 2022
Bio
Kevin is a technology professional with excellent interpersonal skills who strives to understand the needs of the business in order to successfully implement software-based solutions. He has 20+ years of experience in analyzing, developing, and supporting database-driven business applications. Kevin has extensive experience in the full development lifecycle of multiple verticals, including insurance, automotive, and manufacturing.
Portfolio
Massachusetts Institute of Technology - J-WEL
QuickBase, SQL, Dashboards
D2 Legal Change Inc.
Microsoft Excel, QuickBase, Excel VBA, Visual Basic for Applications (VBA)...
Axxima
Microsoft Access, Microsoft SQL Server, VB.NET, C#...
Experience
- Object-oriented Programming (OOP) - 20 years
- Microsoft Access - 20 years
- Visual Basic for Applications (VBA) - 20 years
- Microsoft SQL Server - 15 years
- VB.NET - 9 years
- C# - 9 years
- Visual Basic - 6 years
Availability
Part-time
Preferred Environment
Microsoft SQL Server, Microsoft Access, VB.NET, C#, Blazor, Visual Basic for Applications (VBA), T-SQL (Transact-SQL), English
The most amazing...
...thing I've developed is a claims management system, a completely paperless system that allows users to interact seemlessly with one another and track claims.
Work Experience
QuickBase Developer
2024 - PRESENT
Massachusetts Institute of Technology - J-WEL
- Developed key dashboards which helped upper management handle future projects better by being able to analyze data in a meaningful and clear manner.
- Worked with a team to better understand their requirements and was able to offer insights and suggestions on how QuickBase could be used to improve their reporting requirements.
- Built four dashboards consisting of over 20 different reports in a clean and easy-to-use fashion.
Technologies: QuickBase, SQL, Dashboards
QuickBase Developer
2023 - PRESENT
D2 Legal Change Inc.
- Built an application based on an Excel spreadsheet.
- Implemented an audit trail feature as part of the new QuickBase application.
- Created various views for different levels of users.
Technologies: Microsoft Excel, QuickBase, Excel VBA, Visual Basic for Applications (VBA), Microsoft Access, Teamwork
Programmer Analyst
2012 - 2022
Axxima
- Developed a key web-based claims management system for a major client. Designed and built entire infrastructure from database in SQL server to .NET and set-up a completely paperless system that houses all files entirely within the database.
- Administered an SQL server database system, including creation, setting up backups, indexing, security, and storing procedures.
- Managed junior developers in adding updates to critical systems and trained on the administration of server based functions including IIS and SQL server.
- Provided front-line support to internal and external clients.
Technologies: Microsoft Access, Microsoft SQL Server, VB.NET, C#, Visual Basic for Applications (VBA), IIS, DevExpress Controls, Ajax, JavaScript, SQL, Databases, Database Development, Database Architecture, Database Design, CSS, HTML, Data Management, Cloud, Data, Data Analysis, Azure Virtual Machines, Virtual Machines, CSV File Processing, ETL, T-SQL (Transact-SQL), SQL Server Integration Services (SSIS), Query Optimization, Teamwork, SQL Server 2014, SQL Server 2017, Azure SQL Databases
Architect
2020 - 2021
REIX
- Coordinated with business users to gather requirements and translate that into meaningful specifications for the development team.
- Designed and built database structures and the architecture of applications and assigned work to a team of developers. Led the development of additional stored procedures and table structures as needed by the team.
- Engineered legacy database to extract and load data into a new system.
- Held daily remote scrum meetings with the development team members based in Atlanta and Romania. Hosted code on Git and used Jira to track bugs, issues, and tasks. Used Slack to communicate with the team in real-time.
Technologies: Microsoft SQL Server, C#, Blazor, .NET Core, Jira, Syncfusion, Azure, Azure SQL Databases, SQL, Databases, Database Development, Database Architecture, Database Design, HTML, Cloud, Data, T-SQL (Transact-SQL), Query Optimization, Teamwork, Data Migration, SQL Server 2014, SQL Server 2017
Programmer Analyst
2010 - 2012
Rockwell Automation
- Gathered specifications from engineers, designed, and built an Oracle database and .NET web application to facilitate real-time tracking and quality control for jobs.
- Supported engineering for the Salesforce application over a global region, typically assisting users in North America and users as far as Brazil and Poland.
- Helped design the business logic of an alerting system that would automatically escalate issues depending on the length of time a problem was reported and the severity of the issue.
- Supported and maintained an interface that passed jobs between the AS400 scheduling system and the sheet metal press panel bender. Upgraded this interface from a text format to an XML format in concert with a system upgrade.
- Completed the application that allowed HR to manage sensitive payroll data from SAP and send encrypted data to the payroll administrator.
Technologies: C#, Java, Oracle, IIS, Visual Basic for Applications (VBA), Microsoft Excel, Excel VBA, Databases, Database Development, HTML, Data, CSV File Processing, Data Transformation, ETL, T-SQL (Transact-SQL), SQL Server Integration Services (SSIS), Data Engineering, Query Optimization, Teamwork, MySQL
Programmer Analyst and Database Developer
2005 - 2010
Dion, Durrell & Associates
- Led the architecture, design, implementation, and maintenance of multiple web and Windows applications using VB.NET, C#, VBScript, JavaScript and Ajax.
- Maintained and administered an SQL server database system, including database creation, backups, and indexing of a wide range of databases from 10 gigabytes to over a terabyte in size and various complexities.
- Built a web-based claims management system that averaged 800 claims a year and over 30 gigabytes of supporting documentation. Received paperless reports from counsel and adjusters and produced critical reports for management.
- Prepared and led training seminars for external customers and internal team members.
- Created data analysis and modeling from a wide array of clients in various market sectors including banking, insurance, and retail to aid actuarial analysis.
Technologies: Visual Basic for Applications (VBA), VB.NET, Microsoft SQL Server, C#, Microsoft Excel, Excel VBA, SQL, Databases, Database Development, Database Architecture, Database Design, CSS, HTML, Data Management, Data, Data Analysis, SQL Server DBA, Virtual Machines, CSV File Processing, Data Transformation, ETL, T-SQL (Transact-SQL), SQL Server Integration Services (SSIS), Data Engineering, Query Optimization, Teamwork, Data Migration, Financial Modeling
Microsoft Access Consultant
2001 - 2005
Honda Canada
- Upgraded and integrated existing user-built Microsoft Access applications and data into centralized and organized systems.
- Implemented a security model on applications that protected sensitive data using a combination of the security model and LAN authentication that only allowed users access to specific data based on their security and departmental location.
- Developed varied projects simultaneously from simple inventory to complex accounting applications. Completed development of four database applications in a four month period.
Technologies: Microsoft Access, Visual Basic for Applications (VBA), Microsoft SQL Server, IBM Db2, Visual Basic, Microsoft Excel, Excel VBA, Databases, Database Development, Database Architecture, Database Design, Data, CSV File Processing, Data Transformation, ETL, Query Optimization, Teamwork, Data Migration
Experience
Paperless Claims Management System
Developed a paperless web based claims management system that handles reports from lead counsel, claims details from adjusters, reserves from claim managers, and launches daily notifications. All documents are stored within an SQL server database including emails.
I was responsible for the full design and architecture of the application from gathering user requirements.
I was responsible for the full design and architecture of the application from gathering user requirements.
Bank Points Program Data Modeling Application
Worked with a bank to pull years of points data and upload it to an SQL server database. Wrote an application that analyzed data and created predictions based on various criteria that allowed actuaries to develop reports and recommendations for clients.
Auditing Verification Spreadsheet
An Excel application that took the base MS Access data used in a sampling system and produced separate results used to verify the data for auditing purposes. The mathematics was quite complex and powerful, written in Excel VBA.
Education
1994 - 1999
Bachelor's Degree in Cognitive Science
Carleton University - Ottawa, ON
Skills
Tools
Microsoft Access, Microsoft Excel, Jira, Syncfusion
Languages
Visual Basic for Applications (VBA), SQL, VB.NET, Visual Basic, Excel VBA, HTML, T-SQL (Transact-SQL), C#, JavaScript, Java, CSS
Paradigms
Object-oriented Programming (OOP), Database Development, Database Design, ETL
Storage
Microsoft SQL Server, Databases, Database Architecture, SQL Server 2014, SQL Server 2017, Azure SQL Databases, SQL Server DBA, QuickBase, SQL Server Integration Services (SSIS), IBM Db2, MySQL
Platforms
Azure, Oracle
Frameworks
Blazor, .NET Core
Other
CSV File Processing, English, Query Optimization, Data Migration, Data Management, Cloud, Data, Data Analysis, Virtual Machines, Data Transformation, Data Engineering, Teamwork, IIS, DevExpress Controls, Ajax, Architecture, Analysis, Analytics, Data Modeling, Azure Virtual Machines, Financial Modeling, Dashboards
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