Available to hire
I’m Gustavo Miller, a Systems Analyst, Computer Programmer and Database Modeler with extensive experience designing and delivering business solutions and data models. I’ve built Windows desktop applications and web-based systems using VB, C#, .NET, and MVC/Razor, and I model data with SQL Server, Access, and MySQL. I’m comfortable across the full stack, including EF migrations, OpenXML document generation, and cloud-enabled architectures. I work well remotely or on-site and enjoy translating complex requirements into reliable, scalable software.
I thrive in challenging environments and have hands-on experience with ASP.NET Core, Power Apps, Power Automate, and Microsoft 365 automation. I’m passionate about clean design, maintainable code, and strong data governance, and I enjoy collaborating with cross-functional teams to deliver value quickly while maintaining high quality and security standards.
Skills
See more
Language
English
Fluent
Work Experience
Senior Business Analyst / Database Modeler at Shared Services Canada (SSC)
October 1, 2025 - October 20, 2025Led the analysis and migration of two legacy Excel-driven applications (Task & Financial Authorization and Project Control Workbook) to a Power Apps/Dataverse solution, including relational data modeling, Power Apps UI, and Power Automate flows; migrated data and implemented pagination for large tables; delivered a modern, scalable entry and workflow system with 100k+ records.
Senior Business Analyst / Database Modeler at Department of National Defense (DND)
February 1, 2025 - October 20, 2025Enhanced QAIS web application by introducing EF Core migrations, refactoring SQL Server/Azure data access, and implementing stored procedures; migrated to schema-based design; added document generation using Office Open XML and automated email reminders via Flow; managed DevOps versioning and backups.
Senior Business Analyst / Database Modeler at New Connections Ministries - NCM
August 1, 2023 - October 20, 2025Led ASP.NET MVC 7 web application enhancements, expanding intake workflows, data integration, and a maintenance module for submissions; implemented multi-tier architecture with Unit of Work/Repository patterns and EF Code First migrations; added OpenXML document generation for intake forms.
Senior Business Analyst / Database Modeler at Shared Services Canada (SSC)
July 1, 2023 - October 20, 2025Redesigned BR Costing and Network Trackers by up-sizing MS Access to SQL Server, migrating data to Azure SQL, creating database models, stored procedures, and a web-based CakePHP/Oracle migration path; used JIRA data to synchronize local and cloud data.
Systems Analyst / Web Developer / Database Modeler at New Connections Ministries - NCM
January 1, 2023 - October 20, 2025Led database design and web development for an integrated nonprofit platform; implemented REST-like data structures, EF migrations, and a content-driven admin interface; built a governance-friendly admin tool using Access front-end with SQL Server backend.
Systems Analyst / Senior Developer / Database Modeler at Shared Services Canada (SSC)
September 1, 2022 - October 20, 2025Helped modernize the Project Management area by transitioning from Access/Excel prototypes to a web-based solution; designed relational data models, implemented EF migrations, and introduced DevOps practices for code management and deployments.
Systems Analyst / Senior Developer / Database Administrator at Department of National Defense (DND)
February 1, 2021 - October 20, 2025Refactored and upsized an Access-based DB to SQL Server, implemented server-side business logic, and introduced Ribbon XML UI, XML scripts, and DNS-less connections. Created Excel/Word macro templates and integrated with Office automation.
Systems Analyst / Senior Developer at Department of National Defense (DND)
September 1, 2022 - October 20, 2025Second DND engagement focusing on DGMEC Pilot Product Performance Database; implemented Ribbon UI, XML configuration, and integrated with SQL Server; migrated data to SharePoint Lists and ensured data integrity with stored procedures.
Systems Analyst / Senior Developer at Transport Canada – Aviation Security
January 1, 2017 - October 20, 2025Developed an Airport Security Risk Management Tool; updated Aerodromes workbook using VBA extensibility, redesigned Excel interfaces, and implemented CustomUI ribbons and XML-based configurations.
Systems Analyst / Senior Developer at IDRC (International Development Research Center)
November 1, 2016 - October 20, 2025Developed grant administration workbook using VBA; implemented import/export processes, in-memory data structures (ADODB), and XML-based storage; designed ribbon interfaces and data workflows for reporting.
Systems Analyst / Senior Developer at Transport Canada – Aviation Security
July 1, 2016 - October 20, 2025Enhanced the Airport Security Risk Management Tool; migrated Access data to SQL Server 2012, normalized DB design, and created dynamic Ribbon UI using XML scripts and VBA interactions.
Systems Analyst / Senior Developer at Foreign Affairs, Trade and Development Canada (DFATD)
March 1, 2016 - October 20, 2025Enhanced Fiduciary Risk Management Tool (FRET) used for evaluating risk across recipients and projects; introduced XML structures to replace Excel lists and integrated with Access for reporting.
Systems Analyst / Senior Developer at Transport Canada – Aviation Security
December 1, 2015 - October 20, 2025Developed Office-based tools across Excel/Word/Access; implemented XML parts, Ribbon UI, and Office automation; upgraded to SQL Server and normalized data for distributed use.
Senior Business Analyst / Database Modeler at Shared Services Canada (SSC)
October 1, 2025 - October 20, 2025Joined the Strategic Engagement Branch to modernize legacy Excel-driven tools (PCW, TFA) into Power Apps and Power Automate; designed relational database structures in Dataverse; created canvas apps and flows; performed data migrations and process improvements.
Senior Business Analyst / Database Modeler at Department of National Defence (DND)
February 1, 2025 - October 20, 2025Supported QAIS modernization; implemented EF Core migrations, refactored SQL schemas, and data access layers; developed Word/Excel document generation using Office Open XML; managed deployments, backups and security constraints.
Senior Business Analyst / Database Modeler at New Connections Ministries - NCMS
August 1, 2023 - October 20, 2025Led development of an ASP.NET MVC web application; created an online Intake Application form; designed supporting database schema; implemented multi-tier architecture with EF Core and SQL Server 2019; integrated reporting and document generation.
Systems Analyst / Web Developer / Database Modeler at New Connections Ministries - NCM
January 1, 2023 - October 20, 2025Transformed a static site to ASP.NET Core Razor Pages with Bootstrap 4; implemented identity for authentication/authorization; applied Repository and Unit of Work patterns; built an admin interface using Access connected to SQL Server.
Systems Analyst / Senior Developer / Database Modeler at Shared Services Canada - SSCS
July 1, 2023 - October 20, 2025Support for Project Management Center of Excellence; prototyped Lessons Learned Master Database in Azure SQL; built PowerApps interfaces and Microsoft Flow workflows; developed dashboards in Power BI and established DNS-less connections.
Systems Analyst / Senior Developer / Database Administrator at Department of National Defence (DND)
February 1, 2021 - October 20, 2025COS/VCDS Administration; migrated Access to SQL Server; implemented server-side business rules via stored procedures, functions and triggers; migrated data to SharePoint and updated deployment processes.
Systems Analyst / Senior Developer / Database Modeler at Department of National Defence (DND) – COS/VCDS (Part-time Contract)
September 1, 2022 - October 20, 2025DGMEC Pilot Product; implemented Ribbon UI via XML, migrated from Access to SharePoint, and updated EF mappings; managed server-side data integrity and UI enhancements.
Systems Analyst / Senior Developer at Transport Canada – Aviation Security
December 1, 2015 - October 20, 2025Developed the Airport Security Risk Management Tool; modernized VBA-based workflows; created Word reports, XML schemas, and DNS-less Office integrations; enhanced security and automation.
Systems Analyst / Senior Developer at IDRC - International Development Research Center (Ottawa)
November 1, 2016 - October 20, 2025Developed the Grant Administration Workbook (VBA); automated budgeting and reporting; connected Excel workbooks with Access and XML-based data structures.
Education
Diploma in Computer Science at Peru
January 1, 1985 - January 1, 1985Coding Bootcamp at Carleton University
January 1, 2024 - January 1, 2024Diploma in Computer Science at Peru
January 11, 2030 - January 1, 1985Coding Bootcamp at Carleton University
January 1, 2024 - October 20, 2025Qualifications
Bootstrap 4 from Scratch
September 1, 2020 - September 1, 2020Advance ASP.NET Core 3.1 Razor Pages
January 1, 2021 - January 1, 2021Bootstrap 4.0 / CSS Courses
January 1, 2021 - January 1, 2021JavaScripts/jQuery
January 1, 2021 - January 1, 2021SQL Server Administration Part 1
November 1, 2022 - November 1, 2022Power Apps Complete Guide
February 1, 2023 - February 1, 2023Master Bootstrap 5
March 1, 2023 - March 1, 2023Coding Bootcamp
January 1, 2024 - January 1, 2024Microsoft Office Open XML
October 1, 2025 - October 1, 2025Working with Git and GitHub in Visual Studio
October 1, 2025 - October 1, 2025Developing an An asynchronous ASP.NET Core Web API
October 1, 2025 - October 1, 2025Bootstrap 4 from Scratch – Udemy
September 1, 2020 - October 20, 2025Advance ASP.NET Core 3.1 Razor Pages – Udemy
January 1, 2021 - October 20, 2025Bootstrap 4.0 / CSS Courses – On-line Certificates
January 1, 2021 - October 20, 2025JavaScripts/jQuery – LinkedIn Academy
January 1, 2021 - October 20, 2025SQL Server Administration Part 1 – Udemy
November 1, 2022 - October 20, 2025Power Apps Complete Guide – Udemy
February 1, 2023 - October 20, 2025Master Bootstrap 5 – Udemy
March 1, 2023 - October 20, 2025Carleton University – Coding bootcamp
January 1, 2024 - October 20, 2025Microsoft Office Open XML
October 1, 2025 - October 20, 2025Working with Git and GitHub in Visual Studio
October 1, 2025 - October 20, 2025Developing an Asynchronous ASP.NET Core Web API
October 1, 2025 - October 20, 2025Industry Experience
Government, Professional Services, Software & Internet
Skills
See more
Hire a Web Developer
We have the best web developer experts on Twine. Hire a web developer in Gatineau today.