*

Per

Claudia BISHAY

Business Intelligence (BI) Analyst

Professional Experience

Skilled data analyst with +10 years of industry experience in collecting, analyzing, and interpreting large data sets. Possess good management and supervisory skills. Proficient to drive business results using data-based insights and to provide Executive Management with reports on specific data findings impacting on organizational growth and success.

Manager at Data Analytics & Business Intelligence Unit - Qatar National Bank - QNB AA – Cairo, Egypt Data Analytics & Business Planning Department - Commercial & Marketing Division

Mar.19 till Aug.23

Manage the process of large data sets collection and Extraction.

Work with business partners through the analysis of quantitative and qualitative data using data querying

Provide various monthly analytics visualization reports and Performance indicators dashboards on Power BI

Develop on SAS Viya custom predictive models and algorithms to apply to data sets.

Develop & support the implementation of Data-based insights that support in Management Decision Making and ensure a positive return on ROI, profitability growth and operational effectiveness

Glendora, Ca 91741

626-***-****

ad3xrl@r.postjobfree.com

In https://www.linkedin.com/in/claudia-ghattas/

Birth Date, 15 July 1985

Dashboarding Business insights Large Data sets Analytic models - SAS Viya ETL

Relevant Technical Skills

Languages

• English

• French

• Arabic

Technical Skills

• Data Analysis

• Data Visualization

• Excel

• Presentation Skills

• Power BI

• SQL

• Dashboarding

• Large Data Sets

Professional Skills

• Financial Analysis

• Budgeting

• Commercial Reporting

• Segmentation Analysis

• Business Analysis

• KPIs

• Expenses Analysis

• Profitability Analysis

• Customer Profiling

• Sales Analysis

Education

Bachelor of Economics & Political Science, French Department, Cairo University

May 2006 Major: Economics - Cumulative Grade: Good Selected Training & Courses

Healthcare Analytics Essentials

Northeastern University Jan.24

https://coursera.org/share/6290efbc3ad3f9f41e8997a4f0510623 Business Analytics - From Data to Decisions

Imperial College London Jan.21

Imperial College - CB.pdf

Data Challenger Track

Udacity Nanodegree Jul.21

Data Challenger - Udacity Nano degree.pdf

Marketing Analytics Foundation

Meta - Coursera Mar. 2023

Marketing Analytics - Meta.pdf

Getting Started with SAS

Visual Analytics Coursera - Jan.20

Getting Started with SAS Visual Analytics.pdf

How Digital Banking and FinTech is

Changing Banking Jun. 2021

..\Certificate\Certificate.pdf

Measure and Optimize Social Media

Marketing Campaigns- Jan.20

Measure and Optimize Social Media Marketing.pdf

Power BI SQL Business Intelligence

2

Manager at Performance Analysis & Control Unit - Qatar National Bank - QNB AA – Cairo, Egypt Business Planning - Performance & Budgeting Department - Commercial & Marketing Division

Nov.17 - Mar.19

Plan the annual Profitability & Commercial Budget in collaboration with concerned commercial business lines

Prepare several reports to follow-up branches KPIs, Commercial & Profitability budget achievement

Responsible for developing a clear definition for the bank customer segments tiers for all line of business.

Responsible for all customer segment group research on all levels and to Provide analytical studies to marketing teams to assist in the promotion of bank products & services

Analyze historical commercial segmentation data, trends and the products behavior and seasonality Financial Reporting Team Leader - Qatar National Bank - QNB AA – Cairo, Egypt Business Planning - Performance & Budgeting Department - Commercial & Marketing Division

Jan.15 - Nov.17

Develop various financial profitability reports at different levels of the Bank (e.g. Branches, Customers and Products)

Develop expenses report to analyze each “branch direct expenses” including operating expenses, staff expenses, real estate costs, stamp duty, depreciation, expenses YOY growth and budget utilization.

Develop profitability reports covering all bank “Assets & Liabilities” products, Net banking income, Net Interest spread, Fees & Commission, Payroll deals, etc.…

Senior Commercial & Budgeting Executive - Qatar National Bank - QNB AA – Cairo, Egypt Retail Animation & Marketing Department

Jul.12 - Jan.15

Release regular Commercial reports regarding branches Retail Commercial Budgeting and achievement.

Prepare Retail Activity Report and indicators that analyze the branches figures such as Sales per product, penetration ratios, commercial effectiveness and budget achievement and Customers segmentation analysis. Financial Analysis and Reporting Officer - National Société Générale Bank - NSGB Retail Animation & Marketing Department

Jun.07 - Jul.12

Prepare Retail banking reports to management and branches.

Analyze the branches performance reports to deduce indicative figures and comparative Studies such as sales per product, penetration ratios, commercial effectiveness, and ranking. Retail Commercial Reporting Retail Budgeting

Budgeting Profitability & Commercial reporting Customers Segmentation Analysis Fees & Commission Budgeting Expenses Reporting & Analysis Profitability Analysis KPIs

Segmentation Analysis

Selected Analytics Projects

Irregularities Forecasting Analysis

Successfully Implemented Time-series analysis to forecast the default risk of bank customers; possibility of not being able to repay credit facilities principal or interest. Analysis is based on variable factors related to customers profiling data and historical payments.

Customers Profiling Project

Using each Customer Profile Data, historical behavior, Interactions, and Products Preferences to develop personalized customer segment analysis. The Analysis had positive impact on improving customer experience by offering better personalized value proposition and targeted marketing to each Customer Churn Analysis

Dedicated Analysis for most valuable customers to identify patterns and reasons for their recent inactivity. Resulted Findings had been successfully used to customize proactive retention offers for these customers and as insights to reduce attrition and improve customer retention in the future.

Contact this candidate