JUAN CARLOS GUTIÉRREZ VALLE
Servicios ofrecidos: Microsoft Power BI , Tableau software , Formación avanzada en Excel , Python , MySQL , Análisis de datos , SQL Server
Sobre 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.
Experiencia
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
Data Analyst
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
Head of Regional Attention Unit
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.
Educación
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
Profesionales que compiten con JUAN
Profesionales que ofrecen servicios similares a los de JUAN CARLOS GUTIÉRREZ VALLE
Profesionales del mismo sector Ingeniería / Arquitectura que JUAN CARLOS GUTIÉRREZ VALLE
Profesionales que ofrecen servicios de Microsoft Power BI
Profesionales que ofrecen servicios de Tableau software
Profesionales que ofrecen servicios de Formación avanzada en Excel
Profesionales que ofrecen servicios de Python
Profesionales que ofrecen servicios de MySQL
Profesionales que ofrecen servicios de Análisis de datos
Profesionales que ofrecen servicios de SQL Server
Profesionales de diferentes sectores cerca de Mexico City, Ciudad de México
Otros usuarios que se llaman JUAN
Trabajos cerca de Mexico City, Ciudad de México
-
Analista De Ingresos
hace 2 semanas
Truper Xico, MéxicoTruper Empresa a niver Nacional reconocida en Latinoamérica en manufactura, distribución y comercialización de herramientas y productos para todos los segmentos de la industria ferretera.Si disfrutas el trabajo en equipo y estás enfocado a resultados, esta es tu oportunidad de co ...
-
Ejecutivo De Ventas
hace 1 mes
Autodinero Xico, MéxicoAUTO DINERO**Empresa líder en el sector de créditos sobre autos por apertura, te invita a formar parte de su equipo de trabajo como **EJECUTIVO DE VENTAS **para nuestra sucursal **"Guanajuato"****OBJETIVO DEL PUESTO**:Cumplir con el objetivo de colocación de créditos (Empeño) sob ...
-
Coordinador de Cobranza Castigo Call Center
hace 3 días
Aplicar directamente
AR Soluciones de Estrategicas de Cobranza Tlahuac, México**Empresa de call center está en la búsqueda de un coordinador con experiência en cobranza, que cumpla las siguientes funciones**: · **Actividades principales**: · - Creación y manejo de estrategias para recuperación de cartera. · - Asegurar el cumplimiento de objetivos y buen fu ...