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

€600/day
Paris, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Gabriele

Financial services management consultant with10 years of experience in supporting complex, regulatory, and technological transformation projects.

Possessing strong analytical and interpersonal skills.

Extensive expertise in tooling formanaging complex transformation programsinnational and international contextswith exposure totop management 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 (not exhaustive):
  • Creation ofautomated dashboards on 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 workload and free up team time for more analytical work.
  • Creation offinancial models in Excel VBA and Power Queryfor company financial valuations and Research Tax Credit amount valuations.
*Managementof major transformation projects for significant players in the banking sector and projects related to the automation of foreign exchange risk management for a major French agro-industrial player.

*Definitionof committee structures, governance, responsibilities (RACI), budget management, schedule creation and management, team management, action plan creation, 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 2 months)
    Paris, France

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

    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 Organizational Consulting Risk Mapping KPI Definition Team Management
  • 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 Department & PROCUREMENT Department - 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 Business 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 Department 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 recommendations 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 Python Programming VBA Programming Organizational Transformation GDPR Compliance 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 in Paris 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 and responsible 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.

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 Applied Statistics
    Toulouse School of Economics (TSE)
    2024
    Économétrie, data mining, optimisation , Python, R, SAS

Skill set (33)

Categories