Rick Huang

Tech Talk · 4 essays

Business Logic

Fees, ledgers, identities and restatements: turning how the business works into models finance agrees with.

  1. 9 min readMigrating a chart of accounts without breaking a single reportWhen finance re-cuts the general ledger, every dbt model, metric and dashboard downstream is exposed. A playbook: crosswalks, dual-running, zero-tolerance reconciliation, and treating the account hierarchy as a data contract.MigrationBusiness Logic
  2. 8 min readBasis points on a moving balance: modeling asset-based feesCustody and asset-management fees are charged in basis points on balances that change every block. Average daily balance, tiered vs. banded pricing, minimums, valuation cutoffs, and reconciling the model to the invoice.Business Logic
  3. 9 min readOne customer, five systems: entity resolution and survivorship for finance dataCRM, contracts, ERP, billing and KYC each have their own idea of who the customer is. How I model a canonical party, match records without guessing, pick survivorship rules per attribute, and prove the result is right.Data ArchitectureBusiness Logic
  4. 8 min readAs-of vs. as-was: bitemporal modeling for financial reportingLate prices, backdated deposits and restatements mean "what was the balance on December 31?" has two right answers. How to model both, and why auditors care which one you show.Data ArchitectureBusiness Logic