Juan Camilo Chaves

Experience

• 

  EConcept AEI

  Jun 2016 - Dec 2016

  Intern
• 

  Universidad de los Andes - Colombia

  Jul 2017 - Jun 2019

  Teaching Assistant

  Teaching assistant of Macroeconomics 1, Mathematical Thinking, and Game Theory (Graduate)

• 

  Centro de Estudios sobre Desarrollo Económico (CEDE)

  Oct 2017 - Jun 2018

  Research Assistant

  Developed and implemented online surveys in Qualtrics. Estimated series of exponential random network models (ERGMs) in R. Coded a network formation simulator in R. Reviewed the recent literature on how to properly specify ERGM models.

• 

  Aleph

  Feb 2020 - Dec 2021

  Data Analyst

  -Developed real-time trend analysis dashboards using Power BI and Twitter API in Python, enabling the company to track emerging trends in Twitter Colombia and adjust marketing strategies accordingly.-Segmented audiences based on sentiment analysis, leveraging Google’s NLP tools in Python to enhance ad campaign targeting, improving engagement and conversion rates.-Built an SEO automation tool in Python Flask, integrating Google Custom Search API and Google Trends to generate organic content, leading to higher search rankings and increased web traffic for clients.-Automated web scraping of 10,000+ data points across two countries using Selenium, Pynput, and Crawlera, providing key market insights that improved competitor analysis and pricing strategies.-Optimized document processing workflows by implementing OCR and PdfToText in Python, reducing manual data extraction time for mining plans by over 70% and improving data accuracy. Show less

• 

  Universidad de Los Andes

  Jul 2021 - Jun 2022

  College Lecturer

  Introduction to Mathematical Thinking-Taught a first-year undergraduate course designed to develop logical reasoning, mathematical precision, and proof-writing skills.-Guided students in understanding the foundations of mathematical language, critical thinking, and problem-solving in analytic disciplines.-Designed and delivered lectures that bridged theoretical concepts with real-world applications, enhancing student engagement and comprehension.

• 

  Rappi

  Jul 2022 - now

  -Scaled and now lead a cross-functional 5-people team .-Revamped the CRM (Zoho), transforming it into a key business tool for client onboarding, deal generation, and financial compliance—reducing DSO and saving hours of manual work.-Own financial closure & P&L reporting for the business unit, ensuring accuracy in revenue tracking.-Developed an alert system using Slack, integrating JIRA, Google Sheets, and Snowflake to improve operational quality, product performance, and financial oversight.-Automated key workflows with Airflow DAGs, enabling seamless data flow from JIRA to Snowflake and Zoho, streamlining execution tracking.-Balancing strategy & hands-on execution: Split time 50% leading and managing (team, planning, documentation, and meetings) and 50% hands-on work (SQL queries, automation, dashboards). Show less -Set up foundational data processes for ad campaigns with CPG companies.-Developed and automated JIRA workflows for a diverse ad product portfolio (sponsored products, banners, communications, social media), significantly reducing manual work and errors.-Built Power BI reports to support different teams: Enabled the commercial team to track operations. Helped the operations team monitor KPIs. Provided product teams with insights on ad performance. Created business unit dashboards for tracking brand performance and lead opportunities. Show less

  • Insights Lead at Rappi

    Feb 2023 - now

  • Business Intelligence Analyst

    Jul 2022 - Feb 2023