CSE498, Collaborative Design, Spring 2015
Computer Science and Engineering
Michigan State University

Quicken Loans, headquartered in downtown Detroit, Michigan, is the largest online retail mortgage lender in the US. With almost 30 years of experience, their customers include over 2 million American families.

As it rapidly expands its workforce, Quicken Loans faces the continual challenge of meeting the parking needs of its team members, many of whom commute by car.

Quicken Loans is frequently overbilled due to discrepancies between garage managers’ invoices and Quicken Loans’ records. These discrepancies are reconciled manually by the Quicken Loans Parking Team through a number of processes including spreadsheets and emails to garage managers.

Our Parking Allocation and Expense Reconciliation dashboard automates this process by ingesting data from each garage and identifying points of contention. Our system also provides an easy way to communicate problems to garage managers by generating and sending issue reports.

The dashboard manages invoices and visualizes numerical data such as the number of spots billed each month, which is used to track and monitor parking expenses. It also includes the ability to monitor team member parking by communicating with badge scan readers located in several garages and displaying parking activity, thereby enabling the Parking Team to optimize usage and allocate spots as needed.

Our dashboard is written in C# using the .NET Framework. The underlying database is Microsoft SQL Server 2012. The front end uses Google Maps, AngularJS and jQuery.