IndyRadar: Unified Aura–CRDB Insights for Data Ops

Next.js 14 web app leveraging Google OAuth, TypeScript, and REST APIs to detect orphaned and duplicate database instances instantly.

Lead Product Designer & FE Engineer, 2024 – 2025

Challenge

Hidden orphan and duplicate records in Aura vs. CRDB created costly blind spots for ops teams. Management needed a single pane of glass to flag issues before they snowballed into service interruptions.

Led ideation to define status categories and wireframe a streamlined anomaly-filter view.

Approach

I kicked off with stakeholder workshops to map data mismatches, then distilled those insights into three clear status categories. This user-centered framing ensured every design choice solved a real pain point. Discovery I started by mapping Aura and CRDB schemas side-by-side to pinpoint mismatches, then defined three status categories (orphan, duplicate, matched) to drive our UI. Design From those insights, I sketched low-fi wireframes in Figma, iterated with key stakeholders, and finalized high-fidelity mocks that balanced data density with scan-ability. Development I built the app in Next.js 14 with iterative two-week sprints, pairing unit-tested React components (TypeScript + Tailwind CSS) with Prisma-backed API calls for reliable data linking.

Drilled into instance details—region, size, memory—in modals that accelerate data audits and guide next features.

Prototype & Tech

Next.js 14 + App Router auth-next + Google OAuth Aura REST API / CRDB via pg / swr Client-side data‐link logic in TypeScript Test via jest Built in Next.js 14 with TypeScript, Prisma, NextAuth/Google OAuth and Tailwind CSS, the MVP balances performance with maintainability. Every API call and component is unit-tested to Norwegian enterprise standards for reliability.

Orphan and duplicate data in Aura vs. CRDB created hidden operational risks and wasted resources.

Key Screens

The “Matched vs. Orphan” grid lays out instance health at a glance, while the “Grouped by Customer” view delivers targeted insights for account teams. Color-coded badges and tooltips guide users without overwhelming them.

Built on Next.js 14 with NextAuth/Google OAuth, TypeScript, Prisma, and REST APIs for secure data linking.

Outcomes & Next Steps

Early trials slashed manual audit time by over 50 % and surfaced 120+ orphan records in week 1. Next up: add real-time alerts and reporting exports to extend the value across Nordic operations.

Interactive grid of matched instances with live status badges and customer grouping for instant clarity.