Professional & Personal Projects

Welcome to my project showcase! Here, I present a curated selection of my recent projects, epitomizing my knack for deciphering complex data and turning it into meaningful insights. I’ve worked tirelessly to hone my data analysis skills, employing statistical know-how to delve beyond the surface of numbers. Each project is a reflection of not only my analytical prowess but also my dedication to making data-driven decisions.

Each project snippet here includes a concise preview and a link for a deeper dive into the project itself. These snippets are just a glimpse into the sea of projects I’ve undertaken over the years. As you explore, I invite you to immerse yourself in the journey each project embodies, appreciating the discovery, problem-solving, and insights woven into them.

This collection spans an array of domains, from predictive modeling to business strategy, encompassing my work with varied datasets and tools such as Excel, R, Python, and SQL. Additionally, I’m passionate about blending my interests in sports (as well as Fantasy Sports) with my data analysis skills. I relish tracking personal data and crafting dashboards to uncover patterns in various platforms, including Fitbit, Netflix, Spotify, and Google Maps, making my life’s data as exciting as my work.

Thank you for exploring my work. I’m eager to discuss how my diverse experience and analytical skills can be an asset to your team. Enjoy the ride through my data-driven world!

PROFESSIONAL

Energy Meter Analysis Web App

This is a web application I designed to prototype energy analytics solutions. Built on R Shiny, it provides a straightforward and effective way to quickly import, analyze and model energy consumption data. It served as a prototype towards the development of more comprehensive energy analytics tools.

This online poker league is a community-driven project I established during the global pandemic, serving as an innovative blend of recreational activity and statistical analysis. From hosting tournaments to awarding seasonal champions, the league exemplifies the practical application of my data management skills in an engaging, social context.

Online Poker League

Website

PERSONAL

PROFESSIONAL

Data Integration

Python Package

This Data Integration Python Package is an efficient tool built to interact with external APIs for streamlined data integration. It excels in sophisticated timezone management, robust interaction with blob storage, and seamless CRUD operations with APIs.

The "NBA Player Stats" web app is an interactive tool that lets users explore and analyze statistics of NBA players. With a user-friendly interface, you can filter data by player, team, location, and date range to see detailed performance metrics. Whether you're looking to study a player's scoring trends or compare stats between players, this app makes it simple and engaging. Perfect for NBA enthusiasts and data geeks!

NBA Player Stats

Web App

PERSONAL

PROFESSIONAL

Energy Signature Analytics Web App

The Energy Signature Analytics Web App is an R Shiny-based platform that empowers building owners and managers with insights into their building's energy consumption patterns. Through sophisticated analysis of electricity and natural gas utility bill data, the app provides an array of metrics such as Electric Base Load, Gas Base Load, Heating and Cooling Load Slopes, and Heating and Cooling Balance Points. Visualizations like color-coded base load charts and scatter plots for raw energy data, as well as tabular metric summaries, enable users to make informed decisions for optimizing energy use.

In this exploratory data analysis project, I created a dynamic Power BI dashboard that slices and visualizes COVID-19 data scraped from John Hopkins University's GitHub repository. The dashboard features a myriad of interactive visuals including treemaps, timelapses, rolling 7-day charts, and more, enabling me to flexibly analyze the pandemic's trends. The dashboard, once embedded on a website, offered others an alternative avenue to engage with COVID-19 data.

COVID Analytics

Dashboard

PERSONAL

Honorable Mentions

Journey into Mobile Development: My First Android App

Embarking on an exciting foray into mobile application development, I plunged into learning Kotlin and the Android SDK to craft my first Android phone app. With no prior experience in app development, this venture epitomized self-learning and tenacity. Although the app is still in the testing phase, it has been effectively demonstrated and serves as a testament to my adaptability in embracing new technologies, especially Kotlin.

The app is tailored to offer users statistical information for managers in one of my Fantasy Football leagues. It kicks off with a splash page showcasing an image during the loading process. The home screen, set against a dark grey background, features a light blue title and two buttons - "Regular Season Stats" and "Playoff Stats." Tapping a button leads to a new screen with a dropdown list of names; selecting a name unveils the manager's stats, which are pulled from an imported file. Despite its simplicity, the app is intuitive and user-friendly, and lays a solid foundation for future app development.

This endeavor underscores my proactive stance in adopting and mastering new technologies. Through self-education in Kotlin and the Android SDK, I breathed life into an idea and constructed a functional mobile app from the ground up, reaffirming my dedication to skill expansion and tackling new challenges.

Innovative Fantasy Football App:

From Excel Prototype to Web Platform

In another innovative endeavor, I combined my passion for Fantasy Football with a deep dive into data scraping and analysis. I began by creating an intricate prototype in Excel using VBA and Macros. The essence of this project is to allow users to draft football players from various eras and construct Fantasy Football teams, which can then compete against one another using historical data.

The foundation of this app involved a meticulous data scraping process from Pro Football Reference to acquire an extensive list of player statistics. I subsequently refined this data, applying Fantasy Football scoring settings, and synthesized summary datasets. The Excel prototype is packed with several tabs, each serving a distinct purpose, ranging from drafting players to viewing matchup outcomes and league standings.

To ensure this brainchild reached its full potential, I decided to evolve the prototype into an interactive web application. The transition from Excel to a web-based platform demands different technologies, and I am currently exploring options such as Python with Django or Flask for backend development and React or Angular for the frontend. The web application will need user account capabilities and a robust database to store historical data and user information.

This project reflects my resourcefulness and my capability to wield diverse tools - from Excel, VBA, and Macros to potentially employing modern web development technologies. It exemplifies my dedication to constantly expanding my horizons and crafting innovative solutions that blend entertainment with data-driven insights.