Skip to content

Instantly share code, notes, and snippets.

View JewelsHovan's full-sized avatar

Julien Hovan JewelsHovan

View GitHub Profile

Change Orders Refinement — Manual Test Checklist

Project: test n → Service: TEST_UPLOAD - Project Controls → Change Orders tab


Test 1: CIA Estimation Search Dialog

  • Open a CIA-stage change order (or create a new one with title, originator, trigger, discipline, responsible lead, implementation date)
  • Scroll down to "CIA Cost Breakdown Estimation" section
@JewelsHovan
JewelsHovan / agent-architecture-migration.md
Created March 26, 2026 02:45
Apotex Legal AI — Agent Architecture Migration Plan (LangGraph + Tools)

Implementation Plan: LangGraph Agent Architecture Migration

Status: Draft — source of truth for ticket creation Date: 2026-03-25 Branch: feature/vector-db-migration (current) → new branch per phase


Overview

@JewelsHovan
JewelsHovan / ingestion-explainer.md
Created March 23, 2026 15:59
AIDCDA Incremental Ingestion + Delta Sync Explainer

How the Incremental Ingestion + Delta Sync Pipeline Works

The Big Picture

PDFs in UC Volume → Ingestion Notebook (weekly job) → parsed_documents Delta table → Delta Sync index → Vector Search

There are two independent mechanisms working together:

@JewelsHovan
JewelsHovan / gist:7a6eea56cfd985f387e79736909d66f2
Created March 20, 2026 17:09
Guide to creating a GitHub bot that teammates can @mention in issues/PRs to trigger custom workflows
# GitHub Bot for Team Workflows via @mentions
A guide to creating a GitHub bot that teammates can @mention in issues/PRs to trigger custom workflows.
---
## Approach 1: GitHub Actions + Comment Triggers (Recommended Start)
Zero infrastructure. Uses GitHub Actions triggered by issue/PR comments.
@JewelsHovan
JewelsHovan / teams-claude-agent-bot.md
Created March 20, 2026 00:32
Teams Claude Agent Bot — Design Document (codebase + Confluence knowledge)

Teams Claude Agent Bot — Design Document

A Microsoft Teams bot powered by Claude Agent SDK that has deep knowledge of your codebase and Confluence documentation. Think of it as an always-available senior engineer teammate that knows the code, the docs, and the context.

What It Does

  • Lives in Teams as a bot you can DM or @mention in channels
  • Answers questions about the codebase (architecture, how things work, where things are)
  • Answers questions about Confluence docs (specs, decisions, runbooks, onboarding guides)
  • Can reason across both — e.g., "how does the auth flow described in the Auth RFC actually get implemented in the code?"
@JewelsHovan
JewelsHovan / ai-avatar-influencer-research.md
Created March 20, 2026 00:30
AI Avatar Influencer Tech Stack — Research Synthesis (March 2026)

AI Avatar Influencer Tech Stack — Research Synthesis

Date: March 2026 | Dimensions: 5 | Sources: 80+ | Research Method: Parallel multi-agent exploration (avatar models, video/animation, voice synthesis, case studies, startup tooling)


Executive Summary

The AI influencer space is real and monetizable — top AI personas earn $10K-$50K+/month via brand deals and Fanvue subscriptions. The tech stack has matured enough that a solo founder can launch in 48 hours using all-in-one platforms, or a small team can build a fully automated multi-persona content factory. The core insight across all research dimensions: character consistency (same face, same voice, same personality across all content) is the #1 technical challenge and the #1 differentiator between success and failure.

@JewelsHovan
JewelsHovan / databricks-vector-search-research.md
Created March 18, 2026 15:04
Databricks Vector Search — Research on incremental updates, Delta Sync vs DVAI, embeddings strategy

Databricks Vector Search — Comprehensive Research

Date: 2026-03-17 Context: We have ~7,000 chunks in a DVAI index using PubMedBERT (768-dim) embeddings with frequent incremental updates of pharmaceutical patents and FDA documents. This document consolidates research across all relevant Databricks documentation.


Topic 1: Delta Sync Index vs Direct Vector Access Index (DVAI)

What is each type?

Programmatic Data Lineage in Databricks Unity Catalog

Executive Summary

There are 3 approaches for programmatically getting table lineage in Databricks, each with different trade-offs. The native lineage-tracking REST API exists but is not yet in the official Python SDK. SQL system tables are the most powerful option for historical analysis.


Approach 1: REST API (Direct HTTP Calls)

@JewelsHovan
JewelsHovan / discrepancy_results.json
Created March 12, 2026 05:26
Mitapivat (Aqvesme) — Standalone Candidate Generation Report: FDA vs USPTO Discrepancy Analysis
[
{
"has_discrepancy": true,
"composite_score": 71.5,
"patent_source": "mitapivat_app_14115289_CLM_1.pdf",
"fda_source": "mitapivat_216196Orig1s000AdminCorres.pdf",
"similarity_score": 0.9252641201019287,
"discrepancy": {
"category": "dosing_inventorship",
"description": "FDA reviewers questioned and effectively identified/criticized the proposed dosing/clinical regimen and primary endpoint (\u226533% reduction in transfusion burden over 24 weeks, single-arm design with dose optimization) for mitapivat prior to or contemporaneous with patent claim amendments asserting clinical methods using the compound class.",