Cross-Platform Green Space & Market Share Analysis

Organization

CargoSprint / EModal

Role

Senior Data Analyst

Function

Sales, Strategy

Timeline

2022 – Present

Cross-platform green space analysis merging two post-acquisition customer databases against external freight registries — $250K–$1M net-new revenue opportunity sized in three days.

← All Work

3 Days

From brief to $250K–$1M opportunity sized and delivered to leadership

Project image — placeholder

CargoSprint acquired EModal, combining two freight payment platforms — SprintPay and EModal — under one organization. Leadership needed a cross-platform view of the combined customer base to understand where the real revenue opportunity was: who wasn't a customer yet, who could be upgraded, and where conversion from one side of a transaction to the other was possible.

No unified customer master existed across the two systems. Payor and payee relationships — the same company appearing on both sides of a freight transaction — further complicated the picture. Entity resolution had to come first.

Normalization approach — placeholder
  • Merged customer data from SprintPay and EModal against three external freight market registries: NVOCC, FMC, and IATA
  • Built a Python normalization script to unify payor and payee data into a single canonical company master — resolving the same entity appearing as both sides of a transaction
  • Classified revenue opportunities: upsell, cross-sell, payor-to-payee conversion, and net-new across air and ocean freight verticals
  • Sized the Southeast region's opportunity at 10% upsell capture as the primary scenario for leadership presentation

$250K – $1M

Net new annual revenue — Southeast region at 10% upsell capture

Delivered in three days. Provided sales and revenue leadership with a prioritized view of upsell, cross-sell, conversion, and net-new targets across air and ocean freight — segmented and actionable without additional manual interpretation.

The canonical company master produced as a side output became a reusable foundation for future cross-platform analysis.

Python SQL MySQL GCP Data Normalization Market Analysis Entity Resolution Revenue Modeling