Fund performance reporting automation

Client

A Global Asset Management

• To enable the marketing team to analyse the performance of various funds on the fly for 15 plus categories from different data sources like Bloomberg, Lipper, Morning Star

• Data Sourcing, Collection: The marketing team extracts the data from the Lipper System as CSV files
• Data Cleansing: Raw data is uploaded into the database and then its cleansed in the database. This complete process takes around 20-30 second
• Data Staging: The cleansed data is then imported in the stage area of the database for further processing. This takes approximately 2-5 seconds
• Data Consumption and Deployment: The latest data is used to update dashboard using Tableau
• Data Mart Loading: The processed data is then loaded into the data warehouse. The DW follows a star schema, and the process takes around 20-25 seconds
• Stage Processing: The data is further processed and becomes ready to be uploaded in the DataMart. This takes around 10-15 seconds
• Tools Used: Tableau, MySQL, SSIS, Talend
  

• Streamline market data reporting and reduce processing efforts
• Marketing team can envisage new ideas for pitching their funds with greater efficiency than the conventional method of report delivery