Transforming data integration from complex JSON workflows into an intuitive Admin Console. By redesigning the system with Redwood style guidelines and visual configuration interfaces, we enabled System Administrators to create job configurations, ingest data, and manage schemas 70% faster—eliminating the need to work directly with raw JSON files.
The legacy MCPS-Manager exposed raw JSON data structures that System Administrators had to manually parse, understand, and manipulate. Admins like Gavin needed to create Job Configurations to ingest customer data, but the process was cumbersome: working directly with complex JSON files, managing source detection, and mapping columns—all without visual assistance.
The result: slow, error-prone workflows and significant cognitive load on a small team managing critical data integration tasks.
Redesigned the entire platform using Oracle's Redwood Style Guide, creating a visual-first Admin Console where System Administrators can:
Deep analysis of the legacy MCPS-Manager system. Documented how System Administrators currently worked with JSON structures, identified pain points, and mapped the data flow from source detection to column mapping to data ingestion.
Designed a clear, hierarchical structure for the Admin Console. Created navigation patterns that surface key actions (Create, Search, Edit, Delete) and organized screens logically: Dashboard → Job Configurations → Configuration Details → Execution Logs.
Built intuitive workflows for data source selection and connection. Designed forms and wizards that guide admins through source detection, validation, and configuration without requiring JSON knowledge.
Designed comprehensive CRUD interfaces following Redwood style guidelines. Created detail pages with inline editing, confirmation dialogs, and clear error messaging. Built list views with filtering, sorting, and search to help admins manage hundreds of job configurations.
Transformed the query builder interface from a text-based JSON editor into a visual query composer. Admins can now build complex queries through an intuitive interface with drag-and-drop column selection, operator dropdowns, and real-time query preview.
Implemented the unified shell/navigation framework, integrated all modules into a cohesive Admin Console, and ensured consistent styling across all components using Redwood design system.
Role: Manages data integration workflows and job configurations for Oracle Unity Data Platform.
Key Responsibilities:
Mental Model Shift: Gavin thinks in terms of "data sources," "columns," and "jobs"—not JSON structures. The redesign centered on his mental model, not the underlying data format.
Visual Preference: Admins strongly prefer visual interfaces. When shown mockups of the visual column mapper vs. JSON editing, Gavin's team unanimously chose the visual approach.
Searchability Matters: Gavin manages 500+ job configurations. The ability to quickly search and filter was critical to his workflow.
Confidence in Decisions: When Gavin can see a preview of his configuration before saving, he makes decisions faster and with fewer revisions.
"The old system forced me to become a JSON expert just to manage configurations. With the new console, I can focus on the data itself—which sources to connect, which columns to map—instead of wrestling with JSON syntax."
Before: Creating a job configuration took 45 minutes (JSON file creation, manual column mapping, syntax verification, testing).
After: Same task takes 12–15 minutes using the Admin Console (guided workflow, visual mapping, instant validation).
Result: 70% time savings per configuration
JSON syntax errors dropped significantly. The visual interface with real-time validation eliminated typos and structural errors before configurations were saved. Failed imports due to configuration errors reduced by 85%.
New System Administrators could become productive in days instead of weeks. The team confidently manages 2.5× more job configurations with the same headcount, enabling rapid expansion of data integration capabilities across Oracle's product lines.
Self-Service Platform: System Administrators work independently without requiring data architects to write JSON code.
Faster Go-to-Market: New data source integrations launch faster when configurations can be created visually.
User Satisfaction: Gavin's team reported significantly higher job satisfaction—managing data instead of fighting JSON syntax.
The Admin Console (Job Configs) is the critical foundation of the entire Oracle Unity Data Platform. It enables System Administrators like Gavin to efficiently ingest data, which then flows through mastering and analytics, ultimately enabling downstream users to explore and report on clean, unified data.
Without efficient job configuration and data ingestion, the entire downstream mastering and exploration pipeline cannot succeed. The Admin UI directly enables 70% faster data integration workflows.
Download the full case study PDF for detailed design process, data architecture, and research findings.
I'm always happy to discuss design process, data platform design, or how I approach making complex technical workflows approachable.
Enter the password to download the full PDF with wireframes and research findings.