InternalSnow College
Enterprise IT Portal
IT budgeting, inventory, and computer-replacement planning lived in spreadsheets nobody trusted.
roleFull Stack Development Intern & Team Lead
timelineJun 2024 — May 2025
statusinternal
- React
- TypeScript
- FastAPI
- Oracle
- PostgreSQL
// problem
College IT tracked budgets, inventory, and machine-replacement cycles in spreadsheets — error-prone, unauditable, and painful to report from.
// users
IT staff, directors, and leadership planning budgets and replacements.
// solution
A centralized portal for IT budgeting, inventory, and computer-replacement workflows, including QR-code-based inventory tracking of physical assets.
// architecture
React + TypeScript frontend over a FastAPI backend integrating Oracle and PostgreSQL databases.
// my role
- Frontend build and backend contributions
- QR-code inventory functionality
- 10+ demos to IT leadership and directors; user and product-owner training
- Mentored four interns — onboarding, code reviews, weekly milestones
// status & outcomes
Replaced spreadsheet-based processes with a centralized application adopted by the IT organization.
// lessons
Demos drove adoption more than features — showing leadership their own data every two weeks built the trust the spreadsheets never had.