Skip to main content

6 posts tagged with "ai-agents"

View All Tags

Public Budget AI #6: Inspector Web Portal & Full Verification

· 10 min read
Jaybee
AI & Robotics Engineer

National Budget Inspector Web Portal v3.0 & 20/20 Verification

💡 Key Takeaways

  • Inspector Web Portal v3.0 Completed: Transformed fragmented CLI scripts into a centralized, real-time command center featuring 7 dedicated workspaces (Overview, 6-Sector Partition, Summons Generator, e-Naradoum Subsidies, Bidding Rings Graph, Budget Cut Analyzer, Precedents & HWPX Validator).
  • Full Verification Test Harness Passed (20/20 PASS): Achieved a 100% pass rate across all 20 end-to-end automated test suites, covering Text-to-SQL, GraphRAG, streaming anomaly monitors, DART registry tracking, bidding cartels, and HWPX cost validation.
  • 2 Challenges Prevented in Design: (1) Mitigated server bottlenecks by decoupling heterogeneous audit engines behind 12 normalized RESTful DTO endpoints, (2) Prevented browser DOM bloat during continuous streaming via a Circular DOM Ring Buffer.
  • 3 Unexpected Production Bugs Resolved: (1) Solved Vis.js infinite physics oscillation and UI freezing via stabilization-triggered physics freezing, (2) Resolved 50-page HWPX XML parsing event-loop blocking via ThreadPoolExecutor async worker queues, (3) Eliminated SQLite file lock contention during parallel test runs via process-isolated in-memory DB mounts.
  • Series Grand Finale: Reflecting on the engineering evolution from a simple Text-to-SQL prototype to an enterprise-grade public procurement audit intelligence platform.

Public Budget AI #5: 6-Sector Audit Suite & Year-End Dumps

· 6 min read
Jaybee
AI & Robotics Engineer

6-Sector Targeted Audit: Divide & Conquer Suite

📌 Key Takeaways

  • Divide & Conquer Full Suite: Filtering 85% routine consumables across 4 million public contracts, we expanded our targeted surveillance pipeline to encompass 6 high-risk sectors (Sectors 1–6) covering structural public corruption corridors.
  • Unmasking 2 Elusive Blind Spots:
    1. Sector 5 ($40K Preferential Smurfing): Exploiting statutory affirmative action ceilings ($40,000 / 50M KRW) by clustering split contracts at $39,000 (99.0% threshold proximity), catching $180,000 in evasive awards.
    2. Sector 6 (December Fiscal Dumping): Rushing $120,000 across 3 consecutive sole-source awards within 4 days in late December to avoid budgetary clawbacks.
  • 2 Preempted Architectural Hurdles:
    1. Built a Sweet Spot (96–99.8%) Proximity Engine distinguishing genuine social enterprise support from artificial splitting.
    2. Designed Temporal Density & Task Feasibility Analyzers distinguishing standard year-end settlements from rushed dumping where completion is physically impossible.
  • 3 Real Production Bugs Resolved: Multi-sector classification collisions resolved via priority weighting, VAT gross/net confusion fixed by reverse-calculating supply costs, and fiscal year carry-over date shifts resolved.

Public Budget AI #4: Breaking Cartels via DART & Registries

· 7 min read
Jaybee
AI & Robotics Engineer

Breaking Cartels: Corporate Registry & DART Integration

📌 Key Takeaways

  • Overcoming the Field Limitation: Addressing our honest admission from Part 2 that "procurement logs alone cannot identify borrowed-name dummy CEOs and decentralized shells", we built a real-time corporate governance ingestion client (CorporateRegistryClient) integrating DART filings and supreme court corporate registries.
  • 2 Preempted Architectural Hurdles:
    1. Resolved identifier fragmentation across Tax IDs (10-digits), Court IDs (13-digits), and DART codes (8-digits) via a 3-way hash index bridge.
    2. Prevented knowledge graph explosion by enforcing governance significance thresholds (executive seats + 50%+ equity).
  • 3 Real Production Bugs Resolved:
    1. Circular Cross-Shareholding: Fixed RecursionError crashes during recursive ownership traversals using NetworkX Strongly Connected Components (SCC) cycle condensation.
    2. Newly Minted Shell Blind Spots: Added delta-day calculations (<180 days) to flag entities incorporated immediately prior to high-value bids.
    3. 51:49 Spousal Equity Disguise: Unmasked dummy sole-source privilege fronts via compound family relation graph rules.
  • Shipped Verification: Unmasked a $130,000 tender where a single hidden individual owned 80% and held board seats across two seemingly competing bidders; 17/17 test suites passed.

Public Budget AI #3: 3D Sector Partitioning & Live API Audit

· 8 min read
Jaybee
AI & Robotics Engineer

3D Sector Partitioning & Live Audit Web Portal

📌 Key Takeaways

  • Eliminating Alert Fatigue: In massive public procurement feeds where 80–95% of transactions represent routine office consumables, our 3-Dimensional Sector Partition Manager filters out 85%+ noise, focusing deep AI reasoning onto high-risk sectors.
  • Anticipated Challenges & Prevention: To handle public API latency and schema deprecations, we decoupled the ingestion tier with an isolated SQLite unaudited buffer queue and exponential backoff retry policies.
  • 3 Real-World Production Bugs Resolved:
    1. Caret (^) Multi-Value Delimiters: Legacy API fields returning composite records flattened via regex parsers and strict type schemas.
    2. Browser UI Freezes in Vis.js: Visualizing thousands of knowledge graph nodes caused severe UI lockups, solved by Depth-1 Ego-Network subgraph virtualization, cutting latency by 98%.
    3. Duplicate Contract Alerts: Polling shifts triggered redundant findings, eliminated using SHA-256 fingerprint hashes guaranteeing pipeline idempotency.
  • Shipped Artifact: Launched Inspector Web Portal v2.0 with live API sync, a 10-year precedent database, instant HWPX parsing, and 13/13 integration tests passed.

Public Budget AI Audit: 5 Fraud Findings & System Evaluation

· 8 min read
Jaybee
AI & Robotics Engineer

National Budget AI Audit Findings

📌 Key Takeaways

  • Interim Audit Deployment: Using our production-grade autonomous audit agent (national_budget_ai), we completed a full audit screening across representative public procurement datasets (5 major budget programs and 6 procurement contracts).
  • 4 Core Fraud Findings (Strictly Anonymized):
    1. Split Private Contracts: Smurfing contracts under the $20,000 threshold across 12 days to evade competitive bidding ($43,000 total, 94.5% similarity to Supreme Audit rulings).
    2. Shared Address Shell Cartels: 3 dummy vendors sharing the exact same room and building winning exclusive tenders ($158,000 total).
    3. 7x–10x Unit Price Markup: Inflated advisory fees (7.0x median) and GPU server rentals (10.0x median) detected via automated HWPX table parsing.
    4. Low Delivery Efficiency (DEI 30.0%): Only 30.0% of funds reached target beneficiaries, with 70.0% absorbed in administrative overhead.
  • System Performance Evaluation:
    • Precision: 0.00% financial calculation hallucination via deterministic SQL AST parsing; 11/11 test suites passed.
    • Throughput: 0.03s per contract to generate complete audit dossiers and statutory enforcement drafts.
    • Field Limitations: Blind spots in borrowed-name owners and multi-tier private subcontracts identified.

Autonomous Budget Audit Agent: Text-to-SQL & GraphRAG

· 10 min read
Jaybee
AI & Robotics Engineer

Autonomous Public Budget Audit Agent

📌 Key Takeaways (TL;DR)

  • The Goal: Build an autonomous AI agent to audit $500B annual public expenditures, tracking government procurement contracts (KONEPS), fiscal databases (dBrain+), and messy Korean HWPX budget tables to detect price gouging, split contracts, and paper-company cartels.
  • Anticipated Challenges & Prevention: Prevented LLM numerical hallucinations by delegating calculations to a Deterministic Text-to-SQL Engine, while isolating relationship and cartel tracking to a Heterogeneous Knowledge Graph (GraphRAG) in a dual-brain architecture.
  • Actual Bugs Encountered & Solved: (1) Solved company name and street address fragmentation breaking cartel detection via a robust EntityResolver, (2) Caught temporal split contracts slipping past date filters via a 30-day sliding window algorithm, (3) Overcame auditor distrust of AI black-boxes by building an XAI Dossier Generator binding findings 1:1 with statutory clauses and 10-year official audit precedents.
  • Verification: 11 out of 11 regression test harness suites passed, successfully exposing a 38.5M KRW shared-address private procurement cartel and a 70% indirect overhead leakage (DEI score 30%).