
JOB Description
A London based foreign bank has a requirement of shifting its credit MIS to back office and thus has an immediate opportunity for a contract role for the MIS function.
Job Responsibilities:
You will be required to prepare MIS based upon existing standard operating procedures (SOP).
Process |
Description |
ODA file |
Update limits, limit expiry dates, calculate availment of limits for multi-currency OD limits, limits against FD etc |
Limit Sanction statement |
Preparation of list covering all the credit facilities sanctioned during the reporting month |
Consolidated data |
Preparation of industry-wise, country-wise data of entire credit portfolio of the bank |
Credit dashboard |
Pictorial representation of the credit portfolio based on various parameters |
India based exposure |
Reporting of India based exposure to parent bank |
Real estate exposure |
Add new accounts opened |
Real estate exposure |
Update exposure by updating the latest position of undisbursed loan amounts as on reporting date |
Real estate exposure |
Update value of security, cost of project, Gross Development Value etc |
Real estate exposure |
Add loans under process and loans sanctioned but not disbursed. Remove loans which have been disbursed. |
Key risk indicators |
Update the KRIs as requirement of Risk Department |
Largest and second largest exposure |
Select largest and second largest inflow |
Restructured accounts |
Reporting of accounts which have been restructured |
Loan file |
Instalment-wise breakup of the term loans in the credit portfolio and identification of addition of irregular accounts |
Control of capital adequacy |
Analysis of inflow and outflow based on proposals under process and expected repayments |
Valuation, Visit, Insurance |
Reporting of pending valuations, visits and insurance |
IFRS 9 |
1. Collating information from various sources to populate respective information sheet (3c File data). |
BTL regulatory reporting |
Reporting for Residential BTL Loans |
The candidate should have good knowledge of Microsoft Office Suite (Excel, Word) comprising of H/V Lookup, Data Flow Charts & Graphs, Pivot Table.
Candidate having knowledge of the following will be preferred
-
Fair understanding of credit functions
-
IFRS 9 application – ECL, stage 1/2/3
-
Banking products related to loans and advances TL, OD etc
-
NPA – days past due, standard, sub standard
-
LTV- LTC , GDV
-
Property type – Residential, Commercial, W/H, Industrial
-
ROI – Libor, fixed, floating

Similar jobs

