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, MapleStory, GTA V, and Black Desert Online (pearl marketplace, boss timer, tax calculator). 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.

Progression tracker for Challenger World Season 3. Per-level missions (260–290), Kai tier gates, updated boss roster with Adversary, and coins-only hunting missions.

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.

World boss spawn tracker for Black Desert Online (NA). Previous, next, and upcoming spawns from the Pearl Abyss Pacific schedule with countdowns and a weekly grid in your chosen display timezone.

Pearl Shop sale tracker with the best discount recorded per item, original vs sale pearl prices, and post dates. Searchable catalog with quick filters for subscriptions, maids, and category-only rotations.

Central Market (NA) profit calculator. Enter a sell price and see tax, Value Pack, Merchant Ring, and Family Fame bonuses broken down into net silver.

Custom new tab page for Chromium browsers. This portfolio page is an interface showcase with screenshots.

Personal reading analytics from your MangaUpdates lists: momentum, genre mix, catalog depth, and a weekday rhythm—with list metadata, reading history, and cover art from MangaUpdates.

Pipeline observability across portfolio repositories: consolidated run history, success rates, 7-day trends, and failure surfacing in one view. Cloudflare Pages Functions call the GitHub REST API with a server-side PAT, cached at the edge for 30 minutes per refresh.

Convert and compress HEIC, JPG, PNG, and WebP images in your browser. Batch convert between formats with optional size optimization — files never leave your device.

Format and minify JSON in your browser. Side-by-side input and output with collapsible tree view or plain text. Validates syntax on format or tree view.

Compare two pieces of text side-by-side with instant highlighting. Line, word, or character diff modes with options to ignore case, whitespace, or accent changes. Export a unified patch without leaving your browser.