Project Overview: Billing Management System

Texas Distribution Co. needed an efficient system to track purchases from various suppliers, manage product inventories, and generate accurate tax invoices. The existing manual processes were prone to errors, time-consuming, and lacked real-time data insights, impacting the company's operational efficiency and customer satisfaction.

The development of a web-based Billing Management System was crucial to:

Streamline purchase tracking and supplier management.

Automate tax invoice generation to reduce errors and ensure compliance.

Enhance data organization for better decision-making.

Improve operational efficiency by replacing manual processes with automated solutions.

Provide real-time insights and reporting capabilities to support strategic planning.

The project was successfully completed by:

Designing and implementing modules for Suppliers, Products, and Billing.

Creating a robust online PostgreSQL database for data management.

Developing a user-friendly web application using Streamlit.

Ensuring seamless functionality through iterative testing and bug fixes.

Deploying the application on AWS, providing a scalable solution for the company.

Database Setup: PostgreSQL

Web Application Development: Python3, Streamlit

Tax Invoice Generation: HTML, PDF conversion libraries

Testing and Deployment: AWS

Project Management: Flowcharts, Design Documents

Database Design: ER Diagram