CRM Build and Restructuration of a Database

Jean-Baptiste Perez
Published

0
  • Project creator

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.