Build and manage end-to-end data analytics workflows: implement A/B testing with statistical rigor, design reliable analytics tracking, create interactive D3.js visualizations, architect scalable database schemas, and optimize SQL for cloud-native databases.

Implement Domain-Driven Design with tactical patterns (aggregates, entities, value objects), CQRS, event sourcing, and saga orchestration. Design bounded contexts, map integration contracts, and build event stores with read models for scalable, event-driven systems.

Design and optimize NoSQL data models for MongoDB, DynamoDB, Redis, and Cassandra by analyzing access patterns, embedding vs referencing, denormalization trade-offs, sharding keys, and indexes.

Provision and manage isolated test environments using Docker Compose and Testcontainers for databases, caches, queues like PostgreSQL, MySQL, Redis, DynamoDB. Generate docker-compose files, env vars, seed data scripts, startup scripts, and cleanup code to enable reliable, reproducible testing without local setup conflicts.

Manage AWS data lakes and analytics workflows: create and query Iceberg tables on S3 Tables, run Athena SQL across Glue and Redshift catalogs, ingest data from JDBC databases, Redshift, Snowflake, BigQuery, and DynamoDB, audit Glue Data Catalog assets, and store/query vector embeddings on S3 Vectors for semantic search and RAG.

Interactively configure secure AWS S3 buckets with encryption, versioning, lifecycle rules, and logging, then generate CloudFormation or CDK IaC plus documentation. Set up complete Lambda functions with handler code in Node/Python/Go, IAM roles, DynamoDB triggers, and IaC via CloudFormation/SAM/CDK.

Accelerate Java Spring Boot development by generating CRUD apps, REST APIs, and AI integrations with LangChain4j; write unit/integration tests; integrate AWS services like RDS, DynamoDB, S3, Lambda; refactor code, audit security/dependencies, and produce documentation/architecture reviews via agents, commands, skills, and LSP support.

Generate production-ready AWS CloudFormation templates for VPCs, EC2, ECS, RDS, DynamoDB, Lambda, S3, CloudFront, ElastiCache, Bedrock, and security groups; deploy ECS services via GitHub Actions CI/CD; bootstrap SAM projects; create Draw.io architecture diagrams; automate AWS CLI workflows; optimize costs; and review designs with expert agents.

Build and deploy Python MCP servers to expose custom tools, resources, and prompts to LLMs like Claude. Configure storage backends with memory, disk, Redis, or DynamoDB options. Integrate OAuth proxy for secure access and handle cloud deployment, lifespan management, middleware, circular imports, and async errors.

Validates Terraform configurations, enforces infrastructure-as-code best practices, and provides code intelligence for HCL files with diagnostics, references, and module organization guidance.

Automate data classification for privacy compliance: discover PII in structured/unstructured data, build GDPR RoPA inventories, track lineage, label special categories, detect bias in AI datasets, and harmonize policies across GDPR/CCPA/HIPAA using AWS Macie, Azure Purview, and regex/spaCy.

Design, optimize, and deploy serverless architectures using AWS Lambda, Azure Functions, and Google Cloud Functions. Implement event-driven patterns, API Gateway integrations, serverless databases like DynamoDB, security measures, workflows, and cost-saving strategies.

Architect scalable databases by selecting SQL/NoSQL/TimeSeries technologies, designing normalized schemas with PostgreSQL best practices, planning migrations, and optimizing complex SQL queries for OLTP/OLAP performance in cloud-native systems like PostgreSQL, MySQL, MongoDB, Redis, and DynamoDB.

Manage the full lifecycle of a feature from idea capture through implementation, review, and shipping, including backlog tracking, scope enforcement, troubleshooting, and dashboard generation with quality gates.

Audit any database schema, ORM, or migration with two independent 0-100 scores (Design & Integrity, Performance & Scale) and receive a prioritized, evidence-backed report of findings. Run read-only checks for security, concurrency, indexing, normalization, and antipatterns, then optionally apply safe, reversible fixes on explicit approval.

Build and deploy serverless applications on AWS using Lambda, SAM, API Gateway, EventBridge, Step Functions, and event-driven patterns like DynamoDB and SQS triggers.