Browse Skills

Build production-grade AI-powered features using the Vercel AI SDK with streaming responses, structured outputs, tool calling, and multi-provider support in Next.js applications.

Expert in MongoDB production systems — document modeling, aggregation pipelines, sharding, indexing strategy, Atlas operations, and migration from relational databases.

Expert guidance for building and optimizing Looker LookML models, Explores, and dashboards. Covers semantic layer design, derived tables, performance optimization, and governance patterns for scalable self-serve analytics.

Guide practitioners through selecting, designing, and interpreting statistical hypothesis tests with proper assumptions checking, sample size calculations, and actionable conclusions.

Designs production-grade Retrieval-Augmented Generation pipelines including chunking strategies, embedding model selection, vector database architecture, hybrid search, reranking, and hallucination reduction techniques.

Ensure offline/online feature consistency in ML systems by designing validation pipelines, detecting training-serving skew, and implementing point-in-time correctness guarantees across feature store architectures.

Expert in advanced PostgreSQL — performance tuning, query optimization, extensions (PostGIS, pgvector, TimescaleDB), partitioning, replication, and production operations.

Prepare research outputs for public sharing and long-term preservation with FAIR-compliant data packaging, reproducible environments, proper licensing, and repository publication strategies.

Design and analyze rigorous policy impact evaluations using causal inference methods including difference-in-differences, regression discontinuity, synthetic control, and propensity score matching.

Designs dimensional data warehouse schemas using Kimball, Inmon, or Data Vault methodologies. Guides star/snowflake schema design, slowly changing dimensions, ETL/ELT patterns, and cloud warehouse optimization for Snowflake, BigQuery, and Redshift.

Expert regression analysis guidance covering model selection, diagnostics, regularization, and causal inference across OLS, GLM, and ML techniques.

Designs and enforces formal data contracts between producer and consumer teams, implementing schema governance, automated quality testing, and graduated enforcement strategies to ensure upstream data discipline.

Analyzes and optimizes Elasticsearch query performance, index mappings, and cluster configurations to achieve faster search latency and lower resource consumption.

Guides the design, development, testing, and deployment of custom PostgreSQL extensions using C, Rust (pgrx), or trusted languages (pg_tle) with proper type systems, index integration, and upgrade paths.

Design AI agent systems with precisely calibrated human oversight, mapping every action to the right autonomy level — from fully automatic to synchronous approval — using established frameworks for trust calibration, escalation policies, and audit trail architecture.

Guides geospatial data analysis including GIS fundamentals, PostGIS spatial queries, coordinate systems, geocoding, spatial indexing, and map visualization. Helps design location intelligence solutions and spatial analytics workflows.

Expert guidance for building high-performance analytical queries and data pipelines using DuckDB, the embedded OLAP database engine with columnar storage and vectorized execution.

Designs normalized event tracking schemas for product analytics, defining event taxonomies, property standards, and validation rules to ensure consistent data collection across teams.

Designs real-time analytics systems using stream processing frameworks like Kafka Streams, Apache Flink, and Spark Streaming. Covers event-time processing, windowing strategies, exactly-once semantics, and low-latency dashboard architectures.

Helps users evaluate AI-generated nutrition advice for safety risks, recognize dangerous diet recommendations, identify eating disorder triggers in AI output, and know when to consult a registered dietitian.

Guides decisions on when and how to fine-tune large language models, covering LoRA/QLoRA, dataset curation, RLHF/DPO alignment, evaluation strategies, and cost-performance tradeoffs for production deployments.

Create publication-quality static figures with Matplotlib and interactive web-ready visualizations with Plotly, guided by visual perception research and data storytelling principles.

Guides analytics engineering best practices using dbt, SQL modeling patterns, semantic layers, metrics definitions, and testing strategies. Helps design maintainable, well-documented analytics workflows from raw data to business-ready datasets.

Designs measurable outcome indicator frameworks for social impact programs, including theories of change, logic models, SMART indicators, and results-based monitoring systems.