Ethan Castillo | Detail Oriented Data Specialist

Ethan Castillo

Detail Oriented Data Specialist

Based in Orlando, FL

About

Hello, I'm Ethan a Data nerd who specializes data analytics, engineering and database management. My most frequently used skills are Excel, SQL, Python, and Power BI. You can check out my Github repository for my projects. I focus mainly on data analytics, but I am definitely capable of wearing many hats. I have working skills in data engineering, machine learning, and database administration. Looking forward to providing my best work for any role given!

Skills

Projects

Kickstarter Excel Analysis

I utilized excel to analyze theater fundraising campaign data in order to provide my client with an actionable plan to launch a successful fundraising campaign of her own.

Pewlett-Hackard SQL Analysis

I utilized PostgreSQL to create a company database and run custom queries in order to check which employees are eligible for a career mentorship program.

Fred API Unemployment Python Analysis

I connected to the Fred API to load in unemployment data from the years 2020 to 2022 and in conjunction with Python I provided some exploratory data analysis to view how COVID impacted unemployment.

Citi-Bike Python Analysis

The purpose of this analysis is to show to investors that a bike sharing business model would be successful in Des Moines Iowa by gathering the NYC citi-bike data and putting together a couple of visualizations in a Tableau story.

DDoS Detection Machine Learning Model

In this project I showcased a combination of my ETL skills, my Exploratory Data Analysis skills, and my Machine Learning skills to design a Machine Learning Model that can take network data and use it to learn how to better detect DDoS attacks in order to be implemented detection system.

Internet Sales Analysis

In this personal project I tried taking on many different roles. I showcased a bit of database administration, a bit of data engineering, and a bit of data analysis all wrapped up into a pretty neat end to end project in order provide a dashboard to track sales metrics.

Experience

2021-2022

Office Administrator at S&M Bulletproof

Organized office goals, policy, and procedures to ensure that the work environment was optimized for productivity. Maintaining correspondence with business partners, investors, and customers. Preparing and analyzing payroll, asset allocation, and other financial responsibilities. Attending meetings in order to communicate company goals, office metrics, and possible plans of action.

2022-Current

Data Analyst at S&M Bulletproof LLC

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%. Utilized Python and AWS in order to manage and analyze large datasets ranging in the millions of records in order to allow the company to effectively double its work capacity. Designed ETL pipelines using python, SQL, and cloud services in order to provide reliable data to be worked with. Created and managed a customer database using PostgreSQL to provide easier access to customer records, and wrote custom SQL queries in order to better assist repeat clients, or to better understand trends to help drive business decisions. Created Monthly dashboards using Power BI in order to help the business owner make informed market

2024 - Current

Data Tutor at Varsity Tutors

Curate lessons, and help students achieve their learning goals. Manage student expectations and provide a roadmap to help break down and achieve. Schedule sessions with students to help review concepts being studied in their classes, or to help students get over certain misunderstandings or hurdles.

Education

2022

Data Analytics and Visualization at the University of Central Florida

This was a rigorous and fast-paced certification that focuses on the practical technical skills needed to solve data problems. Throughout the course, I gained proficiency in numerous marketable technologies, including Excel, Python, JavaScript, SQL Databases, Tableau, and more.

2024

MySQL for Data Analytics at LinkedIn Learning

Relevant Coursework included Exploring Data utilizing MySQL, Utilizing Functions within MySQL, and Utilizing advanced query methods to refine MySQL queries.

2024

Power BI for Data Visualization at LinkedIn Learning

Relevant Coursework included Exploring Power BI and its features, Creating and Editing Simple Visuals, Creating and Editing Advanced and Custom Visuals, and curating Reports and Designing Dashboards.