Enterprise IT Equipment Management

Built during a professional IT internship, this system replaces manual asset logs with a centralized platform for receiving, assigning, and auditing enterprise equipment. It supports document attachments, user management, and searchable inventory records.

IT departments receiving hardware across multiple locations lacked a single source of truth. Paper forms and shared drives led to lost records, duplicate entries, and slow audits.

A centralized ASP.NET application where staff log received equipment, attach documentation, assign assets to users, and query inventory through a structured admin interface backed by SQL Server.

• —Equipment receiving and intake forms
• —Document upload and attachment storage
• —User management with role-based access
• —Searchable inventory with filtering
• —Audit-friendly record history

Classic three-tier ASP.NET web application with server-side rendering, SQL Server for persistence, and Bootstrap for responsive admin UI. Business logic separated from data access for maintainability.

Normalized SQL Server schema with tables for equipment, users, departments, documents, and assignment history. Foreign keys enforce referential integrity; indexes optimize common search queries.

• Migrating paper-based workflows without disrupting daily IT operations
• Designing flexible document storage linked to asset records
• Balancing enterprise security requirements with usability for non-technical staff

• →Enterprise software adoption depends on matching existing processes, then improving them incrementally
• →Strong database design upfront prevents costly refactors as inventory grows
• →Admin UX clarity reduces training time and support burden

• • Barcode/QR scanning for asset check-in
• • Automated depreciation and lifecycle alerts
• • Integration with procurement systems
• • API layer for cross-department reporting