AB InBevInsights
Sep. 2022 - Aug. 2023Bogota, Capital District, ColombiaResponsibilities: - Structuring data processing and report generation for the company's Marketplace, which is used for strategic planning for the upcoming period. - Supporting commercial, supply, trade marketing, and pricing strategies by analyzing operations, projections, data segmentations, and identifying trends and relationships within datasets. - Coordinating with local, regional, and global data teams to optimize Marketplace processes through data products and automation tools. Achievements: - Reduced the creation time for Marketplace team reports and ad hoc analysis SLAs by 95% by creating a data integration service with Python and SQL. This facilitated trend and pattern visualization, improving response times for commercial areas, partnerships, and trade. - Decreased customer churn by 10% by implementing four joint strategies with the E-Trade team for each identified segment. These strategies focused on customer loyalty, development, and brand positioning. - Increased the average ticket size by 40% through commercial data analysis, identifying correlations between products and purchasing trends. This enabled personalized product recommendations and promotions for each segment.