Mohamed Ayman

Data Analyst

*th October, Egypt

Mohamed Ayman LinkedIn

Cell: +201********* Email: ad2llq@r.postjobfree.com BD: 25 July 1998 OBJECTIVE

Data Analyst with an Analytical Mindset and strong apt for learning, passion for using data to drive business decisions, having a demonstrated experience in Data Manipulation and Predictive Modeling, aiming to develop data products that can add a significant business value by applying different data analysis, and science techniques, and having a Proficient knowledge in Statistics, Mathematics, Regression, Classification, Clustering using R, Python, Microsoft Power BI, Microsoft SQL Server, Oracle SQL Developer, Tableau, Excel, Power pivot and Power Query. EDUCATION

1. Bachelor's Degree in Statistics, Faculty of Economics and Political Science, Cairo University, 2021.

2. Diploma in Data Science, Machinfy, 2022.

3. Business Intelligence Developer Program, Information Technology Institute (ITI), 2023. WORK EXPERIENCE

RETAIL RISK PORTFOLIO MANAGEMENT OFFIER - Credit Agricole Egypt Data Analyst – Retail Risk management / Jul. 2023 - Present

• Building and maintaining daily, monthly, and quarterly BAU reports and dashboards to be frequently presented to senior management.

• Providing analytical and reporting support in projects and Ad-hoc related to Retail Risk.

• Participate in monthly IFRS 9 and Cost of Risk reporting to Central Bank of Egypt and Crédit Agricole Group.

• Implementing daily caps analysis visualizations to track policy change impact according to the Risk Policy.

• Working with Retail Risk units such as Retail Risk Control, Retail Risk Policy, Retail Risk Modeling and Retail Risk Portfolio Management in joined project and Ad-hoc tasks.

• Performing an automation cycle for all reports and dashboards starting from extracting data from data warehouse to sending the reports to targeted stakeholders.

• Creating automation trackers to monitor daily and monthly automated reports. DATA ANALYST – Huawei Technologies Co.

Retail Data Analyst – Operation Department / Jan. 2022 - Jul. 2023

• Managing deliverables, including new products, coverage, merchandising objectives, voids/chronic out of stocks, and other project requests by Retail Country Manager.

• Conducted market research and competitive analysis to inform product development strategies.

• Developed and maintained automated reports and dashboards to monitor key performance indicators.

• Collaborated with cross-functional teams to develop data-driven solutions that improved business outcomes.

• Created customized data visualizations and reports to communicate insights to executive leadership.

• Responsible for Egypt Incentive Calculations Project for all Dealers IR, OR, IT, and Operators.

• Preparing and Presenting a Training Session “How to Find Business Issue Through Data” for Regional Managers, Area Managers, and Field Force Team in “Egypt FF Campus”. FREELANCER DATA ANALYST - Upwork

Upwork, Mostaql, Khamsat, and Fiverr / Oct. 2019 – Present

• Conducted data cleaning, transformation, and analysis to identify trends and patterns in large datasets.

• Developed dashboards and reports to visualize data and communicate insights to stakeholders.

• Collaborated with clients to develop data-driven solutions that improved business outcomes.

• Maintained and updated databases and data pipelines to ensure data accuracy and integrity.

• Providing Statistical Consultant for Postgraduate Students.

• Helping Corporate Analyze Quarterly and Yearly Performance Surveys.

• Worked with more than 80 clients on 120 projects from all over the world. CERTIFICATIONS

• Business Intelligence Developer - Information Technology Institute (ITI) Mar. 2023 (369 hrs. at 30 hrs./week).

• Credit Scoring Analysis with Python - 365 Data Science Aug. 2022 (2 weeks at 3 hrs./week).

• LinkedIn Learning Data Analyst Career Path - LinkedIn Learning May 2021 (28 hrs. at 10 hrs./week).

• Data Analyst Nanodegree - Udacity June 2019 (4 months at 10 hrs./week).

• IBM Data Analyst Professional Certificate - Coursera Oct. 2019 (11 months at 3 hrs./week). TECHNICAL SKILLS

• Data Manipulation and Predictive Modeling.

• Statistical Analysis and Mathematics.

• Regression, Classification, Clustering.

• R, Python, Microsoft Power BI, Microsoft SQL Server, Oracle SQL Developer, Tableau, Excel, Power Pivot, Power Query.

BANKING SKILLS:

• Retail Risk Portfolio Management (Cash Loans, Auto Loans, and Credit Cards).

• Retail Risk Analytics.

• Retail Risk Policy.

• Portfolio Performance Analysis.

• Cost of Risk Reporting.

• IFRS 9 Reporting.

• Credit Scoring Analysis.

Contact this candidate