ALFREDO SERRANO

Data Science Consultant

Alfredo Serrano

About Me

Welcome to my 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

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

2021-Present

President of Suffolk University’s Information Systems Business Analytics Club

Maintained club’s operations, assisted in the recruitment process of members, schedule conferences and meetings. Hold multiple data science workshops for students (Excel, SQL, Tableau).Since appointed in May, the club has grown from 34 members to 127, hosting 3 workshops and a conference speaker.

2021-Present

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.


2020-2021

Financial AnalystSuffolk University Information Systems Business Analytics Association                                         

Analyzed cost cutting strategies with the School’s Director of Treasury, discarding events as well as high fees; analysis saved a monthly amount of 3,000 USD after ending partnerships with three different providers. Cost modelling resulted in total savings of 45% compared to previous year. 

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.”