The Client
A Global Asset Management Company
Challenge
- Transfers Team gets bulk requests to perform Book Cost Adjustments on the assets held under portfolio
- Manual repetitive work which doesn’t require any decision making while processing as there are no changes in quantity just amending the book cost
- 8620 transactions received under single request which could have took 59 business days to complete with one FTE aligned to cumbersome task
Solution & Execution
- While performing process study Bulk BCA activity was identified as an opportunity
- Utilized excel based Macro which interacts with client investment platform to enter the details reading from excel input file
- User creates an excel file and copy pastes the client instructions to bot readable format. Macro utilizes the input file to process transactions on client investment application and shares the output
- Exceptions are processed manually by user
- Client approval prior implementing in live production
Value Delivered
- Efficiency Gain ~190 hours savings in the project
- Quicker turnaround – Macro working continuously as per system availability timings
- Similar tool implemented at both Onshore and Offshore within other sub-process requiring repetitive tasks and data entry
