Last 12 Months

CJ AI Background

This is the recent AI operating pattern: building decision surfaces, automation systems, reporting tools, research hubs, content workflows, and production-grade n8n pipelines that connect real business systems instead of staying at the concept stage.

n8n orchestration
Neon Postgres
Shopify analytics
Executive dashboards
AI content workflows
Competitive intelligence
Compliance tooling
Decision surfaces

Best Framing

Over the last 12 months, I have not been dabbling in AI. I have been building operational systems that connect data, workflows, reporting, publishing, research, and AI services into usable decision-making tools.
  • Messy inputs turned into structured decision surfaces.
  • Webhook intake, enrichment, publishing, sync, and reporting loops.
  • Multi-provider AI orchestration based on speed, cost, and fit.
  • Projects shipped across e-commerce, content, compliance, intelligence, and executive reporting.
What You Built Dashboards, research hubs, content systems, compliance tooling, microsites
Automation Pattern Webhook intake, sync, enrichment, upsert, publish, report, review
Commerce Layer Shopify line items, blog publishing, asset uploads, GA4 reporting
AI Layer Generation, summarization, classification, structured outputs, review logic
Interview Theme Real systems, not theoretical AI experimentation

Interview-Ready Project List

Executive DashboardsBuilt Shopify and store-performance dashboards for weekly business reviews and leadership visibility.
Social Content Ops ToolsCreated systems for planning, review, scheduling, queue management, and usage diagnostics.
AI Content ProductionBuilt workflows for image generation, video direction, ad analysis, and blog publishing.
Workflow ExplainersShowed how n8n, Neon Postgres, Google Drive, Gmail, and AI services connect behind the scenes.
Competitive Intelligence PortalsCreated research hubs for market scans, pricing, brand health, and category intelligence.
Semiconductor IntelligenceBuilt RISC-V landscape reports and semiconductor news-monitoring hubs.
Supplement Research HubsCreated systems covering clinical evidence, regulation, manufacturing, and market research.
FDA and Compliance ReviewBuilt tooling for supplement claims review, content QA, and controlled internal workflows.
Brand and Photography GuidesStandardized packaging, lighting, creative direction, and asset production consistency.
Media Asset BrowsersBuilt campaign review and asset-management tools for creative execution.
Shopify Blog SystemsCreated structured post-creation, admin tracking, system messaging, and webhook-driven publishing hooks.
Narrative MicrositesBuilt targeted sites for recruiting, executive follow-up, business development, and audience positioning.
Decision-Support ToolsCreated interactive comparison guides, research libraries, and public information utilities.
Decision SurfacesTurned messy research and workflows into focused web apps decision-makers can use quickly.

Top n8n Automations to Highlight

SGS Social App to ContentStudio

Automated approved social asset handoff into ContentStudio for scheduling and publishing.

ContentStudio Usage Sync to Neon

Synced scheduled and published post data back into Neon for reporting and campaign visibility.

Schedule Asset Webhook Capture

Captured scheduling requests from the social app through webhooks and routed them into backend workflows.

ContentStudio Sync All Posts to Neon

Pulled post history into Neon to support scheduled, published, and historical reporting.

Shopify Line Items Simple Sync

Automated Shopify line-item sync into analytics for product-level sales and reporting.

Shopify JSONL to Neon Upsert Builder

Built a reusable bulk-ingestion pattern that parses, normalizes, and upserts commerce data into Neon.

GA4 Report V4

Automated Google Analytics 4 reporting for digital performance tracking and marketing analytics.

SGS Web App Blog Builder

Supported content creation, approval, and Shopify or website publishing through the web app.

SGS Product Environment Uploader

Automated product and environment image uploads for repeatable creative workflows.

SGS FDA Checker

Built supplement compliance review automation for FDA-sensitive language and claims checking.

Endpoint and Provider Stack

AI and LLM Endpoints

  • OpenAI
  • Google Gemini / PaLM
  • Together AI
  • Used for generation, classification, summarization, enrichment, structured outputs, and workflow logic.

Search Intelligence

  • SerpApi
  • Used for search-result automation, trend discovery, market research, and external signal monitoring.

Web Data Acquisition

  • BrightData
  • Used for web research, enrichment, structured data capture, and competitive intelligence.

Browser Automation

  • Airtop
  • Used when a normal API does not exist and browser-level interaction is required.

CMS and Publishing

  • WordPress API
  • Used for publishing, updates, tagging, media handling, and content ops.

Media and Asset Sourcing

  • Pexels
  • Used for image search, stock sourcing, and content-production workflows.

Auth Patterns

  • Bearer Auth
  • Header Auth
  • Used for custom token and header-based services outside native credentials.

Multi-Provider Orchestration

  • OpenAI + Gemini + Together AI
  • Task routing based on cost, quality, speed, or model capability.

What This Pattern Shows

  • Webhook intake plus backend routing is a repeatable operating pattern.
  • AI is used as a working layer inside systems, not as a disconnected experiment.
  • Commerce, reporting, publishing, and research all feed a shared operational model.
  • Neon is used as a reporting and normalization layer behind multiple workflows.
  • Compliance and QA are treated as first-class automation use cases, not afterthoughts.
  • Projects shipped across tech, semiconductor, manufacturing, supplements, e-commerce, marketing ops, and executive reporting.

Best Interview Summary

The strongest theme from the last 12 months is that I have been building AI-enabled operating systems, not just prompts. The work combines automation, data movement, publishing, analytics, research, and compliance into tools that business users can actually run on.