aadi malaviya
~/work/genter-capital03 / 05

Genter Capital Management

Automated an IRS-mandated compliance calculation across 200+ client accounts, where the cost of a wrong number is a federal penalty.

ROLE   Data Analyst InternTYPE   Wealth management firmFROM   June 2025TO     September 2025
200+client accounts under automated RMD calculation
~40 hrssaved during compliance season
3+ hrs/wkcut from portfolio reporting
  • Python
  • Pandas
  • Plotly
  • Schwab API
  • BeautifulSoup
01
[01]

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.

02
[02]

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.