Data Validation Tool

Enterprise Level Application

Enterprise Level Application

Proof of Concept

Duration - 1.5 weeks

Description

Description

This is an enterprise level application that will be used by the analysts and

vendors to get shipment notifications that will be tagged to POs. This will work

as a data validation tool that will validate the ASN data before it goes through

other systems like order management or fulfilment systems (including all WMS

in network) to report errors found in data to vendors to provide corrected

transitions assuring data integrity. It also has a data aggregation capability that

can draw together EDI data, purchase order data and receipt data.


The main aim of this tool is to ensure data integrity and accuracy in shipment

notifications to prevent errors, delays, and inefficiencies in order management

and fulfilment processes.

My Responsibility

Requirement Gathering

Understand the tasks carried out by the user and client

requirements

Attend timely calls with various stakeholder to understand

the expectations from the tool

UX and UI Design

Create user flows and persona to ensure stakeholders are

on the same page

Design wireframes and hi-fidelity screens.

Project Goal

The main aim of this tool is to ensure data integrity and accuracy in shipment notifications to prevent errors, delays, and inefficiencies in order management

and fulfilment processes.

Real Time Updates

To have a view of shipments coming in from

vendors and suppliers

Data Aggregation

Capability to draw together EDI data, purchase

order data and recipt data.

Error Reporting

To report errors found in data to vendors so it can

provide corrected transitions assuring data

integrity.

Tracking and Monitoring

Data validation process and trading partners

Automation

Needed to automate data validation and

processing to reduce errors and increase

efficiency.

Data Validation

To validate the ASN data prior to its consumption,

throughout the order management systems.

Information Architecture

A day in life of a Replenishment Analyst

Replenishment Analyst will be our primary user of the tool. To understand them better we mapped out a day in life to understand their daily activities with

regards to the work they have to do. This helped us envision their important tasks.

Replenishment Analyst will be our primary user of the tool. To understand them better we mapped out a day in life to understand their daily activities with

regards to the work they have to do. This helped us envision their important tasks.

Logs In

Logs Out

User Persona

Lets get to know more about our user.

About

Nitin is a Replenishment Analyst whose role is to ensure timely replenishment

of inventory and ensures smooth stock flow by validating shipment and PO

data. He works closely with vendors and analysts to catch and fix errors before

deadlines. He has 4+ years of experience in supply chain management. He

excels in data analysis and is detail oriented.

Nitin is a Replenishment Analyst whose role is to ensure timely replenishment

of inventory and ensures smooth stock flow by validating shipment and PO

data. He works closely with vendors and analysts to catch and fix errors before

deadlines. He has 4+ years of experience in supply chain management. He

excels in data analysis and is detail oriented.

Frustrations

Manual data entry and processes leading to errors and inefficiencies.

Lack of visibility and real-time updates in shipment status and PO details.

Existing tools or processes unable to handle a large volume of shipments.

Lack of proper communication with vendors and suppliers.

Goals

To ensure data accuracy and integrity in shipment notifications.

To report errors to vendors so they can fix them and ensure data integrity

To check shipment data for errors before it's used in other systems.

To get real-time visibility for shipment status and PO details.

Maintain positive relationship with vendors and trading partners.

Wireframes

We created a few ideation wireframes after discussions with the BA and our client.

Prototype

Dashboard

The dashboard was

intentionally designed

to help users access

the information easily

at a glance, prioritising

clarity and concision.

Testing Summary

This screen shows a list

of purchase orders.

The design of this

screen needed to be

clear and concise with

appropriate filters and

pagination so user can

scroll through multiple

pages easily.

This screen shows a list

of purchase orders.

The design of this

screen needed to be

clear and concise with

appropriate filters and

pagination so user can

scroll through multiple

pages easily.

Testing Detail View

In this page the content

needed to be divided in a

tab format to divide the

data in groups of easy

coherence. Proper labels

have been used that

makes it easy for user to

navigate around the

information required.

Testing Detail View

This screen shows the

possible information

that will be displayed

under ‘Error Validation’

tab.

Error Validation

This screen shows a

detailed view of error

validation with three

action buttons.