Asset Management

Inventory Tracker

Problem

Businesses needed a centralized inventory system with accurate stock and expiry date tracking.

Solution

Built an inventory system with stock and expiry date tracking, and report generation.

Inventory Tracker GIF

Key Features

Stock tracking
Expiry date tracking
Inventory report generation (Excel file)
Inventory Tracker GIF 2

Technologies Used

PythonTkinterPostrgreSQLGithub

My Contributions

  • Developed the entire application independently
  • Tested the application with real inventory data and iterated based on quality of output
Inventory Tracker GIF3

Challenges

  • Making data entries easier for 200+ inventory items
  • Identifying reports that need to be separated into multiple reports for better readability

Key Learnings

  • Iterating based on the quality of the output file is crucial for improving usability
  • Generating reports in multiple formats can improve readability and user experience

Entity-Relationship Diagram

Inventory Tracker ERD

Interested in Learning More?

Feel free to email me if you'd like to discuss this project in more detail or explore potential work/collaboration opportunities.

shaniaaman98@gmail.com