Completed Work

This list is based on artifacts present in the FreightTiger project folder, not git history.

Pylon Account And Data Hygiene

• Updated FreightTiger TMS account metadata in Pylon from the review spreadsheet.
• Populated owner, CSM lead, customer ops, customer tier, MRR, and active modules.
• Documented that customer tier is HubSpot-synced/read-only and may be overwritten by upstream sync.

Pylon Dashboard And Reporting Design

• Created the TMS dashboard plan in platinum_tms_dashboard_plan.md.
• Defined the Pylon-native saved-filter approach for TMS accounts and top tiers.
• Designed action queue, portfolio scorecard, account risk table, module health breakdown, and hygiene roadmap.
• Captured follow-up sprint items for CSM assignment, MRR backfill, active module backfill, severity tagging, bug ranking, and weekly volume trends.
• Built dashboard_mockup.html as a dashboard mockup artifact.

Weekly TMS Analytics Pipeline

• Built Makefile pipeline orchestration.
• Built scripts/01_pull_pylon.py to pull Pylon accounts and issues into dated snapshots.
• Built scripts/02_compute_metrics.py to compute SLA, health, breach, module, account, tier, age-bucket, and red-flag metrics.
• Built scripts/03_generate_summaries.py to generate LLM concerns and persona action items using local Ollama.
• Built scripts/04_render_report.py to render Markdown and HTML leadership reports.
• Built scripts/05_publish.sh to encrypt and publish reports to Cloudflare Pages.
• Created Jinja templates for HTML and Markdown reports.
• Added config files for modules, personas, Pylon links, SLA policy, and tier display.
• Added report linkification for Pylon accounts, tickets, and tier views.
• Added safeguards to strip LLM-invented ticket references not present in the snapshot.
• Generated dated weekly snapshots and reports for April and May 2026.

Pylon To Linear Automation

• Built pylon-linear-bridge/, a Cloudflare Worker that creates Linear issues from Pylon webhooks.
• Added shared-secret verification with X-Pylon-Webhook-Secret.
• Added module-to-Linear-team routing via MODULE_TEAM_MAP.
• Added fallback routing to the default FreightTiger Linear team.
• Added Pylon attachment extraction and Linear upload/attachment creation.
• Added Pylon external-issue linking after Linear issue creation.
• Added durable idempotency check using Pylon external issues.
• Added Cloudflare KV dedup claim to prevent duplicate Linear issues during webhook retries.
• Added fast acknowledgement using ctx.waitUntil to avoid Pylon retry storms.
• Documented setup, secrets, trigger body, failure modes, limits, and tests in pylon-linear-bridge/README.md.
• Added tests for verification, worker behavior, routing, attachment upload, idempotency, and failure paths.

Insurance / CRM Discovery Artifacts

• Created insurance-crm-evaluation.md.
• Created insurance-clm-framing-research.md.
• Created insurance-portal-requirements.md.
• Created insurance-implementation-scope.md.
• Created insurance-onepager.md, insurance-onepager.html, and insurance-onepager.pdf.

Handoff Packaging

• Created Markdown documentation under docs/.
• Created the installable Codex skill package under skills/freighttiger-weekly-analytics/.
• Bundled the runnable weekly analytics pipeline as a skill asset.
• Added .env.example for the packaged report pipeline.
• Created this VitePress documentation site under docs-site/.