CRM Build and Restructuration of a Database
Jean-Baptiste Perez
Published
Structuring and securing business data through the design of a custom CRM that doubled the client database and improved visibility across the entire sales cycle.
Context & objectives
The ESSI Group, a B2B service provider, faced fragmented data systems and limited visibility into commercial performance. The project’s goal was to develop a custom in-house CRM, centralizing all client, prospect, and activity data to enhance sales tracking, reporting, and lead management.
Role & responsibilities
- Digital Project Manager, in charge of the complete CRM redesign.
- Created the functional specification, mockups, and implementation roadmap.
- Defined team roles and coordinated between developers and business stakeholders.
- Led data migration and enrichment: field mapping, deduplication, and integration of newly purchased datasets.
- Delivered the project in three agile-based versions (V1–V3).
- Built analytical dashboards for sales performance tracking.
- Conducted training sessions and user onboarding.
Methodology :
Iterative, lot-based project delivery (V1 to V3).
Key phases: audit, functional design, data migration, user testing, training, and rollout.
Results
Database doubled in size and scope.
Centralized and reliable sales data improving day-to-day operations.
Elimination of duplicate entries, improving lead qualification and speed.
Comprehensive sales and marketing dashboards implemented.
Increased data-driven decision-making across departments.