Serverless data pipeline for data-driven decision making to mitigate pet surrenders

Abstract

Secondhand Hounds (SHH) is a non-profit animal rescue organization located in Minnetonka, Minnesota and was facing a rise in pet surrenders. A pet surrender is when an owner relinquishes ownership of the pet to a shelter or rescue. On top of this, the processing of surrender applications was a manual and extremely tedious process. The aim of this project was two-fold: create an automated data pipeline and a reporting dashboard for key insights. This would enable data-driven decision making for SHH to hopefully mitigate these surrenders in the future. As part of this project, we collaborated with the team at Secondhand Hounds to automate the processing of surrender applications and storing of records, created a centralized NoSQL database for surrender data and built a business intelligence dashboard for data analysis.