Performance Tuning

Performance Tuning


Case Study: 1
For a Large Health Care Client, the key “Accounts Payable” module was having performance issues which delayed the payment processing for vendors that had a cascading effect on month end close cycles. This caused a reputation risk for the organization. The problem was compounded by a lack of access to the source code.
Solution :
The team of database & system engineers analyzed and identified the bottleneck. The core issue was remediated by an ingenious solution that instantly paid off. The solution could be adapted swiftly and implemented seamlessly. This resulted in performance gains of over 99%.
Outcome / Benefits:
  • The batch processing time was reduced from 44 hrs. to under 1 hour resulting in efficiency leap.
  • This resulted in faster turnaround time for AP voucher processing & strengthened the relationship.
  • The innovative solution was accepted and incorporated by one of the leading applications vendor.
  • This in turn resulted in 3000+ customers getting benefited by this solution.
Case Study : 2
For a Large IT Services Company, the “Pay When Paid” module was having performance issues. The closed system with restricted access has compounded the challenge in terms of troubleshooting.
Solution :
The Velocity Logics team mimicked the complete setup offline and replicated the issues iteratively through profiling and identified the root cause of the core problem at database end. The sequential updating of high volumes has been identified as the core cause of the performance problem. The data rendering was converted to parallel model and the reconstructed data snap was imaged to the original database.
Outcome / Benefits:
  • Significant execution time improvement from 11 mins 2 seconds to less than 10 secs.
  • The unique approach opened up doors for non-intrusive troubleshooting model.
  • The breakthrough approach has strengthened the maintainability of the core product suite.
Case Study : 3
A Large Midwestern Client was having performance issues with critical Cognos reporting module “Project Cost Revenue Detail”. The consolidated report generation was taking more than 24 hrs and hence Velocity Logics was engaged to fine tune and streamline the project.
Solution :
The Velocity Logics Cognos SMEs looked at the report layout, queries and expressions in the report and identified the bottleneck with the query structure. The team untangled the query complexity and came up with the ingenious solution that not only optimized query structures but implemented cache model that had improved the performance by 98%.
Outcome / Benefits:
  • The shortening of execution time by 50 times has helped to better TAT.
  • The efficiency of the reporting module has helped faster processing of the downstream systems.
  • This has equipped analysts to make faster financial forecasting decisions.
  • The effectiveness of the reporting system improved by over 98%.
Case Study : 4
A Large Midwestern Client was dealing with performance degradation issues due to exponential data growth and engaged Velocity Logics for performance tuning of the Cognos reporting module (Project Budget Detail Report)
Solution :
The Velocity Logics team methodically analyzed the problem by using various toolsets including profilers and identified the erroneous Queries and redundant iterative calls. The SMEs came up with consolidated querying yet selective and sequential execution model. This helped to improve the report execution time from 90 minutes to 7 minutes, i.e. 85% of improvement.
Outcome / Benefits:
  • The execution time got shortened by 10 times.
  • The overall effectiveness of the reporting system improved by over 60%.