Theo Lourencao

• Served as the sole data focal point for a newly created business unit with aggressive growth targets. • Built an AI agent using RAG to navigate domain-specific business contexts, integrated with tools such as GitLab, reaching ~500 monthly interactions. • Designed the analytical layer for the CRM retention process, enabling structured tracking of retention and purchase frequency KPIs. • Led data-driven implementation of strategic projects, bridging business context and technical execution. • Conducted A/B testing analysis (subsidy elasticity, landing page attractiveness) and Cost per Order (CPO) deep-dives. • Consolidated traffic source analysis across channels, presenting unified insights to s

- Built a CRM analytics infrastructure from scratch following the Medallion Mesh architecture, integrating data from over five sources, including Marketing Cloud, push notifications, and in-app events. - Achieved over 90% on-time data product updates within the 7 AM SLA, maintaining a failure rate below 3%. - Led the migration from Tableau to ThoughtSpot in the Groceries Operations business unit, migrating 7 individual panels and supporting multiple partner areas with technical assistance, impacting over 30 dashboards in total. - Developed near real-time alerts capable of detecting campaign discrepancies within 30 minutes.

- Generated over 30,000 high qualified leads per month for commercial teams from internal sources—such as recycled leads, high-scoring leads, and incomplete sessions—driving more than 1,000 new seller conversions monthly. - Developed a WhatsApp crawler bot for lead generation, later scaled by the data team and proven to be the top-performing outbound lead source. - Analyzed user journey and product interaction, providing gamification insights for enhanced user experience. - Performed retention and frequency analytics by examining payment methods, lead sources, and monthly cohorts.

- Engineered a dashboard for store performance metrics aiding Commercial and Sales Ops teams, utilizing Databricks SQL and Tableau. - Enhanced lead acquisition and account performance tracking through strategic data source identification and dashboard development. - Advanced geographic coverage analysis with QGIS and Google Colab, creating tools for Commercial team efficiency. - Managed Databricks data tables and spearheaded the integration of new KPIs across various teams to optimize commercial strategies.

- Automated daily updates of key performance indicators using Macros and VBA, enhancing operational efficiency. - Designed and implemented a knowledge management application and an Excel-based tool for robust team performance evaluation. - Led the design and measurement of OKRs for management, aligning team objectives with organizational goals. - Streamlined operational processes using BPMN methodology and developed visual analytics for performance tracking in Tableau and PowerApps. - Created and managed ETL processes using Alteryx to ensure data accuracy and availability.

- Orchestrated Capacity Planning for operational expansion, enabling scalable growth. - Developed a unified report for key operational indicators to streamline management decision-making in Power BI. - Monitored and reported on quality indices, ensuring adherence to high standards. - Implemented management tools for operational order oversight and SLA achievement. - Designed analytical visualizations in ZenDesk to reduce backlog and improve CSAT and NPS scores.