williamcorrea23
- 806 skills
- 0 followers
- 2 repo stars
- 2 days ago last updated
- ▌ Sap Oracle Dataguard · williamcorrea23 bundleOracle Data Guard under SAP — what SAP actually permits, which is narrower than Oracle's own documentation: physical standby only (logical is forbidden), the Broker, the three protection modes and the Maximum Protection trap that terminates the primary, Fast-Start Failover (permitted but unsupported), Active Data Guard and Far Sync licensing, and the read-only rule that blocks starting an SAP instance on a standby. Covers the DGMGRL command surface, BR*Tools interaction and standby backups. Use for "Oracle Data Guard SAP", "physical standby", "DGMGRL", "switchover", "failover", "Maximum Availability", "ORA-16724", "is Data Guard supported by SAP".
- ▌ Speckit Constitution · williamcorrea23Create or update the project constitution from interactive or provided principle inputs.
- ▌ Sap Software Download · williamcorrea23 bundleFind, qualify and download SAP software from the SAP for Me Software Center — Support Packages, kernel and patches, installation media, add-ons — and build a correct SP import queue. Resolves a component (e.g. "ST-PI 740") to exact filenames, object keys, sizes, SHA-256 checksums, the required SPAM/SAINT level and the EPS .PAT name via the Software Center's OData service, then covers where files go and how to verify them. Downloads are scriptable with X.509 client-certificate auth. For add-ons it walks the INSTALLATION vs EXCHANGE-UPGRADE tree. Use for "download a support package", "which SP is latest", "get the kernel SAR", "SP queue from SP28 to latest", "software center", "automate SAP downloads", "SAPCAR extract", "EPS/in", "SAINT installation package".
- ▌ Speckit Taskstoissues · williamcorrea23Convert existing tasks into actionable, dependency-ordered GitHub issues for the feature based on available design artifacts.
- ▌ Engine Cap Development · williamcorrea23This skill should be used when creating, auditing, testing, or deploying SAP CAP projects in the EngineBR Azure DevOps standard. It covers the Engine QuickStart, CAP scaffold, Azure CI/CD, branch policies, BTP Cloud Foundry DEV deployment, and existing QM project adaptation.
- ▌ Sap Sqlserver Alwayson · williamcorrea23 bundleSQL Server Always On Availability Groups under SAP NetWeaver — listener-based connection configuration (SAPDBHOST, dbs/mss/server, MSSQL_SERVER, MultiSubnetFailover and the case-sensitive JDBC parameter), why logins must be created by SWPM "Configure additional Always On Node" and never manually, the readable-secondary rules including the unsupported "Yes" setting, sync vs async and the latency guidance, WSFC without shared disks, and per-node failover verification. Also covers Database Mirroring. Use for "SQL Server AlwaysOn SAP", "availability group", "listener", "MultiSubnetFailover", "readable secondary", "SAP cannot connect after failover", "error 976".
- ▌ Sap Hana Lifecycle Tools · williamcorrea23 bundleThe two HANA command-line tools outside SQL — hdblcm for install, update, add/remove hosts, host roles, internal network and SLD registration (resident vs media, --action, batch mode), and hdbcons for expert diagnostics when SQL is unavailable: runtime dumps, call stacks, memory analysis, savepoints, log release. Use for "hdblcm", "add host HANA", "update HANA revision command line", "hdbcons", "runtime dump", "HANA hangs SQL not possible", "call stack HANA", "mm ipmm", "log release", "cons.crashdump".
- ▌ Sap Client Copy Accelerator · williamcorrea23 bundleRescue an SAP client copy (SCC9 / SCCL / SCC7) that has stalled or is crawling on ONE huge table — ACDOCA, BSEG, FAGLFLEXA, MATDOC, COEP — by moving the rows database-natively instead: batched DELETE, then parallel INSERT...SELECT partitioned by fiscal year, on HANA (Smart Data Access) or Oracle (database link). Diagnoses FIRST and exhausts the supported levers before bypassing anything; gates cross-database access on explicit licence confirmation. Use for "client copy slow", "client copy stuck", "SCC9 stuck on ACDOCA", "SCCL stuck", "accelerate client copy", "client refresh running for days", "SDA table copy", "client copy ETA 13 hours" — even when the user only says the refresh will miss its window.
- ▌ Sap Hana System Replication · williamcorrea23 bundleConfigure, operate, monitor and take over HANA System Replication — the full hdbnsutil set (sr_enable, sr_register, sr_takeover, sr_unregister, sr_changeReplicationMode, sr_state), replication and operation modes, multitier and multitarget, Active/Active read-enabled, takeover with handshake, failback, and the systemReplicationStatus / getTakeoverRecommendation checks. Establishes the revision BEFORE quoting a command, since syntax and defaults differ across HANA 1.0 SPS09-12 and 2.0 SPS01-08. Covers HA/DR provider hooks and SAPHanaSR vs SAPHanaSR-angi. Use for "set up HANA replication", "register secondary", "HSR takeover", "failback", "replication is out of sync", "logreplay vs delta_datashipping", "multitarget replication", "Active/Active read enabled".
- ▌ Sap Sscr Keys · williamcorrea23 bundleSAP Software Change Registration (SSCR) — developer keys and object keys. Decide whether the system even needs them (S/4HANA, BW/4HANA and AS ABAP 7.51+ do not; NetWeaver 7.50 and below do), gather the parameters a key binds to, request them in SAP for Me, handle the 14-day post-upgrade SPAU grace window, and reassign/restore keys with RS_SSCR_KEY_UPLOAD. Covers DEVACCESS and ADIRACCESS and why you must never edit them by hand. Use for "developer key", "object key", "access key", "SSCR", "key required to modify SAP object", "register developer", "SPAU asking for object keys".
- ▌ Speckit Tasks · williamcorrea23Generate an actionable, dependency-ordered tasks.md for the feature based on available design artifacts.
- ▌ Sap Crypto Pse · williamcorrea23 bundlesapgenpse and CommonCryptoLib — managing the PSEs behind SNC and SSL/TLS: get_pse, gen_pse, import_own_cert, export_own_cert, maintain_pk, seclogin, the PSE/cred_v2 pairing that causes "works as one user, fails as another", SECUDIR, PSE types, SAProuter certificate renewal, HSM-backed PSEs. Use for "sapgenpse", "PSE", "SNC certificate", "SSL certificate SAP", "import_own_cert", "seclogin", "cred_v2", "SECUDIR", "renew SAProuter certificate", "GSS-API no credentials". Linux/Windows/AIX.
- ▌ Sap Nw Java Pi · williamcorrea23 bundleSAP NetWeaver AS Java and PI/PO operations — NWA, the J2EE sapcontrol functions, jcmon and the telnet admin shell on 5<nr>08 as out-of-band channels, the AS Java log set (defaultTrace, std_server*.out, dev_jcontrol), and on PI: PIMON, message monitoring, the EOIO stuck-message decision tree, CPA cache and adapter traces. Explains why JCo is the WRONG tool for AS Java and what the real programmatic surfaces are (SOAP web services, monitor servlets, sapcontrol SOAP, JMX/P4, telnet). Use for "AS Java", "NWA", "PIMON", "PI message stuck", "To be delivered", "EOIO HOLD", "CPA cache refresh", "ESR", "Integration Directory", "defaultTrace", "server0", "adapter trace".
- ▌ Speckit Analyze · williamcorrea23Perform a non-destructive cross-artifact consistency and quality analysis across spec.md, plan.md, and tasks.md after task generation.
- ▌ Speckit Clarify · williamcorrea23Identify underspecified areas in the current feature spec by asking up to 5 highly targeted clarification questions and encoding answers back into the spec.
- ▌ Speckit Specify · williamcorrea23Create or update the feature specification from a natural language feature description.
- ▌ Sap Support Case · williamcorrea23 bundleRaise an SAP support case (incident) properly — earn it first by exhausting the supported remedies, route it to the right component using SAP's own routing KBAs rather than the component name the error text happens to print, gather the IDs SAP will ask for (correlation ID, formation/job ID, troubleshooting key), set an honest priority against SAP's published definitions, and get the subject and description right BEFORE submitting — the case wizard buries them in an early step and will happily submit a stale description written before you fixed half the problem. Covers the multi-step case wizard's navigation traps, the business-impact fields that unlock at High, the troubleshooting key as a customer consent decision, and what to do when a case goes out wrong. Use this whenever raising, drafting, routing or correcting an SAP case or incident, and for "raise an SAP ticket", "open a case with SAP", "create SAP incident", "which component should I use", "case priority high or medium", "SAP wants a correlation ID",
- ▌ Speckit Converge · williamcorrea23Assess the current codebase against the feature's spec, plan, and tasks, then append any remaining unbuilt work as new tasks to tasks.md so implement can complete it.
- ▌ Sap Gui Landscape · williamcorrea23 bundleCentral SAP GUI landscape configuration — SLMT (report RSLSMT) and the SAPUILandscape.xml / SAPUILandscapeGlobal.xml files SAP Logon, Business Client and SAP GUI for Java read: maintaining them centrally, distribution by UNC or HTTP(S), the LandscapeFileOnServer registry keys and HKCU-vs-HKLM precedence, and the full connection-string grammar (/H/ /S/ /M/ /G/ router chains) including SNC parameters. Also Windows client deployment: SAPSetup / NwSapSetup, silent install, AWUS, frontend SNC (SNC_LIB, SNC_LIB_64). Use for "SLMT", "SAPUILandscape.xml", "distribute SAP GUI connections", "connection string", "SAP GUI for Java SNC", "sncqop", "logon group not working", "NwSapSetup", "silent install SAP GUI", "SNCERR_UNKNOWN_MECH".
- ▌ Sap Space Reclaim · williamcorrea23 bundleLandscape space-reclamation assessment — what can be deleted, what has a configurable retention, what is self-service vs change-controlled, and how much disk you actually get back. Covers ABAP technical tables (spool/TemSe, table logging, application log, job logs, dumps, IDoc/RFC queues, workload stats, change documents), the Security Audit Log archive/delete path, per-database diagnostic files and crash dumps across all six platforms, and OS-layer leftovers (work-directory traces, core dumps, old kernels, SUM directories, installation media). Honest that deleting rows does not shrink a database without reorganization. Use for "database is full", "reclaim disk", "what can we clean up", "retention settings", "core dumps", "db2diag", "adrci", "DBTABLOG huge", "TST03 huge".
- ▌ Speckit Checklist · williamcorrea23Generate a custom checklist for the current feature based on user requirements.
- ▌
- ▌ Verification Loop · williamcorrea23Verify SAP Router changes and agent outcomes with bounded loops, independent checks, PASS/FAIL/NOT_RUN evidence, and explicit separation of offline results from observed SAP field responses.
- ▌ Sap Os Executables · williamcorrea23 bundleThe SAP executables that cross the OS/ABAP boundary — sapevt to raise background-processing events from outside SAP (it needs no dialog work process, so it triggers work when nobody can log on), sapxpg as the controller behind SM49/SM69/DB13/SXPG_COMMAND_EXECUTE with its Y/Z privilege boundary and S_LOG_COM, and sapinst unattended with an inifile. Use for "sapevt", "raise SAP event from script", "trigger job when SAP GUI is down", "sapxpg", "SM49", "SM69", "external command failed", "SXPG_COMMAND_EXECUTE", "sapinst", "SWPM unattended". Linux/Windows/AIX.
- ▌ Sap Compliance Docs · williamcorrea23 bundleMap an SAP landscape or subscription to the governance, certification and usage-rights documents that apply to it — the Trust Center Compliance Finder, the certification catalogue (ISO 27001/27017/27018/27701/42001, SOC 1/2 and bridge letters, C5, PCI DSS, CSA STAR, TISAX, GxP, FedRAMP, IRAP, NIS2), AI governance, ALM usage rights (Cloud ALM, Solution Manager, Focused Run, Tricentis), and the contract stack (order form, CSD/SDG, DPA, GTC, SLAs, TOMs). Use for "which ISO certificate covers my service", "SOC 2 report for", "compliance finder", "trust center", "do we need to license Focused Run", "service description guide", "SLA document", "DPA", "what did we actually buy". Locates authoritative documents — not legal or licensing advice.
- ▌ Sap Dormant Clients · williamcorrea23 bundleAssess whether a client is genuinely dormant and retire it safely — 000/001/066 and abandoned project/sandbox clients. Builds evidence from last logon (RSUSR200/SUIM), ST03N workload statistics, jobs (TBTCO/TBTCP), change documents and client-specific table volumes, then deletes with SCC5 (test run first) and handles what it leaves behind — TemSe, spool, T000, SAP*. Use for "can we delete client 001", "is client 066 still needed", "dormant client", "unused client", "SCC5", "client cleanup".
- ▌ Sap Troubleshooting · williamcorrea23 bundleMethod and rules of thumb for troubleshooting any SAP issue — establish the facts, enumerate EVERY relevant log/trace source (SM21, ST22, SLG1, ST01/STAUTHTRACE, ST05, RSAU_READ_LOG, SM58/SMQ1, /IWFND/ERROR_LOG, Java defaultTrace, kernel dev_* traces, DB and OS logs), correlate by timestamp, ask what changed, and escalate to SAP with the right evidence. Use whenever something is broken, slow, failing intermittently, or "worked yesterday" — before reaching for a restart. Pairs with sap-log-reference and sap-health-triage.
- ▌ Claude Mem · williamcorrea23 bundlePersistent cross-session memory architecture for AI coding agents. Captures session activity, generates AI-compressed observations, maintains searchable timeline indexes, and provides progressive 3-layer context retrieval across restarts.
- ▌ Sap Btp CLI · williamcorrea23 bundleSAP BTP command-line administration — the btp CLI (subaccounts, directories, entitlements, role collections, environments, service instances) and the cf CLI as SAP uses it, including the MultiApps plugin (deploy, bg-deploy, rollback-mta, undeploy) and mbt. Use for "btp CLI", "btp login", "create subaccount", "assign entitlement", "role collection", "cf CLI", "cf push", "deploy MTA", "mtar", "blue-green deploy", "mbt build".
- ▌ Sap Ase Hadr · williamcorrea23 bundleSAP ASE (Sybase) HADR / Always-On built on SAP Replication Server — the RMA command surface (sap_status, sap_failover, sap_materialize), setuphadr, the Fault Manager, split-brain and when `force` is legitimate, sync vs async, the three-node DR topology. Use for "ASE HADR", "Sybase high availability", "Always-On", "ASE failover", "companion server", "split-brain ASE", "setuphadr". NOT HANA System Replication.
- ▌ Sap Db2 Hadr · williamcorrea23 bundleIBM Db2 for LUW HADR under SAP — synchronization modes, multiple standbys and HADR_TARGET_LIST, VIP vs Automatic Client Reroute, cluster automation with SA MP or Pacemaker, takeover and the Graceful Maintenance Tool, rolling Fix Packs, Reads on Standby, and the non-logged operations that silently invalidate a standby. Use for "Db2 HADR", "DB6 HADR", "takeover", "standby database Db2", "HADR_SYNCMODE", "peer state", "automatic client reroute", "db2haicu", "rolling fix pack", "SQL1776N".
- ▌ Sap Hana Xsa · williamcorrea23 bundleSAP HANA XS Advanced operations — `xs` for normal work and `XSA` for local maintenance when remote access is gone (diagnose, collect-traces, restart, du, list-tenants). Covers the org/space model, routing mode (unchangeable after installation), the app-working directory and its sizing, global_allocation_limit, certificate expiry, tenant-database registration and the joint-recovery backup rule, and XSA under HANA System Replication. Use for "xs CLI", "XSA", "xs login", "xs apps", "XSA diagnose", "xscontroller not starting", "xs command not found", "routing mode", "app_working". NOT the BTP `cf` CLI.
- ▌ Sap Maxdb Ha · williamcorrea23 bundleSAP MaxDB, liveCache and Content Server HA/DR — the four mechanisms and when each is right: cluster failover (MSCS, UNIX agents, LifeKeeper), shadow/standby via log recovery, Hot Standby with a storage-vendor HSS library, and snapshot/split-mirror. Covers why SAP recommends a shadow database over Hot Standby for DR, the read-only Hot Standby constraint, hss_enable, the single-database limit in MSCS, and log-area mirroring rules. Use for "MaxDB high availability", "liveCache hot standby", "standby database MaxDB", "shadow database", "libHSS", "hss_enable", "MaxDB cluster", "APO liveCache HA".
- ▌ Sap Spec Kit · williamcorrea23 bundleApply GitHub Spec Kit 1.0.6 to SAP Router work. Use automatically for new features, contract or data-model changes, integrations, and multi-component SAP changes; use when the user explicitly requests Spec Kit or specification-driven development. Keep localized fixes and read-only work on the lightweight Karpathy path.
- ▌ Speckit Plan · williamcorrea23Execute the implementation planning workflow using the plan template to generate design artifacts.
- ▌ Sap Odata CLI · williamcorrea23 bundleQuery and inspect SAP OData services with the sap-odata CLI — service discovery, entity metadata and SAP/UI5 annotations, test queries, Fiori-readiness lint, service health checks, and offline EDMX browsing. Use when the user asks about SAP OData or Gateway services, entity sets, $metadata, SAP annotations, Fiori readiness, or wants live data samples from an SAP system.
- ▌ Valuation Integration 2 · williamcorrea23估值综合分析 — 整合多种估值方法(DCF/可比公司法/交易法), 确定估值区间,形成最终投资建议。 适用情形:M&A 投资决策、或者用户要求"综合估值"时执行。 核心:多方法估值 + 权重分配 + 谈判区间建议。
- ▌ Project New 2 · williamcorrea23新建项目 — 创建项目目录 + project.md 模板,引导填写项目信息。 适用情形:开始一个新的财务周期项目(年度审计启动、Q2 预算审查立项、税务申报周期开启)。 触发词:新建项目、创建项目、立项、新财年审计、Q2 预算立项、税务申报周期。 核心:项目类型选择 → 代码生成 → project.md 模板填充 → 关联场景激活。
- ▌ Project List 2 · williamcorrea23项目列表 — 扫描 ~/.config/finance-skills/projects/ 列出所有项目,标注状态、阶段、关键日期。 适用情形:开始工作时查看活跃项目、做周报时盘点所有项目状态、切换前确认项目代码。 触发词:项目列表、有哪些项目、活跃项目、项目状态总览。 核心:自动扫描 + 按状态分组(活跃/规划/报告/已关闭)+ 高亮下次关键日期。
- ▌ It Declaration Prep 2 · williamcorrea23企业所得税预缴/汇算申报准备 — 核对利润总额、应纳税所得额和应纳税额。 适用情形:季度预缴(季度结束后 15 日内)和年度汇算清缴(次年 5 月 31 日前)执行, 从 ERP 获取财务数据,核对申报表与账务差异,生成可提交的申报数据。 核心:会计利润 vs 税法收入的差异调整 + 税收优惠应享尽享。
- ▌ Tax Risk Assessment 2 · williamcorrea23税务风险自检 — 核查金税系统预警 + 发票风险 + 申报异常,输出风险清单和整改建议。 适用情形:定期(每月/每季度)执行,从金税系统获取风险预警, 结合发票数据和申报数据,识别须关注的税务风险点,制定整改计划。 核心:系统预警核实 + 根因分析 + 分级整改。
- ▌ Trend Analysis 2 · williamcorrea23趋势分析 — 分析业务/财务数据的趋势模式,识别周期性、季节性和结构性变化, 辅助业务预测和决策。 适用情形:用户要求"趋势分析"、"看历史走势"、"分析同比环比"时执行。 核心:时间序列分解 + 季节性识别 + 趋势预测 + 异常检测。
- ▌ Tax Filing 2 · williamcorrea23税务申报管理 — 从 [ERP] 获取税务数据,完成税务申报,跟踪缴纳状态。 适用情形:月度/季度税务申报时执行,从 [ERP] 获取申报数据, 核查申报准确性,确认缴纳,输出税务申报报告。 核心:税种覆盖 + 数据获取 + 申报审核 + 缴纳跟踪。
- ▌ Fx Exposure Calculation 2 · williamcorrea23外汇敞口计算 — 识别和量化公司面临的外汇风险敞口, 包括交易敞口、会计敞口和经济敞口的分类计算。 适用情形:季度外汇风险管理评估、投资决策前,或用户要求"计算 FX 敞口"时执行。 核心:敞口识别 + 金额量化 + 敏感性分析 + 报告生成。
- ▌ Financial Due Diligence 2 · williamcorrea23财务尽职调查 — 对目标公司进行全面的财务尽职调查,核实财务数据真实性、 评估资产质量、识别负债和风险,为投资/并购决策提供依据。 适用情形:M&A 交易前、战略投资前、或用户要求"做财务 DD"时执行。 核心:财务数据核实 + 资产质量评估 + 负债识别 + 风险量化。
- ▌ Vat Declaration Prep 2 · williamcorrea23增值税申报准备 — 核对销项/进项/应纳税额,生成可提交的增值税申报表。 适用情形:每月固定时间(如次月 1-5 日)执行,核对开票系统、 勾选平台和 ERP 账务数据,生成申报表数据,发现异常须升级。 核心:三方数据交叉核对 + 税负率预警 + 申报前最终确认。
- ▌ Survey Analysis 2 · williamcorrea23调研分析 — 设计并执行问卷/访谈/焦点小组调研,收集和分析数据, 提取业务洞察并形成调研报告。 适用情形:用户要求"做 NPS 调研"、"员工满意度调查"、"市场调研"时执行。 核心:调研设计 + 数据收集 + 统计分析 + 洞察提炼。
- ▌ Cost Control Master 2 · williamcorrea23成本控制主流程 — 整合标准成本差异 + 费用率分析 + 成本中心绩效的综合成本管理。 适用情形:月度成本分析时执行,整合 standard-cost-variance、 expense-ratio-analysis 和 cost-center-performance,输出完整的成本控制报告。 核心:成本监控 → 差异诊断 → 责任落实 → 改善跟踪。
- ▌ Kpi Dashboard 2 · williamcorrea23KPI 仪表盘生成 — 生成财务 KPI 仪表盘,跟踪核心指标健康度和趋势。 适用情形:每周/每日定期执行,从 [ERP]/[BI] 获取实时数据, 生成 KPI 仪表盘,识别须关注的指标,触发预警并输出待办。 核心:KPI 健康度评估 + 趋势分析 + 异常预警 + 下待办。
- ▌ Fixed Assets Master 2 · williamcorrea23固定资产管理主流程 — 整合折旧分析 + 资产购置审核 + 资产处置审核的综合管理。 适用情形:月末/年终固定资产管理报告时执行,整合 depreciation-analysis、 asset-acquisition-review 和 asset-disposal-review,输出完整的固定资产管理报告。 核心:折旧准确 → 资产安全 → 处置合规 → 账实相符。
- ▌ Ecl Disclosure 2 · williamcorrea23IFRS 9 / IFRS 7 信用风险披露 — 生成 ECL 变动表、Stage 转移说明、 宏观调整披露、敏感性分析和模型假设披露,满足监管和审计要求。 适用情形:季度末/年报披露前,风险经理配合 ecl-calculation 和 macro-forward-adjustment 结果生成正式披露文件。
- ▌ Approval Matrix 2 · williamcorrea23审批权限矩阵 — 建立和维护公司的财务审批权限矩阵,明确各级审批人的 授权范围、审批金额上限和审批流程。 适用情形:新员工入职培训、组织架构调整、业务扩展或用户要求"建立审批矩阵"时执行。 核心:分层授权体系设计 + 金额阈值确定 + 特殊审批规则。
- ▌ Control Testing 2 · williamcorrea23控制测试 — 对已设计的内部控制执行测试,验证控制是否按设计要求有效运行, 并记录测试结果。 适用情形:SOX 审计期间(年度/中期),或重大业务流程变更后验证控制有效性时执行。 核心:抽样测试 + 偏差分析 + 有效性结论。
- ▌ Kpi Data Tracking 2 · williamcorrea23KPI 数据追踪与报告 — 从各业务系统提取 KPI 实际数据, 核对数据准确性,生成多维度 KPI 达成追踪报告。 适用情形:月度/季度 KPI 追踪周期,或用户要求"追踪 KPI 进度"时执行。 核心:从 BI/ERP/CRM 等系统提取目标值 vs 实际值 + 趋势分析。
- ▌ Project Status 2 · williamcorrea23项目详情 — 显示单个项目的完整状态(基本信息 + 阶段进度 + 关联产出物 + 历史上下文)。 适用情形:项目启动时核对基线、阶段切换时回顾现状、周报/月报生成。 触发词:项目详情、项目进度、项目基线、查看项目。
- ▌ Project Switch 2 · williamcorrea23项目切换 — 加载指定项目的 project.md 上下文到当前会话。后续所有 skill 操作 都在该项目上下文中执行(产出物写到 projects/{code}/,引用项目阈值)。 适用情形:开始/恢复一个财务项目(年度审计、Q2 预算审查、税务申报周期、M&A 尽调)时执行。 触发词:切换项目、进入项目、恢复项目、加载项目上下文、switch to project。 核心:单例项目上下文(同时只能激活一个项目),所有 skill 引用 ~/.config/finance-skills/projects/{code}/project.md。
- ▌ Lcr Assessment 2 · williamcorrea23流动性覆盖率(LCR)评估 — 评估公司/集团的 LCR 指标, 识别流动性风险并提出改善建议。 适用情形:季度流动性评估、重大交易前后、或用户要求"评估 LCR"时执行。 核心:LCR 计算 + 构成分析 + 风险识别 + 改善建议。
- ▌ Esg Rating Tracking 2 · williamcorrea23ESG 评级追踪 — 追踪公司 ESG 评级变化,分析评级驱动因素, 制定评级提升计划。 适用情形:年度 ESG 评级发布后、季度追踪,或用户要求"追踪 ESG 评级"时执行。 核心:评级信息获取 + 差距分析 + 提升策略 + 行动计划。
- ▌ Ecl Calculation 2 · williamcorrea23ECL 计量 — 对每个 Stage 的敞口计算预期信用损失(12 个月或存续期), 应用 PD / LGD / EAD 参数,生成 ECL 计量结果。 适用情形:完成 Stage 分类后,风险经理计算每个敞口的 ECL, 汇总 Stage 级别 ECL,准备迁徙分析和覆盖率验证。
- ▌ Kpi Alert Handling 2 · williamcorrea23KPI 预警处理 — 处理 KPI 预警信号,进行根因分析, 制定应对措施,追踪预警关闭。 适用情形:KPI 触发预警条件(跌破阈值/异常波动/趋势恶化)时执行。 核心:预警分级 + 根因追溯 + 措施制定与追踪。
- ▌ Kpi Target Setting 2 · williamcorrea23KPI 目标设定与分解 — 设定 KPI 目标值,将公司级目标分解到业务线/部门, 确定衡量标准和数据来源。 适用情形:年度/季度目标设定周期,或用户要求"设定 KPI"、"分解目标"时执行。 核心:目标值设定逻辑(历史基准/行业对标/战略倒推)+ 分解到责任单元。
- ▌ Payroll Master 2 · williamcorrea23薪资核算管理主流程 — 整合薪资计算 + 社保审核 + 个税审核的综合薪资管理。 适用情形:月度薪资管理报告时执行,整合 payroll-calculation、 social-insurance-review 和 tax-withholding-review,输出完整的薪资核算报告。 核心:薪资准确 → 社保合规 → 个税合规 → 按时发放。
- ▌ Project Archive 2 · williamcorrea23项目归档 — 把项目状态改为 archived,目录变为只读,标记完成日期。 适用情形:项目完结(年度审计出具报告、税务申报周期结束、M&A 交易完成)后保留历史记录。 触发词:归档项目、关闭项目、项目完结、项目封存。 核心:状态流转 closed → archived,目录权限改为只读,保留所有产出物供历史查询。
- ▌ Fund Forecast 2 · williamcorrea23资金预测 — 滚动预测未来 [X] 天/[X] 周/[X] 月资金,识别资金缺口并预警。 适用情形:每周/每月定期执行,从 [CASH]/[OA]/[ERP] 获取数据, 预测未来资金流入/流出,识别缺口时间点,输出融资计划建议。 核心:短期预测 + 中期预测 + 缺口预警 + 融资方案。
- ▌ Audit Support Master 2 · williamcorrea23审计配合主流程 — 整合资料收集 + 调整审核 + 函证管理的全流程审计配合。 适用情形:年度审计配合报告时执行,整合 audit-evidence-collection、 audit-adjustment-review 和 confirmation-management,输出完整的审计配合报告。 核心:资料完整 → 调整合规 → 函证充分 → 报告出具。
- ▌ Esg Data Integration 2 · williamcorrea23ESG 数据整合 — 从多个来源(环境/社会/治理)整合 ESG 数据, 检查数据完整性和准确性,生成 ESG 数据质量报告。 适用情形:ESG 报告期(年度/季度)开始时,或用户要求"整合 ESG 数据"时执行。 核心:多源数据汇总 + 完整性检查 + 数据质量评分。
- ▌ Esg Reporting Master 2 · williamcorrea23ESG 报告主流程 — 整合环境/社会/治理数据收集、ESG 评级管理、重大事件应对与报告编制。 适用情形:年度 ESG 报告披露或评级机构(MSCI/Sustainalytics)评估时执行, 整合 esg-data-integration、esg-materiality-assessment、esg-rating-tracking 和 esg-reporting, 输出符合监管要求的 ESG 报告。 核心:数据完整性 → 重要性评估 → 评级管理 → 合规披露。
- ▌ Profit Analysis 2 · williamcorrea23利润表分析 — 分析收入/成本/费用的同比/环比/预算对比,识别盈利异常并归因。 适用情形:月度财务分析时执行,从 [ERP] 获取利润表数据, 按同比/环比/预算三维度分析,识别毛利/费用异常,归因到具体产品/部门。 核心:毛利分析 + 费用分析 + 预算差异归因 + 改善建议。
- ▌ Asset Disposal Review 2 · williamcorrea23资产处置审核 — 核查固定资产出售/报废/盘亏的合规性,确认处置损益。 适用情形:资产处置(出售/报废/盘亏)时执行,从 [FA]/[ERP] 获取信息, 核查处置原因、审批流程、资产评估,计算处置损益,输出处置建议。 核心:处置原因分析 + 审批合规 + 净值确认 + 损益计算。
- ▌ Depreciation Analysis 2 · williamcorrea23折旧分析 — 核查 [FA]/[ERP] 月度折旧计提准确性,分析折旧变动原因。 适用情形:月末结账时执行,从 [FA] 获取折旧计算表,与 [ERP] 凭证核对, 分析折旧变动(新增/减少/变更),输出折旧准确性报告。 核心:折旧计提核对 + 变动分析 + 异常识别。
- ▌ Fraud Investigation 2 · williamcorrea23舞弊调查 — 接收舞弊举报或发现异常线索后,启动独立调查, 搜集证据、评估影响并报告。 适用情形:审计委员会/管理层收到举报、审计中发现舞弊迹象、 外部监管要求调查时执行。
- ▌ Close Verification 2 · williamcorrea23结账验证 — 在月结完成后,对报表进行最终钩稽验证,确认结账正确性。 适用情形:所有结账分录已完成,执行 close-checklist-executor 确认前置项通过后, 作为结账流程的最终 Skill,执行报表钩稽验证,输出结账完成证明。 核心:三表钩稽 + 试算平衡 + 期初/期末衔接 + 最终结论。
- ▌ Payment Scheduling 2 · williamcorrea23付款排期 — 基于到期日和资金可用性,安排每周/每月的付款计划。 适用情形:固定付款周期(如每周二)执行,从 ERP 获取到期应付清单, 结合资金可用性,按优先级安排付款,输出付款计划供审批。 核心:到期日分析 + 资金缺口预警 + 付款优先级排序。
- ▌ Insight Generation 2 · williamcorrea23洞察生成 — 从业务/财务数据中提取洞察,识别模式、异常和机会, 转化为可落地的业务建议。 适用情形:用户要求"生成洞察"、"提炼 insights"、"从数据中找机会"时执行。 核心:数据模式识别 + 置信度评估 + 洞察到建议的转化链路。
- ▌ Insight Validation 2 · williamcorrea23洞察验证 — 验证已生成洞察的数据准确性、逻辑合理性和业务可操作性, 确保洞察质量并分级管理。 适用情形:洞察生成后进行验证,或用户要求"验证洞察"、"核实 insights"时执行。 核心:数据核实 + 逻辑检验 + 可操作性评估。
- ▌ Wacc Calculation 2 · williamcorrea23加权平均资本成本(WACC)计算 — 计算公司的 WACC, 用于折现率设定、投资评估和价值管理。 适用情形:年度 WACC 更新、投资评估、估值建模时,或用户要求"计算 WACC"时执行。 核心:权益成本 + 债务成本 + 资本结构 + WACC 组装。
- ▌ Expense Ratio Analysis 2 · williamcorrea23费用率分析 — 分析销售/管理/研发费用率变化,识别失控费用并归因。 适用情形:月度费用分析时执行,从 [ERP]/[BK] 获取费用数据, 按费用类型/部门分析费用率变化,区分"战略性投入"和"失控费用"。 核心:费用率趋势 + 超支归因 + 合理性判断 + 控制建议。
- ▌ Standard Cost Variance 2 · williamcorrea23标准成本差异分析 — 分析实际成本与标准成本的差异,分解为量差/价差/效率差。 适用情形:月度成本分析时执行,从 [ERP]/[COST]/[MES] 获取数据, 计算标准成本差异,分解量差/价差/效率差,归因到具体原因。 核心:材料差异 + 人工差异 + 费用差异 + 责任归属。
- ▌ Invoice Verification 2 · williamcorrea23发票验真 — 对增值税发票进行自动化真伪验真和票面信息核对。 适用情形:收到发票后,在报销审核前,读取国家税务总局查验平台的验真结果。 核心:查验发票状态 + 核对票面信息 + 识别失控发票。
- ▌ Reimbursement Review 2 · williamcorrea23报销审核主技能 — 综合发票验真、标准合规、预算、审批完整性的全链路审核。 适用情形:员工提交报销申请后,依次触发各原子 Skill 进行审核, 最终输出统一结论(通过/需补正/驳回/升级)。 核心:按六项必检项逐项审核,整合各原子 Skill 的输出形成最终报告。
- ▌ Control Deficiency 2 · williamcorrea23控制缺陷评估 — 对发现的内部控制缺陷进行评估,确定缺陷等级(重大/重要/一般), 分析根本原因,并制定整改计划。 适用情形:控制测试发现偏差、审计检查发现问题或业务流程出现重大事故时执行。 核心:缺陷等级评估 + 财务影响量化 + 整改计划制定。
- ▌ Sox Control Design 2 · williamcorrea23SOX 控制设计 — 为财务报告相关的关键业务流程设计和记录内部控制, 建立控制点、控制活动和控制证据要求。 适用情形:SOX 合规项目启动时,或业务流程变更后重新设计控制时执行。 核心:识别风险 → 确定控制点 → 设计控制活动 → 定义证据要求。
- ▌ Scenario Analysis 2 · williamcorrea23情景分析 — 对投资或业务决策进行多情景分析, 包括基准、乐观、悲观情景下的财务影响评估。 适用情形:重大投资决策、战略规划、预算编制前,或用户要求"做情景分析"时执行。 核心:情景设计 + 财务测算 + 概率加权 + 敏感性分析。
- ▌ Cost Center Performance 2 · williamcorrea23成本中心绩效分析 — 分析各成本中心成本绩效,评估产出效率和成本控制水平。 适用情形:月度/季度成本中心绩效评估时执行,从 [ERP]/[COST]/[MES] 获取数据, 计算各成本中心单位成本/成本效率,评估绩效等级,归因差异来源。 核心:单位成本 + 成本效率 + 产能利用率 + 责任归属。
- ▌ Annual Audit Planning 2 · williamcorrea23年度审计计划制定 — 风险导向审计方法,识别高风险领域, 合理分配审计资源,制定本年度内部审计计划。 适用情形:审计总监/经理在每年 Q4 制定下一年度审计计划时执行, 或年中根据风险变化调整计划时执行。
- ▌ Internal Audit Master 2 · williamcorrea23内部审计管理主流程 — 整合年度审计计划/专项审计/审计发现整改全流程。 适用情形:审计总监/审计经理制定年度审计计划、启动专项审计、 管理审计发现整改时执行,整合 annual-audit-planning、 process-compliance-audit、audit-finding-tracking 和 fraud-investigation, 输出完整的内部审计管理报告。 核心:风险导向 → 发现问题 → 整改跟踪 → 持续改进。
- ▌ Kpi Management Master 2 · williamcorrea23KPI 管理主流程 — 整合 KPI 目标设定、数据追踪、预警处理与根因分析。 适用情形:月度/季度经营分析会或 KPI 异常预警触发时执行, 整合 kpi-target-setting、kpi-data-tracking、kpi-alert-handling 和 kpi-root-cause-analysis, 输出完整的 KPI 监控与归因报告。 核心:目标设定 → 数据采集 → 异常预警 → 根因归因 → 改善跟踪。
- ▌ Aging Analysis Ar 2 · williamcorrea23应收账款账龄分析 — 生成全公司应收账款账龄分析报告,识别高风险逾期客户。 适用情形:每周固定时间(如周一)执行,从 ERP 获取应收账款数据, 按账龄/客户/信用等级多维度分析,输出逾期清单和催款优先级。 核心:账龄分层 + 逾期天数计算 + 坏账概率评估 + TOP N 高风险客户。
- ▌ Credit Assessment 2 · williamcorrea23客户信用评估 — 对新客户或现有客户进行信用评估,决定信用额度和账期。 适用情形:新客户合作前评估 / 现有客户年度复审 / 客户申请提升信用额度时执行, 综合财务数据 + 外部信息 + 历史交易,判断是否授予信用及额度。 核心:财务指标 + 外部风险信号 + 付款历史 + 信用建议。
- ▌ Audit Adjustment Review 2 · williamcorrea23审计调整审核 — 核查 [ERP] 审计调整分录,评估调整合理性,处理调整分歧。 适用情形:审计过程中执行,从审计调整台账获取调整数据, 核查调整分录准确性,评估对报表影响,输出调整审核报告。 核心:调整识别 + 影响评估 + 分歧处理 + 最终确认。
- ▌ Confirmation Management 2 · williamcorrea23函证管理 — 协调 [ERP]/[BANK] 银行函证和往来函证,跟踪回函状态,处理异常。 适用情形:审计函证程序时执行,跟踪银行和往来函证发函/回函状态, 核查回函差异,输出函证管理报告。 核心:发函跟踪 + 回函核对 + 差异处理 + 替代程序。
- ▌ Cash Flow Forecasting 2 · williamcorrea23现金流预测 — 滚动预测未来 1-3 个月现金流,识别资金缺口和融资需求。 适用情形:每月固定时间(如月末)执行,从 [ERP]/[OA]/[BK] 获取数据, 预测未来 1-3 个月资金流入和流出,识别资金缺口,输出融资计划建议。 核心:滚动预测模型 + 乐观/基准/悲观三情景 + 缺口时间点定位。
- ▌ Payment Scheduling Cm 2 · williamcorrea23付款计划编排 — 基于资金可用性和付款优先级,编排每周/每日付款计划。 适用情形:固定时间(如每周一)执行,从 [OA]/[ERP] 获取待支付清单, 结合 [CASH] 可用余额,按优先级编排付款计划,识别资金缺口。 核心:到期日分析 + 付款优先级(P0-P4)+ 资金缺口预警 + 付款计划输出。
- ▌ Dispute Identification 2 · williamcorrea23报销异常识别 — 在报销审核流程中主动识别高频异常模式和潜在风险。 适用情形:reimbursement-review 的各原子 Skill 执行后, 综合分析各节点输出,识别跨节点异常模式和潜在风险。 核心:不是替代其他 Skill,而是在其他 Skill 输出基础上做二次风险扫描。
- ▌ Asset Acquisition Review 2 · williamcorrea23资产购置审核 — 核查新增固定资产的采购合规性、折旧政策适用性,完成入账。 适用情形:新增资产入账时执行,从 [FA]/[PO] 获取采购信息, 核查采购流程合规性,确认折旧政策,输出入账建议。 核心:采购合规 + 折旧政策确认 + 入账金额验证。
- ▌ Audit Finding Tracking 2 · williamcorrea23审计发现整改跟踪 — 对所有未关闭的审计发现进行跟踪管理, 验证整改效果,对超期未整改项执行升级流程。 适用情形:审计经理/总监每月审查整改状态、 验证已完成整改、或对超期整改执行升级时执行。
- ▌ Npv Irr Calculation 2 · williamcorrea23NPV / IRR 计算与敏感性分析 — 构建 DCF 模型,计算净现值和内部收益率, 执行单变量和多变量敏感性分析,评估项目风险。 适用情形:CFO/财务经理评估项目投资可行性时执行, 须配合项目财务假设(收入/成本/折现率)使用。
- ▌ Board Deck Preparation 2 · williamcorrea23Board Deck 编制 — 编制董事会汇报用的专业 Board Deck, 包括执行摘要、财务业绩、战略进展、风险分析和下阶段计划。 适用情形:董事会/审计委员会/战略委员会会议前 [X] 天,或用户要求"编制 Board Deck"时执行。 核心:内容框架设计 + 数据可视化 + Board 风格规范。
- ▌ Board Reporting Master 2 · williamcorrea23董事会汇报主流程 — 整合 Board Deck 编制、审计委员会支持、董事会议程管理与重大事项汇报。 适用情形:年度/季度董事会与审计委员会会议前执行,整合 board-deck-preparation、 audit-committee-support、board-meeting-management 和 board-material-distribution, 输出完整的董事会汇报材料包。 核心:会议准备 → 材料编制 → 委员会协同 → 重大事项汇报。
- ▌ Cash Management Master 2 · williamcorrea23现金管理主流程 — 整合余额监控 + 付款计划 + 缺口预警的完整资金管理周期。 适用情形:每日/每周/每月定期执行,整合资金余额监控、付款计划编排、 现金流预测全流程,输出完整的资金管理报告和下期待办。 核心:日监控 → 周计划 → 月预测的三层管理体系。