HEYSEN PINTO
West Haven,CT
Summary
- Business analytics graduate with specialization in sports management.
- Proficient in Python and R programming for data pre-processing, analysis, and visualization.
- Excel expert with advanced capabilities, including X-lookups, V-lookups, and pivot tables.
- Proficient in SQL servers for querying, designing and extracting relevant information from multiple databases.
- Strong analytical and data visualization abilities, capable of analyzing complicated datasets and generating actionable insights by creating interactive dashboards on Tableau.
- Knowledge about cloud platforms and using Pyspark functions in Databricks for advanced data Transformation.
Overview
3
3
years of professional experience
Work History
Data Analyst Intern
Hartford Athletic Fc
01.2023 - 05.2023
- Transformation, extraction and integration of multiple data sources to glean business insights and solutions that are actionable including the organization.
- Develop, maintain and distribute insight dashboards to support sales and marketing team in decision making.
- Utilized advanced SQL techniques to efficiently update and create tables In MySQL server.
- Used R programming to implement data validation checks and improved Data Quality to maintain data accuracy and integrity.
- Worked with Databricks using PySpark and Spark SQL for faster data testing and processing.
Event and Operations Intern
Hartford Athletic FC
10.2022 - 12.2022
- Matchday Preparation: Assisted with setup, facilities, and coordination to ensure a smooth
matchday event. - Parking Management: Managed traffic flow and directed parking to ensure safe and
efficient parking on matchdays. - General Stadium Maintenance: Helped maintain facilities, equipment, and infrastructure to
keep the stadium in good condition.
Marketing Data Analyst Intern
Mumbai City Fc
04.2020 - 07.2021
- Data Extraction and Analysis: Utilized Python libraries (Pandas, Requests) for marketing data retrieval, parsing, and analysis from surveys, web APIs, and SQL server.
- Data Filtering and Preprocessing: Applied NumPy and Pandas for data filtering, cleaning, and preprocessing to ensure data integrity by removing outliers and irrelevant information
- Dashboard Design and Visualization: Created compelling Tableau visualizations and dashboards, presenting marketing performance and KPIs effectively using bar graphs, pie charts, heatmaps, and geographical maps.
- Interactive Dashboards: Implemented Tableau features for interactive exploration and in-depth data analysis
- Reporting and Insights: Presented actionable data-driven insights to non-technical stakeholders through clear visualizations, reports, and presentations with engaging storytelling techniques.
Education
Master of Science - Business Analytics, Sports Management
University of New Haven
West Haven, CT05.2023
Bachelor of Management Studies - Sports Business
Nagindas Khandwala College
Mumbai, India07.2021
Skills
- Data Analysis
- Data Visualization
- Statistical Analysis
- Written and Oral Communications
- Problem Solving
- Database Management
- Data-Driven Decision Making
- Microsoft Suite
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
The way to get started is to quit talking and begin doing.
Walt Disney
Timeline
Data Analyst Intern
Hartford Athletic Fc
01.2023 - 05.2023
Event and Operations Intern
Hartford Athletic FC
10.2022 - 12.2022
Marketing Data Analyst Intern
Mumbai City Fc
04.2020 - 07.2021
Master of Science - Business Analytics, Sports Management
University of New Haven
Bachelor of Management Studies - Sports Business
Nagindas Khandwala College
Projects
1) Brand Analysis using R, SQL and Tableau
- Conducted comprehensive brand analysis using correspondence analysis (CA) biplot in R.
- Gathered and meticulously cleaned diverse data sources using R programming.
- Utilized FactoMineR and ggplot2 in R for statistical analysis and biplot visualization.
- Integrated SQL to query and extract relevant information from databases.
- Generated actionable insights for brand improvement using Tableau Dashboards.
2) COVID-19 Data Visualization using Tableau
- Developed interactive Tableau dashboards for global COVID-19 trends using reliable data, including line charts and heat maps.
- Gathered and cleaned COVID-19 data from diverse sources, aggregating and visualizing it with line charts and heat maps.
- Designed visually appealing dashboards, illustrating global pandemic impact with insightful visualizations.
- Collaborated with team to enhance interactive features and present findings effectively to diverse audience.
Technical Skills
- R Programming
- Python Programming
- SQL
- Tableau
- Advanced Excel
- Data Mining
- Data Entry
- DataBricks
- Machine Learning
- V lookup/ X lookup/ Pivot table
- ETL tools
- Data collection/ Data Quality
Similar Profiles
Charlotte OtisCharlotte Otis
Operations & Events Intern at Hartford AthleticOperations & Events Intern at Hartford Athletic
Skylar EvansSkylar Evans
Social Media Intern at Hartford AthleticSocial Media Intern at Hartford Athletic
Danny BradyDanny Brady
Volunteer at Hartford AthleticVolunteer at Hartford Athletic
Mornah TogbahMornah Togbah
Coordinator of Risk Management at Marrakech, Inc.Coordinator of Risk Management at Marrakech, Inc.
Yasheka WaiteYasheka Waite
Medical Assistant at Medi Weight LossMedical Assistant at Medi Weight Loss