Ally Financial is an industry leader in financial services headquartered in Detroit, Michigan. As one of the largest online-only banks, Ally Financial provides their approximately 11 million members with a full suite of banking and financial services powered by ever-advancing modern technology.

Focusing on the rapid growth in data-driven decision-making, Ally Financial’s experts analyze various types of data across multiple sources for critical processes. The analysis process requires effective management of varied and abundant data to ensure consistency and accuracy which is time-consuming and may cause overlooked discrepancies if done manually.

Our Data Consistency and Reconciliation Tool streamlines the process by analyzing and validating multiple data sources. The tool automatically detects anomalies and generates reports highlighting issues.

When using our web-based application, users are first presented with a dashboard showcasing a summarized overview of data sources and consistency checking displayed through various charts and tables. On the data ingestion page, users upload data sources in various formats to be analyzed. The tool applies predefined validation rules for consistency checking, and any mismatches present are analyzed between two different data sources for reconciliation, logging discrepancies to provide an inconsistency history.

Our tool cuts down on the complexity and time cost associated with analyzing and reconciling multiple types of data, giving Ally Financial’s experts more time for other endeavors.

The user interface is developed using React. Data is stored and processed in Snowflake, a cloud-based data warehouse platform. Flask, a Python web framework, is used to transfer data between the front end and database.