juandiaz

Generated daily treasury report for COO and CIO across 30+ accounts, reconciling account balances, forecasting liquidity for LP redemptions, VC investments, FOF capital calls, and trading operations to optimize cash deployment and yield strategies. Built and maintained a venture investment database tracking 50+ metrics across 200+ investments (valuations, deal terms, FOF subscription terms) and created a dashboard interface for operations and executive teams to access real-time portfolio data. Managed regulatory compliance filings for SEC-registered RIA managing 15 entities across 3 fund structures, including Form ADV, Form PF, Form D, and Blue Sky renewals, as well as CIMA-regulated offshore entity filings (ESN, FAR, BOI), coordinating with fund administrator and compliance consultants to meet all filing deadlines. Managed documentation and response coordination for routine SEC RIA examination covering 100+ information requests, collaborating with compliance consultants to compile supporting materials and submissions, achieving zero enforcement findings. Led onboarding of 30+ exchanges, custodians, and trading counterparties across 3 master-feeder fund structures and 2 offshore trading entities, establishing documentation processes and account infrastructure to support trading operations. Managed 70+ KYC applications and periodic refresh reviews across all active counterparty relationships, maintaining updated documentation to ensure continued good standing and uninterrupted operational access. Supported monthly accounting close, annual audits, and tax preparation by coordinating weekly with external teams to deliver requested documentation, including accounting schedules, trade confirmations, counterparty statements, LP capital activity, and private investment records across multiple fund structures. Built end-to-end accounts payable infrastructure, processing $2.5M+ in annual vendor payments and creating approval workflows, reducing payment processing time while enabling quarterly expense analysis to drive vendor negotiations and cost optimization. Designed and executed data migration from Dropbox to Google Drive, implementing a new folder structure and document management system that streamlined audit, compliance, and monthly close processes and improved document accessibility for internal and external teams.