Analyst

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). 2. To assign staging to each loan account as per bank approved document. 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