SHUMAIL HUSSAIN

• Financial Reporting & Analysis for Mass, Emirati and Branch Distribution & Channels
• Manage Balance Score Card, KPI’s, Dashboards, Monthly Profitability Report, Forecast, Sensitivity Analysis, Peer Group Comparison, Cross Sell, Portfolio Management, Product Penetration and Central Bank Reports for Consumer Banking Group.
• Business Strategy & Planning: Budgeting and Planning for Consumer Banking (Asset / Liabilities / Revenue / Expenses / Provision / Net Profit / Yield / COF / Booking) at Product level.
• Automation & Standardization of MIS’s, Reports, Business Drivers & Key Performance Indicators for Consumer Banking Products and all ADHOC queries related to retail finance.
• Integration Project SPOC for all financial related requirement of Personal Banking Group
• Implemented customer segmentation for Consumer Banking Group (Including Emirati, Mass, Business Banking and Private / Wealth Segments)

• Individually automated Consumer Banking Financials on SQL Server as database and VB, as front end tool in FGB and Standard Chartered Bank that delivers financials in 20min on a daily basis.
• Successfully Launched Monthly Profitability Report for Consumer Banking in FGB and HSBC.
• Comprehensively developing budgets for CBG, covering Assets and Liabilities based on portfolio trends, market situation and business initiatives.
• Implemented Customer Data Mart and OBIEE Data-warehouse for CBG.
• Awarded for great support for Premium Banking Segments in streamlining their 15% of financials in FGB.
• Consumer Banking SPOC for OFSAA - FTP Project
• Lead financial modeling & analytics initiatives to build models for cross-sell, up-sell, anti-attrition, delinquency prediction, & spend stimulation using data analytics from leading services provider.
• Develop Expense management system for retail.
• Pre-Merger (FGB): To prepare and manage financials of approx. 50Bn worth of Assets and 35bn of liability portfolio for consumer banking and support top management in achieving the net profit target of approx. 1bn every year.
• Key Member of Product Bundling Project and provide support in all financial analysis.

Working on QlikView (Business Intelligence Tool) for RBG Product

RESPONSIBILITIES:

" Automate Sales Incentive for all Retail Banking products.
" Design & Develop Dashboard for Retail Banking Group of all the financials.
" Implement Business Intelligence for Retail Banking Group.
" Perform Data-Mining, Data-Warehousing, and Analytics for Retail Banking Group

ACHIEVEMENTS / PROJECTS:

" Developed a Financial Model for Retail Banking Daily Financials.
" Implementation of web based sales management system including (incentive, tracking of applications, disbursement, logins, approved, cancelled, re-processed, top up case, non starter, TAT, DSA & TL performance)
" Design a Dashboard & MIS Deck for Retail Banking Product Sales.

Designation: Business Analytics Manager for Unsecured Business  Consumer Banking Department: Product Development Department  Personal Financial Services

RESPONSIBILITIES:

" Portfolio Management  Unsecured Business (Business Drivers, KPI, Portfolio Segmentation, Financial Analysis i.e. AIF, CIF, ENR, ANR, delinquency, T/R, approval, decline rates, Active, Inactive, Spend, Income, payments etc.
" Business Analytics and Modeling for Unsecured Business
" Data Warehouse for Unsecured Business, Implementation of web intelligent cubes & Adhoc queries.
" Automation & Standardization of Reports, Business Drivers & Key Performance Indicators for all products

ACHIEVEMENTS / PROJECTS:

" Developed a Financial Model for Unsecured Business
" Implementation of web based sales management system including (incentive, tracking of applications, logins, app, cancel, TAT, DSA & TL performance)
" Design a Dashboard & MIS Deck for Personal Loan and Credit Cards Sales.
" Planning to implement a web based scoring system using SAS.
" Design and Develop Credit Card application management system. Objective: To track card application end to end i.e. sales to operations, sales productivity, performance, TAT, wrong capturing.
" Develop a Training and Governance MIS pack.

Formerly Known as Union Bank in 2005, Designation: Business Analyst for Unsecured Assets Decision Sciences Department (Business Intelligence Unit)

RESPONSIBILITIES:

" Financial / Functional Analyst for Credit Card Business
" Group, American Express, Visa and Master Card International Reporting.
" Implementation of Wealth, Cards and Merchant Acquiring Data Warehouse, Deployment and Implementation of SAS, Analyze, Design, and Implement new Business Softwares and
" Adhoc queries.

ACHIEVEMENTS / PROJECTS:

 Card Tech Limited CTL and Go Live Module
Design a module for Go Live campaign.
Work on Prime Reports. Design acquiring report for credit cards
Work on CTL database, queries, reports, and design schema for various tables.

 Design and Develop Standard Chartered Bank Sales Incentive System (SIS)
This application designed to overcome the manual incentive generation through out the country for AMEX and VISA Cards including sub products. A web-based application developed on ASP + ASP.NET as front end and SQL Server as backend.

 Union Bank Ready Cash Application Tracking System (RMS)
Helps us to control (TAT) of ready cash application processing. Use OOA&D (UML i.e. Use Cases, Class Diagrams.etc.), ASP.NET and SQL server technologies as front and back end.

 Union Bank Cross Sell Branch Bank Management System (BMS)
Cross Sell Branch banking system includes following features: BMS Batch, LST Upload, and Generation of Report, Setup of Customer, PB, CSE, Region, and Area, admin module etc.

 Union Bank Direct Marketing Information System DMIS

 Union Bank Telemarketing System TMS

 Union Bank Ready Cash / Ready Loan / Kissan Card Incentive System (SIS)

I joined this organization as a trainee and promoted to senior software engineer and looking after all the major projects i.e. Bridges TV, HMIS, Speciality Printers, Online Bazar and Vermeer FTI System.

Specialty Printers System SP

 A web based ERP Solution, which covers Finance, Production, Administration, Sales, Dispatch and Accounts Module.

Bridges TV - Online channel information system http://www.bridgestv.com

 It is an on line information website for the first American Muslim Channel. This site includes following sections.
1. Subscribers/ Customers section, Administration section, Comersus Shopping cart section


Hospital Management Information System

 An ERP solution for hospital which is developed on C#.Net, SQL Server, XML and Crystal Reports and 4 Tier applications.
 There are 11 modules including patient care, blood bank, inventory, security, laboratory, department, billing, human resource, accounts, administration and Operation Theater.
Online Bazaar

 Online Bazaar is an online shopping portal. Allows online shopping of different products. This site contains 3 modules are: online shopping, business listing, and customer area.

Vermeer FTI System

 A windows service designed in order to generates XML based data for client/ server environment. XML files are used by flash reports and generate the required report.