Skill UI

A comprehensive expert system for analyzing software codebases to identify, quantify, and prioritize technical debt across various dimensions (code, architecture, testing, infrastructure). It provides detailed metrics, impact assessments (development velocity, quality loss), and actionable, prioritized remediation roadmaps with clear ROI projections.

Mastery of advanced system design patterns, including Event Sourcing, CQRS, and Event-Driven Architecture (EDA). This skill covers designing event stores, building read/write projections, orchestrating sagas, and managing eventual consistency. It is ideal for building complex microservices that require guaranteed audit trails, historical state querying (temporal queries), and robust handling of business workflows with compensating actions.

A professional tool for building Discounted Cash Flow (DCF) valuation models directly in Excel. This skill generates a comprehensive, multi-sheet model including FCF projections, WACC calculations, terminal value analysis, and two-way sensitivity tables. It is designed for investment banking and corporate finance professionals needing to determine intrinsic or enterprise value.

Generates full-scale Excel LBO models with sources & uses, debt schedules, operating projections, and return curves so private equity teams can gauge IRR, MoM, and covenant compliance before pursuing a deal.

A guide to building robust projections and read models from continuous event streams. This pattern is essential for implementing CQRS read sides, creating materialized views, optimizing query performance, and building complex search indexes in event-sourced architectures. Use it when data needs to be transformed and aggregated from raw events into optimized query structures.

This skill generates a comprehensive, investor-ready business case document. It guides users through creating detailed sections covering market analysis (TAM/SAM/SOM), solution development, competitive positioning, financial projections, go-to-market strategy, and team structure. It is essential for founders undergoing fundraising or strategic corporate planning.

Build comprehensive 3-5 year financial models essential for startup planning and fundraising. This skill meticulously projects revenue using cohort-based methods, details cost structures (COGS, S&M, R&D, G&A), plans headcount, and performs detailed cash flow analysis. It calculates critical metrics like LTV, CAC, and burn rate, providing three scenarios (conservative, base, optimistic) for robust strategic decision-making.

Build comprehensive 3-5 year financial models crucial for early-stage startups. This guide covers revenue projections using cohort-based methods, detailed cost structuring (COGS, S&M, R&D, G&A), robust cash flow analysis, and multi-scenario planning (Conservative, Base, Optimistic). It provides the quantitative foundation needed for fundraising, strategic planning, and investor presentations.

Guides CMOs through brand positioning, growth model selection, budget allocation, and org design for scaling companies, using diagnostic questions and projections to align marketing with revenue goals.

This methodology provides a structured framework for stress-testing critical business assumptions before they fail in the market. Learn to systematically identify, challenge, and model the downside risk associated with market size, revenue projections, competitive moats, and customer behavior. It moves beyond optimism to achieve crucial business calibration.

This comprehensive guide provides best practices for developing robust and efficient data access layers using Entity Framework Core. It covers critical areas including DbContext design, performance optimization (e.g., AsNoTracking, Select projection), secure querying techniques, migration strategies, and testing methodologies, ensuring the creation of scalable and maintainable applications.

This comprehensive guide provides advanced techniques to diagnose and significantly boost ClickHouse query performance. It covers analyzing slow queries using system tables, optimizing ORDER BY keys, implementing data skipping indexes (Bloom, Set, MinMax), utilizing projections for pre-aggregation, and fine-tuning server settings and materialized views. Essential for high-volume OLAP environments.