# Adrien Valentin — Salesforce Application Architect
> Portfolio: https://adrienvalentin.com
> Location: Paris, France
> Current: Qonto (European B2B fintech, ~1,500 employees, 10+ markets)
> Education: Master's degree in Computer Engineering (Efrei Paris, 2015), taught in English
> Experience: 11+ years software engineering, 8+ years Salesforce
> Certifications: 7× Salesforce Certified — Application Architect (combined), Platform Developer I, Platform App Builder, Platform Data Architect, Platform Sharing and Visibility Architect, Platform Identity and Access Management Architect, Platform Integration Architect. Pursuing the combined System Architect credential (remaining: Development Lifecycle & Deployment).

## Summary
Systems that business teams run, frameworks that developers follow. At Qonto (B2B fintech, ~1,500 employees, 10+ European markets), I designed and shipped a complete ecosystem of 9 Salesforce tools to production. From data model to deployment — end-to-end. Every system presented here was conceived, designed, built, and deployed by me.

## What I Solve
- **High-Volume Processing**: 129,552 leads auto-assigned in 6 months (711/day). Rules engine + capacity planning. (LAM Editor, TMM)
- **Beyond Salesforce Standard**: Data models breaking SF constraints. 1 Lead → N companies. (LCI, Enhanced History)
- **Zero-Downtime Async**: 1,440 executions/day, 0 crashes since June 2025. Error isolation, automatic retry. (AsyncCollector, CIOConnect)
- **Multi-Country Operations**: 16 SDRs, 4 countries, 1,400 accounts/month. Deficit-based distribution. (FTE, TMM)

## Business Impact at a Glance
- LCI: 587 opportunities recovered, invisible in standard Salesforce
- LAM: Zero manual intervention since go-live — PMs fully autonomous
- TMM: 66 automatic reassignments/day — no manager action needed
- AsyncCollector: Replaced 5 independent jobs — 0 crashes since June 2025
- CIOConnect: Admins add sync fields in 5 min — zero code deployments
- FTE: Replaced 4h of weekly manual Google Sheets work
- CPQ: 1,167 references migrated — zero data loss
- AD: ~5 min saved per merge — 1,981 merge requests processed
- EH: Full audit trail — traces every UI, API, Flow, Batch change

This portfolio (adrienvalentin.com) is a fully interactive, bilingual (FR/EN) website featuring 8 playable interactive demos, 9 hand-crafted animated SVG walkthroughs with scrubber controls, and 3 side projects.

---

## 9 Production Systems — Technical Details

### 1. LCI — Lead Company Info (Multi-Company Lead Model)
- Breaks Salesforce's standard 1-Lead-1-Company constraint
- A Lead becomes a Person linked to N independent Company Infos
- 2-level matching: person (email/phone dedup) then company (SIRET + fuzzy matching via FindDuplicates API)
- 4 auto-conversion paths, multi-company conversion wizard
- 6 interconnected trigger handlers
- Impact: 3,188 LCIs created, 587 opportunities generated — business that did not exist under the standard model
- 18% of touchpoints involve a different company than the Lead's primary company
- In production since February 2026
- **Portfolio**: Interactive demo (playable LCI system with touchpoint creation and matching) + Animated SVG walkthrough (6 steps: ① Touchpoint → Lead + LCI, ② Match + Split, ③ Manual conversion, ④ Auto-conversion, ⑤ Hourly batch, ⑥ Big Picture)

### 2. LAM Editor — Lead Assignment Management Rules Engine
- Complete rules engine with interval algebra, gap analysis, cross-rule validation
- Hierarchical data model: Rule → Audience → Criteria (self-referential recursion)
- Polymorphic type system: Number, String, Date, Boolean, Reference fields
- Gap Analysis via set inversion — detects populations not covered by any rule
- Dynamic SOQL generation via recursive SoqlNode tree
- ~8,000 lines of structured Apex (CTRL→SVE→UTL layers)
- LWC with custom LightningDatatable extension
- Impact: 129,552 leads processed in 6 months (711/day), 0 change requests since go-live
- Product Managers fully autonomous on rule configuration
- **Portfolio**: Interactive demo (fully playable rule editor with criteria configuration, interval visualization, gap analysis) + Animated SVG walkthrough (7 steps: ① Rule creation, ② Audience hierarchy, ③ Criteria with intervals, ④ Incoming lead, ⑤ Evaluation engine, ⑥ Assignment, ⑦ Big Picture)

### 3. TMM — Team Members Management (Capacity Planning)
- Manages ~130 sales reps across 124 assignment groups
- Three-level model: Group → Member → Distribution (per object)
- Deficit-based assignment algorithm: assigns to member furthest below target percentage
- Dual inactivity circuit: manual vs automatic, fully independent
- Virtual accounting for inactive members, automatic reactivation
- Automatic Outlook/Salesforce Calendar sync for absences
- Impact: 12,181 automatic reassignments in 6 months (66/day)
- **Portfolio**: Interactive demo (member/group management with quota visualization) + Animated SVG walkthrough (4 steps: ① Members with dual Lead/Opp quotas, ② Group creation with % distribution, ③ Records tracking, ④ Big Picture)

### 4. Enhanced History — Advanced Field History Tracking
- Dual perspective: View by Field + View by Transaction (Update)
- Update Source tracking: UI, API, Flow, Batch — full audit trail
- Sibling comparison analytics: compares values against peers with distribution charts
- Anomaly detection: identifies rapid changes (e.g., 2 reassignments in 2 minutes)
- Impact: 96 fields tracked across 4 Salesforce objects (Lead 31, Account 50, Contact 2, Opportunity 13)
- **Portfolio**: Interactive demo (dual-view history interface with field grouping and timeline) + Animated SVG walkthrough (8 steps: ① Lead created, ② Updates tracked, ③ Qualification, ④ Conversion, ⑤ Status view, ⑥ Owner view, ⑦ Sibling comparison, ⑧ Big Picture)

### 5. CIOConnect — Salesforce to Customer.io Sync via Segment
- Metadata-driven sync: 100% declarative configuration via CIO_connect__mdt
- Supports direct fields, lookups, relationships with filters (recursive boolean expression parser) and sorting
- Trigger-based flagging (SyncCIO__c DateTime field) → Scheduled batch collection → Dynamic SOQL → JSON payload → HTTP to Segment
- Dual sync: batch every 15 minutes + real-time for critical events
- Admins add new sync fields in under 5 minutes without any code changes
- Impact: 60,000+ synchronizations since July 2024, 0 crashes
- **Portfolio**: Animated SVG walkthrough (8 steps: ① Metadata config, ② Lead flagging, ③ Batch collection, ④ Relationship traversal, ⑤ JSON payload, ⑥ HTTP callout, ⑦ Customer.io delivery, ⑧ Big Picture). No interactive demo — backend sync engine.

### 6. AsyncCollector — Centralized Async Job Orchestrator
- Replaces N independent Scheduled Apex jobs with a single entry point
- Metadata-driven via Features__mdt (asyncClassToBeCollected__c, asyncInterval__c, Enabled__c)
- Dynamic instantiation via Type.forName().newInstance()
- Configurable delays, duplicate prevention, error isolation per job
- Auto-retry on UNABLE_TO_LOCK_ROW (up to 10 attempts)
- Orchestrates 5 critical jobs: Lead Assignment, Case Routing, Partner Sync, Opportunity Processing, Partnerstack
- Impact: 1,440 executions/day, 0 crashes since June 2025
- **Portfolio**: Interactive demo (orchestration pipeline visualization with job scheduling and retry) + Animated SVG walkthrough (7 steps: ① Collectable pattern, ② Metadata config, ③ Scheduler, ④ Delay filtering, ⑤ shouldRun(), ⑥ Auto-retry, ⑦ Big Picture)

### 7. CPQ Import Suite — Product Catalog Migration
- Product catalog migration tool for Salesforce CPQ, built for a post-acquisition catalog migration at a European technical furniture manufacturer
- Imports from a legacy CSV (originally Odoo ERP): 61 bundles, 350 features, 1,167 products
- Automatic intra-file conflict resolution (vote-by-occurrence) + range-based discount management via Custom Metadata
- Per-record rollback capability, Bulk API 2.0
- Impact: in production since March 2026, 1,167 references migrated, zero data loss
- **Portfolio**: Interactive demo (CSV import pipeline with validation and conflict detection) + Animated SVG walkthrough (8 steps: ① Odoo extraction, ② Legacy import, ③ Validation, ④ CSV export, ⑤ SF import, ⑥ Suppression, ⑦ Bundle import, ⑧ Big Picture)

### 8. Account Duplicates — Detection & Merge
- Automated duplicate detection: FindDuplicates API + SIRET normalization + company name fuzzy matching
- Scan pipeline → DuplicateRecordItem creation → Group assessment → Merge eligibility
- Impact: 1,981 merge requests processed, 14/day average, ~5 min saved per merge
- **Portfolio**: Interactive demo (duplicate detection simulation and merge workflow) + Animated SVG walkthrough (7 steps: ① Empty merge tool, ② Compute pipeline, ③ Records loading, ④ Group assessment, ⑤ Checkbox selection, ⑥ Merge with strikethrough, ⑦ Big Picture)

### 9. FTE Account Assignments — Territory Management
- FTE-based monthly account assignment with monthly versioning
- Deficit-based algorithm with priority sorting, automatic redistribution
- Per-SDR configuration: Target (objective) and Current (pipeline) rows across 6 tiers (T1-T3 Queued + T1-T3 Recycling)
- External key pattern: {FTE_ID}_{YEAR}_{MONTH}_{COUNTRY} for rollback
- Impact: 1,400 accounts/month distributed automatically across 16 SDRs and 4 countries (~300 accounts assigned every Monday)
- Replaces 4h of manual weekly work on Google Sheets
- **Portfolio**: Interactive demo (SDR parameter config and batch simulation) + Animated SVG walkthrough (4 steps: ① Existing SDR table with Target/Current dual rows, ② New SDR addition + save, ③ Weekly batch with deficit calculation, ④ Big Picture)

---

## Ecosystem — How the 9 Tools Connect

### Lead Lifecycle (Acquisition → Conversion)
LCI creates multi-company leads → LAM Editor assigns via rules engine → TMM manages team capacity → LCI handles conversion with per-company wizard

### Assignment & Capacity Planning
TMM detects absences via Outlook/SF Calendar sync → triggers redistribution → AsyncCollector orchestrates the reassignment batch

### Data Quality Pipeline
Account Duplicates detects and merges → Enhanced History tracks all changes with audit trail → CIOConnect syncs clean data to Customer.io

### CPQ Migration
CPQ Import Suite handles bulk CSV import from Odoo with validation, conflict detection, and per-record rollback

---

## Key Aggregate Metrics
- 129,552 leads processed via LAM (711/day)
- 12,181 automatic reassignments via TMM (66/day)
- 1,440 AsyncCollector executions per day
- 60,000+ CIOConnect synchronizations
- 3,188 Lead Company Infos, 587 opportunities generated
- 1,981 merge requests (Account Duplicates)
- 1,400 accounts/month assigned (FTE)
- 1,167 references migrated (CPQ Import Suite)
- 96 fields tracked across 4 objects (Enhanced History)
- 0 crashes across all production systems

## Architecture Decisions
1. **Multi-Company Lead Model** (Qonto): LCI decouples 1 Lead into 1 Person + N Company Infos, breaking Salesforce's native 1-Lead-1-Company constraint without data loss.
2. **Granular Automation Bypass** (AG2R La Mondiale): reusable bypass framework with per-validation-rule, per-trigger, per-method granularity. Adopted as the standard across the Sales Cloud platform.
3. **PRM Data Model Migration** (Qonto): custom partner objects (PartnerOrg__c, PartnerDeal__c, PartnerContact__c) migrated to standard Salesforce PRM via a mandatory dual-write cohabitation phase.
4. **Async Orchestration Without Conflicts** (Qonto): AsyncCollector's single-entry-point pattern with Type.forName(), configurable delays, error isolation, auto-retry.
5. **CSV Delivery Plan Import Pipeline** (Martin Brower, 2018-2021): two-phase custom pipeline for ~1,500 restaurants, 3 years in production, 0 data loss.

## Working Style & Leadership
- Method starts with understanding: mapping dependencies, identifying ownership, working out how features and integrations interact, then deciding. Since 2024, uses AI as an implementation accelerator, under direct ownership — architecture decisions and trade-offs remain mine.
- At AG2R La Mondiale (national insurer, 15,000 employees): one of three members of the Design Authority, arbitrating cross-cutting architecture decisions in weekly sessions, validated before any production deployment. Managed teams of 3 to 5 developers (internal + external), PR reviews via Copado.
- At Qonto: the partner model migration to standard PRM required a dual-write phase to prove parity figure by figure before any cutover. Traceability, governance, reversibility are treated as inputs to the problem, not obstacles.

## Technical Expertise
- Apex: Design patterns (Strategy, Factory, Observer), governor limits optimization, async patterns (Batch, Queueable, Platform Events), metadata-driven architecture, dynamic SOQL generation
- LWC: Custom LightningDatatable extensions, complex state management, event-driven architecture, custom cell types
- Architecture: Rules engine design, set theory applied to business logic, recursive data structures, interval algebra, polymorphic field handling
- Data Modeling: Self-referential hierarchies, polymorphic relationships, versioning patterns, sharing model optimization
- Integration: REST API, Bulk API 2.0, Segment/Customer.io, metadata-driven sync patterns
- DevOps: SFDX, CI/CD, Copado, scratch orgs

## Career Timeline

### 2023–present: Qonto (European B2B fintech, ~1,500 employees, 10+ markets)
Salesforce Application Architect. Designed the internal tooling ecosystem from scratch: multi-company Lead model (LCI), metadata-driven async orchestrator (AsyncCollector), custom-to-standard PRM migration. 129K+ leads auto-processed, 1,440 async executions/day, 0 crashes. Full ecosystem ownership.

### 2021–2023: AG2R La Mondiale (national insurer, 15,000 employees) and Criteo, via the consultancy Texeï
One of three members of the Design Authority at AG2R La Mondiale: multi-team architecture governance, technical decision oversight, validation of the team's deliveries through Copado, including the Salesforce Industries (Vlocity) Insurance layer. International engagement at Criteo.

### 2018–2021: Martin Brower France (global logistics company, 13,000 employees, 18 countries, 25,000+ restaurants supplied)
First Salesforce architecture role, as Lead Developer: data model design, CSV import pipeline architecture for ~1,500 restaurants (custom API, unit rollback per restaurant, job chaining, Bulk API 2.0). 3 years in production, 0 data loss. First structural build-vs-buy decisions.

### 2015–2018: Dassault Systèmes
First steps in application architecture: technical referent on Biovia Content Manager, mobile app design. Start of a structured approach to software design.

### Currently also: External Salesforce CPQ Specialist
Post-acquisition catalog migration for a European technical furniture manufacturer (CPQ Import Suite). In production since March 2026, 1,167 references migrated, zero data loss.

### 2015: Efrei Paris
Master's degree in Computer Engineering, taught in English.

---

## 3 Side Projects (playable on the portfolio)

### Surprise Calendar — /calendar/
Virtual advent-style calendar platform. Interactive opening animations (Stargate, Pong, roulette, and more), Canvas2D-animated backgrounds, plugin system, WYSIWYG editor. Advent calendars, daily surprises, one-shots.

### Gravity — /gravity/
Gravity-based game built on Matter.js. Fusion system (12 types), monsters, obstacles, visual and sound themes, physics-based gameplay.

### Piano Magique — /jeu.html
Interactive piano with visual effects, multiple game modes, and a touch interface designed for children. Built as a playful tool for musical discovery.

---

## Portfolio Website Technical Details
- Single-page application, vanilla HTML/CSS/JS (no framework)
- Bilingual FR/EN with runtime language switching
- 8 interactive demos embedded in modals (playable HTML apps)
- 9 hand-crafted SMIL SVG animations (49s each, looping) with scrubber controls and step-by-step navigation
- Dark theme, responsive design, smooth scroll navigation
- Schema.org JSON-LD structured data (Person + 9 SoftwareApplication + WebPage)
- .ai-readable hidden blocks for AI/bot crawlers on every section

## Contact
- Website: https://adrienvalentin.com
- LinkedIn: linkedin.com/in/adrienvalentin
- Trailblazer: salesforce.com/trailblazer/avalentin91