Skills

Reviews applications and data flows for common privacy-regulation obligations (GDPR, CCPA/CPRA). Maps what personal data is collected, where it flows, and how long it is retained; checks for lawful basis, consent handling, data-subject rights, and third-party sharing; and produces a prioritized remediation list. Provides engineering guidance, not legal advice.

Writes conversion-focused ad copy for search, social, and display. Crafts headlines and descriptions within platform character limits, leads with a clear benefit and hook, matches message to audience and funnel stage, and produces multiple variants for A/B testing. Keeps claims honest and includes a strong, specific call to action.

Designs surveys that produce reliable, unbiased data. Turns research goals into clear questions, chooses appropriate scales and response types, avoids leading and double-barreled wording, orders questions to reduce bias, and plans screening and branching logic. Outputs a ready-to-field questionnaire with an analysis plan for each question.

Builds disaster recovery and business continuity plans for systems and data. Defines RTO and RPO targets, maps critical dependencies, chooses backup and replication strategies, documents failover and restore procedures, and designs a testing cadence with game days. Produces a plan that balances resilience against cost and operational complexity.

Drafts email newsletters that get opened and read. Writes subject lines and preview text, structures the issue with a clear lead, scannable sections, and a single primary call to action, and adapts tone to the audience. Can turn a list of updates or links into a cohesive issue and suggest send-time and segmentation tips.

Turns analysis results into a clear narrative for a specific audience. Selects the key message, orders findings for impact, recommends the right chart for each point, writes plain-language takeaways, and frames actionable recommendations. Helps analysts move from raw numbers to a memo or slide narrative executives can act on.

Designs caching strategies across the stack to cut latency and load. Chooses cache layers (browser, CDN, application, database), picks patterns (cache-aside, read-through, write-through, write-behind), sets TTLs and eviction policies, and plans invalidation to avoid staleness and stampedes. Produces a layered plan with keys, TTLs, and invalidation rules.

Plans authorized penetration tests for systems you own or are permitted to assess. Defines scope, rules of engagement, and objectives; maps the attack surface; structures phases (recon, mapping, exploitation, post-exploitation, reporting) around a framework like the OWASP Testing Guide or PTES; and specifies safe handling of findings. Emphasizes explicit authorization and non-destructive testing.

Turns customer results into a persuasive, credible case study. Structures the story as challenge, solution, and measurable results, weaves in quotes and concrete metrics, keeps claims verifiable, and ends with a clear call to action. Produces a publish-ready draft plus a one-paragraph summary and pull-quote suggestions.

Helps turn a game concept into a structured game design document. Captures the core loop, mechanics, progression, economy, controls, level structure, art and audio direction, and target platform and audience. Keeps scope realistic, flags dependencies and risks, and produces a living GDD that a small team can build from.

Designs and implements rate limiting for APIs and services. Recommends an algorithm (token bucket, leaky bucket, fixed or sliding window) for the use case, defines per-key and per-endpoint limits, plans distributed enforcement with Redis, and specifies response headers and 429 handling with retry-after. Produces a design plus reference implementation.

Generates and refactors dbt models for analytics engineering. Writes staging, intermediate, and mart models following layered conventions, adds schema.yml tests and descriptions, applies incremental and materialization strategies, and structures sources and refs correctly. Produces SQL plus YAML that fits dbt best practices and is ready to run.

Produces structured test plans for features and releases. Defines scope and objectives, derives test cases from requirements and acceptance criteria, covers functional, edge, negative, performance, and accessibility cases, sets entry/exit criteria, and maps risk to test priority. Outputs a clear plan with a traceability matrix linking tests to requirements.

Writes idempotent Ansible playbooks and roles from a described target state. Structures tasks with proper handlers, variables, and templates; favors modules over shell commands; applies role-based layout and inventory grouping; and adds check-mode safety and tags. Produces playbooks that are re-runnable without unintended side effects.

Sets up and maintains Git hooks for a repository. Recommends a manager (Husky, Lefthook, or pre-commit), wires up pre-commit and commit-msg hooks for linting, formatting, type checks, secret scanning, and conventional-commit validation, and keeps hooks fast with staged-file filtering. Produces config plus a short contributor guide.

Builds discovery and usability interview guides that surface real insight. Translates research questions into open, non-leading prompts, sequences warm-up to deep-dive topics, adds follow-up probes, and applies techniques like the "five whys" and past-behavior questions. Outputs a timed guide with a consent intro and a synthesis template for notes.

Creates accessible color palettes for brands and UIs from a brief or a seed color. Produces primary, secondary, and neutral scales with hex values, suggests semantic tokens (success, warning, error, info), and checks foreground/background pairings against WCAG contrast ratios. Outputs ready-to-use CSS variables or design tokens.

Helps process a busy inbox quickly. Categorizes messages by urgency and type, extracts action items and deadlines, drafts short reply options, and proposes an order to handle them. Summarizes long threads into the decision needed and flags anything sensitive or requiring escalation, so you can clear the inbox with fewer decisions.

Explains what a SQL query does in plain language and how it executes. Breaks down joins, subqueries, CTEs, and window functions step by step, describes the result set, reads EXPLAIN/EXPLAIN ANALYZE output to identify slow scans and missing indexes, and flags correctness pitfalls. Helps developers understand, review, and trust unfamiliar SQL.

Builds structured competitive analyses from public information. Maps competitors across positioning, pricing, features, target segments, and go-to-market motion; produces feature-comparison matrices and SWOT summaries; and highlights differentiation gaps and opportunities. Emphasizes citing sources and separating verified facts from inference.

Helps make and document structured decisions. Elicits the options and the criteria that matter, assigns weights, scores each option, computes a weighted result, and runs a quick sensitivity check to show how robust the recommendation is. Produces a clear matrix plus a short written rationale suitable for an ADR or decision log.