Kalyan Kumar

Sr.Executive - Application Development and Support

IDBI Intech Ltd•  March 2024 - Present•  Hyderabad

Writing and maintaining PL/SQL procedures, functions, and packages for reconciliation and transaction processing. Supporting the reconciliation process for UPI and IMPS transactions. Downloading files from the server, extracting necessary data, and uploading to the database via PuTTY. Performing Reconciliation after successful data loading, ensuring all processes are completed accurately. Working closely with Union Bank’s team to resolve technical issues related to reconciliation. Generating and downloading reports and TTUMs, maintaining high standards of data integrity and accuracy. Monitoring daily transaction reports and ensuring accurate reconciliation between systems. Collaborating with the support team to address issues raised by business users. Maintaining documentation related to processes and procedures for knowledge sharing.

Oracle Trainee

The Hackett Group, Inc.•  October 2021 - April 2023

Performed System Study, Design, Development, and Implementation of the system. Created various (Back-End) PL/SQL code to implement business rules through Procedures, Functions, and Packages using SQL Developer. Developed SQL Scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into temporary tables. Used SQL*Loader to view errors in the log file, rectified the errors, and loaded the data into the interface tables. Created stage tables, performed validations, and finally loaded them into base tables. Customized Open Interface tables to handle exceptions during invoice validation and import. Designed and developed Payables interface import program and interface tables to load the invoices from legacy systems into the Oracle Payables base tables. Validated the data and populated the Payables interface table through a Concurrent program. Responsible for day-to-day monitoring of interfaces and working on issues reported by business users.