Data & Analytics

prism-shadow Skill

ApexCloud Retention Operations — CRM Retention Analytics Skill

prism-shadow Bundle

Audit a Cedar Ridge Intake Coordination Portal batch (patients, referrals, transfers, or program candidates) and return a single JSON object that conforms to a staged answer_template.json. Use for any task pointing at the Cedar Ridge portal that demands template-conformant, controlled-vocabulary JSON output with cohort/summary counts.

prism-shadow Bundle

Produces a structured JSON determination, disposition, summary, or correction packet for a Northstar Health Plan payer-operations work item. Use whenever a task asks for a UM-nurse prior-authorization determination, pharmacy coverage appeal and/or manufacturer-assistance intake disposition, payment-integrity claim repricing packet, peer-to-peer (P2P) final summary, or UM-finance margin-queue summary — i.e. any task that supplies a prompt plus a task_context.json and an answer_template.json and expects a single JSON object back from the shared Northstar payer-operations environment. Covers reaching the environment only over the network (SQL endpoint + bearer token + open business endpoints), reconciling conflicting evidence via the domain source-precedence rule, evaluating criteria, classifying evidence vs excluded records, and assembling the basis_audit trail.

prism-shadow Bundle

Produces a structured JSON deliverable for an M&A deal-review task driven by the running deal workbench — asset/stock purchase agreement issue registers, SPA closing & economics packages, carveout transition reviews, M&A committee escalations, and SPA deviation matrices. Use when a task casts you as buyer-side or seller-side counsel, points you at a deal workbench reachable over the network, asks you to compare draft terms against a playbook or committee policy, classify issues by status/risk, quantify dollar exposure from the purchase price, and return only JSON conforming to a shipped answer_template.json. Reads base URL and read-only SQL token from environment_access.md and never imports another deal's schema, IDs, or values.

prism-shadow Bundle

Solve Public Health Observatory (PHO) registered algorithmic audit tasks. Fetch evidence from the read-only PHO Web portal, resolve final releases/revisions, build cohorts, run the declared deterministic statistical modules in order, apply the controlled decision, and emit exactly one JSON object conforming to answer_template.json. Use when a task provides analysis_request.json + answer_template.json and references the PHO portal (TASK_ENV_BASE_URL), asking for a reproducible multi-module audit (release/cohort resolution, regression/ridge/elastic-net, wild bootstrap, conformal, PCA/clustering, perturbation/sensitivity/mediation) ending in a controlled classification.

prism-shadow Skill

ApexCloud Retention Operations — Self-Serve Analytics

prism-shadow Skill

ApexCloud Retention Operations — Self-Service Analytics Skill

prism-shadow Bundle

Produce a structured JSON determination for a Northstar Health Plan payer-operations task by reading its inputs and querying the shared read-only payer-ops environment (SQLite-backed portal with a POST /sql/query endpoint plus GET /api business endpoints). Use when a task packet gives a prompt.txt + task_context.json + answer_template.json that references the Northstar payer operations environment and asks for JSON matching the template. Covers the five archetypes: UM prior-authorization nurse determination, pharmacy coverage appeal + manufacturer-assistance intake, payment-integrity claim repricing, peer-to-peer (P2P) final summary, and service-margin queue analysis. Triggers: "Northstar", "payer operations", "prior authorization", "UM nurse", "determination", "coverage appeal", "manufacturer assistance", "claim repricing / benchmark", "peer-to-peer", "service margin queue", "pa-review-token", "basis_audit".

prism-shadow Bundle

Produce a structured JSON determination for a Northstar Health Plan payer-operations work item (UM prior-auth nurse review, pharmacy coverage appeal + manufacturer assistance intake, payment-integrity claim repricing, peer-to-peer closure, or UM-finance margin-queue review) by reading the task's own answer_template, querying the shared read-only payer-operations environment, and mapping the environment records into the exact output contract. Use whenever a task hands you a prompt.txt + payloads/task_context.json + payloads/answer_template.json referencing a Northstar / payer-operations environment reachable at <TASK_ENV_BASE_URL> with a POST /sql/query endpoint.

prism-shadow Bundle

Produce a structured Northstar Health Plan payer-operations determination from a task packet (prompt.txt + task_context.json + answer_template.json) by querying the shared read-only operations environment and returning a single JSON object that conforms to the task's answer_template. Covers five recurring work types — UM prior-authorization nurse determinations, pharmacy coverage appeals + manufacturer-assistance intake, payment-integrity claim repricing, peer-to-peer (P2P) final summaries, and UM-finance margin-queue analysis — plus their shared basis_audit trail. Use whenever a task references a `<TASK_ENV_BASE_URL>` environment with a `POST /sql/query` endpoint and asks for JSON matching an answer_template.

prism-shadow Bundle

Produce the strict JSON answer for a GDPEVO "licensing review" task — a regulatory decision (contractor eligibility, restricted liquor package, or alcohol renewal queue) computed from a live licensing data service. Use when a prompt casts you as a licensing examiner/reviewer, points at a task environment (an environment_access.md with a base URL, GET endpoints under /api/{contractor,liquor,alcohol,renewal,policies}, and POST /api/sql), and asks for JSON matching an answer_template.json. Triggers: "licensing examiner/board", "eligibility batch", "restricted liquor license", "renewal manual-review queue", "answer_template.json", "contractor applications", "X-Task-Token".

prism-shadow Bundle

Produce the structured JSON decision for a State licensing review task by reading records from the shared licensing HTTP environment. Covers three task families served by the same environment: (1) contractor batch eligibility reviews, (2) restricted liquor-license staff packages, and (3) alcohol renewal manual-review queues. Use whenever a prompt asks for a JSON answer conforming to input/payloads/answer_template.json against endpoints like /api/policies, /api/contractor/*, /api/liquor/*, /api/alcohol/*, /api/renewal/rules, or POST /api/sql.

prism-shadow Bundle

Produce the answer.json for an Atlas Commerce Operations workplace task — the request family that hands you a prompt.txt plus a payloads/ request contract and answer_template.json, and points at an authenticated Atlas service (GET /api/schema, GET /api/data-dictionary, POST /api/sql, POST /api/sql/transaction, GET /api/correction-audit). Use when a /work task asks for a fulfillment scorecard, refund/settlement reconciliation, carrier-quality correction, warehouse-productivity review, support-health review, or any similar cutoff-based operational scorecard, reconciliation, correction, or SLA/risk classification computed from the Atlas read-only SQL (and, when explicitly requested, the controlled transaction) endpoints.

prism-shadow Bundle

Produce cutoff-based operational reports and authorized data corrections from the Atlas Commerce Operations workplace database. Use when a task points at a `<TASK_ENV_BASE_URL>` Atlas service with GET /api/schema, GET /api/data-dictionary, POST /api/sql (read-only) and POST /api/sql/transaction, ships a request-facts payload plus an answer_template.json JSON-Schema, and asks for one exact answer.json — e.g. fulfillment scorecards, refund/settlement reconciliations, warehouse productivity reviews, support-health reviews, or carrier-quality canonical corrections.

prism-shadow Bundle

Solve Public Health Observatory (PHO) reproducible / transportability / robustness / mediation audit tasks that ship an analysis_request.json plus an answer_template.json and require pulling evidence only from the read-only PHO web portal named in environment_access.md (<TASK_ENV_BASE_URL>). Use whenever a task asks for a "registered audit", "algorithmic transportability audit", "six-module audit", "robustness gates", "controlled decision/classification", release/revision resolution, cohort construction, or deterministic statistical modules (fixed effects, ridge/elastic-net nested CV, wild cluster bootstrap-t, split/grouped conformal, trajectory PCA + k-means, GMM, Shapley, partial-R2 sensitivity) whose result must be returned as ONE JSON object conforming to a supplied answer template.

prism-shadow Bundle

Solve Public Health Observatory (PHO) registered algorithmic-audit tasks. Use when a task gives an analysis_request.json plus an answer_template.json and points to a read-only PHO web portal (state/county/country health & socioeconomic data), asking for a multi-module statistical audit — release/cohort resolution, fixed-effects / GMM / ridge / elastic-net, nested cross-validation, wild cluster bootstrap-t, split/grouped conformal, trajectory PCA + deterministic k-means stability, source perturbation / Shapley — returned as one JSON object conforming to the template. Recompute every value live from the portal; never reuse numbers across tasks.

prism-shadow Bundle

Answer portfolio-analytics tasks against the shared portfolio environment (work items, mix targets, SLA policy, releases, milestones, dependencies, blockers, and a restricted SQL query endpoint described in environment_access.md). Use for: quarterly portfolio-mix / investment-mix reviews against a target mix; SLA aging / breach / escalation audits; and release-readiness (ship decision) assessments. Handles the environment's authoritative-vs-stale field conventions, category classification, duplicate and cancelled exclusion, date windows, and produces a single JSON object that matches the task's answer_template.json.

prism-shadow Skill

ApexCloud Retention Analytics — Reflect-3 Skill

prism-shadow Skill

CRM Retention Analytics Skill

prism-shadow Skill

CRM Retention Analytics Skill

prism-shadow Bundle

Resolve CRM service-ticket / support-queue tasks against the shared read-only support-console API. Use this whenever a task asks you to act as a support operations analyst, contact-center lead, queue-quality analyst, mobile-data recovery analyst, or enterprise support lead and to "resolve", "classify", "route", "triage", or "produce a structured response/summary" for tickets, cases, mobile lines, or enterprise export incidents, returning JSON that conforms to a provided answer_template.json. Trigger it for any payload of service tickets, a case/queue snapshot (CSV or JSON), a mobile worklist, or an enterprise complaint email, even if the prompt does not name this skill — the decisions must come from support-console records, never from assumptions.

prism-shadow Bundle

Solve Northwind Components ERP operations tasks against the shared read-only ERP API: expedite/dispatch decisions, mixed-warehouse allocation and transfer waves, kit-build replenishment (BOM coverage, transfers, purchase requisitions), supplier incident scorecards, and supplier quality-hold / replenishment-control reviews. Use this skill whenever a task references the Northwind Components ERP, a "wave", an expedite/allocation/ dispatch queue, a BOM/kit build, a supplier incident scorecard, a quality-hold review, effective inventory availability, shipping quotes, or asks for a structured JSON decision file built from /orders, /products, /inventory, /customers, /suppliers, /warehouses, /boms, /purchase_orders, /incidents, or /shipping/quote — even if the task only mentions a memo, planning extract, or answer_template.json. The local memo/extract is planning context only; the live API is the source of truth.

onfire7777 Bundle

Automate Gong conversation intelligence -- retrieve call recordings, transcripts, detailed analytics, speaker stats, and workspace data -- using natural language through the Composio MCP integration.

onfire7777 Bundle

Excel Automation: create workbooks, manage worksheets, read/write cell data, and format spreadsheets via Microsoft Excel and Google Sheets integration

onfire7777 Bundle

Automate Snowflake data warehouse operations -- list databases, schemas, and tables, execute SQL statements, and manage data workflows via the Composio MCP integration.

pyfagorass Skill

Google Sheets: Append a row to a spreadsheet.

pyfagorass Bundle

Analyze git repositories to build a security ownership topology (people-to-file), compute bus factor and sensitive-code ownership, and export CSV/JSON for graph databases and visualization. Trigger only when the user explicitly wants a security-oriented ownership or bus-factor analysis grounded in git history (for example: orphaned sensitive code, security maintainers, CODEOWNERS reality checks for risk, sensitive hotspots, or ownership clusters). Do not trigger for general maintainer lists or non-security ownership questions.

pyfagorass Skill

Append a deal status update to a Google Sheets sales tracking spreadsheet.

onfire7777 Bundle

Automate customer engagement workflows including broadcast triggers, message analytics, segment management, and newsletter tracking through Customer.io via Composio

pyfagorass Bundle

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

pyfagorass Skill

Google Sheets: Read values from a spreadsheet.

prism-shadow Bundle

Solve State Licensing Board structured-review tasks (contractor application eligibility, restricted-liquor staff packages, alcohol renewal manual-review queues) against the shared licensing data service. Read this BEFORE drafting any candidate answer — it covers how to read the environment, the decision logic per task family, output-conformance rules, and how to iterate one candidate at a time using only score/correct feedback. Use only the allowed GET endpoints and the SQL endpoint; never call any judge/scoring endpoint while solving a real (non-train) task.

prism-shadow Bundle

Solve Atlas Commerce Operations cutoff-based analytics scorecard tasks — fulfillment, refund, carrier-quality, warehouse-productivity, and support-health reviews produced from a live read-mostly SQL workplace service. Use at the start of any task whose input is a prompt.txt + a JSON request (scope + business definitions) + an answer_template.json output contract, backed by an authenticated SQL/schema/data-dictionary service.

prism-shadow Skill

ApexCloud Retention Operations API — CRM Analytics Skill

prism-shadow Skill

CRM Retention Analytics Skill

prism-shadow Skill

CRM Retention Analytics — Action Board Generation