Features Integration Automation Bloomberg API Replace VBA
The business flows involves many small, but different sequential operations; such as retrieve data from third-party market vendor, excel calculations, FTP, batch scheduling, reporting and monitoring. Any error on one operation will affect flows downstream.
We replaced the legacy VBA excel sheets with a flexible Bloomberg linked batch applications. Our solution removed single Desktop/User dependency, streamlined operation flows and reduced human error. In short, the IT solution stabilized their fund publishing business operation flow.
Good experience learning typical listed-funds operations. It seems many financial institutions are still stacked with manual BAU tasks, they should automate for better efficiency and accuracy.