Kevin is available for hire
Hire KevinKevin Gordon
Verified Expert in Engineering
Visual Basic for Applications (VBA) 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
Blooms Wholesale Nursery, Inc
Visual Basic for Applications (VBA), Microsoft Access, SQL...
Massachusetts Institute of Technology - J-WEL
QuickBase, SQL, Dashboards
D2 Legal Change Inc.
Microsoft Excel, QuickBase, Excel VBA, Visual Basic for Applications (VBA)...
Experience
- Visual Basic for Applications (VBA) - 20 years
- Microsoft Access - 20 years
- Object-oriented Programming (OOP) - 20 years
- Database Development - 20 years
- Microsoft SQL Server - 15 years
- C# - 9 years
- VB.NET - 9 years
- Visual Basic - 6 years
Preferred Environment
Microsoft SQL Server, Microsoft Access, VB.NET, C#, Blazor, Visual Basic for Applications (VBA), Transact-SQL (T-SQL), English, C#.NET
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
Senior Data Analyst
2025 - PRESENT
Blooms Wholesale Nursery, Inc
- Took responsibility for supporting a complex nursery planning application that integrates with a larger SaaS.
- Updated key audit functionality with more detailed logging features.
- Sat with key business users to understand where crop plans failed and fixed them in real time.
- Rebuilt the initial menu for better, enhanced functionality.
Technologies: Visual Basic for Applications (VBA), Microsoft Access, SQL, Microsoft SQL Server, Data Migration, VPN, ODBC, Linked Data, Performance Tuning, Reports, Complex SQL Queries
Data Engineer & 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, Microsoft Dynamics 365, Microsoft Power Apps, Reporting, Microsoft Dynamics, Dynamics CRM 365
Senior Data Analyst
2025 - 2026
Adjudicate Inc
- Developed a large number of reporting queries for mid-year and end-of-year executive-level reports.
- Built stored procs to facilitate various requirements like cleaning names and processing regions.
- Built queries to document meta-level data for a new set of EDM tables.
Technologies: Microsoft SQL Server, SQL, Transact-SQL (T-SQL), SQL Stored Procedures, Query Optimization, Performance Tuning, Database Schema Design, Database Normalization, SQL Server Reporting Services (SSRS), Data Modeling, Database Administration (DBA), SQL Server Integration Services (SSIS), Complex SQL Queries, SQL Server
Data Analyst & DBA
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, Transact-SQL (T-SQL), SQL Server Integration Services (SSIS), Query Optimization, Teamwork, SQL Server 2014, SQL Server 2017, Azure SQL Databases, Git, Data Visualization, Microsoft 365, SQL Stored Procedures, Business Intelligence (BI), APIs, Excel 2016, Excel Macros, .NET, Azure SQL, ASP.NET, C#.NET, Azure, ODBC, .NET Core, Data Modeling, Database Migration, Database Optimization, Performance Tuning, Reports, Complex SQL Queries, SQL Server
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, Transact-SQL (T-SQL), Query Optimization, Teamwork, Data Migration, SQL Server 2014, SQL Server 2017, Git, Microsoft 365, SQL Stored Procedures, Business Intelligence (BI), APIs, Excel 2016, .NET, Azure SQL, ASP.NET, C#.NET, Reporting, Data Modeling, Database Optimization, Performance Tuning, Reports, Complex SQL Queries, SQL Server
Senior Full-stack Developer
2017 - 2020
EPRA
- Deconstructed the sampling Microsoft Access application and built a .NET application using C#, JavaScript, and CSS, running on the SQL Server version based on an understanding of the original system. Included use of Telerik 3rd-party controls.
- Upgraded data from the original MS Access database to SQL Server.
- Changed out hardcoded queries to stored procedures to allow for better maintenance and performance.
- Worked with a .NET application that interfaced with SAP to both push and pull XML accounting data.
Technologies: C#, SQL Server 2017, Excel 2010, Excel VBA, Microsoft Access, Visual Basic for Applications (VBA), JavaScript, CSS, Telerik Web Controls, XML, SAP, Macros, Excel Macros, .NET, ASP.NET, C#.NET, FTP, SFTP, Reporting, Database Migration, Performance Tuning, Reports, VB, Complex SQL Queries, SQL Server, Auditing
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, Transact-SQL (T-SQL), SQL Server Integration Services (SSIS), Data Engineering, Query Optimization, Teamwork, MySQL, APIs, .NET, ASP.NET, C#.NET, FTP, SFTP, ODBC, Database Migration, Database Optimization, Performance Tuning, Reports, VB, Complex SQL Queries, Auditing
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, Transact-SQL (T-SQL), SQL Server Integration Services (SSIS), Data Engineering, Query Optimization, Teamwork, Data Migration, Financial Modeling, Data Visualization, SQL Stored Procedures, Business Intelligence (BI), APIs, Excel Macros, .NET, ASP.NET, C#.NET, Reporting, ODBC, Database Migration, Database Optimization, Linked Data, Performance Tuning, Reports, VB, Complex SQL Queries, SQL Server, Backup & Recovery, SQL DBA, SQL Backups, Auditing
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, Excel Macros, FTP, SFTP, ODBC, Database Optimization, Linked Data, Performance Tuning, Reports, VB, Complex SQL Queries
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
Libraries/APIs
ODBC, Complex SQL Queries
Tools
Microsoft Access, Microsoft Excel, Git, Excel 2016, Microsoft Power Apps, VPN, Microsoft Dynamics, Jira, Syncfusion, Excel 2010
Languages
C#, Visual Basic for Applications (VBA), SQL, Transact-SQL (T-SQL), C#.NET, VB, VB.NET, Visual Basic, Excel VBA, HTML, JavaScript, Java, CSS, XML
Frameworks
.NET, ASP.NET, .NET Core, Blazor
Paradigms
Object-oriented Programming (OOP), Database Development, Database Design, ETL, Business Intelligence (BI)
Storage
Microsoft SQL Server, Databases, Database Architecture, SQL Server 2014, SQL Server 2017, SQL Stored Procedures, Azure SQL Databases, SQL Server DBA, QuickBase, SQL Server Integration Services (SSIS), Azure SQL, Database Migration, IBM Db2, MySQL, SQL Server Reporting Services (SSRS), Database Administration (DBA)
Platforms
Azure, Microsoft Dynamics 365, Oracle
Other
CSV File Processing, Data Engineering, English, Query Optimization, Data Migration, Reporting, Linked Data, Performance Tuning, Reports, SQL Server, Data Modeling, Data Management, Cloud, Data, Data Analysis, Virtual Machines, Data Transformation, Teamwork, Microsoft 365, APIs, Macros, Excel Macros, FTP, SFTP, Database Optimization, Dynamics CRM 365, Backup & Recovery, SQL DBA, SQL Backups, IIS, DevExpress Controls, Ajax, Architecture, Analysis, Analytics, Azure Virtual Machines, Financial Modeling, Dashboards, Data Visualization, Telerik Web Controls, SAP, Database Schema Design, Database Normalization, Auditing
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