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

Bertrand Gazon

Consultant Data Integration & Solution Designer

€650/day
Nemours, FR
15+ years

Average response time: 24 hours

Freelancer profile translated to English.
Back to original language

About Bertrand

Expert data (+15 years), specialized in architecture, modeling, and solution integration. My hybrid profile allows me to translate business requirements (Finance, Retail, CRM, Supply) into robust and high-performance technical solutions (ETL, GCP / Azure Cloud, inter-application flows). I ensure end-to-end project management, from model design to the production of complex flows.

TECHNICAL SKILLS

Data Integration & Pipelines
  • SSIS (expert)
  • Stambia
  • Talend
  • Dataform
Databases & Cloud
  • SQL Server
  • GCP (BigQuery, GCS)
  • Oracle
  • DB2
Reporting / Data Visualization
  • Power BI
  • Cognos
  • SSRS
Data Modeling & Architecture

  • Dimensional modeling
  • Data Warehouse
  • DataMart
  • FP&A, Stock, Order, Price, Customer Models
  • Data platform structuring
Languages & Scripting
  • SQL (expert)
  • Python (intermediate)
Versioning & Collaboration
  • Git
  • TFS
  • Jira
  • Confluence
ERP / POS / DMS
  • JD Edwards
  • Cegid Y2
  • Cegid Orli

FUNCTIONAL SKILLS

Finance
  • FP&A model interfaced with Anaplan
  • Accounting entry integration
Retail
  • Store sales and stock data
  • POS / ERP / e-commerce synchronization
  • Store performance KPIs
CRM / Customer
  • Customer datamarts and KPIs: frequency, main activity
  • Complex segmentation, Main Store, reference SA according to business rules
Supply Chain / Logistics
  • Order flows, ASN, returns, stock levels
  • Synchronization between ERP, warehouses, transport
  • Logistics status tracking
Product Development
  • Product data, bill of materials management
  • Catalog updates
  • Collaboration with collection and purchasing teams
Interoperability & Governance
  • Structuring of enterprise models: Customer, Stock, Order, Pricing, FP&A
  • Documentation, normalization of inter-application exchanges
  • Data quality management (CBDT, China compliance)
  • French

    Native or bilingual

  • English

    Conversational

Can work on-site
Nemours (up to 50km), Nemours (up to 100km)

Experience

  • Isabel Marant
    Data Engineer
    LUXURY GOODS
    February 2017 - Today (9 years and 4 months)
    Paris, France
    • Development of SSIS flows and SQL procedures for populating a CRM datamart
    • Implementation of customer KPIs from raw data: purchase volume, frequency, main activity, etc.
    • Creation of enriched indicators from complex calculation rules: main store, reference Sales Associate (SA), personalized customer segmentation
    SQL SSIS
  • Celine
    Data Engineer / Data Architect
    LUXURY GOODS
    June 2016 - September 2025 (9 years and 3 months)
    Paris, France

    Data Engineer

    • Design, development, monitoring, and optimization of over 300 SSIS flows, covering a wide range of inter-application areas (ERP, POS, CRM, e-commerce, warehouses, etc.)
    • Development of an SSIS interface for populating the Image Bank
    • Creation of CRM-oriented KPIs (customer segmentation, main store typology, activity indicators) in collaboration with CRM business teams
    • SSIS platform capable of supporting intensive loads, with flow triggers every 8 seconds on certain days
    • Bidirectional communication with third-party systems: Salesforce, Anaplan, Mojix, Joor
    • Design and maintenance of critical flows between the ERP and the central warehouse (orders, statuses, stock updates)
    • Contribution to a robust data architecture, supporting the constant availability of critical data (orders, stock, customer)
    • Enrichment of CRM data contributing to better customer targeting and improved marketing actions

    Data Architect

    • Structuring the data platform around enterprise models: Customer, Order, Pricing, Stock, FP&A
    • Definition of modeling, naming, and documentation standards
    • Modeling of a multi-company FP&A system, interfaced with Anaplan, facilitating exchanges with management control
    • Participation in the BI migration to BigQuery, with partial redesign of data models, adaptation of flows, and guarantee of data quality during go-live
    • Close collaboration with business departments (Finance, CRM, HR, Dev & Sourcing) to formalize functional needs, design models, and ensure their alignment with usage
    • Writing functional and technical specifications for the migration from JD Edwards to SAP
    • Normalization of enterprise models promoting cross-functional data reading between businesses
    SSIS Data Integration Transact-SQL BigQuery Solution Design

Recommendations

FU
Antoine RichardAR
FU
+3
Former user and 5 other people have recommended Bertrand

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

  • BTS Management Information Systems
    Alternating Training Center of Issy-les-Moulineaux (92)
    2006

Skill set

Categories