Aidan Rogers

Picture of Aidan Rogers

UCF IT student always looking to improve.




About

My name is Aidan Rogers and I am an upcoming senior majoring in Information Technology at UCF. I found a love for data analysis when I took the Google Data Analytics Certification while I was trying to explore possible career options. I enjoy every aspect of working with data, whether that be cleaning, analyzing, or presenting it. I often utilize my skills in Python, SQL, Excel, and Tableau to support my data analysis process.

I have gained pratical experience with data analytics over the past year. First, I interned with the USDA in the Office of the Chief Information Officer (OCIO) where I worked as a data analyst on various projects using Python and tableau. After my internship with the USDA I began interning at Florida Blue health insurance under the Commercial Analytics Enablement team. I worked on data validation using SQL and have now taken on the role as the Business Systems Analyst on various projects. I hope to bring the data analytics skills I have honed with my personal projects and internships to a full time position once I have finished my schooling at UCF.

I am passionate about data analysis but outside of that, my other passions include my love for dogs, playing guitar, and spending time with my girlfriend.





Experience

...
Florida Blue

Role: Commercial Analytics Enablement Intern
Date: (May 2024 – Present)

...
USDA: Office of the Chief Information Officer (OCIO)

Role: Student Trainee (Information Technology/Data Analytics)
Date: (December 2023 – May 2024)




Projects

...
Taylor Swift Spotify Data Analysis

A project analyzing the Spotify data of Taylor Swift

A personal project I wanted to work on to find statistical trends in Taylor Swift's music and to demonstrate my skills in data analysis. I worked with datasets in Kaggle that have quantitative Spotify data on Taylor Swift's music. I specifically wanted to see how the different sonic qualities present in Taylor Swift's albums impact their popularity. I used Excel, R, SQL, and Tableau to analysis and present this data. I also used techniques such as descriptive statistics and linear regression.
...
Google Data Analytics Capstone: Cyclistic

A capstone data analysis project

My final capstone project for the Google Data Analytics Certification. I tackled a sample set of data from a fictional bike sharing and went through all of the steps of the data analysis process with it: ask, prepare, process, analyze, share, and act. I utilized Excel, PostgreSQL, R, Power BI, and PowerPoint to work with over 5 million rows of data to clean, analyze, and present it in a comprehensible manner.
...
Album Popularity Trends

Graph the popularity of an artist's albums

This Python project takes the input of the user and displays a plotly scatter chart that shows the popularity of an artist's albums over the years. This popularity is determined and attained via the Spotify API. This project heavily utilizes the Spotify API to get an artist's page, albums, and album stats. Initially this project was made to view the popularity of Mariah Carey's official album releases so her results are the most tailored.
...
Card Game Analysis

Play Go Fish and see stats on the results

A Python project where you can play go fish and then have the results of the game(s) be graphed out for you with plotly. The Go Fish game is made using Objected Oriented Programming in making classes for the cards, card decks, and players. The player can play go fish themselves or have the computer play itself 1 or 100 times to get a solid dataset to graph.

...
My Blog

A long-form blog social media web app

A website made using Python, HTML, Django, and Bootstrap. This website allows users to create their own personal blogs and blog posts to share with others. Every user gets their own blog page featuring all of their posts. The website features a follower system akin to many popular social media platforms.
https://my-blog-web-app.herokuapp.com/

(Heroku removed free webhosting options so this link is down for now, the GitHub link will still show all of the code.)



Certifications

...
Google Advanced Data Analytics

Link to Certification

...
TestOut CyberDefense Pro

Link to Certification

...
Google Data Analytics

Link to Certification

...
TestOut IT Fundamentals Pro

Link to Certification