%0 Student Work %T Transaction Validation and Analysis %A Danke, Manasi; Yuen, Joseph; Merrill, Ethan %D 2020-01-31 %8 2020-08-22 %I Worcester Polytechnic Institute %R https://digital.wpi.edu/show/vh53wz20k %X 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. %9 Major Qualifying Project %~ Digital WPI %W WPI