Projects
Data Visualization
In my past internship with RW Baird I was tasked with quantifying the value a wealth manager provides to retail investors, a challenge that few firms have undergone (Vanguard, Parametric, etc.). After weeks of collecting data and building out an extensive and dynamic Excel sheet, I transferred the data into Flourish so that users can clearly see (by clicking on the arrows) the value-enhancing aspects that Wealth Managers can provide for retail investors. This graphic is still live on my team's site. Please note this is not meant to offer any financial advice.
VBA
In one of my last Information Analytics courses, I learned the basics of VBA. For my final project, I decided to create a spreadsheet that would analyze stock price data.
​
Although the Yahoo Finance API no longer supports active pulls from the database for historical pricing data, I created a quick script to scrape the webpage based upon ticker symbols.
​
I also integrated a chart library to allow users to plot the big tech companies' share price and volume data over the last year. The sheet is relatively simplistic but given a longer time frame I believe it could be a useful way to use loops in search of buy/sell signs.
You can download the sheet in the file to the right, please note that the sheet will only properly work on PCs due to ActiveX controls.
Web Design
One of my favorite classes of all time has been the introductory classes on web design. Throughout these classes, I have learned the basics of HTML, CSS, and JavaScript including jQuery and some of the React library. I have attached a few examples of work created below, the view the examples click the image.
This simple portfolio site was created to showcase the projects I worked on throughout my advanced web class. Click the image to check out some of my more current work.
For my final project in my advanced web design class, I used React/JSX to create an app that creates a fake tweet for Donald Trump. This fake tweet pulled real Donald Trump tweets and concatenated them with text from a Kanye West API, while using Firebase on the backend to display users' input. The results was some pretty funny tweets and the scary realization that it is immensely difficult to spot where Donald Trump's tweet ends and Kanye's starts