Projects

What I've been working on

Automated Performance Reporting System

  • A multi-source SQL ETL pipeline engineered to consolidate fragmented client metrics into a unified reporting database, accelerating real-time performance tracking and data analysis.
  • Automated Anomaly & Threshold Alerts: SQL-driven alert engine that triggers real-time automated email notifications to stakeholders whenever critical operational or financial performance thresholds are breached.
  • Data Integrity & Schema Auditing: System-wide data audit process designed to identify and resolve underlying formula errors, data inconsistencies, and schema drift, ensuring reliable metrics for high-stakes decision-making.
SQLETLAutomation

Shelfie

  • A social reading app that lets you search millions of books in real time by pulling live results from the Google Books API straight into a Supabase-backed catalog.
  • Designed the database schema to support shelves, friendships, and recommendations, with personalized feeds built through server-side data aggregation instead of a generic activity feed.
  • Built as a proper multi-user app on Next.js App Router with Supabase SSR authentication, so every user's shelf and account data stays private to them.
Next.jsSupabaseGoogle Books API
Visit site GitHub

SlidesToNotes

  • Automated Extraction: Converts uploaded PowerPoint (.pptx) decks into concise, easy-to-scan bullet points using automated content extraction.
  • Interactive In-Browser Editor: Features a responsive TypeScript and Tailwind CSS web interface for real-time note refinement and editing.
  • Seamless Exporting: Generates formatted .docx files directly from edited web notes for quick studying, printing, and sharing.
TypeScriptTailwind CSSPPTX to DOCXClaude Code
Visit site GitHub

TransiTask - Scheduling Assistant

Hackathon Participant, The Golden Hack 6.0

  • A full-stack scheduling app built in React that pairs real-time task management with location-based services to help students and newcomers find their footing around the city.
  • Synced live with users' Google Calendars via OAuth, so events created or updated in the app show up on their calendar and vice versa.
  • Took 1st place for “Best Community Business Solution” at The Golden Hack 6.0 for connecting people to local essential services in a way that actually made daily life easier.
ReactREST APIsGoogle Calendar API
GitHub

Student Marking Application

  • An automated grading tool built in Excel with VBA, using SQL queries under the hood to pull, transform, and analyze student data without manual spreadsheet wrangling.
  • Linked Excel to Word to auto-generate statistical summaries, charts, and KPIs directly from the grading data, cutting a repetitive reporting task down to one click.
  • Wrote setup and maintenance docs so instructors could deploy and run the tool themselves, without needing a developer around every time something changed.
ExcelVBASQL

AI Detection System

Hackathon Participant, Hack Canada

  • Intelligent AI Text Detection: Leverages a Python and Scikit-learn machine learning model trained on engineered text features to detect and flag AI-generated content with high prediction accuracy.
  • Fast, Real-Time Inference: Operates on a lightweight Flask backend using Pandas, NumPy, and Joblib to ensure low-latency text processing and instant classification results.
  • Transparent Factor Breakdown: Features a clean, accessible web interface that delivers a granular, factor-by-factor analysis explaining why text was flagged, rather than a basic binary verdict.
PythonScikit-learnFlask
GitHub

Neighbourhood Database

  • A relational MySQL database built in phpMyAdmin, normalized to Boyce-Codd Normal Form (BCNF) to eliminate data redundancy and prevent operational anomalies across neighbourhood records.
  • Automated Data Logic: Incorporates custom MySQL triggers and stored functions to enforce integrity rules, perform automated checks, and update internal state changes.
  • Simplified Data Access: Features complex SQL multi-table queries and custom views designed to abstract relational data for fast administrative reporting and retrieval.
MySQLphpMyAdminSQL

Student Daily Pulse

  • Dual-Role Submission Engine: An internal daily check-in tool allowing team members to submit daily pulse updates via voice or text, automatically persisting responses to a Supabase backend.
  • Role-Based Privacy Middleware: Custom middleware architecture that enforces strict role-based data isolation, preventing individual contributors from viewing peer entries while granting managers secure administrative oversight.
  • AI-Powered Manager Analytics: Integrated Groq AI models into the manager dashboard to generate instant, customizable summaries of employee updates across selected dates or multi-week timeframes.
SupabaseGroq AIMiddleware