Summary

Pain Points: Heavy reliance eon manual effort to extract data from PDF Reports into MS Excel for analysis and interpretation, Solutions: Robotic process automation (

Pain points

Our client owns multiple investment portfolios managed by different asset managers. Every month, each asset manager would issue a monthly report in PDF format.

To analyse data, our client had to manually export data from a PDF report into a Microsoft Excel spreadsheet, transforming it into a more accessible format. Due to the manual nature of the process, it not only took up to three man-days each month, there was also a high potential for human errors.

 

Solutions

We proposed using robotic process automation (“RPA”) to enhance our client’s analytical process. We developed a workflow that read the data from the PDF investment reports, extracted the data, processed it into a structured format, and performed analyses such as calculation of the portfolio’s closing balance, realised profit and loss, and made comparison with market benchmark.

Furthermore, to allow for enhanced insights, the performance of the portfolio could be loaded onto an interactive dashboard for reporting purpose.

 

Results/Benefits

With this new automated system in place, it boosted the efficiency of financial and accounting operations (along with performance tracking and management reporting) by more than 90%. 

This means that our client will be able to allocate resources to higher-value tasks that drive better business decisions.

 

==============================

Our Data Science team, comprising a group of specialists with multi-disciplinary skills, helps our clients make better strategic and operational decisions by turning data into actionable insights.

For more information, contact:

Adrian Tan  
Partner & Industry Lead, Technology, Media & Telecommunications  
T: +65 6594 7876  
[email protected]