Aswath Sengottuvel

Project Details & Description:

Client : Star Link Bank

Duration : 2020-2023 OCT

I specialized in two pivotal sub-modules within the Loan Section: Origination and Management Systems. In Origination, I managed processes from underwriting to loan disbursement, crafting quotations based on user inputs. In Management, I ensured timely payments through various methods and created vital reports for tracking defaulters, bank presentations, and pending charges

Responsibilities:

• Developed several Packages, Procedures, Functions and Triggers to use in multiple series of other backend programs using PL/SQL.
• Created Tables and Queries, Packages, and Stored Procedures.
• Used Ref cursors and Collections for accessing complex data resulting from joining of large number of table.
• Used PL/ SQL Tables, and Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process.
• Improved query performance by query optimization - tracing query execution plan (explain plan).
• Created indexes for better performance.
• Involved in PL/ SQL code review and modification for development of new requirements.
• Analyzing tables and indexes for performance tuning Involved in coding and testing of system.
• Developed PL/ SQL procedures, customizing existing programs according to te needs of client testing.
• Worked with the team to design, develop, test & implement system. Creation of database objects like tables, and procedures using Oracle tools like PL/ SQL, and TOAD.
• Written Stored Procedures using PL/ SQL.