Muhammad Sarfaraz أحمد, MIS Analyst - Retail Banking Division

Muhammad Sarfaraz أحمد

MIS Analyst - Retail Banking Division

Ajman Bank

البلد
الإمارات العربية المتحدة - دبي
التعليم
بكالوريوس, Marketing
الخبرات
18 years, 5 أشهر

مشاركة سيرتي الذاتية

حظر المستخدم


الخبرة العملية

مجموع سنوات الخبرة :18 years, 5 أشهر

MIS Analyst - Retail Banking Division في Ajman Bank
  • الإمارات العربية المتحدة - دبي
  • أشغل هذه الوظيفة منذ يونيو 2010

 Directly reporting to Head of Retail Banking.
 Data management for retail banking division, which would further enhance reporting capabilities & serve as the starting point for an in-house data warehouse solution.
 Preparation of Assets & Liabilities Products Performance MI on daily, weekly & monthly basis for the division.
 Conduct daily analysis related to the product’s disbursement/ approval / balances.
 Develop Monthly Deck includes Assets & Liabilities Portfolio Performance, profit and loss by product & branch, budget variances, products financing yields, CASA TD balance movement by segment and branch, delinquency trend by product and customer demographics.
 Preparation of Asset Liability Committee (ALCO) monthly reports
 Develop Monthly Deck related to Alternate channels & e-business.
 Responsible to maintain effective analytical environment to monitor the portfolio and quickly respond to adhoc for assignments.

MI Analyst - Retail & SME Cards في Barclays Bank
  • الإمارات العربية المتحدة - دبي
  • فبراير 2008 إلى أبريل 2010

 Directly reporting to National Sales Manager
 Preparation of daily, monthly, Quarterly and yearly MIS of Cards Acquisition.
 Conducting daily analysis for Sales Head related to the approval rate.
 Daily analysis of day to day and month on month Cards Acquisition comparison.
 Maintaining MI of Balance transfer and Cash on Call
 Monthly Acquisition MIS Deck for Head of Cards and Retail Assets.
 Monthly analysis of LGs/SEs aging, attrition and productivity
 Analysis of various segments i.e. product type, income band, industry type, nationality & gender.
 Analysis on Various incentive models to optimize the payout structure.
 Analysis of monthly cost Sheet with respect to cost centers
 Accruals of expenses on monthly basis and amortization of cost on Quarterly and Yearly basis.
 Worked on the Non Starters to minimize the attrition control, and maintaining activation rate, also preparing deduction MIS for Non Starters.
 Coordinating with FRMU on fraud related complaints.
 Impact Analysis on Credit Initiatives & policies
 Coordination with agencies related to SE hiring and Attrition
 Responsible for SE code activation and keeping active and inactive staff record
 Preparation of variable commission for outsource and FTE staff on monthly and quarterly basis.
 Responsible to maintain and compile payroll data of country wide contractual staff, cross check and validate data and resolving discrepancies before final processing.
 Obtain required approvals before final processing of payroll and monitor end to end process of payments.
 Preparation of various MI reports as and when required by the Business.

MIS Officer - Credit Cards في Citibank N.A.
  • باكستان - كراتشي
  • يناير 2007 إلى يناير 2008

 Directly Reporting to National Sales Manager
 Preparation of Daily, monthly and Quarterly MIS.
 Analysis of various segments i.e. product type, income band & industry type.
 Monthly Acquisition MIS Deck for higher management.
 Maintaining MI of Balance transfer and Cash on Call
 Analysis on Non-Staters and impact analysis to reduce cost per account and budgeting
 Responsible to maintain and compile payroll data of country wide contractual staff, cross check, validate data and resolve discrepancies before final processing.
 Obtain required approvals before final processing of payroll.
 Preparation & processing of outsource staff monthly commission.
 Preparation of FTE Quarterly commission
 Coordination with Citiphone, DSA and In-house Staff.
 Coordinate with rejection review unit to get the discrepant cases resolved.
 Preparation and processing of DSA Commission
 Preparation of PPR (Product Profitability Report) for DSA’s

Vigilance Officer - Credit Cards في Citibank N.A.
  • باكستان - كراتشي
  • ديسمبر 2005 إلى ديسمبر 2006

 Directly Reporting to Manager Vigilance & Card Processing
 Prescreening & analyzing of the credit cards applications to maintain the quality & conduct vigilance call to check the performance of the sales executive.
 System check of credit card application on RCC
 Cross verification through phone.
 To handle and resolve the customer queries and problems regarding the issuance of Credit Card.
 Co-ordination with Direct Sales Associate.
 Co-ordination with other units i.e. Branch, Citiphone banking, Credit Initiation & Credit Policy etc.
 Preparation of daily Vigilance MIS for senior management.
 Responsible for vigilance training to card sales.

الخلفية التعليمية

بكالوريوس, Marketing
  • في PIMSAT, Karachi
  • يناير 2006

Specialties & Skills

Analysis
Retail Banking
Payroll Processing
MIS Reporting
Portfolio Management
MS Excel
MS SQL Server
MS PowerPoint
MS Word
MS Access

اللغات

الانجليزية
متمرّس