Banking (Cards) - Browser and Mobile App Multi-Tool NFT

CONTEXT

Cards & Payment Services from the biggest PSU bank in India, one of the largest credit card companies and payment providers in the country. The company is the only publicly listed pure-play credit card issuer in India and the second-largest credit card issuer in the country.

Challenges

Solution

Developed over 60 web-based and mobile API scripts using a mix of Fiddler, LoadRunner, and JMeter
Executed 150+ performance tests over a span of 8 months
Real-time monitoring and issue reporting using NewRelic APM
Supported DBA in analyzing Oracle AWR reports to highlight problematic queries
Worked in shifts over 24 hours to support on-time product delivery

Value Delivered

Exhaustive testing revealed numerous issues in the server configuration, particularly around how the server manages concurrent connections. This was done by analyzing application thread dumps and OS logs.
Testing also uncovered that many plug-and-play modules on the application were not capable of handling high concurrency, forcing developers to create custom modules that helped the client achieve their concurrency goals.
AWR analysis uncovered more than 20 long-running and frequent queries, and optimizing those reduced DB server utilization by more than 20%.
The application was creating database connections at a ratio of 1:8 for every web request, which was deemed unacceptable. This issue was highlighted using real-time NewRelic monitoring over several tests.