JRV

Portfolio / CASE STUDY

Private data migration tool

FUB to Sierra CSV Converter.

A tool for previewing and transforming Follow Up Boss contacts into Sierra CRM import files.

MY ROLE

Independent converter and web workflow development

Why it exists

CRM migrations can fail on small differences in field names, phone formats, tags, and import limits.

What I built

I built a deterministic mapping and normalization pipeline, then wrapped it in a browser upload, preview, and download workflow.

Engineering decisions

01

Normalize before exporting

The converter maps source fields to the target schema, formats phone values, and deduplicates tags. Unit tests cover the transformation rules.

02

Plan for large imports

Large outputs can be split into bounded chunks and bundled for download. Users can inspect the preview before exporting.

03

Test the round trip

Integration and upload/download tests exercise the flow from fixture data to converted output. The web app also includes cleanup for session files.

Capabilities in practice

  • Schema mapping
  • Data normalization
  • Import tooling
  • Integration testing

Status & scope

Private migration utility with synthetic example data and tests. I can discuss the conversion rules and test strategy on request.

Private repository FUB-to-Sierra-CSV-Converter

KEEP EXPLORING

Medical Device Integration & Test Tooling