Adam Lauzon

Applying somewhere outside data/database work? See the general resume → or the manufacturing-focused resume → · Most of my career runs behind company firewalls — read the work records →

Professional Summary

Senior developer with 25+ years designing and building the databases behind ERP, MES, and reporting systems for electronics and industrial manufacturers. Has designed schemas and data models from a blank slate (built a manufacturing execution system's entire data model early in his career), consolidated multi-system operational data into reporting databases used company-wide, and built the data entities and ETL that move information between ERP and shop-floor systems. Works across SQL Server, PostgreSQL, and MySQL, with Dynamics 365 F&O data entities and REST data contracts on the integration side. AI-assisted development now accelerates schema and pipeline work without changing who owns the design decisions. Holds an active Government of Canada Reliability Status.

Core Skills

• Database development: schema & data model design, T-SQL, stored procedures, views, reporting-database design, SQL Server, PostgreSQL, MySQL, Oracle (early career)
• ETL & integration: ETL pipelines between ERP/MES and shop-floor systems, Dynamics 365 F&O data entities & REST data contracts (certified MB6-894), document/BOM normalization pipelines, vendor API data integration
• Reporting & dashboards: Grafana, SQL reporting, consolidated "digital twin" production reporting databases built to keep ad-hoc queries off production servers
• Domain data modeling: product genealogy & lot-code traceability, defect/repair tracking, test tracking, kitting, SMT feeder verification, MRP-integrated materials data
• Compliance: Government of Canada Reliability Status (Active through 2034)
• Application layer (full-stack context): C#/.NET, Node.js, Angular/TypeScript, REST API design
• AI-accelerated development: AI-assisted coding workflows, LLM integration, MCP, AI agents, prompt engineering

Professional Experience

MPIQC / Timila — Senior Developer

SQL Server • MySQL • Angular • Node.js • REST APIs • AI

• Build and maintain applications and utilities for use across all departments on SQL Server and MySQL backends, alongside Angular, Node.js, C# .NET, Python, and PHP.
• Built a quoting platform (Angular/Node.js/n8n/Ollama with vendor pricing APIs) that cut quote turnaround from hours (sometimes 1–2 days) to about five minutes — required normalizing pricing data from multiple vendor sources into a consistent internal model.
• Built an automated document control process that parses customer Bills of Materials and maps them into the company's internal BOM data format.
• Used AI-assisted development to accelerate delivery while maintaining full engineering ownership and code quality.

Ross Video — Senior Developer

SQL Server • Grafana • ETL • Angular • C#/.NET

• Designed and built a consolidated "digital twin" reporting database (SQL Server) that pulled together data from multiple operational systems — quality, manufacturing, logistics — so staff could run ad-hoc queries and dashboards (Grafana) without touching production servers.
• Built the reporting/dashboard UIs on top of that database, giving operations staff self-serve access to production data that previously required a request to engineering.
• Developed Angular/TypeScript applications supporting quality, manufacturing, logistics, administration, and reporting — the primary internal tooling for operations staff.
• Led a small team of developers and business/systems analysts for two years while remaining hands-on with database and application design.

SigmaPoint Technologies — Senior Developer

Dynamics 365 F&O (X++) • SQL • Azure Logic Apps • Power Automate

• Technical lead for Microsoft Dynamics 365 F&O integration, bringing the company's new Kitchener/Waterloo facility onto the ERP — designed data entities for migration and integration, REST data contracts, and ETL workflows connecting the ERP database to manufacturing systems (Azure Logic Apps, Power Automate).
• Built cross-system quality flows with data flowing both directions — e.g., quality orders created on component receipt in D365, dispatched to the FactoryLogix MES database for incoming inspection, with pass/fail results written back automatically to release material to stock.

CGI — Senior Consultant

Oracle • JavaScript • Bootstrap

• Developed B2B web portals on an Oracle-backed platform for a major telecommunications client, on a multi-developer team.
• Held Government of Canada Top Secret security clearance for the duration of the engagement.

Earlier Roles — SigmaPoint Technologies (2004–2011) • United Tri-Tech (1999–2004)

• Designed and built the data model for SigmaTrack, SigmaPoint's ColdFusion-based MES, growing it from a WIP-tracking app into the full manufacturing execution system for the Cornwall facility: product genealogy, defect and repair tracking, test tracking, materials tightly integrated with Alliance MRP, kitting, SMT feeder verification, component lot-code traceability, and a price book — all from a schema built from scratch.
• A decade of database and web development for electronics manufacturing on SQL and PostgreSQL: inventory and traceability applications, customer and supplier portals, company intranets, plus web-server setup and administration.

Independent Projects — Snapi.ca & Acrewity.com

SQLite • Multi-tenant data architecture • Node.js • Angular

• Designed multi-tenant data models for two SaaS products built solo end to end — including usage metering and account/API-key data for a 22-service API platform (Acrewity) and a SQLite-backed schema for persistent, positionable record storage in a workflow application layer (Snapi, built to migrate to MySQL as scale requires) — demonstrating current, hands-on schema design outside the manufacturing domain.

Selected Open Source

• MES Track — full MES for electronics assembly built around a serialized WIP-tracking schema: scan stations, routing, defect & repair, first-off inspection (Angular 18 • Express/TypeScript • SQLite or SQL Server • Docker). A from-scratch personal project in the domain worked in for 20 years.
• ERP-System — event-driven ERP for electronics contract manufacturers built on a multi-tenant PostgreSQL schema: real-time planning with no batch MRP run, API-first with signed webhooks (Node/TypeScript • Angular).
• SassyEL — self-hostable SaaS enablement layer: multi-tenant auth, plans & entitlements, team management, webhooks, embeddable control-panel SDK.

Education & Certifications

• miniMBA — University of Windsor (2023)
• Dynamics 365 Development, Extensions & Deployment (MB6-894) — Dynamics Edge (2018)
• Enterprise Java Developer Certificate — Algonquin College (2009)
• Business Technology / Information Systems Diploma — St. Lawrence College (1998)