Portfolio
Capital Bikeshare Availability Prediction API
I built a system to predict bike availability in Washington D.C.'s Capital Bikeshare system as an intern at Mission Data. The system applies machine learning techniques to past Capital Bikeshare data and weather data to predict the chances a bikeshare station will have bikes or empty docks available at a given point in the future.
Written in Python 3
Data analysis with Pandas
Machine Learning with scikit-learn
JSON API using Falcon
Web interface in Angular 2 with TypeScript
PostgreSQL and SQLAlchemy
Additional details and source code are available on GitHub. You can also download my slides from when I presented this project at a Capital Bikeshare Hack Night in November 2016.
Comic Book Guide Amazon Alexa App
While at Mission Data, I built a custom voice application for Amazon Alexa speakers and devices that answers questions in a conversational format about characters, teams, items, and more from comic books. If you have an Alexa device, you can use Comic Book Guide by saying "Alexa, enable Comic Book Guide".
Source code is available on GitHub.
Biblocomplete Senior Design Project (In Progress)
For my senior design project, I am working with a partner to create an autocomplete system that uses natural language processing techniques to provide enhanced results. The project involves processing terabytes of data from the Google Books Ngram Corpus, storing it compactly, and accessing it efficently. Completions are made available via a JSON API, and we have two interfaces to demonstrate autocompletion - a web application and an Amazon Alexa voice interface.
Data processing using Python 3
API endpoint and database access using Java
Data storage and indexing with MongoDB
Web interface using JavaScript and jQuery
Voice interface using JavaScript and Alexa Skills Kit
WRGW News
For WRGW News, I worked to create a professional and clean news site that kept the content front and center. I designed the site as a custom built WordPress theme (using PHP, HTML, and CSS), which allowed the newsroom to take advantage of WordPress as a content management system.
WRGW News is the news department of the student radio station at the George Washington University. Development on the website is not currently active.
Mock Dorm Management System
For a semester-long class project, I worked with a small group to create a mock dorm management system. Build for a standard LAMP stack (Linux, Apache, MySQL, and PHP), our system allowed users to search for buildings, rooms, and facilities issues based on various criteria. Users could also submit applications for housing, and view their current housing assignment. Administrators could view residents and their housing assignments, and edit buildings, rooms, residents, and other elements of the system.
I lead the design of the database schema (diagram pictured), ensuring the schema was properly designed to reflect the data being stored and was extensible and easy to make queries from. I also ensured the system was secure - I implemented the login system, ensured proper access control, hashed and salted the passwords before storing them, and protected all input fields against SQL injection. In addition, I wrote a substantial amount of the SQL statements executed by the system, and contributed to other parts of the project.
St. Patrick's
I built a simple website for St. Patrick's, my home parish. The site was originally built using only HTML and CSS, and I later adapted it to work with WordPress.
This website is no longer online, as St. Patrick's recently switched to a new custom system built for churches.
JoePaolicelli.com
This website is built with Foundation 6, using HTML, SCSS/Sass, JavaScript, Gulp, and Bower. The site is fully responsive. You can view the code for this site on Github.