Portfolio > Unity Data Platform
1/ About the Project
Unity Data Platform is a massive data aggregator and GUI based query application.
It gathers disparate data from internal and external sources, does advanced analysis, augments, cleans, and standardizes your data, and then rewrites it into logical tables so that you can consume it.
UDP provides a highly customizable platform and framework to meet the most specific business needs.
(Organisation Data Warehouse Cloud)
Unity Data Platform Admin Console, June 2021
My Role
Started: May 2020 - June 2021
This project was started from inception and was delivered in quarterly phases, meeting all deadlines. In June 2021 this project was merged within Oracle marketing teams for their usage.
I was the Lead User Experience Designer contributor from inception till transition.
Working closely with the product managers and development teams to provide quick low and high fidelity prototypes.
User testing the designs, getting the consensus of the PMs, sponsors users, and development team.
Working closely with the Redwood Design Team, getting the hi-fidelity flows reviews, design components reviews, and incorporating the changes.
Working with the Quality Assurance team to review the implementation of the designs. Updating feedback on the issues and working back with the development to fix them.
User Journey Map
Initially, this product was positioned as an internal tool for the Organisation System Administrators and Instant Administrators to use the Admin Console interface to create complex queries and create rules for their customer's tables and export the data to view the desired filtered results.
Example AT&T Use Case: The system administrators will be ingesting thousands of tables from their customer tenancy and the Unity data Platform will analyse, augment, clean and then rewrite it into logical tables, by using the platform engines. Further, these can be used to give predicted results about end-users using the business services, in terms of Customer Churn, Customer Sentiments, Customer Data.
The System Administrator will speed up their work by 70%, working on the user interface console by creating complex JSON queries and rules.
User Journey Map or To Be Scenario flow with User Roles, April 2021
Personas
User persona roles, for the three critical phases of the application.
Power Users / API Developers
Configure Customer Metadata
Query Data
Run Jobs
API Developer | Power User
Marketing 360 Client Administrator
Run and Export DW Jobs
Filter and Query Data
Lookup Unified Customer Records
Organisation System Administrator
Provision the Service
Setup Tenants and Users
Configure Customer Metadata
Customer Instance Administrator
Provision the User
Administrative access to
customer Tenant
Configure Customer Metadata
Configure Tenant Metadata
Query Data
Run Jobs
2/ Business Requirments
Phase 1
Study JSON Tool Manager.
Design the Navigation and Information Architecture of the Administration Console
Design the Data Ingestion.
Rebrand the Query Builder
Design the Shell and Branding
Phase 2
Design the complex JSON Rule pages, in the format of View, Edit and Create flows:
Master Tables
Promotion Rules
Aggregated Attributes
Clustering Rules
Cube and Models
Data Source Viewer
360 Explore View
In any customer tenancy, the system administrator needed a user interface solution, to navigate between different JSON tables, and build rules for design engines to support complex queries results.
The tables and the columns were all written in complex JSON queries and a required user interface will ease the workload by 70% for the basic system administrator to complete the task at hand.
Understanding the existing API based tool with tables and columns in JSON. (Left to Right)
The design journey started with understanding the complex JSON tool and how the mapping works with the metadata of the Master table IDs and Source tables IDs.
3/ Designing Information Architecture
Creating an Information Architecture for a Query Builder Platform aimed at boosting administrator efficiency by 70%. This entails refining the user interface console to facilitate the streamlined creation of complex JSON queries and rules. The objective is to enhance the platform's usability, enabling administrators to perform tasks more swiftly and effectively.
Portfolio > Unity Data Platform