You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Gabriele De StefanoGD

Gabriele De Stefano

Data Analyst - Expert Excel, Power Query, VBA

€500/day
Paris, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Gabriele

Manager Consultant in financial services with10 years of experience in supporting complex, regulatory, and technological transformation projects.

Possessing strong analytical skills combined with excellent interpersonal abilities.

Extensive expertise in tooling formanaging complex transformation programsinnational and international contexts**, with exposure to stakeholders at the **Executive Management level of industrial companiesandkey players in the banking sector.

*Trilingual:Spanish, English, French
  • Trainer** in Excel, Power Query, Power Pivot, and VBA for 5 years.
*Expertise:Operational Risks, Market Risks, Corporate Finance, project management, program management, team management, business restructuring, data modeling, data crunching, GDPR...

Portfolio of achievements (non-exhaustive):
  • Creation ofautomated dashboards in Excel VBAfor monitoring the activity of project teams or operational teams (banking, agro-industrial, public sectors).
  • Automation of tasks using VBA and Power Query to reduce work strain and free up team time for more analytical work.
  • Creation offinancial models in Excel VBA and Power Queryfor financial company valuations and Research Tax Credit amount valuations.
*Managementof large transformation projects for major banking sector players and projects related to the automation of foreign exchange risk management for commodities for a major French agro-industrial player.

*Definitionof committee structures, governance definition, responsibilities definition (RACI), budget management, creation and management of schedules, team management, creation of action plans, team training.
  • French

    Native or bilingual

  • English

    Fluent

  • Spanish

    Native or bilingual

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

Experience

  • Inetum Consulting
    Manager Financial Services Advisory
    CONSULTING AND AUDITS
    April 2024 - Today (2 years and 4 months)
    Paris, France

    BNP Paribas - Global Data Office and Risk & Finance Data Office

    With the aim of strengthening the overall Groups’ Data Management Framework, following an European Central Bank On Site Inspection regarding Group alignement with BCBS239 & RDARR principles on Risk Data Aggregation and Risk Reporting:
    - Led an experienced consulting team in Risk & Finance Data Office environment for both a 360 procedural framework review (creation of Group level normative framework including BCBS239 Adherence Policy, Defaulting Rules & algo sourcing governance policy, Scope & application of use cases (reports, metrics, models) policy…) and a 360 maturity analysis of all the Risk & Finance “Filières” ( data maturity assessment, analysis and restitutions)
    - Definition of the methodology for Group level critical data definition and labeling criteria and processes
    - Operational Implementation of the normative framework

    Société Générale - Global Data Office Direction

    Following a SREP (supervisory review and evaluation process) by the European Central Bank. Definition of the mandate of an operational risk transversal first line of defense (1LOD), expert on data :

    • Identification and definition of roles and responsibilities,
    • Definition of the scope of action (group macro activities, activities, risks covered, entities prioritization and ramp-up plan)
    • definition of the interaction model with stakeholders (Group CDO, Pillar CDOs, Business Units CDOs, 2LOD, risks coordinators)

    Loxam/GL Events Joint Venture - Paris 2024 Olympic Games (JOP 2024)

    Definition and implementation of an automated follow up tool (Excel, Power Query, Power Pivot, VBA) to ensure the procurement of temporary energy needs for the 53 competition centers.

    Inetum Group - Chief Financial Office (CFO)

    Definition and implementation of an automated cash management process (weekly process, Excel, Power Query, Power Pivot, VBA) for the 4 Group Business Lines (organisation and tool).
    Power BI Desktop data crunching VBA Programming KPI Definition Target Operating Model
  • Inetum Consulting
    Senior Consultant Financial Services, Inetum Consulting
    CONSULTING AND AUDITS
    September 2022 - April 2024 (1 year and 7 months)
    Paris, France

    Credit Agricole SA - RISK Direction & PROCUREMENT Direction - Worldwide

    • Redesign of the Strategy, the Politics and the Risk Management framework (including risks taxonomy and control plans) on outsourcing activities to include the European Banking Authority Guidelines on outsourcing (2019) as well as Digital Operational Resilience Act (DORA) expectations and clarify the roles and responsibilities of the first and second lines of defense.
    • Redesign of several processes including: LOD2 Risk Notices, LOD1 Metier Risk Analysis, FAQ on outsourcing, notifications, design of key performance indicators and key risk indicators
    • European Central Bank outsourcing Register: Design of an automatic system on Power Query, Power Pivot and VBA to help Procurement Direction perform automatic data analysis and remediation campaigns.

    BNP Paribas - RISK Function Operational Risk - Worldwide

    • Following European Central Bank recommendations related to the improvement of tax risk follow-up on a worldwide perimeter.
    • Following an Executive Committee decision regarding the second level of defence reorganization.
    • Deliverables: Strategic definition of a POC perimeter, tax risks and processes as-is analysis, production of heatmaps and recomendations regarding first level and second level of defence organization, built the foundations for a target operating deployment model.

    BNP Paribas - Data Privacy & Protection (GDPR) - Transversal Functions

    • Review of all the Personal Data Processing Activities of the Organization
    • Personal Data Processing Activity Target Operating & Organizational model definition including Compliance & Legal functions responsibilities
    • Creation of a Data Privacy & Protection website for institutional communication
    Microsoft Power BI Microsoft Power Query VBA Programming Organization Transformation Operational Risk
  • Harwell Management
    Senior Consultant - Project Manager CIB
    CONSULTING AND AUDITS
    October 2021 - October 2022 (1 year)
    Paris, France

    BNP Paribas - Project Manager - Corporate and Institutional Banking

    • Operational Risk Unified System deployment
    • Scope: global, 44 countries, 8000 users
    • Project Management
    • Process monitoring under Aris Risk and Compliance Manager
    *Project KPI's automation under VBA and Power Query
    • Actively contributed to the optimization of the ORUS teams (BP2S, Global Banking, Solution Coordination, Maintenance) activity both inParis and India by understanding the client's needs and proposing value added solutions, process and training.
    • Created several systems under Power Query to help the ORUS Team and BP2S to ensure the data collection extraction and correction.
    • In charge of the communication with ORCORP teams andresponsible for the data quality sent to the ORCORP systems ( 30 000 operational risk related controls).
    *Created systems in order to generate the control assessment process.

    *Coordinated the data enrichment and data entry of more than 10000 operational risk controls with teams in EMEA, AMERICAS and APAC

    HARWELL Management - Knowledge Management Program:

    • As a member of the Control and Compliance practice, I actively contributed with the creation of pitches and articles related to data and operational risk.
    Microsoft Power Query Microsoft Power BI Operational Risk 1LOD VBA

Recommendations

FB
Flora DelmasFD
Florian Blot and 1 other person have recommended Gabriele

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

  • Master in Corporate Finance - Programme Grande Ecole, Finance
    Toulouse Business School
    2016
    Master in Corporate Finance - Programme Grande Ecole, Finance
  • DU Statistiques appliquées
    Toulouse School of Economics (TSE)
    2024
    Économétrie, data mining, optimisation , Python, R, SAS

Skill set

Categories