Data Analyst
MCB Bank
Total years of experience :30 years, 3 Months
Department: MIS and Analytics Designation: Data Analyst Responsibilities a. Historical Trend Analysis, Roll Rate Analysis, Segmental Analysis of Portfolios on different BI tool like Cognos, SAS, SPSS). b. Preparing monthly MIS Pack of Consumer Products for monitoring the portfolio. The MIS Pack is a comprehensive portfolio analysis document covering delinquency performance, bucket picture, WAS/IS analysis, deviation performance, net flows, booking analysis, resolution analysis and portfolio caps. The monthly MIS Pack is the source for all Credit Reviews presentation for higher Management. c. Preparing the Consumer Collections daily delinquency monitoring reports for all Consumer Products launched by MCB namely (Payara Ghar, Auto loan, Personal loan & Credit Cards) for Consumer Collections & Credit department, Finance Department. d. Managing Consumer Products Portfolios of over Rs.30 Billion on SQL Server 2000. e. Coordinate with other department to resolve their data related requirements.