Back to Portfolio

FCRF | Diamond Reports & Intelligence Platform

Enterprise-grade diamond intelligence platform delivering automated reports, pricing analytics, and rarity insights for global luxury brands.

Live Demo
FCRF | Diamond Reports & Intelligence Platform

Project Overview

FCRF is a high-end diamond intelligence and reporting platform used by global luxury brands, auction houses, and financial institutions. It delivers advanced rarity analysis, pricing intelligence, auction insights, and automated PDF reports through both web tools and external APIs.

Trusted By

DiorSotheby’sBulgariBloombergFinancial TimesCartierKnight Frank

Key Features

  • Advanced diamond analytics tools (Rarity, Argyle, Diamond Diary, Price Intelligence)
    • True Face-Up analysis
    • Auction Genie
    • Diamond Index tools with visual charts
  • High-volume external APIs for enterprise automation
  • Automated, high-fidelity PDF and booklet generation
    • Report history
    • Save, share, and download
  • SEO-friendly public report sharing

Key Contributions

  • Designed two independent service layers: Web App and External APIs
    • Implemented Google Sheet locking using async-mutex
    • 0.5s throttling to prevent race conditions
  • Built queue-based processing for high-concurrency API usage
    • Isolated sheets per company
    • Prevented cross-tenant conflicts
  • Migrated heavy sheet calculations into backend services
  • Designed a custom pricing intelligence engine using multi-source data
  • Implemented parent-child user hierarchy with shared credits
  • Integrated QR-based GIA number extraction
  • Built Puppeteer-based PDF automation and booklet formats
  • Implemented iframe token exchange with WordPress
  • Integrated Sentry and webhooks for monitoring and tracking

Challenges

  • Heavy Google Sheet calculations causing performance bottlenecks
  • Concurrency conflicts from shared enterprise credentials
  • Secure communication with WordPress iframe environment

Solutions

  • Queue-based execution and backend offloading of calculations
  • Sheet isolation per tenant and serialized API execution
  • Token exchange via postMessage events

Architecture Highlights

NestJS API with Queue/Worker patternGoogle Sheets as controlled computation enginesPuppeteer for PDF automationEvent-driven integrations with webhooks

Tech Stack

React.jsNestJSGoogle Sheets APIPuppeteerQueuesWebhooksHighchartsSentryWordPress Integration

Outcome

  • Enterprise adoption by global luxury brands
  • 95% reduction in manual reporting effort
  • Stable, high-performance reporting under heavy concurrency