Infrastructure Live Project: fwfg-ai-ops  ·  BigQuery: us multi-region Last updated: 2026-04-04
Active Employees
11
of 18 defined roles · 7 pending hire
Founding Era Tokens
~170K
across 5 sessions · all estimated
Tasks Completed
8
of 10 work queue items · 2 open
Unrouted Cost
100%
founding era · target: 0% at maturity
Org Chart
Token Usage
Activity Feed
Alan Powell
Owner · CFO
● Human
Find What Feels Good, Inc.
Founder
T0 · Interface Layer
● Active
Routes all requests · logs delegation
FounderReceives every request from Alan Powell, routes to the correct employee, logs to WORK_QUEUE.md. Nothing consequential happens without flowing through the Founder.
QA Lead
T2 · Independent
● Active
Reports directly to Founder
QA LeadEvaluates all employee outputs on 4 dimensions: Accuracy, Completeness, Format compliance, Scope compliance. Independent of all operational departments.
Chief of Staff
T1 · Executive Oversight
◈ Defined
Executive layer · not yet active
HR Trainer
T3 · HR Layer
● Active
Capability gap register · token surplus training
HR TrainerKnows which employees are missing which capabilities. Uses token surplus windows (low-usage periods) to run Opus-powered training sessions.
Engineering & Platform Department
Engineering Lead
T2 · Department Head
● Active
GCP · Python · best tool wins
Engineering LeadOwns all automation infrastructure decisions. GCP + Python default. Oversees Cloud Engineer, Data Engineer, Systems Analyst. All new automation routes through Engineering first.
Cloud & Platform Engineer
T3 · Manager
● Active
GCP infra · IAM · Secret Manager
Cloud & Platform EngineerProvisions GCP resources, manages IAM, deploys Cloud Functions and Scheduler jobs. Just deployed fwfg-ai-ops project and all BigQuery datasets.
Data Engineer
T3 · Manager
● Active
BigQuery pipelines · DDL + DML
Data EngineerBuilds and runs data pipelines from Stripe, PayPal, Apple, Google → BigQuery. Owns fwfg_raw and fwfg_operations layers. Training pending on bigquery-write capability.
Data Schema Tracker
T3 · Elevated (hard role)
● Active
SCHEMA_REGISTRY.md · DDL only
Data Schema TrackerOwns every BigQuery table definition. Hard rule: never rename a field in place. All changes versioned. Owns SCHEMA_REGISTRY.md.
Systems Analyst
T4 · Specialist
● Active
Tools inventory · integrations map
Systems AnalystMaintains TOOLS_INVENTORY.md (~45 tools across 13 sections). Identifies integration opportunities and gaps across the FWFG tool stack.
Shared Services (cross-department)
Session Chronicler
T4 · Shared Service
● Active
Institutional memory · handoff payloads
Session ChroniclerExtracts decisions, schema changes, token estimates, and workforce events from each session. Produces structured handoff payloads for downstream employees. Writes to DECISION_LOG.md and SESSION_STATE.md — never directly to BigQuery.
Token Ledger Keeper
T4 · Shared Service
● Active
TOKEN_LOG.md · unrouted cost metric
Token Ledger KeeperTracks token usage per session and employee. Key metric: "unrouted cost" — % of tokens where Claude acts directly instead of through an employee. Target: trend to zero.
Shared Data Analyst
T5 · Shared Service
○ Pending
Read-only BigQuery · cross-domain queries
Identity & Credential Governance Manager
T5 · Shared Service
○ Pending
1Password · Secret Manager · IAM
Other Departments (pending staffing)
Revenue Reconciliation Manager
T3 · Finance & Revenue
○ Pending
Stripe · PayPal · Apple · QBO
Triage Coordinator
T3 · Support & CX
○ Pending
Gmail · Front · inbox management
+ 8 Specialists
T4–T5 · Various
○ Pending
Apple, Stripe, PayPal, Support, Ops…
Workforce Governance Layer (structural evolution)
Workforce Strategy Director
T2 · Governance
◈ Defined
Decides what roles should exist
Workforce Design Analyst
T3 · Governance
◈ Defined
Analyzes incoming role requests
Workforce Operations Manager
T3 · Governance
◈ Defined
Executes approved structural changes
Token Usage by Session — Founding Era
All values estimated (1 token ≈ 0.75 words). Actual tracking begins when Cloud Functions are instrumented.
Session Log
founding-001
UNROUTED
Full architecture build — folder structure, core docs, employees, capabilities, governance
~75K
founding-002
UNROUTED
Tools inventory — QuickBooks pulls, 13 sections, ~45 tools documented
~30K
founding-003
UNROUTED
Engineering dept — philosophy, 4 employees, Pub/Sub clarification
~20K
founding-004
UNROUTED
Founder, Session Chronicler, Token Ledger Keeper hired. Routing layer established.
~11K
founding-005
UNROUTED
GCP project created. BigQuery live. IAM, Secret Manager, control plane tables deployed.
~34K
Unrouted Cost Over Time
100% unrouted during founding era — all requests went directly from Alan → Claude. Founder role is now active. Target: >50% routed within next 5 sessions, trending to 0% at maturity.
Work Queue — Active & Complete
IDTaskOwnerStatus
WQ-001 Build FWFG AI operating system architecture All employees ROUTED
WQ-010 Train Data Engineer + Schema Tracker on bigquery-write HR Trainer OPEN
WQ-009 Store service account key in Secret Manager Cloud & Platform Engineer COMPLETE
WQ-008 Provision BigQuery data layer — APIs, datasets, IAM, control plane Cloud & Platform Engineer COMPLETE
WQ-007 Create GCP analytics project fwfg-ai-ops Cloud & Platform Engineer COMPLETE
WQ-006 Pull QuickBooks data to discover tools Engineering Lead COMPLETE
WQ-005 Hire record-keeping layer; Founder role Workforce Strategy Director COMPLETE
WQ-002–004 Tools inventory, engineering team, philosophy Engineering Lead COMPLETE
Deferred Pipeline Tasks
IDTaskPriorityBlocker
WQ-D002 Stripe daily pull pipeline → fwfg_raw P1 None ✅
WQ-D003 PayPal daily pull pipeline → fwfg_raw P2 None ✅
WQ-D001 Google Play financial report API pipeline P3 None ✅
WQ-D004 Build JOBS_TO_BE_DONE.md P4 —
WQ-D005 Categorize $315K QBO Miscellaneous expenses Finance —
WQ-D007 Confirm Gusto status (legacy vs. active vs. YWA) Med —
Infrastructure Status
✅ LIVE
GCP project fwfg-ai-ops · us multi-region
✅ LIVE
BigQuery: fwfg_control, fwfg_raw, fwfg_operations, fwfg_analytics
✅ LIVE
Control plane tables: functions, function_runs, credentials
✅ LIVE
Secret Manager: fwfg-service-account-key v1
✅ LIVE
Cloud Storage: gs://fwfg-data-lake/
⏳ NEXT
Stripe pipeline · bigquery-write training · QA certification