At Datahouse Asia, I developed SQL queries and dbt models for the Disability Compensation Division - State of Hawaii, processing data across a database of 100+ tables. I also built QuickSight dashboards covering business metrics and reporting needs.
For the Helpdesk Power BI Dashboard project, I built reports on Jira ticket data and automated daily refreshes through Power BI Service. The dashboard reduced recurring manual Excel reporting by an estimated 5–7 hours per week.
At The ALAB Data Technology, I scraped tea-industry data and designed a PostgreSQL database for analysis and reporting. I also co-developed Tableau dashboards and contributed to a Django web application supporting 32K+ orders and 9.5K+ customers.
In my personal projects, I designed a PostgreSQL hospital data warehouse with ETL workflows and embedded Power BI dashboards in a Django platform. I also developed a movie recommendation system using TF-IDF and cosine similarity, with an interactive Streamlit and Plotly dashboard.
