3. Data, Science & AI

Assists junior developers in drafting basic SELECT SQL queries from simple requirements, providing a starting point for data retrieval.

Manages ServiceNow import sets for data import and ETL, enabling record insertion and retrieval.

Expert in handling .faf files for persistent AI project context, including AI-readiness scoring, CLAUDE.md bi-sync, and MCP server configuration.

Generates images via Google's Gemini 2.5 Flash for frontend designs, illustrations, and creative assets upon user request.

Expert in designing and managing modern databases with PostgreSQL, MongoDB, and Redis using advanced data patterns for application needs.

Specializes in R 4.4+ development for data analysis pipelines, visualizations using ggplot2, and Shiny application development.

Optimizes data formats (JSON/YAML) and serialization for LLM transmission, with schema validation and format conversion capabilities.

Manages enterprise AI sessions with token optimization and state persistence for efficient LLM interactions.

Adds a footer with AI platform icons to pre-populate prompts for website summaries via external AI services.

Offers a single API endpoint to access over 400 AI models, streamlining integration for developers.

Guides users in running, managing, and fine-tuning AI models on Replicate via CLI for image generation, language models, and ML deployments.

Comprehensive guide for implementing, configuring, and analyzing data in Google Analytics 4, covering events, tracking, audiences, and BigQuery integration.

Provides robust production-grade PDF processing for forms, tables, OCR, and batch operations with validation and error handling.

Generates ontological knowledge graphs in [[wikilinks]] syntax for InfraNodus visualization, extracting entities and relationships from text for AI-powered gap analysis.

Enables multi-model AI review of plans, architecture decisions, and fact-checking using Gemini-3-Pro and GPT-5.2 via OpenCode.

A tool for editing OBO format ontologies, enabling term querying, version control, and adherence to OBO conventions in scientific data management.

Analyzes Instagram/YouTube/TikTok influencer metrics to calculate composite scores for brand KOL selection.

Simulates AI crawler perspective to audit website structure, assess LLM-friendliness, and provide optimization recommendations.

Analyzes YouTube video transcripts to generate structured summaries, core points, and key concepts for efficient content comprehension.

Enables complex ontology querying and management using the Ontology Access Kit (OAK) for semantic data integration and knowledge graph applications.

Guides consistent ontology term creation and maintenance using Dead Simple Ontology Design Patterns for structured data modeling.

Systematic methodology for creating compact, expressive prompts for Claude Code subagents using lambda contracts and symbolic logic, validated for agent composition and tool integration.

Validates methodology effectiveness through historical data analysis with statistical confidence, avoiding live deployment to reduce time and cost.

Optimizes project iteration planning using a prediction model, reducing time by 40-60% when baseline metrics and domain scope are met.