Back to Portfolio
Featured Project

Pioneer Commissions Portal

Commission tracking platform for a healthcare staffing agency — dual-engine model with a matrix-based calculator for recruiters and a tier-based calculator for account managers, pulling live data from Salesforce with real-time dashboards, split commissions, reassignment rules, and business development bonus tracking.

Pioneer Commissions Portal

Tech Stack

Next.jsFastAPIPostgreSQLRedisSalesforce APITypeScriptMicrosoft Graph API

Overview

Pioneer's recruiters and account managers had no transparent, real-time view of their own earnings — and finance had no audit trail of how commissions were calculated. This platform solves all three pain points: it syncs Financial_Record__c data live from Salesforce, runs two separate calculation engines (matrix-based for recruiters, tier-based for account managers), and surfaces accurate earnings through role-gated dashboards. The system handles split commissions across shared deals, candidate and client reassignment edge cases, business development bonuses, and quarterly bonus calculations — with a full audit trail on every figure.

Key Features

Recruiter engine: dual-axis matrix — 5 cumulative hours tiers × 8 gross margin brackets
Account manager engine: gross profit-based tier commission with separate rate tables
Split commission handling — shared deals tracked with per-user %, approval workflow, and status (pending/approved/paid/disputed)
Candidate & client reassignment management — commissions correctly re-attributed on ownership changes
Business development bonus tracking and quarterly bonus calculations
Webhook-driven recalculation — commission updates trigger automatically on Salesforce record changes
Redis caching for real-time commission estimates without repeated heavy DB queries
Full commission audit trail — every calculation is versioned and explainable
Weekly, MTD, YTD dashboards with year-over-year comparison and 26-week trend charts
Tier performance chart — live hours/GM vs. tier thresholds with active tier highlight