Aaron Berquist, Developer in Hamilton, ON, Canada
Aaron is available for hire
Hire Aaron

Aaron Berquist

Verified Expert  in Engineering

Bio

Aaron has 25 years of experience as a senior enterprise resource planning (ERP) developer. He is well-versed in Dynamics 365 Business Central and Microsoft Dynamics GP, having enhanced and supported some of Canada's largest Microsoft Dynamics GP installations. Aaron is friendly and adaptable and always puts the success of his clients first.

Portfolio

Rimrock
Dynamics 365 Business Central, Microsoft Dynamics GP, Azure, SQL...
The Dynadex Group, Inc.
Azure, Microsoft Dynamics GP, OpenText ECM, Microsoft 365, Avalara Tax API...
OpenText
Microsoft Dynamics GP, SQL, Citrix XenApp, Crystal Reports, Windows Server...

Experience

  • SQL - 20 years
  • Microsoft Dynamics GP - 20 years
  • C# - 10 years
  • Dynamics 365 Business Central - 5 years
  • AL - 5 years
  • Microsoft Power BI - 5 years
  • Azure - 5 years
  • Dynamics CRM 365 - 5 years

Availability

Part-time

Preferred Environment

Microsoft Dynamics GP, Dynamics 365 Business Central, SQL, Azure, AL, C#

The most amazing...

...project I've led was the creation of an accounts payable workflow solution to streamline payables processing using COTS software, C#, and ERP APIs.

Work Experience

Systems Engineer

2019 - 2025
Rimrock
  • Led development efforts for all Dynamics 365 Business Central extensions created to support custom software integrations with Business Central.
  • Created all integrations in TIBCO Scribe for bidirectional data transfer between Microsoft Dynamics CRM and Business Central.
  • Scoped, implemented, and managed Azure resources for 20+ clients running Microsoft Dynamics GP, including Microsoft SQL Server and Remote Desktop Services.
Technologies: Dynamics 365 Business Central, Microsoft Dynamics GP, Azure, SQL, Dynamics CRM 365, Avalara Tax API, TIBCO, Remote Desktop Services, Microsoft SQL Server, Windows Server, Office 365, Microsoft Teams, SharePoint, Windows File Systems, Microsoft Power BI

Principal Consultant

2017 - 2019
The Dynadex Group, Inc.
  • Implemented an accounts payable (AP) automation solution for a large Canadian corporation that ingested invoices, automatically populated key fields from their ERP system, and then routed them to an AP staff member for review and payment.
  • Provided full-service IT consulting and Microsoft Dynamics GP enhancements for clients, including upgrades and custom solutions for tax and regulatory requirements.
  • Advised and implemented a streamlined method to process US tax exemptions using Avalara Tax API, leading to more accurate and timely tax payments to state governments.
Technologies: Azure, Microsoft Dynamics GP, OpenText ECM, Microsoft 365, Avalara Tax API, Intuit QuickBooks, Windows Server, Office 365, Microsoft Teams, Windows File Systems, Microsoft Power BI

Manager IT – Enterprise Business Systems

2009 - 2017
OpenText
  • Managed the operational support and enhancement of Microsoft Dynamics GP, which supported around $1.4 billion in annual revenue.
  • Developed numerous performance solutions to account for the growth of Microsoft Dynamics GP to over 220 company databases, which involved extensive research and design to accommodate the performance impact of that growth.
  • Chaired steering committee meetings for financial systems and partnered with key business members to understand strategic goals and produce an execution strategy to ensure success.
  • Handled hiring and terminations, performance reviews, training plans, career paths, and goal planning for my 11 team members.
Technologies: Microsoft Dynamics GP, SQL, Citrix XenApp, Crystal Reports, Windows Server, Avalara Tax API, Office 365, SharePoint, Windows File Systems

IT Senior Technical Analyst

2003 - 2009
OpenText
  • Led the technical planning and execution of Microsoft Dynamics GP upgrades from 7.0 to 7.5 and 7.5 to 10.
  • Designed and implemented legacy data migrations from over 40 acquired companies into OpenText financial systems.
  • Liaised with core IT staff to ensure IT infrastructure could support the needs of the business applications.
  • Handled 150 support tickets per month for various IT systems, ensuring prompt resolution and customer satisfaction.
Technologies: Microsoft Dynamics GP, Crystal Reports, SQL, Citrix XenApp, Avalara Tax API, Windows Server, Office 365, SharePoint, Windows File Systems

Experience

Accounts Payable Automation Solution

I developed a custom paperless accounts payable (AP) solution that uses OpenText Capture Center software, .NET, and eConnect to streamline two of Canada's largest Microsoft Dynamics GP deployments, each processing over 100,000 invoices yearly. The system retrieves documents via SFTP or a network scanner and imports them into the Capture Center software. Key fields are populated via OCR, and API calls are made to the ERP system to validate the selected data. Payables documents are then imported into the ERP system via eConnect and presented to AP staff using custom windows created using C# within the ERP system. Documents are then sent to staff for approval via a custom workflow and processed for payment once approved.

Business Central Extensions for Custom Integrations

I was the lead developer for all Dynamics 365 Business Central extensions to support the bidirectional data integration between Microsoft Dynamics CRM and Business Central. This project involved designing and building the necessary extensions to Business Central to capture key CRM fields. I then created over 30 integrations in TIBCO Scribe to manage the flow of data between those systems.

Certifications

APRIL 2022 - PRESENT

Microsoft Certified: Azure Fundamentals

Microsoft

Skills

Libraries/APIs

Avalara Tax API

Tools

Microsoft Dynamics GP, Dynamics 365 Business Central, Crystal Reports, GitHub, OpenText ECM, Citrix XenApp, Microsoft Dynamics CRM, Microsoft Teams, Microsoft Power BI

Languages

SQL, AL, C#

Frameworks

.NET

Paradigms

Azure DevOps

Platforms

Azure, Windows Server, SharePoint

Storage

SQL Server Integration Services (SSIS), Microsoft SQL Server, Windows File Systems

Other

Office 365, Dynamics CRM 365, QuickBooks Desktop, Microsoft 365, IIS, Integration, TIBCO, Intuit QuickBooks, Remote Desktop Services

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