CAA Niagara — Inventory Management System

An internal tool that replaced CAA Niagara's spreadsheet-based inventory tracking with a proper application built on ASP.NET MVC and SQL Server.

Problem

Inventory and operational assets were being tracked in shared spreadsheets. Data was inconsistent, reports were slow to produce, and role-based access was impossible to enforce.

Solution

Built a full ASP.NET MVC application with:

• Backend controllers supporting inventory tracking and operational asset workflows
• Role-based authorization and server-side validation across every module to reduce incorrect submissions
• SQL performance tuning — refined joins and added targeted indexes to make reporting queries fast
• Audit-friendly — every state change tracked with timestamps and user attribution

Stack

ASP.NET MVC · C# · SQL Server · Entity Framework · Bootstrap

Impact

Reporting queries that previously took seconds now run in milliseconds. Role-based access removed an entire class of data-entry mistakes, and the team stopped relying on spreadsheets for operational decisions.