# BI Dashboard  (US-Based)

**Tech Stack:** [ASP.NET](http://ASP.NET) MVC · Dapper · MS SQL Server, 3PL Concept

**Project Summary:**  
Designed and delivered a **scalable Business Intelligence (BI) dashboard** providing real-time analytics and cross-department reporting for a **multi-store business ecosystem**. The solution enabled management to make faster, data-driven decisions through consolidated KPIs and interactive visualizations.

### Key Contributions

* Led **backend development** using [ASP.NET](http://ASP.NET) MVC and Dapper, ensuring high-performance data access and scalability.
    
* Designed and optimized **complex SQL queries, stored procedures, and database schemas** to support real-time reporting.
    
* Worked directly with the client to **analyze business workflows** and translate requirements into modular, maintainable features.
    
* Built **interactive dashboards** with charts, KPIs, and analytics views for executive and operational reporting.
    
* Developed analytics modules covering **inventory, purchases, orders, sales, and employee performance**.
    
* Implemented **report export functionality** (PDF, Excel, CSV) to support business and compliance needs.
    
* Architected **multi-store, multi-seller, and multi-user access** with secure role-based authorization.
    
* Performed **testing, debugging, and performance tuning** to ensure reliability under large datasets.
    
* Supported **deployment, documentation, and handover**, enabling smooth long-term maintenance.
    

### Impact & Results

* Delivered a **high-performance BI platform** with real-time insights across multiple business units.
    
* Significantly **improved reporting speed and usability** through query optimization and efficient data access patterns.
    
* Enabled leadership teams to track performance and trends from a **single centralized dashboard**.