Key Work & Impact

Designed a normalized relational schema using ER modeling to ensure consistent reporting across businesses, users, reviews, and relationships—reducing redundancy and improving query reliability.

Built an interactive BI application that supports real-world exploration workflows: search businesses by city, name, and star thresholds, with results displayed in a scrollable table for fast comparison.

Implemented user-driven analytics and interaction flows (login validation, write-a-review, add-friend) to simulate how BI systems support operational actions—not just read-only dashboards.

Wrote and optimized 10+ SQL queries powering dynamic filters and reports, ensuring case-insensitive search and flexible optional filtering without breaking the UX.

Added clear success/error messaging and simple navigation to make the tool usable for non-technical users while keeping the underlying query logic structured and testable.

Packaged the project with documented structure and instructions so the database + application can be reproduced and demoed end-to-end.