Diederich College of Communication Website
Skills: HTML, CSS, JavaScript, PHP, MySQL, XML
The website migration project for the Diederich College of Communication is one of the largest web development projects I have completed. Tasked with migrating this 500-page website to a new content management system, I worked continually to re-write and re-design all content from the previous CMS and integrate suggestions from student and staff stakeholders to improve on user experience. While I have worked as the Website Administrator at Milwaukee Public Schools since November, 2019, most of the web design and content changes I implemented are reflected in the current website.
Roadmap to Readiness Website
Skills: HTML, CSS, JavaScript, PHP, MySQL, IIS Administration
At the beginning of 2020, I was tasked with developing a website within two weeks for Milwaukee Public Schools to ensure families had quick, easy-to-access information about the continually changing circumstances with regards to remote learning. Research indicated that families prefer to consume website content in small blocks of information, so large, easy-to-read headers were created. This website is built in WordPress with an existing theme which I modified to adhere to branding and style requirements for the district.
BikeShare Project
Skills: Python Programming, Github
As part of the Programming for Data Science nanodegree, I wrote a program in the Python programming language that would allow a user to ask questions about bikeshare trip data collected from New York City, Seattle, and Washington D.C.
SQL and Excel
Skills: SQL, Excel, Data Visualization
Completing this project was an important part of my Programming for Data Science Nanodegree. I learned how to manage and query SQL databases to perform data analysis and was tasked with using Excel to communicate important insights about the data. This specific project entailed querying several databases to glean insights about a video rental business.
Please note: The images of the visualizations are rendered at small screen sizes to optimize the pdf file for the web. The Excel file is available upon request.
Credit Card Checker
Skills: JavaScript Programming, Automation, Github
This program in JavaScript checks the validity of credit card numbers. It is designed to automate what would otherwise be a manual task of checking each credit card in question against a set pattern.
Not part of any project or tutorial, it meets a set of open-ended requirements. The project uses the new ES6 syntax.
Data Analysis and Reporting
Skills: Data Analysis, Data Visualization, Google Sheets, Tableau
This project, part of the Marketing Analytics nanodegree from Udacity, required me to analyze data and report whether or not a digital marketing campaign met its goals to increase total sales by 30% on Black Friday 2018 vs. Black Friday 2017 while decreasing total ad spend by 30% from Black Friday 2017 to Black Friday 2018.
The data came in the form of a Google sheet, and I used Tableau to draw insights from the data and create the visualizations needed to communicate the findings.
Reporting and Data Analysis with Google Analytics
Skills: Data Visualization, Marketing Analytics, Google Analytics
In both the Google Analytics and Marketing Analytics nanodegrees, I did in-depth work in Google Analytics to learn how to create custom reports, dashboards, and set alerts. I also learned best practices for communicating findings through reports.
In addition to data exploration, this project also required advanced techniques in Google Analytics, including filtering and segmentation. The data was from the Google Merchandise Store to mimic an eCommerce scenario. In my role as the webmaster for Milwaukee Public Schools, I have curated several reports for departments that were seeking specific information on their web traffic and the effects on their marketing campaigns.
URL Shortening Software
Skills: Python Programming, Github, Software Development
This is a bookmark server or URL-shortening service, similar to TinyURL.com or goo.gl, but with no persistent storage. This server will accept a URL and a short name, check that the URL actually works (returns an HTTP 200), then store it in a Python dictionary.
Analyzing Demographic Data in Excel
Skills: Advanced Excel, Data Analysis, Statistics
This project required the use of statistics and several types of visualizations, including pie charts, histograms, scatter plots, etc. to glean data insights from demographic data of Udacity students. Advanced Excel techniques such as creating pivot tables and data visualizations were used. The findings from Excel were then gathered into a report to communicate the findings.
This particular project truly taught me a lot about how to choose the right tool for the job and how to identify outliers that could otherwise skew data.
Face Recognition Software
Skills: APIs, Databases, Full-Stack Web Development, Machine Learning, React, SQL
I built this face-recognition software as the final project from the Zero to Mastery Complete Web Developer course. Because my primary experience working with JavaScript had been as a front-end web developer, I decided to take this course in order to learn full-stack JavaScript.
The project includes a hook up to the Clarifai API, which is machine-learning software to recognize faces. It makes use of React, the front-end library invented at Facebook, includes a Node.js backend, and a PostgreSQL database.
While this project primarily involved coding along with the instructor, I did have to do a lot of troubleshooting on my own in order to get all of the parts of the software to work correctly. Because there are several JavaScript files, the link below is to the Github repository where this project resides, rather than to a single file. To view the code files for this project, click on the “src” folder after clicking on the link below.