Open to opportunities

Andrew Stam

@andrewstam

Message

Senior .NET developer modernizing enterprise backends with scalable REST APIs and optimized SQL.

Canada

Message

What I'm looking for

I’m looking to build secure, high-performance .NET backends—modernizing legacy systems, designing scalable REST APIs, and tuning SQL Server—within Agile teams that value CI/CD, testing, and collaboration.

I’m a Senior .NET Developer with 10+ years of experience designing, building, and modernizing enterprise backend systems. I focus on scalable REST APIs, database performance, and transforming legacy platforms into maintainable architectures.

In my recent roles, I architected multi-tenant database models to improve scalability, maintainability, and data isolation. I also led legacy MySQL/MariaDB migrations to PostgreSQL, managing schema transformation, data mapping, and validation while refactoring Entity Framework configurations for accurate, high-performance data access.

I’ve built secure, high-throughput integrations and workflow platforms that reduce operational burden—for example, designing a scalable sales order workflow used by 20+ resellers and cutting manual order processing time by 60%. I’ve also delivered product-level capabilities like a dynamic localization service for multilingual UI support.

I’m comfortable delivering in Agile/Scrum environments across the full software lifecycle, from design to production support. I regularly apply CQRS, Repository Pattern, and Clean Architecture, and I leverage CI/CD, automated testing, containerization, and cloud-based deployments to ship reliable, secure systems.

Experience

Work history, roles, and key accomplishments

Software Developer III

Upperity (SEZC) Ltd

Jan 2024 - Jan 2026 (2 years)

Architected a multi-tenant database model and refactored EF configurations to improve scalability, maintainability, and data isolation. Led migration from MySQL/MariaDB to PostgreSQL and built secure REST APIs and a sales order workflow used by 20+ resellers, reducing manual order processing time by 60%.

C#ASP.NET Core PostgreSQL REST APIs Data Migration CQRS Gitlab

Senior Software Developer

Book4Time Inc.

Dec 2022 - Jan 2024 (1 year 1 month)

Developed and enhanced backend services and enterprise SaaS features using C#, ASP.NET Core, SQL Server, Angular, and TypeScript. Built high-availability REST APIs for thousands of daily transactions and optimized SQL Server queries, stored procedures, and database structures to improve performance and reliability.

C#ASP.NET Core SQL Server T SQL REST APIs Angular TypeScript Stored Procedures Agile Scrum

Senior Developer

DMS Organization

Jan 2022 - Jul 2022 (6 months)

Rebuilt a high-traffic buy-and-sell web platform from the ground up using ASP.NET Core, SQL Server, Angular, and TypeScript. Designed the database schema and data access layers, developed REST APIs and backend services, and supported Salesforce administration for multiple business units.

ASP.NET Core SQL Server EF Core Angular TypeScript REST APIs Database Schema Design Salesforce Administration

Systems Programmer

Cayman Islands Monetary Authority

Jan 2020 - Jan 2022 (2 years)

Designed, developed, and maintained regulatory enterprise systems using ASP.NET Core and SQL Server. Implemented CQRS and Repository patterns, automated unit/integration testing, built SQL Server objects (stored procedures, views), and reduced deployment time using structured SQL Server Database Projects while integrating external regulatory websites with internal platforms.

ASP.NET Core SQL Server CQRS Stored Procedures Integration Testing DevOps

Software Developer

DMS Fund Governance

Feb 2019 - Jan 2020 (11 months)

Developed and maintained workflows, reports, and tools using .NET Framework and SQL Server. Built a secure client portal for external users and supported backend systems with database updates and troubleshooting, including investigating Salesforce issues related to quarterly maintenance releases.

.NET Framework C#SQL Server Reporting Workflow Development Salesforce Support

Lead Software Developer

ClearPay Canada Corporation

May 2018 - Dec 2018 (7 months)

Led technical strategy while staying hands-on in development (50% leadership / 50% engineering) and managed two contract developers. Contributed to achieving SOC 2 Type 1 certification and maintained ASP.NET applications and SQL Server databases, monitoring performance metrics and supporting hosting/security vendor relationships.

ASP.NET .NET Framework SQL Server Technical Leadership Performance Monitoring Agile Scrum Git

Contract SQL Developer

Brac Informatics Centre

Nov 2017 - May 2018 (6 months)

Developed and maintained stored procedures, SQL scripts, and C# web services supporting multiple web clients. Performed database troubleshooting, performance analysis, and query optimization, and produced Tableau business intelligence reporting while diagnosing and resolving production database and application issues.

C#.NET Framework SQL Server T SQL Stored Procedures Query Optimization Tableau Web Services Production Support

Contract Web Developer

Harmonic Fund Services

May 2017 - Nov 2017 (6 months)

Developed enterprise web applications using ASP.NET MVC, SQL Server, Angular, and TypeScript. Implemented backend logic and REST endpoints, created unit tests to prevent regressions, and participated in code reviews to ensure maintainable, optimized code.

ASP.NET MVC C#SQL Server Angular TypeScript REST APIs Unit Testing Code Review

Contract Web Developer

DMS Fund Governance

Oct 2009 - Mar 2017 (7 years 5 months)

Developed internal enterprise applications and integrations using C#, ASP.NET MVC, and SQL Server. Automated invoicing and digitized document workflows, reducing processing time from one week to approximately three hours, and built WCF web services while optimizing SQL Server stored procedures and SSRS reporting.

C#ASP.NET MVC SQL Server WCF SQL Optimization JavaScript

Education

Degrees, certifications, and relevant coursework

Python Institute

Certified Entry-Level Python Programmer (PCEP), Python

Earned the PCEP certification (Certified Entry-Level Python Programmer) in October 2023.

Georgian College of Applied Arts and Technology

College Diploma, Computer Programmer/Analyst

Completed the Computer Programmer/Analyst program at Georgian College and received a college diploma. The course included systems analysis and design and a third-year system project using the Systems Application Development Life Cycle.