AKHIL ABRAHAM

PROJECTS

• Developed and deployed Pre-approved Personal loan (PAPL) by identifying eligible candidates using advanced data modeling techniques, achieving yield of 13% for the bank.

• Engineered and implemented daily Management Information System (MIS) for bank assets by leveraging data warehousing techniques, providing comprehensive vertical-wise analysis of achievements, disbursements, and book positions.

• Developed and deployed statistical application scorecard for personal loans, reducing turnaround time (TAT) through automated approvals/rejections and enabling dynamic pricing based on risk assessment.

• Designed and implemented Turnaround Time (TAT) tracking systems for Retail Advances departments, with focus on housing loans, thereby reducing end-to-end processing time from 30 days to 12 days.

• Created and implemented 'Profitability Analysis' tools for specific business verticals, enhancing strategic decision-making.

KEY RESPONSIBILITIES

• Utilize advanced SQL queries to extract and transform complex datasets, collaborating closely with data warehouse team to ensure efficient data retrieval and preparation for visualisation and analysis.

• Design and develop reports for various business teams, ensuring data accuracy and actionable insights.

• Collaborate in development and implementation of Business Forecast and Prediction Models for asset business, contributing to strategic planning and risk management.

Lead Business Manager overseeing Current Account Business for Bangalore Region.

• Oversee and analyze daily operations for current and savings accounts, ensuring smooth processes and driving increased business.
• Leverage Excel and SQL to analyze data, create reports, and present insights using advanced functions, pivot tables, and pie charts.
• Lead my teams to implement data-driven strategies aimed at improving regional business.

Branch banking operations, customer relationship management, and retail loan processing.