TA Dashboard

Overview

• ▸Hierarchical drill-down navigation (Year → District → Field) with live-filtered dashboard content at every level
• ▸Real-time Pre-TA vs. TA completion gauges computed via server-side SQL aggregation rather than client-side calculations
• ▸Interactive breakdowns by asset type (vessels, tanks, piping) and inspection method (VI, VE, UT, MT, PT, radiography, etc.)
• ▸Migrated the backend from MySQL to PostgreSQL, reverse-engineering and rebuilding six lost stored procedures as native Postgres functions with only the client API contract to go on
• ▸Diagnosed a subtle PostgreSQL bug where random() inside an uncorrelated subquery was evaluated once and silently reused across every generated row, corrupting seeded data distributions
• ▸Traced a global CSS leak (an unscoped stylesheet selector) that was forcing incorrect row heights across every table in the app
• ▸Replaced a heavyweight third-party data-grid dependency with a lightweight custom table component for better layout control and performance
• ▸Designed a full visual identity — color system, typography, spacing, component library — from scratch, replacing a legacy, inconsistent UI

Full-stack analytics dashboard for tracking industrial turnaround (TA) inspection progress across sites, districts, and asset types. Built with React, Node/Express, and PostgreSQL. Designed the entire UI from scratch and migrated the backend from MySQL to PostgreSQL, including reconstructing lost stored procedures. Features live progress gauges, interactive charts, and drill-down navigation by year/district/field.