Develop KPI monitoring tool using Excel VBA, pivot tables, and advance formulas setting
The Company I worked for: TJX Hong Kong Buying Office Purpose: To monitor and control the KPI performance of vendors on on-time booking, cargo delivery and documents submission, send massive email reminders to vendors for taking actions Skills: Process simplification Data mining,cleansing & analysis Excel VBA Pivot table advance formula setting Achievement: Improved KPI of on-time booking, delivery and documents submission from ~70% to ~90%