Avnish Gupta

• Automated data population for the Margin Pledge Allowed Stocks & Haircuts page, eliminating manual processing and boosting operational efficiency by 70%.
• Optimized ticket creation process for tasks such as transit order cancellations, pending AMO procedures, and mass order cancellations through SQL query modifications; enhanced efficiency by 75% and reduced error rate by 28%.

Bank QR Service

• Led development service dedicated to fulfilling bank's QR needs to supported functionalities like 20M debit card, 5M NCMC cards. Supported daily traffic of avg. 0.7M daily cash withdrawal requests and avg. 0.1M request for card activation, address verification etc.

Batch Operations Service

• Overhauled scheduler-based batch processing, introducing Kafka for asynchronous file processing, reducing task execution time by 60%, and integrating UPI reconciliation and interest certificate generation.
• Furthermore, extended service's functionality by creating multiple flows, such as UPI reconciliation (averaging 1 million transactions per day), and seamlessly integrated it with our partner bank's SFTP system to automate interest certificates and TDS certificate generation.

External Integration Service

• Contributed to development of Java and Scala-based service that is proficient in managing mappings and parsing between internal services, as well as external services at impressive rate of 20K tps.
• Collaborated with IBL, SSFB, and IMPS clients to integrate their APIs and develop detailed API contracts enhancing system reliability by 30%.

Recon Service

• Automated reconciliation for IMPS and AEPS transactions, overseeing refund handling such as customer chargebacks and credit adjustments resulting in 50% decrease in operational expenses while guaranteeing efficient processing without penalties.

Implemented centralized API for database configurations, decreasing production release frequency by 60%.

Health Pass

• Developed Health Pass, featuring a one-year subscription with benefits like free accidental insurance and expert dental and diet consultations, resulting in a 15% boost in customer renewals.

Insurance

• Led strategic integration of Personal Accident Insurance with ICICI Lombard, boosting revenue by 20%, and played pivotal role in enhancing Bus Travel Insurance and Payment Products at Paytm. Also worked on pre-payment and post-payment processes.

• Worked on developing backend service APIs, including Account Information API aligned with OpenBanking guidelines, integrated MuleSoft policies for security, and optimized monitoring with Splunk queries.
• Created backend service APIs for pushing and deleting messages from AWS SQS queues.