Rick Huang · Applied AI · Data

Better data models. AI that does real work.

I'm Rick Huang, an Applied AI Architect, Business Lead. I design the data models businesses run on and put AI to work inside them. Here I share what holds up in practice.

About Rick HuangGet in touch

Rick Huang seated at an office pantry counter in a maroon shirt, a coffee cup beside him.

Start here

Four essays that explain what I do.

Browse everything

For data teams

Four essays on how it's built.

More on AI

Latest

New on the Blog

  1. I Gave the Router the Big BrainDeepSeek keeps its router thin. I gave mine the strongest model, added an advisor, and let cheaper workers build. One real run, with the token numbers.
  2. Microsoft Is Offering Its Own Copilot Team a Buyout. And That's Your AI Strategy?A company about to lose 12% of its revenue banned every AI tool except Copilot. Meanwhile, Microsoft is offering its Copilot team a check to leave.
  3. Two Dashboards, One Number, Zero TrustSales says $12.4M, Finance says $9.8M. Why two dashboards disagree, and four plain-language fixes that make company numbers trustworthy again.
  4. Your AI Shouldn’t Need a BabysitterDeepSeek’s Super-agent design says the limit on AI isn’t the model anymore. It’s my attention. How it works, and how I already run my week this way.
  5. Less Is More: Cut the Data Catalog, Keep Its JobData catalogs like Atlan and Alation were built so people could find and trust data. AI changed who is asking. Cut the copy, keep the job it did.

Finance data

Five essays on making the numbers agree.

  1. Ledger-First: A Data Architecture for a Crypto CustodianOps, finance and growth report three different AUM numbers. Derive every one from a single double-entry ledger, and reconciliation becomes a test.Data Architecture
  2. One Customer, Five Systems: Why Your Top-Client Report Is OffCRM, contracts, ERP, billing and KYC each count customers differently. Resolve them to one party without guessing, and prove it ties out.Data ArchitectureBusiness Logic
  3. Basis Points on a Moving Balance: Modeling Asset-Based FeesSame client, same balances, same rate card: four methods bill from $2,740 to $3,879. How to model basis-point fees so the invoice is right.Business Logic
  4. As-Of vs. As-Was: Why December 31 Has Two Right BalancesLate prices and backdated deposits give December 31 two right balances. How to model both in dbt, and why auditors care which one you show.Data ArchitectureBusiness Logic
  5. Migrating a Chart of Accounts Without Breaking a Single ReportRe-cutting the general ledger exposes every model, metric and dashboard downstream. Map it as data, dual-run it, reconcile every node to zero.MigrationBusiness Logic

Need a speaker on applied AI and the data underneath it?

Conference talks, company offsites, podcasts and private workshops. Practitioner-level, first-person, no slides full of buzzwords.