Kevin Hsueh Project Registry - Dashboards, Tools & Games

[Enterprise Case Study] A production-grade Power BI solution originally deployed to monitor workforce stability across 40+ client accounts. Built on an Azure Data Factory pipeline to centralize fragmented HR data. This portfolio version presents a static, anonymized snapshot of the production environment, demonstrating complex DAX modeling for retention analysis and strategic attrition forecasting.

A fully automated music intelligence dashboard functioning as a real-time 'Spotify Wrapped.' Engineered a Python ETL pipeline that performs automated data enrichment and hash-based delta detection preventing redundant R2 uploads to minimize bandwidth costs. The enriched data is modeled into a Star Schema, compressed into Parquet, and served via a high-performance React frontend.

A personal productivity tracker that turns raw activity logs into actionable insights. Uses Python ETL scripts to parse unstructured logs, employing incremental loading strategies (checksum validation) to ensure only new or changed data is processed. The data is modeled into a structured Fact/Dim schema and compressed for optimal retrieval speed in the React dashboard.

Comprehensive tax calculator for Uruguayan employees. Automatically computes IRPF, FONASA, and BPS deductions to provide precise net salary breakdowns.

Accessibility-focused color tool generating WCAG-compliant palettes using 6 harmony types (Analogous, Triadic, etc.). Features real-time contrast checking and instant hex export.

Complete percentage suite with 7 modes including Markup/Margin, Discount, Reverse Percentage, and natural language queries like 'What is X% of Y?'.

Financial projection engine comparing loan amortization schedules against potential investment returns. Features compound interest modeling and extra payment scenarios.

Multi-location meeting planner visualizing overlapping business hours across 400+ timezones. Features live world clock and type-to-search offset lookup.

A unified gaming portfolio aggregating data from Steam, Guild Wars 2, and Maplestory. To navigate strict API quotas, I engineered an intelligent Python pipeline with hash-based delta detection and local caching—ensuring 99% reduction in redundant API calls. The system constructs complex Dimension tables to normalize disparate game ecosystems into a unified Star Schema, delivering near-real-time insights.

Progression tracker for 'Challenger World' gaming season. Maps optimization paths from Bronze to Challenger rank with daily checklists, boss XP calculations, and responsive tier visualization.

Comprehensive personal finance tracker to manage income, expenses, and subscriptions. Features 50/30/20 rule analytics, monthly balance tracking, and local autosave.

Universal conversion utility supporting 100+ units across Mass, Length, Volume, Temperature, Speed, and Data storage with high-precision handling.

Vacation entitlement calculator based on Uruguay's labor law No. 12,590. Estimates accrued days, seniority bonuses, and optional vacation payouts.

Interactive WCAG accessibility tester. Checks contrast ratios for text, links, and UI components against AA/AAA standards with live preview and history.

High-intensity arcade survival shooter. Pilot a lone ship against endless waves of enemies using deep stat building and tactical reload mechanics.

Semi-annual bonus estimator for Uruguay (Sueldo Anual Complementario). Supports dual period calculations (June/Dec) and prorated adjustments for partial years.

4-in-1 negotiation tool. Calculates new salary from percentage raises, projects multi-year growth, and estimates net salary impact after deductions.

Visual cron expression generator. Translates cryptic cron syntax into human-readable schedules with next-run previews and one-click presets.

Real-time world boss spawn tracker for Black Desert Online. Displays upcoming boss schedules for NA and EU servers with automatic timezone conversion to your local time.

A personal weather and work location tracking dashboard for Montevideo. Captures daily temperature ranges, humidity levels, and weather conditions using COCO weather codes (1-27 scale). Tracks work-from-home patterns and correlates weather severity with location decisions, providing insights into how climate impacts productivity and remote work choices.