Dhruv Reddy Gandhari

Data Analyst: Supply Chain and Logistics

TikTok

06.2024 - Current

Identified packaging inefficiencies for a top-selling health supplement SKU, revealing ~90% were shipped in oversized boxes; proposed a switch to poly mailers with validated damage analysis, leading to $250K+ in projected annual savings. Extended analysis to other top selling SKUs to maximize impact.
Established a cross-functional cadence with the packaging POC to review packaging for top-selling SKUs; built a centralized tracker and implemented a weekly reporting process to identify cost-saving opportunities. This initiative directly contributed to reducing box usage from 60% to 50%, one month ahead of target and driving ~5M in annual savings.
Supported cost tracking efforts and led real-time reporting for TikTok Shop's first Black Friday Cyber Monday event. Delivered insights with tight turnaround times to director-level stakeholders, enabling a drop in cost per order from $10 to $7 within six months.
Reconciled actual invoices against cost estimates across all fulfillment centers, conducting deep dives using multiple internal data sources. Ensured greater than 95% accuracy despite varying and complex rate structures.
Conducted network-wide analysis to highlight inventory placement gaps, long-zone shipments, and repeated late merchant inbounds. Created and shared a tracker with merchant teams to improve visibility and enable corrective planning across functions aiding in optimized staffing at hub.
Analyzed inbound and outbound cube trends to explain TPH shifts and inform labor and capacity planning decisions across the network.
Built and maintained automated dashboards and standardized cost models using Excel and BI tools to track fulfillment and transportation metrics.

Similar Profiles