1. Software Development

Reviews concurrency patterns and resilience in distributed systems, analyzing retry policies, idempotency, and race conditions for async code and distributed transactions.

Automates BDD-based CLI project setup by fetching and applying cookiecutter templates from Git repositories based on user requirements.

Reviews REST/RPC API contracts for breaking changes, interface consistency, and backward compatibility.

Standardizes Python research code dependencies, environment setup, and lockfiles for consistent development and reproducibility.

Refines software concept designs using six transformational moves to address trade-offs and improve flexibility, generalization, and automation.

Provides multi-perspective code review using Codex, analyzing security, performance, maintainability, and design aspects in parallel.

Manages Supabase database operations, applies security patches, and resolves advisor-related issues for the Dashboard project.

Assesses codebase maintainability for new engineers, identifying onboarding friction, technical debt, and code quality issues.

Refactors data loading, validation, and IO boundaries in Python research code for improved structure and reliability.

Auto-generates Python step definitions from Gherkin feature files for Behave BDD testing with type inference and reuse suggestions.

Orchestrates code reviews by analyzing PR intent, risk, and routing to specialists without performing detailed reviews. Supports full pipeline via 'Review PR <number>' command.

Expert in integrating external APIs, designing backend proxy architectures, and implementing data fetching strategies for seamless data flow from external services to the database.

Reviews system architecture changes for coupling, blast radius, and long-term impact to ensure robust and maintainable design.

Enforces Kent Beck's Tidy First principles by separating structural code changes from behavioral changes during refactoring, ensuring clean commit history.

Provides expert guidance on GigLedger's application architecture, including structure, feature modules, and state management patterns for feature implementation and module creation.

Comprehensive guidance for SQLModel-based database modeling, schema design, and CRUD API development with FastAPI, including production best practices.

Provides React component templates, patterns, and coding guidelines for efficient frontend development.

Adds tests and regression checks to Python research code to ensure stability during refactoring and prevent functionality regressions.

Provides systematic debugging techniques for identifying and resolving bugs, performance issues, and unexpected behavior across any codebase or technology stack.

Refactors Python research code to enhance project structure, modularity, and entrypoint organization for improved maintainability.

Analyzes and optimizes Django ORM queries to resolve N+1 issues, missing indexes, and slow performance for improved API response times.

Builds, tests, and publishes VS Code extensions with configuration, debugging, and marketplace deployment expertise.

Builds REST and gRPC backend services with ASP.NET Core, Entity Framework Core, and authentication features.

Standardizes Git and GitHub (gh) workflows for repository management, branching, and collaborative development practices.