Wilson Forero Mesa Email & Phone Number

Bogotá D.C. Metropolitan Area

- SP&O Restaurants @Rappi-Led a team of 3 analysts delivering weekly results to Rappi’s VP-Level; spearheaded automatic dashboards-Created an end-to-end online conversion (traffic to purchase) funnel prediction model in Python (high accuracy ); identified conversion obstacles and proposed operations and merchandising recommendations to the senior management; project increased conversion by 3pp- Implemented a new market intelligence tool to monitor performance over competitors; gathered market share information in 225+ Latin American cities; informed sales reps about new leads that helped surpass competitors in 3 large cities (500k citizens)

Bogotá D.C. Metropolitan Area

*Evaluated over a dozen in-app experiments to increase orders for new restaurants (first 30 days) by 18% in 6 months; Conceptualized 14 different experiments to boost orders using insights from different customer surveys; Measured multiple AB Tests in Amplitude and dif-in-dif models (Python) to quantify the impact of each experimental and prioritized top 6 performers; Streamlined and automated weekly experimental reports in SQL, Python and Airflow to have real.time results*Assembled a comprehensive top-down target-setting model for our restaurant acquisition team for 4 consecutive quarters; Overhauled previous target-setting models by incorporating variables such as sale reps productivity, three day holiday effects, stationery trends and prioritized zones’ fixed effects leading to more realistic targets for for management and sale reps;

Bogotá D.C. Metropolitan Area

Lectured 80+ students of los Andes’ “Social Entrepreneurship & Strategic Comunications” course (2022 to Present); students’ satisfaction exceeded 90% in every term

Bogotá D.C. Metropolitan Area

- Account Executive for a leading pharmaceutical company- Co-authored the 2022 Colombia Perspective Report

Bogota,D.C., Capital District, Colombia

* Cofounded the big data and machine learning area; identified research niche; assessed the new ventures topics; trained more junior research assistants *Outlined a research proposal to evaluate the effects of social media on vaccine hesitancy during the pandemic; document was used to secure a 15 K USD grant; pitched idea; coauthored a paper ; drafted policy briefs on pro-vaccination campaigns for government offices *Led projects using data mining, text mining, machine learning and applied econometrics for academic/research production and NGO consulting*Performed web-scraping and natural language processing modeling for a paper on sentiment analysis of Colombia’s Peace Agreement’s Plebiscite; assessed political leaders’ Twitter feed; presented findings at global academic and human rights events in Tunisia and Bogota*Authored five journalistic articles about the use and effects of social media on the Colombian political landscape

Bogota,D.C., Capital District, Colombia

*Researched for a report on female reproductive rights using data from the Colombian Attorney General's office. The results are been used in a current lawsuit in the Colombian Constitutional Court.*Researched economic growth policies and drafted policy briefs for a Colombian Presidential candidate (2022)*Coauthored a paper on Historical Electoral Data; led 10 research assistants digitizing and creating visualization for the electoral authority

Bogota,D.C., Capital District, Colombia

- Programing for Social Sciences, 2019, 2020- Comparative Political Institutions, 2020- Introduction to Economics module (C&D), 2018

Bogota,D.C., Capital District, Colombia

High School Internship

Bachelor'S Degree, Economics, 4.4/5

Activities and Societies: Guest columnist at Revista Supuestos (2020-1), Junior Consultant at CIICEP (2019-2), Concentration areas.

Bachelor'S Degree, Political Science And Government

Activities and Societies: MUN Club Board Member (2018), Volunteer Congreso Visible (Congressional Watchdog), Volunteer 2016 Plebiscite.

Summer School, International Business, A-

Summer School, International Political Economy/ Entrepreneurship, A

Summer School, International Relations And Affairs, A

Summer School, Social Entrepreneurship, A

Cours De Civilisation Et Langue Française, 18/20

Activities and Societies: Cours de politique française et d'art moderne et contemporain

High School Diploma, 4.0/4.0

Activities and Societies: Class president ("Personero"), President of the National Honors Society, Fundación Columbus School, Model United.