Portfolio Research Associate
Pittsburgh, Pennsylvania, Us
Sector: Domestic Equity- Built dashboard of 300+ mutual funds to monitor absolute performance and risk/return metrics using Factset to provide a comprehensive tool that could be used to understand performance via customizable dashboards, and use conditional formatting to monitor fluctuations and present critical insights to senior management during weekly meetings.- Spearheaded the quarterly performance reporting process for 350+ funds through aggregating performance metrics from fund managers, validating the data and ensuring that it meets internal compliance standards, collaborating with investment risk, operations, and marketing teams to prepare documents for internal use and dissemination to 250 financial advisors.- Generated monthly sub-style performance report to rank outperformance for > 600 investment funds, then developed Excel heat maps to visually represent data, for use in quarterly performance reporting.- Performed ad-hoc analysis for platform rationalization, sector attribution charts, relative portfolio weights, tracking error, and variance to produce insights and help internal senior analysts prepare for manager meetings on a quarterly basis.- Supported ongoing improvements to performance reporting reports, dashboards, and technology systems and created procedures to spread knowledge with the team , while maintaining consistency of reporting quality and meeting deadlines.