Analytics Consultant
CurrentLast Mile Delivery• Developed and calculated various Key Performance Indicators (KPIs) pertaining to Cost Per Delivery (CPD) using SQL in Big-Query, including base CPD and surge CPD• Collaborated with the strategy team to analyze and reduce base CPD from $6.5 to $5.05. with annualized savings of $14 Million.• Formulated SQL queries to construct a data source and created a dashboard for monitoring planned and executed order details throughout Thanksgiving and Black Friday Sales events.• Developed key performance indicators, such as batch density at slot level in planned vs executed dashboard for monitoring store performance during these Sales events to optimize profitability.