Juan Carlos Gutiérrez Valle

Data analyst with a background in Social Sciences and Humanities. I have collaborated with government agencies, NGOs, and have also worked as a freelance consultant. I specialize in data visualization tools and programming for decision-making. I am seeking opportunities in marketing agencies, consulting firms, and financial institutions that allow me to further develop professionally.

UN (UNODC) Mexico, Mexico City

Jr. Data Scientist

June 2022 – January 2024

• Analyzed ETL processes using Python and Excel to ensure data accuracy.
• Implemented Hypothesis Tests to measure the impact of the training courses offered by the office in 16 States of the Republic with R and RStudio.
• Managed and coordinated the real-time implementation of surveys across 8 states, utilizing Excel, Survey Solutions, and Python.
• Streamlined investigation file analysis in 8 prosecutor's offices by implementing VBA Excel, Python, and Survey Solutions, leading to a remarkable 60% decrease in task duration, ensuring efficient and timely delivery of results.
• Automated reports to display the research results using RStudio.
• Utilized Power BI, R, and Tableau to create compelling visualizations that effectively conveyed research findings.

Freelance Consultant, Mexico City

August 2021 - Present

• Built a non-supervised Machine Learning Model to make a clustering with Python to analyze the market and guide the data-driven decision-making for an organization. 
• Created a model with inferential statistics to measure the public opinion about Mexican political parties before the 2018 elections. 
• Led the creation of impactful visualizations utilizing Tableau and Power BI to present market analysis findings.
•  Created presentations to auditoriums of 50+ individuals, enabling data-driven decision-making.

Welfare Secretary, Mexico City

January 2019 – July 2021

• Managed 22 databases with Excel, Google Sheets, and VBA to supervise the scholarship delivery for 45,000 Mexico City students. 
• Created PowerPoint presentations to showcase the advancement of field operations to Federal authorities.
• Designed formats using Microsoft Office to collect students' data and build the social program database that was used to manage beneficiary information.
• Led a 13-person team in distributing scholarships in Mexico City and coordinated assistance for program beneficiaries, with an average daily attendance of 5000 people during school operations.

Data Analyst

Ironhack Bootcamp - 2022

Master's degree in Social Studies in Science and Technology

UNAM CDMX- 2017

Bachelor's degree in Political Science and Public Administration

UNAM CDMX-2012