Mekala Suribabu

Implementation of an Oracle EBS Application for Bank of India's General Ledger Sheet data automation project where we have to generate day to day trial balance which is required to submit to RBI on daily basis.

Responsibilities:

• Developed and executed SQL queries for four verticals: Domestic, Treasury, CFO, and FCBS, ensuring accurate data extraction and reporting.
• Managed data loading from Linux into staging tables, optimizing data processing workflows.
• Identified and resolved discrepancies in data, coordinating with the Data Center to ensure data integrity and accuracy.
• Handled data from 15 source tables and a currency table, ensuring comprehensive data coverage for reporting.
• Conducted reversals and postings in the system, maintaining batch name integrity and facilitating accurate financial reporting.
• Generated daily Trial Balance reports and 16 additional reports, providing critical insights for financial decision-making.

A merchant account is a type of bank account that allows businesses accept payments in multiple ways, typically debit or credit cards. A merchant account is established under an agreement between an acceptor and a merchant acquiring Bank for the settlement of payment card transactions, here transactions like An off source and on shore merchant transactions.Based on that transaction type to do final calculation and calculate of net fees, service fees, off source bank fees, the main aim of the project is to do the final tally and generate the important reports like off Source bank reports (bank wise), on Source reports and to calculate Important reports like fees(netfees, servicefees, off source bankfees,etc) reports.

Responsibilities :

• Developing procedures and functions as per requirement.
• More often used bulkbind, bulklimit in pl/sql objects for improving performance.
• Extensively used utl file or data transfer.
• Developing sql queries for manipulation of data and transferring data.
• Create script to create new tables, views, queries for new enhancement in the application using pl/sql developer tool.

Finacle liabilties is a banking domain project.The main aim of project is to collect customers details and maintain transaction history and maintain balance and status.We are providing Freeze data and lien data. We are maintainting account details and active accounts and closed accounts. We are providing Saving accounts and Current accounts like SBA and CAA, this type of accounts data provided. We are providing data like scheme code. We are using flat files and lst files. We are providing Financial year data. We maintain KYC details and provide Debit card data and Credit card data.

Responsibilities :

• Developing Procedures and Functions as per the requirement.
• Creating database objects through development and testing environments.
• Creating triggers for the application business logic.
• Using cursors to collect data from table.
• Developing SQL queries for the manipulation of data and transferring data.
• Using Bulk collect, Bulk limit to get data Performance increase.