TRAINING PROJECT

Delivery tracking CRM design (LTP)

Design of an Apex backend prototype for LTP (luxury & fashion): data model, security, import strategy.

Context

Le Temps des Papillons (LTP), France's leading bridal couture house, needed a Salesforce CRM to manage 2 million accounts and integrate 3 carriers with distinct interfaces. Marie Dupont (delivery tracking) and Sébastien Nozerac (sales team) led the project client-side. Mission: design the complete architecture — UML data model, security matrix, import strategy and integration plan — before any development began.

Project Challenges

Massive data volume: 2,123,000 accounts, 3,239,870 contacts, 234,000 opportunities, 56,700 products
3 carriers with heterogeneous interfaces: REST (Livreur LTP France + Transport Luxe Europe), ETL (Rapid International Transport)
Data security: read-only OWD, sharing via profile-based sharing rules
Initial data import without loss or duplicates — parent-child dependency order critical

Architecture & Deliverables

Complete UML data model diagram (standard objects + 5 custom objects)
Security matrix: profiles, OWD, sharing rules — least-privilege access
Import strategy: Data Loader for FR/EU carriers, Talend ETL for Rapid International
Integration plan: REST webservices for French carriers, ETL connector for international
Automation: Salesforce Flow triggering customer notification on each delivery status change
Complete technical specifications (PDF) — delivered to jury and simulated client

Stack & Technologies

Salesforce — Objects, Profiles, OWD, Sharing Rules, Flows
Data Loader — Bulk CSV data import
Talend ETL — Rapid International Transport integration
REST Webservices — FR/EU carrier integration
UML — Data schema modeling
Postman — REST endpoint documentation and testing

Project Timeline

1
Business analysis
Requirements gathered from Marie and Sébastien, standard and custom Salesforce objects identified
2
Data model
UML diagram designed — 5 custom objects (Delivery, Carrier, Parcel…) with relations and fields
3
Security
Access matrix configured — read-only OWD, role-based sharing rules, Sales and Manager profiles
4
Import strategy
Import order defined respecting parent-child dependencies: Accounts → Contacts → Products → Opportunities
5
Integration plan

Results

2.1M

Accounts to manage

Production data volume

Carriers integrated

2 REST + 1 ETL

Custom objects designed

UML data model

4/4

Skills validated

OpenClassrooms jury

Capturas de pantalla