ShopeeData Analytics Senior Associate for Cross Border Latam
Nov. 2022 - Jul. 2023São Paulo y alrededores- Managed the transition of data analytics operations from Mexico, Chile, and Colombia to the newly created Latam Cross Border team in Brazil after Shopee’s local operations closure in Spanish speaking countries.
- Guided the Operations team in strategic decision-making through data analysis and presented insights to senior leadership. Operations team included payments, logistics, customer service, returns & refunds, fraud, and listings.
- Created ETLs using SQL and generated reports on Google Sheets or data visualizations on Looker as needed.
- Developed an optimization model to reallocate logistics volume, reducing costs by at least 10% without impacting coverage or customer satisfaction.
- Analyzed the impact of cancellations, returns, refunds, late deliveries, and customer service issues on customer retention.
- Identified key pain points affecting gross-to-net transactions, including payment issues in offline channels, wrongly set fraud rules and frictions on logistics, that if solved could potentially improve gross to net by 15%