Sheepdog Prosperity Partners
Due Diligence
  • Home
  • Services
  • Process
  • Daily DD
  • DD Tech Lab
  • Case Studies
  • About
  • Contact
  • Articles

Time-Series Anomaly Detection in Excel: Rolling Z-Scores, Exponentially-Smoothed Residuals, and the Period-Over-Period Variance Diagnostic

by Noah Green CPA CFE | Apr 13, 2026 | DD Tech Lab

Year-over-year percent change with a 10% threshold remains the most common analytical procedure on multi-period balance trends. The metric has known limitations the practitioner should account for: it is undefined when the base is near zero, it carries no notion of...

Random Walks on DD Graphs: PageRank, Personalized PageRank, and Influence Ranking for Counterparty Investigations

by Noah Green CPA CFE | Apr 12, 2026 | DD Tech Lab

The Schema Design for Sanctions Screening article in this sub-series handled the direct-match screening problem: counterparty name matches an SDN entry, score the match, route for analyst review. Many sanctioned exposures are not direct. OFAC’s 50 Percent Rule...

GraphRAG for Due-Diligence Knowledge Management: Combining LLM Retrieval With Cypher Path Queries

by Noah Green CPA CFE | Apr 10, 2026 | DD Tech Lab

The DD practice accumulates institutional knowledge in a specific shape: structured (CRM entries, ownership data, transaction records) plus unstructured (engagement memos, IC presentations, expert-call transcripts, regulatory filings). Vanilla retrieval-augmented...

Random-Walk and Stationarity Tests on Account Reconciliations

by Noah Green CPA CFE | Apr 9, 2026 | DD Tech Lab

A reconciliation account that should oscillate around its expected balance, intercompany clearing, suspense, accrued-payroll roll-forward, but instead wanders without bound has failed its control objective. The variance grows linearly with time; the account cannot...

Foundry vs Snowflake + DBT vs Databricks for DD Analytics: Architecture Trade-Off Framework

by Noah Green CPA CFE | Apr 8, 2026 | DD Tech Lab

What you’ll be able to do after reading this. Score your institution against a 10-dimension platform-comparison scorecard. Apply one of three elicited weight profiles (or run your own elicitation per the companion bundle). Estimate a parameterized 5-year TCO...

OSINT for Financial Fraud in Excel: Integrating Public-Source Verification Into the Workpaper Workflow

by Noah Green CPA CFE | Apr 6, 2026 | DD Tech Lab

Vendor validation at engagement scale breaks when each lookup requires manual browser navigation. The auditor opens OpenCorporates, searches the vendor name, copies registration status, switches to EDGAR, runs full-text search, copies filing presence, opens PACER,...
« Older Entries
Next Entries »

Recent Posts

  • Forced Divestiture vs. Forfeiture: A Comparative Anatomy
  • The National-Security Screening Toolkit
  • The Integrated National-Security Diligence Workflow
  • The Whistleblower and Bounty Bridge: Where National-Security Diligence Meets Qui Tam
  • Asset Seizure and Forfeiture: The Sharpest Enforcement Spine

Recent Comments

No comments to show.

Sheepdog Prosperity Partners LLC

5940 S Rainbow Blvd, Ste 400 PMB 855226
Las Vegas, NV 89118-2507

Contact

888-533-3495
noah@noahgreencpa.com

Schedule

Discovery Call

Veteran-owned and operated.



© 2026 Noah Green CPA CFE | All Rights Reserved

Information on this site is general. A CPA-client engagement begins only with a signed Master Services Agreement and per-matter Statement of Work. Pre-engagement notice.