Projects

AI4DA Energy Trilemma Insights Workbook

Tableau · RStudio · Python · Data Analysis & Visualization

Interactive Dashboards Preprocessed Data Reliable Results

Developed a multi-dashboard analytics workbook exploring the Energy Trilemma using household survey data, focusing on energy accessibility, reliability, and sustainability across regions and survey waves.

The analysis highlights regional disparities in infrastructure, electricity reliability, clean energy adoption, appliance ownership, and digital connectivity patterns.

Data cleaning and transformations were implemented and validated using Python and RStudio, ensuring reliable results through standardized preprocessing and aggregation checks.

Links:
Early BI Report · BI Dashboards · Insights Presentation

Credit Card Fraud Detection & Responsible AI Analysis

Python · Pandas · Data Cleaning · Fairness & Privacy Analysis

Fraud Detection Responsible AI Bias Evaluation

Developed a fraud detection analysis pipeline using credit card transaction data, focusing on data preprocessing, exploratory analysis, and responsible AI practices.

Conducted fairness checks across gender, age groups, and geographic populations, identifying demographic patterns in fraud rates while evaluating potential bias and representation imbalance.

Implemented privacy-preserving preprocessing by removing personally identifiable information (PII), transforming sensitive attributes, and structuring transaction-level data to support reliable fraud pattern analysis.

Links:
Github Repository · Project Proposal Slides

LuckySpot: Lottery-Based Event Management App (CMPUT 301)

Java · Firebase · Android Studio · Agile/Scrum

Mobile App Role-Based UX Team Collaboration

Co-developed a mobile app for fair lottery-based event participation with three role-specific journeys:

Includes Firebase Authentication, Firestore integration, UML design, sprint planning, and documented test cases.

Links:
GitHub Repository

Twitter-like Social Media Platform (CMPUT 291)

SQL · Python · MongoDB · DBMS

Database Design CLI Product Query Optimization

Developed a command-line social media platform with user registration, posting, following, and persistent data storage.

Optimized SQL queries for authentication/feed operations and built modular backend flows through structured Git collaboration.

Links:
SQL Project · MongoDB Project

JTI Business Analytics Dashboard

Tableau · Excel

Revenue Trends Operations KPI Customer Segments

Analyzed multi-table business datasets and developed a Tableau dashboard that highlights revenue dynamics, repair patterns, employee performance, and customer segmentation.

Links:
Dashboard Visualizations & Insights