Create Inventory Tracking Database

Project Title Create Inventory Tracking Database
Project Summary Create a database to track IT software and hardware purchase requests and reconcile those PRs to the purchase orders and finally to the items received.
Country Sri Lanka
Agency Department of State
DoS Office N/A
Post COLOMBO
Section IM
Number of Interns 1
Project Description

This project will be a little more complicated than the summary may suggest. We have approximately 20 staff members who place requests and will need to input their PRs into the database. The procurement office creates purchase orders, which may be local, or go through our acquisitions office in DC. The reconciliation process will rarely correlate directly from the request, the order, the requisition, or the items received. There needs to be a way to prompt staff members to track external entities such as procurement and acquisitions. I would like for the interface to be a Google site.

Required Skills or Interests
Skill(s)
Data visualization
Design thinking
Website design
Additional Information

IT inventory management is a challenge we face worldwide. If we can develope a solid functional solution for Colombo, we could potentially share this solution with other posts around the world.