ALFREDO SERRANO

Data Science Consultant


About Me

Welcome to my website portfolio!

Hi, my name is Alfredo and I’m a Data Science Consultant. I recently graduated from Suffolk University with a Bachelors of Science (Data Science, Big Data & Business Analytics).

Since I was young, I always enjoyed to solve riddles and puzzles. That’s my approach to big data sets without meaning, a big puzzle that needs to be solved and put into context so that new information can be discovered. Finding patterns nobody else can see is the challenge that triggers my passion for Data Science.

Trained in Data Science, statistics and sports analytics, I possess an extensive background working with large and varied datasets using advanced statistical methods, data analysis, database management, visualization tools, business intelligence and results communication in order to help companies and researchers analyse their datasets and facilitate decision making.

“Data has all the answers, If you ask the right questions”

MY DATA SKILLS

THE ANALYTICS EXPERIENCE – MY DATA SCIENCE PODCAST

We are the first bilingual podcast in the Spotify community to make Data Science approachable and (Data) friendly so that anyone can understand the basic concepts of it.

We want to make Data Science accessible to everyone willing to learn.

Our mission is that people with both technical & non-technical backgrounds feel comfortable learning with our content, regardless of their knowledge and experience with Data.

 Today’s currency is data. We want to bring value to our listeners by educating them on the most important topic/field of the 21st century.

You’re already using analytics in your job or in a daily basis, by knowing more about the topic you’ll become a better professional, no matter the industry or field, Data Science is and will be everywhere.

Here’s our 3rd Episode of Season 1: Interviewing @FAANG companies with Nick Singh

RECENT DATA SCIENCE PROJECTS

COVID 19 Study – Tableau / SQL / Data Visualization
COVID 19 Study – Tableau / SQL / Data Visualization
Sports Analytics: Premier League Players Analysis – Python / R Studio / Data Visualization
Sports Analytics: Premier League Players Analysis – Python / R Studio / Data Visualization
Report of payment analysis in a tech company – R Studio / Microsoft Excel
Report of payment analysis in a tech company – R Studio / Microsoft Excel
Grubhub Research Project – Excel/PowerPoint/Word Doc
Grubhub Research Project – Excel/PowerPoint/Word Doc
Personal Fitness Tracking Project – PowerBI/PowerQuery
Personal Fitness Tracking Project – PowerBI/PowerQuery
COVID-19 and the adaptation of businesses to the new technologies
COVID-19 and the adaptation of businesses to the new technologies
Movie Recommendation Project – Python
Movie Recommendation Project – Python

Objective Method Study OBJECTIVE After recent blockbusters like Spider-Man No Way Home, No Time to Die or Uncharted I wondered what would be the correlation between a movie’s budget and its success. To do this we will apply correlation models through Python in Jupyter Notebooks. METHOD We will start by importing the necessary libraries, pandas, […]

Sports Analytics: Super Bowl LVI Winner Predictor Model – Python/Excel/Solver/Statistical Analysis
Sports Analytics: Super Bowl LVI Winner Predictor Model – Python/Excel/Solver/Statistical Analysis

Objective Method Study OBJECTIVE Predict accurately the winner of the LVI Super Bowl (Bengals vs Rams). STUDY This will be done through a statistical analysis of the regular season to come up with a forecast of “ratings” in order to give value to all the teams. After the analysis is done we will use Solver […]

Snapchat Ads Analysis – Tableau/Data Visualization
Snapchat Ads Analysis – Tableau/Data Visualization

Analysis of Snapchat's targeting ads strategy when getting closer to political elections

previous arrowprevious arrow
next arrownext arrow

My Experience

Alfredo Serrano

Present

Data Science Consultant @Management Solutions

Developed multiple Climate Risk Machine Learning models which predict natural catastrophes from 2022 to 2050. 

Developed automated aggregation & reporting of results while processing large, multi-dimensional datasets from multiple sources.

Worked with cross-functional teams to provide consultations for various data science use-cases in insurance companies.

Sports Data Analyst – Suffolk University Men’s Soccer

Provided data insights to help the coaching staff on their decision making when it came to deciding line-ups, tactics, and formations. Collected players data through SPT Gametraka to later process it, analyze it and develop plans to enhance the players performance. Provided visualization of the players performance data through Tableau software and Power BI to facilitate a better decision workflow.


Financial AnalystSuffolk University Information Systems Business Analytics Association                                         

Created reports on employee compensation and developed department funds allocation models using Excel, Google Sheets, SQL and Pivot Tables. Reduced time spent creating and running routine reports by 90%. Conducted data mining of booking data to classify customers and extract insights.


Abhy Patel – Operations Analyst

“Alfredo embodies hard work and is determined to succeed without taking any shortcuts. He goes above and beyond in order to achieve his goals and to master the skills required to do so. His high standards and work ethic can be proven by the quality of work he has already produced.”

“His technical aptitude in Python, SQL, Tableau and Excel is advanced. As team member, he is a pleasure to work with and understands how to focus on the best results possible.”

Jorge Lázaro – Sports Management Student

“Alfredo is a hard worker, always with a positive attitude, he always tries to get things done in the correct way. Working with him is really easy, very clear communicator both in English and Spanish, also he is always there to help you with anything you need.”

“He has a lot of skills in the software and data analysis areas. Overall a great person whom you can trust!”

Daniel Escobar – Analyst at Goldman Sachs

“I’ve worked with Alfredo on many data analytics projects. He is determined and a hard-working team player. Fluent in Englishand Spanish. He has strong SQL, Python, SAP, and Excell skills.Overall a great person to have on your team.”

Tracy Geber – Assistant Director Lindenwood University

“Alfredo was an outstanding employee. He is a highly responsible individual who showed up on time, was willing to do whatever was needed, and put 100 percent effort into whatever task was at hand.

He communicated with me when there were any issues and did so in a professional way. I was always impressed with his work ethic, which is not always easy to find. He is polite and gracious even in the tensest of situations.”