Operations Team Member-SUPPORT SERVICES-Treasury Operations

Kotak Mahindra Bank; Mumbai; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Kotak Mahindra Bank is seeking an Operations Team Member in Mumbai to strengthen Support Services for Treasury Operations. The role focuses on reviewing portfolios, risk assessment, and MIS automation.

Ideal candidates will have 4–5 years of MIS automation experience, strong analytics, Excel/Access mastery, and excellent communication. This on-site position offers growth and exposure to regulatory processes.

Qualifications

• 4-5 yrs of MIS Automation experience with SAP BO, SQL, MS Access, MS Excel and VBA Macros.
• Expert MS Excel and MS Access skills with strong PowerPoint presentation abilities.
• Experience in automating MIS, dashboards and reporting tools.
• Strong numeracy, analytical thinking and market research capabilities.

Responsibilities

• Review monthly delinquency, losses and fraud for underwritten portfolios.
• Perform portfolio evaluation and support risk assessments for retail and wholesale portfolios.
• Design risk models and prepare monthly qualitative/quantitative risk reports for senior management.
• Lead audit support and regulatory interactions; help close findings.

Skills

MIS Automation

Analytics

Presentation skills

Market research

Problem solving

Eye for details

Communication skills

Numeracy

English fluency

Tools

SAP BO

SQL

MS Access

MS Excel

PowerPoint

VBA Macros

R

SAS

Knime

Pentaho

Job description

Operations Team Member - Support Services-Treasury Operations

Job Role

• Review the retail and wholesale portfolio every month with respect to delinquency / losses / fraud for the period underwritten.
• Portfolio Management based on accurate evaluation of portfolio performance, market developments and new product management imperatives.
• Design and implement risk assessment model for retail portfolio and wholesale portfolio.
• Preparation of monthly qualitative and quantitative risk assessment report and present to senior management.
• Preparation of loss forecasting model and reviewing the same on Qtrly basis.
• Qtrly analysis of LWO written off in past qtr and present the report to the senior management with highlighting the learning and recommendation for change in Policy.
• Regulatory compliance and interactions with various teams.
• Aid conduct of audit (statutory/internal/operational risk etc.) and help closure of points to satisfaction without any adverse comments.
• Support new product launches and identity the risk involved in new product launches.

Support business by rolling out regular test programs and convert them into policy basis defined success criterion

Job Requirements

Technical Knowledge :

• Candidate should have expertise in working in SAP BO, SQL, MS Access, MS excel , Power point & VBA Macros.
• Expert presentation skill for various management committees. Expert in MS Excel & Access.
• Co-ordinate & working on automation of various MIS, management dashboards and tools for portfolio monitoring.
• Candidate should be able to coordinate with IT Team for getting the processes automated.
• Candidate should be able to conduct UAT / testing and report the changes required in systems available.
• Candidate should have expertise in working in Analytics tools like R, SAS, Knime, Pentaho.
• Candidate should have expertise in working in SQL and Microsoft office programs tools viz Excel Ac.cess and Power Point.

Market Research

• Check and keep track on industry trends, key factors impacting industry.
• Highlight the best practice followed by the market.
• Candidate should be well versed with the risk involved in secured lending and unsecured retail lending business.
• Candidate should understand internal & external factors affecting the business.

Communication Skills

• Candidate should be good communicator and should be able to make understand his point to others.
• Candidate should be confident with communicating with different audiences, from the board of directors to individual employees.
• Should be fluent in English.
• Candidate should have 4-5 yrs of work experience of MIS Automation and expert skills of SAP BO , SQL, MS Access, MS excel & VBA Macros.
• Candidate should have good eye for details.
• Candidate should be comfortable and confident with calculations and numbers.
• Candidate should be having problem solving approach by way of bring creative ideas.
• MIS Automation Skills, Analytical skills, Presentation skills, Market research, Business understanding, Problem solving, Eye for details, Communication Skills, Technical acumen, Numeracy.