• Built from scratch a pending orders tracker joining 4 data sources — giving the Head of FBS real-time visibility into every unshipped order by warehouse stage, age, and ship-by-date, enabling direct escalation on SLA breaches. • Designed and deployed an automated compensation dashboard with fraud detection logic — standardising seller payout calculations and delivering 16% cost savings. • Defined and tracked core KPIs including ADO and ADGMV across 7 sub-departments — delivering daily executive reports to SCommerce division leadership. • Used SQL to investigate data discrepancies, validate reporting accuracy, and maintain data integrity across multiple operational systems.