Data Analysis Business Intelligence
Resume:
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
**************@*******.***
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