READY TO MAKE AN IMPACT

My name is Juan Pablo, and since August of last year, I have held the position of Project Manager Intern at Lumston, a software development company committed to recognizing Mexican tech talent. Currently, I am pursuing my Bachelor's degree in Business Intelligence at the Instituto Tecnológico y de Estudios Superiores de Monterrey in Guadalajara (ITESM). As a dedicated student with the ability to multitask and work well with others, I am determined to leverage my skills to contribute to the company's success, always maintaining a positive attitude and giving my best.

Download CV
My Accomplishments

Significant milestones achieved during my bachelor's degree.

Excelencia TEC.

During the February-June 2023 semester, I was honored with the 'Excelencia Tec' award for achieving the highest GPA in my class, which was a perfect average of 100/100.

Excelencia TEC.

I received the 'Excelencia Tec' (2023) award for my prominent participation in the 'Market Solutions Construction' Challenge. Along with a team, we developed a valuable proposal for the telecommunications company, Telcel.

Academic Talent Scholarship

Due to my exceptional exam results and overall academic performance, I was granted the Academic Talent Scholarship at Tecnológico de Monterrey.

Pioneering Employment through a Mexican Startup

I had the honor of being the first individual hired via Koble, an innovative Mexican startup reshaping the job market for university students.

My projects

Projects that I have done in the past

Analytics to soccer database

I conducted in-depth analytics of a soccer database using R, utilizing various visualizations, manipulations, functions, and personal interpretations.

See HTML file with analysis

Personal webpage.

Making of personal portfolio website, made using HTML, CSS and Java Script, as a way to display my skills and work.

Webpage link

Business proposal.

Together with teammates, we won the "Building Solutions for the Market" challenge course at a regional level. We achieved this by presenting a proposal to the Mexican company Telcel.

You Tube link.

Tableau dashboard

Together with my university team, we developed the following dashboard on the Tableau platform for the taco company 'El Güero Alteño'. It serves as an in-depth analysis of the company's sales, enabling us to derive valuable insights.

Link to dashboard PDF. (Blurred for Privacy Reasons.)

Dirección financiera.

During the financial direction class at ITESM, I had the opportunity to work on a project where I analyzed the basic financial statements, including the Income Statement and Balance Sheet, as well as calculated financial ratios and percentages for horizontal and vertical analysis of financial statements using Excel. The project was focused on Agribest, a company that I studied as part of the course.

Link to video.

Stock Market dynamics analysis.

In this project, I employed a Vector Autoregressive (VAR) model to dissect and predict the stock market performance of key automotive companies like Toyota and Volkswagen. After importing relevant libraries and stock price data, I conducted a Granger causality test, revealing subtle yet significant relationships between the stocks. The findings from the VAR model offered predictive insights and highlighted the interconnected impact of market variables over time.

Link to see code.
Education

My Education throughout my life.

Education

Bahcelor's degree business intelligence

Instituto Tecnológico y de Estudios Superiores de Monterrey (2021 - present)

As a Business Intelligence graduate, I will be able to help organizations identify opportunities and threats that enable them to make agile and analytically supported strategic decisions that add value and make these organizations competitive.

Artificial Intelligence with Business Impact.

Instituto Tecnológico y de Estudios Superiores de Monterrey (2021 - present)

Currently enrolled (February-June 2024) in a specialization focused on 'Artificial Intelligence with Business Impact', I am developing skills to apply AI in solving business challenges, leveraging both structured and unstructured data for effective solution implementation within organizational frameworks.

One year abroad in a military school.

St. Catherine's Academy (2016 - 2018)

During 8th grade, I spent a year abroad at SCA, located in Anaheim California, St. Catherine’s Academy is a private, Catholic day and boarding school with a military tradition. An experience that helped me grow as a person, and improve my english.

Elementary through High School

Liceo del Valle (2009 - 2016, 2017-2021)

At Liceo del Valle, I studied from first to seventh grade, and from ninth to twelfth grade, going through elementary, middle, and high school. In this school, I was able to learn the foundations of different areas of knowledge, as well as forge strong friendships.

Other courses (EXTRACURRICULAR)

Introduction to Python

DATACAMP (February 2023 — April 2023)

In this Introduction to Python course, I learned about powerful ways to store and manipulate data, and helpful data science tools to begin conducting your own analyses.

Introduction to R

DATACAMP (April 2023 — April 2023)

In this introduction to R course, I mastered the basics of this widely used open source language—including vectors, factors, lists, and data frames.

Introduction to SQL

DATACAMP (April 2023 — April 2023)

Through this course, I learned to wrangle and extract data from these databases (relational), understanding that using SQL is an essential skill within the data industry and in increasing demand.

My skills

Skills I have acquired throughout my life

Hard Skills

Soft Skills

Programming Languages

Proficient in Python, SQL, web development basics, and R.

Business Intelligence Tools

Skilled in Tableau, Power BI, AWS Quicksight, and advanced Excel.

Statistical Knowledge

Experienced with chi-squared tests, linear and multiple regressions, ANOVA, and various predictive models.

Artificial Intelligence

Familiar with neural networks, decision trees, and classification algorithms.

Cloud Platforms

Experience with Oracle Cloud and AWS services.

Business Acumen

Understanding of the crucial elements within business operations and financial analysis.

Bilingual

Native in Spanish with a C1 level of English proficiency.

Fast Learner

Quick at assimilating new concepts and mastering skills.

Adaptability

Flexible in rapidly changing environments and diverse teams.

Multitasking

Efficient in handling multiple tasks simultaneously under pressure.

Critical Thinking

Able to analyze issues and come up with creative solutions.

Work Ethic

Dedicated to maintaining high quality standards and integrity.

Conflict Resolution

Proficient in mediating disputes and finding mutually beneficial resolutions.

Teamwork

Capable of working harmoniously within a team and contributing to group objectives.

Who am I?

A little bit more about me

I was born in Guadalajara on January 22, 2003 and have lived there my entire life, except for the year I spent abroad. I consider myself to be an intelligent, passionate and hard working person.

Some of my hobbies and passions include watching and playing many sports, specifically soccer, spending time with my friends and family members, watching movies and TV shows, playing piano, and finally, visiting new places.

Some of my role models are my mom and dad, as well as figures like Steve Jobs, Elon Musk, Phil Knight and Serena Williams

Description of image
CONTACT

Interested in working together? Let's talk