Valuation modelling and roll out process automation

  • 24*7

    Automated execution of fetching data feeds and real-time data valuation

  • 95%

    Reduced turnaround time through automated processes

CLIENT CHALLENGES

  • Time consuming manual excel processes
  • Inefficient and poor quality of data updates
  • Lack of automation for data uploads, valuations, rollouts, and transaction updates

OUR APPROACH

  • Technology expert working along with business analyst automated four processes using Excel VBA, iLevel API and RPA using UIPath
  • Valuation model
    • Automated data feeds from third party providers like CapIQ
    • Enabled automated real-time iLevel data valuation and validations hosted on client’s Azure workstation
    • Automated email alert
  • File Update
    • Automated quarterly valuation model excel file update
    • Automated field mapping for different parameters like FMV, etc.
  • Roll Out
    • Implemented UIPath based RPA for rollout process for public, private and funds assets
    • Automated process is executed on monthly and quarterly rollout process
  • Track Record
    • Automated latest cash transaction pull from iLevel using iLevel API
    • Update transaction details into iLevel Data
    • Automated data refresh
    • Optimized and automated validation of return calculations
    • Automate batch delete cash transaction using iLevel API

IMPACT DELIVERED

  • Automated data feeds from third party providers, updates of quarterly valuation model file, and two-way transaction updates from iLevel and other bulk / batch transactions using Advanced Excel VBA
  • Implemented RPA using UiPath for automated rollout process for public, private and fund assets at defined frequencies
  • Developed a scalable solution considering existing and future infrastructure and models with less or minimal manual intervention.
  • Robust solution with driven by domain and technology subject matter experts and rigorous quality check process.
  • Strong project governance structure for smooth implementation and feedback mechanism
Download as PDF
Thank you for sharing your details

Your file will start downloading automatically

If it does not download within 1 minute,

Share this on