UgamAnalyst
Apr. 2020 - Apr. 2022Bengaluru, Karnataka**Category Health** • Created a single table joining 7 data sources having data across assortment, pricing, space, and sales metrics • Processed ~ 4 TB of data to create tableau dashboard that helped identify potential issues for each category **Installment Services** • Built an Excel tool that automated pricing creation for custom installment services leveraging VBA to get cost, margin, product availability, discount data from 7 excel sheets across 5 vendors to generate pricing for each product • Reduced time taken from 2 days to 10 mins **Promise Time Optimization** • Analyzed clickstream data across PIP visits, orders, cart abandon rate to identify products falling in the 75-100th percentile of visits but only in 0-25th percentile of orders • Deep dive analysis of these products to find the correlation of promise time to the cart abandon rate