Enterprise Automation Framework in Go
At my current company, I identified a major challenge during our transition from an aging Microsoft Navision system to Microsoft Business Central: nearly all automation relied on large, interdependent T-SQL stored procedures that mixed data operations with system logic. To modernize this, I designed and built a Go-based automation and integration framework that decouples core database processes from other automation code that interacts with files, APIs, and external systems. This framework, written entirely in Go, provides a robust, reusable toolkit with modules for SQL Server operations, CSV and Excel data handling, Microsoft Graph email automation, FTP and SharePoint file transfers, and a centralized structured logging system powered by a LogBuffer that records all activity into SQL. The solution emphasizes type safety, modularity, and high performance — transforming legacy, monolithic SQL routines into maintainable, testable, and extensible Go components. As a result, it has dramatically improved developer productivity, standardized our logging and monitoring processes, and enabled faster delivery of automation and integration projects. This project not only streamlined our migration to Business Central but also established a scalable technical foundation for future data-driven workflows across the business.
Back to Portfolio
