Shawn Scott Portfolio

Data Analyst | Masters of Information Technology student @ Nova Southeastern University | B.A in Finance | Experience with Python & SQL
@Shawn Scott

Music Data Engineering Project:
Microsoft Azure ETL Pipeline

This ETL pipeline project is designed to reinforce foundational data principles by applying self-study insights and internship experiences. Utilizing Microsoft Azure tools, including Data Factory, Dataflows, Databricks, and SQL, the project centers on constructing a music database through the extraction, transformation, and loading of data from Spotify's API. The workflow seamlessly loads data into Azure SQL, incorporating automation triggers. This endeavor represents a substantial learning journey, providing valuable insights into orchestrating data pipelines, working with APIs, and gaining a comprehensive understanding of ETL processes.

Trading Bot

An "Automated Forex Trading Bot with Technical Analysis" project showcases the development of a sophisticated algorithmic trading system designed to execute foreign exchange (Forex) trades based on real-time market data and technical indicators. This project leverages Python, popular data analysis libraries, and the OANDA REST API for Forex trading.

Covid
SQL Data Exploration

This data analysis project focuses on COVID-19-related datasets, specifically tracking COVID-19 cases, deaths, and vaccinations across different locations and continents. The primary goal is to analyze and visualize COVID-19 trends and vaccination progress, providing valuable insights into the pandemic's impact on various regions. Several SQL queries and techniques are employed to extract meaningful information from the data:

Data Cleaning
with SQL

This data cleaning project focuses on preparing Nashville housing data for further analysis by standardizing the data, populating missing property address information, breaking down address fields into individual columns etc. The primary objective is to ensure the dataset is well-structured and ready for analysis. Below are the key data cleaning steps:

Web Scraping Anime Database
with Python & Beautiful Soup

Its primary objective is to systematically gather and extract a wealth of essential data concerning a wide array of anime titles meticulously cataloged on the platform.
This scraping endeavor harnesses the capabilities of industry-standard libraries, notably BeautifulSoup for HTML parsing and requests for web page retrieval, enabling precise data extraction and aggregation

FreeCodeCamp
Data Analysis with
Python

This showcases a series of data analysis and visualization projects completed as part of the Data Analysis with Python certification from FreeCodeCamp.org. These projects demonstrate strong proficiency in data manipulation, statistical analysis, and data visualization using Python and relevant libraries.

Correlation
of top 5 Forex Pairs

In this project we gathered price data for the 5 major forex pairs over a 10 year period.
Using python we cleaned the data to observe and understand if and how each pair correlated with each other. Data was acquired by making request to OANDA's API.