Spotify Music Database
Project Summary
Connects to a spotify user’s profile and extracts their listening history to build a database which tracks the user’s playcounts, most recently played songs and most popular artists. Database can be searched to find if particular songs have been listened to before and return the most recent play date.
Technologies Used
Python, SQL database, OAUTH2 authentication, Spotify API, JSON, requests
See more on githubreddit Submission Scraper
Project Summary
Searches a specified timeframe from a forum on reddit.com and tabulates all submissions so that the post and karma counts of each user can be displayed.
Technologies Used
Python, reddit API, requests, JSON, PRAW
See more on githubalbumoftheyear.com Site Scraper
Project Summary
Scrapes the music site albumoftheyear.com to get the top 5000 albums as rated by users and sort them by artist and genre. Program displays tables of most popular artists and genres.
Technologies Used
Python, BeautifulSoup, requests, Jupyter
See more on githubWindows Server Administration
Project Summary
Specified, configured and installed new Dell T440 server for be used as company’s file server and network hub. Server runs two virtualized servers, one file server (files and database, backup software) and one domain controller (Active Directory, DNS server, DHCP server). Wrote backup utilities to copy file database to both NAS and offsite storage.
Technologies Used
Windows Server 2019, Hyper-V 2019, Active Directory, Veeam Backup & Replication, PRTG, Windows Admin Center, WSUS
Solidworks Database Administration
Project Summary
Installed and maintained a Solidworks product data management (PDM) system as the company transitioned to Solidworks 3D from AutoCAD 2D. A database system was created to provide version control and track design changes by each user. Created new company templates such that all drawings populate job information from their respective project folders.
Technologies Used
Solidworks PDM, Solidworks Professional 3D CAD
Personal Website
Project Summary
Designed and uploaded personal portfolio website using Bootstrap 4. Acquired domain name and webspace. Configured domain email and webspace.
HTML5, CSS3, Bootstrap 4, GIT, cPanel