Rehanand P Busjeet

• Crafting and deploying streamlined, automated data models tools with these objectives:

-Compute Cost of Funds of banking facilities for Relationship Managers.
- Determine individual customer profitability.
- Compute Funds Transfer Pricing.
- Streamline Bank's budget preparation.
- Allocate bank's profits efficiently to business units.
- Calculate KPIs for Asset and Liability Management Committee (ALCO).
- Calculate KPIs for Executive Committee (EXCO)

• Setting up PowerBi Report Server for results dissemination.
• Assist in setting up Bank's Data warehouse.
• Liaison between bank and consultants for setting up various datamarts:
  - Budgeting
  - Customer Profitability
  - Funds Transfer Pricing
  - ALM

• Design and implementation of several optimized and automated data models and tools having the following objectives:

- Setting KPIS for Retail SBUs

- Monitoring of monthly/yearly KPIs for the Business Unit

- Calculation of performance bonus for retail actors

- Monitoring of in-Branch customer missed call

- Monitoring of staff shortage in Retail BUs which provides insights onto which branch should reliving staff be deployed

- Refinement of retail customer segmentation

• System to disseminate performance results to each retail actors and their supervisors
• Ad-hoc data reporting from IBM Cognos based on management requirements
• Automation of recurrent report
• Development of Regulatory Report and KPI-oriented report
• Collaboration with other Business Units

Modules Taught and examined:

• Analytical Databases for a BSc course for 30 second-year students
• Database Management Systems for a diploma course for 20 first-year student
• Introduction to Computer Programming for a diploma course fo 30 first-year students
• Introduction to Operating Systems for a diploma course for 8 final-year students

Implementation of Data warehouses for multiple international banks

• Designing and implementing of several financial models for several Asian, and African banks and MCB subsidiaries
• Design of predictive models
• Requirements gathering for DW Design
• Design of reports using Microsoft BI Stack (SSIS, SSRS, SSAS, PowerBi)
• Planning and monitoring of several projects
• Support and maintenance of DW for MCB overseas subsidiaries

• Implementation of several projects within the Finance cluster using several programming languages and methodologies.