You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Anis K.AK

Anis K.

Expert Excel / VBA

€400/day
1 project
Paris, FR
0-2 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Anis

Passionate freelance data professional offering data exploitation support. I specialize in data analysis tasks:

- Dashboard creation and automation,
- Data analysis (Descriptive, Univariate, and Multivariate Statistics)
- Data Mining (Problem definition, data collection, analysis model construction, results study...)


As an Excel expert, I can also assist you with most of your Microsoft Excel-related issues, including (but not limited to):
- Macros & VBA,
- Formulas & functions (simple to complex),
- Data extraction and reprocessing (automation of business rules, duplicate removal...etc.)
- Dashboard implementation,
- Chart creation,
- Excel training for beginners,
- And generally, the automation of any manual task in Excel.

My experience as a Data Analyst at Crédit Mutuel's credit risk department, along with my degrees in static engineering, make me a well-rounded analyst.

I possess an excellent understanding of the challenges businesses face and advanced mastery of Data.

Feel free to contact me for more information.






  • French

    Native or bilingual

  • English

    Fluent

Can work on-site
Paris (up to 50km)

Experience

  • L'Oréal SA - L'Oréal France
    Data Analyst
    FASHION AND COSMETICS
    October 2022 - Today (3 years and 10 months)
    Paris, France
    I hold the position of Data Analyst within the Sustainable Raw Materials Sourcing department. I am responsible for:
    - Updating dashboards and sustainable sourcing reports;
    - Updating procedures related to the Dashboard;
    - Assisting in the development of a new raw materials monitoring tool;
    - Creating KPI production reports;
    - Updating RACI matrices and preparing external audits.
    Microsoft Excel Power BI Power Query Microsoft Word Microsoft Powerpoint
  • Crédit Mutuel
    Data Quality Project Manager
    BANKING AND INSURANCE
    October 2020 - October 2021 (1 year)
    Paris, France
    I held the position of Data Quality Project Manager as part of compliance with BCBS 239 regulation and the implementation of the Data Quality and Risk Reporting department for Crédit Mutuel's risk management.

    Specifically, I worked on the following tasks:

    - Automation and creation of data quality dashboards;
    - Implementation of data quality steering documents (Internal Procedure);
    - Participation in the creation of new databases required by regulators (ECB and CRU);

    - Organization and participation in data quality steering committees with various department directors (Risk, Finance, IT, ...) and regional groups.
    VBA Microsoft Excel Microsoft Powerpoint Banking Regulation Project Management Data Analysis
  • Gulf Bank
    Intern Credit Risk Analyst
    BANKING AND INSURANCE
    February 2019 - July 2019 (6 months)
    Alger, Algeria
    During my internship at the bank, I was involved in:
    - Implementing stress tests / simulations of (profitability/risks);
    - Evaluating the belonging class and the probability of default/migration of companies using an internal rating system developed by Moody's;
    - Calculating financial ratios and modeling the company's financial situation;
    - Analyzing the company's positioning and conducting sector studies;
    - Evaluating and financially analyzing companies' borrowing capacity.

    Furthermore, I worked on a project involving the assessment of the bank's exposures and the unexpected loss of the bank's loan portfolios according to prudential rules, using the Value at Risk (VaR) approach.

    This experience taught me to be rigorous, meticulous, and above all, to develop my analytical skills.
    Microsoft Excel Statistics Data Mining Data Analysis Data Analysis Probability Banking Regulation

Reviews

5.0

Out of 1 rating

K

Kalkavan

Arzu KALKAVAN

Reviewed on 3/6/2023

Recommendations

Be the first to recommend Anis

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • STATISTICAL AND ECONOMIC ENGINEERING OF FINANCE, INSURANCE, AND RISK (ISEFAR) - RISK MANAGEMENT
    Université de Paris Nanterre
    2021
    Ce master est axé sur l’acquisition de connaissances en économie du risque et de l’incertain et en risk management Il permet d’acquérir des compétences dans trois grands domaines : - Modélisation mathématique et méthodes d’estimation statistique ; - Analyse économique des risques; - Maîtrise de logiciels de traitement des données (VBA, R, Python …).
  • Master in Money, Banking, Finance, Insurance - Specialization: Risk, Insurance, Decision
    Université de Paris Descartes
    2020
    Cette formation m’a permis de consolider les connaissances acquises par le passé mais pas seulement, grâce à cette formation j’ai pu : - Apprendre à faire des modélisations économétriques sur R; - Revoir les mathématique financière et actuarielle sous python; - Apprendre les Data science à l’aide de (Python / R / Excel); - Créer des Macros à l’aide de VBA; - M’initier au langage SQL.

Certifications

  • Become a Power BI Expert
    Udemy
    2021
    Power BI Dashboards Power Query
  • Learn Macros and VBA with Excel
    Udemy
    2020
    VBA Microsoft Excel

Skill set

Categories