Designed and implemented a relational Inventory Management Database using SQLite to manage products, suppliers, warehouses, and stock levels. The project includes:

Normalised table structures and foreign key relationships

SQL queries for tracking inventory and generating basic reports

Basic CRUD operations for products and warehouses

View, add, update, and delete inventory records

Notes: Sample / Demonstration Project – runs entirely via terminal with SQLite backend.

Designed and implemented a Sales Analytics Database using MySQL to track product sales across regions. The project includes:

Relational database schema with normalised tables and foreign key relationships

SQL queries for aggregating sales, ranking products, and generating reports

Insights on total sales, top-selling products, and regional performance

Ready-to-use queries for analytics and reporting

Notes: Sample / Demonstration Project – ideal for demonstrating database and SQL analytics skills.

Implemented a Data Cleaning and ETL (Extract, Transform, Load) pipeline to process raw sales and inventory data into structured, analysis-ready datasets. The project includes:

Extracting data from multiple sources (CSV, database)

Cleaning, transforming, and normalising datasets

Loading processed data into MySQL / SQLite for reporting

Sample SQL queries for analytics and reporting

Notes: Sample / Demonstration Project – demonstrates data engineering and analytics workflow.

Created a professional technical documentation portfolio, including system architecture overview, database design documentation, API documentation examples, and a developer setup guide to demonstrate structured software documentation practices.

Notes: Sample / Demonstration Project

This project involved designing and developing a database-driven billing system for small-scale business use.

The objective was to create a lightweight and efficient solution for managing customers, products, and invoice generation without relying on complex enterprise tools.

The system was built using Python with a structured SQLite database backend. A modular architecture was implemented to separate database handling, business logic, and output generation, ensuring maintainability and scalability.

Key challenges included structuring relational data efficiently and generating clean, readable invoices in multiple formats. These were addressed by designing a normalised database schema and implementing automated invoice generation in both PDF and Excel formats.

Retail Inventory & Billing System built in MS Access with a centralized dashboard for managing sales, purchases, customers, and payments.

Includes a dynamic invoice generation system where users can print or export invoices using SaleID selection.

Key strength of this system is built-in business control:

Prevents sales when stock is insufficient Blocks transactions if customer exceeds credit limit

This ensures accurate inventory and controlled credit exposure.

Features:

Dashboard-based navigation (no direct table access) Sales & Purchase tracking Customer and supplier management Payment recording and due tracking Invoice report (print) Query-based analytics (sales, stock, profit & loss, customer status)

Built using MS Access with VBA for automation and control logic.

Suitable for small retail businesses, wholesalers, and inventory-based operations.