General Motors, headquartered in Detroit, Michigan, is the largest vehicle manufacturer based in the United States. OnStar, a subsidiary of General Motors, provides in-vehicle communications, security, navigation, and remote diagnostics.

Within a week of COVID-19 being declared a national emergency, General Motors and OnStar shifted approximately 12,000 OnStar service agents from extremely predictable call center environments to largely variable home offices.

OnStar agents conduct phone calls to vehicles via an internet connection requiring fast and reliable speeds for phone calls to be clear. General Motors IT must know when internet speeds drop, as poor call quality can result in customer dissatisfaction.

Currently, connection speed records are automatically gathered on OnStar agents’ computers into files, which are then regularly transferred to a centralized server for processing. When thousands of OnStar agents are online and making calls, the server processing often becomes backlogged, and data is sometimes lost.

Our High Frequency Data Ingestion application resolves the bottlenecks induced by influxes of data by providing efficient file reading, processing, and writing operations. Furthermore, existing backlogs of files are resolved by limiting the number of data points for any given OnStar agent.

In addition to data ingestion, our software features interactive web dashboards. Data from the ingestion application can be analyzed on multiple webpages. This data includes the OnStar network metrics, OnStar agent comparison tables, and ingestion application processing statistics.

The ingestion application is written in C# and is optimized to work with Microsoft network-attached storage drives and a Microsoft SQL Server. The web application is written in Python Flask and uses Socket-IO and Plotly for plotting.