About Bertrand
TECHNICAL SKILLS
- SSIS (expert)
- Stambia
- Talend
- Dataform
- SQL Server
- GCP (BigQuery, GCS)
- Oracle
- DB2
- Power BI
- Cognos
- SSRS
- Dimensional modeling
- Data Warehouse
- DataMart
- FP&A, Stock, Order, Price, Customer Models
- Data platform structuring
- SQL (expert)
- Python (intermediate)
- Git
- TFS
- Jira
- Confluence
- JD Edwards
- Cegid Y2
- Cegid Orli
FUNCTIONAL SKILLS
- FP&A model interfaced with Anaplan
- Accounting entry integration
- Store sales and stock data
- POS / ERP / e-commerce synchronization
- Store performance KPIs
- Customer datamarts and KPIs: frequency, main activity
- Complex segmentation, Main Store, reference SA according to business rules
- Order flows, ASN, returns, stock levels
- Synchronization between ERP, warehouses, transport
- Logistics status tracking
- Product data, bill of materials management
- Catalog updates
- Collaboration with collection and purchasing teams
- 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
Experience
- Isabel MarantData EngineerLUXURY GOODSFebruary 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
- CelineData Engineer / Data ArchitectLUXURY GOODSJune 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
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- BTS Management Information SystemsAlternating Training Center of Issy-les-Moulineaux (92)2006