Mini Online Retail System
May 2024 - Jul 2024 (3 months)
Designed and implemented 10+ dashboards using SQL & Power BI to visualize sales trends, inventory levels, & customer behavior. Automated inventory management & order processing using stored procedures & triggers, reducing manual errors by 30%. Analyzed 20,000+ records, identifying sales trends that led to a 12% increase in quarterly revenue. Additionally, I leveraged my database management skills in SQL for product and customer data, which provided a strong foundation for future integration with tools like Metabase for enhanced data visualization. While PostgreSQL was not directly utilized, my expertise in relational databases ensures adaptability to various database systems. Although AWS services were not part of this project, my knowledge