PROJECTS

Project | 01

Quality Assurance Operational Dashboard

* Designed and implemented QA operational dashbaord with full transparency on financial status, application testing status and application/release risk evaluation etc.

* Enabled Azure DevOps and Power BI integration to track and monitor all QA IT projects at a glance

* Provided a powerful new way to communicate strategy within QA and leadership team

Random Data used for Demo Purpose only (Azure DevOps Status BI tab)

Project | 02

Refurbished Product Ordering System

* Designed and implemented an ordering platform to help client introduce reconditioned products into market.

* The user-friendly interface ensures simple and quick access to on-hand inventory, discounted product price by condition level with other product related information

* Drove May reconditioned tool sales up by 234% (tripled) since Mar 2020 despite the challenging economic conditions under COVID-19

Random Data used for Demo Purpose only

Project | 03

Inventory Management Dashboard

Inventory management dashboards are designed for 7 distinct management roles/function teams (Logistics, Marketing, Operations, Sales Account Manager, District Manager, Region Manager, General Manager) to provide complete transparency into inventory information and enable data-driven decisions with holistic views.

The out-of-the-box dashboards comprise:

* Inventory and Overstock Dashboard

* Target Event Sales Storage Inventory Dashboard

* Discontinued and New Products Inventory Dashboard

* Inventory Forecast /Projection Dashboard

* Van Inventory Performance Dashboard

* MyVanStock Dashboard

Project | 04

New Product Launch Tool and Tracker

Implemented new product launch template and progress tracker to improve efficiency, transparency, reduce email communications and manual work. Being nominated for Hilti Global lean award 2018 - Continuous Improvement

Random Data used for Demo Purpose only

Project | 05

Supply Chain Network Optimization (Direct-ship Product- Plant to Warehouse)

"Plant to Warehouse Direct-ship Network Optimization" application was designed to reduce total logistics cost with recommended direct-ship product list based on customer demand, minimum inventory level, minimum order quantity, freight cost, cost per line, line count, truck capacity using "Mixed Integer Programming" .

This web app enables team to do quarterly review of direct-ship product list due to dynamic business environment. User is able to update freight cost, forecast, cost per line, min order quantity etc. to calculate updated direct-ship product list which returns minimum logistics cost (Transportation cost, labor cost)