Ginzberg, Michael J.
While working for a large investment firm, our team aimed to enhance its reporting capabilities. We updated the firm's system for portfolio performance tracking and reporting and created a tool to confirm, automate, and customize commentary describing investment performance. In addition, we developed scripts to validate transaction data, generate commentary on top contributors and detractors for gross profit month over month, and utilize timeseries data to investigate trends and perform statistical analysis. Our Azure Validaton Dashboard visualizes data with Microsoft Power Business Intelligence and provides users the ability to customize their view and drill through the raw data to find what caused certain alerts and movement in performance of strategies.
Worcester Polytechnic Institute
Major Qualifying Project
All authors have granted to WPI a nonexclusive royalty-free license to distribute copies of the work, subject to other agreements. Copyright is held by the author or authors, with all rights reserved, unless otherwise noted.