Skills
Microsoft Excel, Power-Bi, Netsuite, Envestnet, Netx360, Portfolio Management, VBA Macro, CRM, Account Reconciliation, ACH Processing, Client Relationship, Fund Accounting, NAV.
About
I'm a finance professional with 8 years of experience in fund accounting, investment operations, and financial analysis. At Brown Brothers Harriman, I led NAV oversight for major institutional clients and enhanced their German Tax Reporting process by updating and troubleshooting a large VBA macro that supported daily compliance. At 3D Wealth Management, I manage reporting across 1,500+ accounts and built a custom Excel VBA macro that tracks ROI, RMDs, cash flow, and triggers trades based on real-time data. I’ve also developed personalized budgets and forecasts for clients using PX Financial Planning tools. My strengths lie in automation, data accuracy, and providing clear financial insights for better decision-making
"At BBH, I was part of the team responsible for German Tax Reporting. The process was slow and prone to errors due to the size and complexity of the macro used. I took the initiative to restructure portions of the macro, improve formulas, and suggest efficiency upgrades—many of which were adopted firm-wide. These changes helped us hit daily deadlines more consistently and reduced NAV discrepancies.
Excel has been one of the most critical tools in my workflow, and I’ve built several advanced solutions that pull, consolidate, and analyze data across multiple platforms. At 3D Wealth Management, I created a dynamic Excel VBA macro that tracks 1,500+ accounts, pulling data from Envestnet (ENV2) and NetX360 to consolidate cash flow, contributions, RMDs, and ROI.
I used functions like VLOOKUP and XLOOKUP to map client IDs to investment holdings or planning assumptions, and IFNA to gracefully handle missing data. I also built nested IF and IFS conditionals to flag accounts that exceeded IRS contribution limits or missed RMDs—automatically alerting us to compliance issues.
My macros also run scheduled refreshes and auto-update allocation tracking based on real-time activity. These tools not only reduced manual errors but saved the team hours of review time each week. Whether reconciling cash positions, forecasting distributions, or prepping audit data, Excel is the engine that helps everything stay connected and compliant."