Financial Consulting Impact
A project to input individual checking, savings, and some credit card transactions into a reproducible pipeline and develop and report on key metrics.
Financial Consulting for Underserved Communities
The client offers financial consulting services to underserved individuals seeking financial independence. The company’s goal is to help their clients navigate predatory debt, reduce their overall debt burden, and, in the long term, increase their income. To achieve this, the company provides financial coaching and recently implemented a new process where clients can securely link their savings and checking accounts.
Data Pipeline and Analysis
After clients linked their accounts, their transaction data was stored in a JSON format within an AWS S3 bucket. I developed a robust ELT (Extract, Load, Transform) data pipeline to process this information. The pipeline efficiently pulls in raw data, loads it, and then transforms it into key financial metrics. A crucial aspect of this project was refining the data to ensure accuracy and relevance. I created a system to accurately distinguish between business and non-business clients, filter out clients with minimal transaction history, and focus on those who are of interest for further analysis.
To improve efficiency, I enhanced the data pipeline to pull in only new records, significantly reducing the data update lag. This optimization ensures that the financial metrics are always based on the most current information available.
The project’s final deliverables included the data pipeline code and a reproducible report. This report automatically calculates and visualizes key metrics, providing the financial consulting team with a clear way to evaluate the effectiveness of their coaching and the progress of their clients.