Ethan Castillo
Orlando,FL
Summary
Detail-focused Data Analyst with knowledge in Python, Excel, Tableau, and PostgreSQL. Eager to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with a passion for problem solving using data.
Overview
1
1
year of professional experience
Work History
Business Analyst Internship
S & M Bulletproof
04.2022 - 02.2023
- Used Excel to re-structure and format company excel sheets to ensure that the data is readable and easy to understand, which helped increase productivity by roughly 25%
- Created and managed a customer database using PostgreSQL to provide easier access to customer records in order to better assist repeat clients, or to better understand trends to help drive business decisions
- Created Monthly dashboards using Tableau in order to help the business owner make informed marketing decisions.
Education
Certificate in Data Analytics & Visualization -
University of Central Florida
Orlando, FL11.2022
High School Diploma -
North Bergen High School
North Bergen, NJ05.2017
Skills
- Python - NumPy, Matplotlib, Seaborn, Pandas, Scikit-Learn, Tensorflow
- Machine Learning - Scikit-Learn, Tensorflow
- SQL - MySQL, PostgreSQL, SQLite, SQLAlchemy
- Microsoft Excel - Pivot Tables, Conditional Formatting, VBA
- Tableau
- Microsoft PowerBi
- Amazon AWS
- Data Cleaning and Organization
- Data Analysis
- Project Management
Projects
Anomaly Detection with Scikit-Learn - used Python to analyze data, and to create a Machine Learning model to identify DDoS attacks.
Company Database Building, and Analysis - used PostgreSQL to build an employee database and ran custom queries to determine who's eligible to participate in the mentorship program.
Visualizing CitiBike Data - used Tableau to create a dashboard to visualize New York City CitiBike data to provide insights on how a bike sharing business is profitable.
Visualizing Emergency Room Data - used Tableau to create a dashboard to better understand emergency room metrics to better allocate hospital resources.
Excel VBA Stock Analysis - used Excel VBA to take a spreadsheet of personal stock options and predict which of these stocks would be considered better investments to hold, or drop for the upcoming year.
Kickstarter Fundraiser Analysis - used Excel to analyze fundraiser campaign data in order to help a client better coordinate a fundraiser of her own for a theater production.
Languages
Spanish
Native or Bilingual
Timeline
Business Analyst Internship
S & M Bulletproof
04.2022 - 02.2023
Certificate in Data Analytics & Visualization -
University of Central Florida
High School Diploma -
North Bergen High School
Similar Profiles
Andrew MayneAndrew Mayne
Senior Account Executive/Partnerships Director at Bulletproof SolutionsSenior Account Executive/Partnerships Director at Bulletproof Solutions
Olena LiulchakOlena Liulchak
Project Manager at Bulletproof RoofingProject Manager at Bulletproof Roofing
VIOLET ORAKWUEVIOLET ORAKWUE
Warehouse Worker at Bulletproof LogisticsWarehouse Worker at Bulletproof Logistics
Anthony Whitmore Jr.Anthony Whitmore Jr.
Deputy Sheriff at Orange County Sheriff's OfficeDeputy Sheriff at Orange County Sheriff's Office
Danny GuadamuzDanny Guadamuz
Freelance Technician at PersonalFreelance Technician at Personal