Wealth Management Corporate Intern
Current• Devised advanced spreadsheets utilizing Excel tools (PIVOT TABLES, XLOOKUPS, POWER QUERY) to analyze raw data; model data was interpreted into action items with project results and suggestions used by upper management • Created guide for Portfolio Strategy team detailing the use of FactSet software to run analytics on bank portfolios• Researched different client account issues for 100+ accounts, results were presented to the 25 members of the portfolio strategy team which resulted in a 50% performance improvement and an overall team 0% error rate• Executed 10+ projects which improved the portfolio team’s job execution as well as enhanced the HNW client experience