Genter Capital Management
Automated an IRS-mandated compliance calculation across 200+ client accounts, where the cost of a wrong number is a federal penalty.
The problem
Two client-facing workflows at the firm were still manual. Portfolio reporting for high-net-worth clients was assembled by hand. And required minimum distributions — the amount the IRS obligates certain account holders to withdraw each year — were being computed account by account. Getting an RMD wrong is not an internal inconvenience; it exposes the client to a federal penalty.
What I built
For reporting, a Python pipeline using the Schwab API, Pandas, and Plotly that generated and emailed custom visualizations segmented by market exposure, cutting more than three hours a week of assembly.
For compliance, three pieces: a scraper to pull account data out of Schwab, a Pandas layer to clean and structure it, and a calculation engine that computed each client's required distribution from age, balance, and IRA type. On top of that, a notification system that told all 200-plus clients their withdrawal amount and deadline, which took turnaround from two or three hours a day to minutes — about 25 hours over the two-week window.