Communitygithub.com

cdcoonce/Portfolio_Website

Charles builds production-grade data pipelines that ingest, transform, and validate data from multiple sources. As a Data Engineer I at Clearway Energy Group, he works daily with Dagster, dbt, Polars, and Snowflake to automate renewable energy asset data workflows. He has experience designing ETL/ELT processes that handle API integrations, spatial data joins, and incremental loading patterns.

What is Portfolio_Website?

Portfolio_Website is a Claude Code agent skill that charles builds production-grade data pipelines that ingest, transform, and validate data from multiple sources. As a Data Engineer I at Clearway Energy Group, he works daily with Dagster, dbt, Polars, and Snowflake to automate renewable energy asset data workflows. He has experience designing ETL/ELT processes that handle API integrations, spatial data joins, and incremental loading patterns.

Works with~Claude Code~Codex CLI~Cursor
npx skills add https://github.com/cdcoonce/Portfolio_Website/tree/HEAD/WebContent/context

Ask in your favorite AI

Open a new chat with this agent skill pre-loaded.

Documentation

Skills Overview

Data Engineering & Pipelines

Charles builds production-grade data pipelines that ingest, transform, and validate data from multiple sources. As a Data Engineer I at Clearway Energy Group, he works daily with Dagster, dbt, Polars, and Snowflake to automate renewable energy asset data workflows. He has experience designing ETL/ELT processes that handle API integrations, spatial data joins, and incremental loading patterns.

Tools & Technologies: Python, Dagster, dbt, dlt, Polars, Snowflake, DuckDB, Hex

Demonstrated in: Renewable Asset Performance Pipeline, Housing Affordability & Commute Analysis, Google Analytics Data Archive, Energy Analytics Pipeline, Synthetic Signal Observatory


Statistical Analysis & Modeling

Charles applies rigorous statistical methods to answer research questions and validate findings. His work includes OLS regression with robust standard errors, ANOVA, interaction models, quantile regression, and cross-validation. He is comfortable selecting between model specifications using AIC, diagnosing multicollinearity with VIF, and interpreting results for both technical and non-technical audiences.

Tools & Technologies: Python (statsmodels, scipy), scikit-learn, R

Demonstrated in: Housing Affordability & Commute Analysis, Wine Quality Analysis, Ames Housing Price Prediction, Sleep Deprivation Analysis


Machine Learning

Charles has experience building and evaluating supervised learning models for both regression and classification tasks. He has worked with linear models, k-nearest neighbors, random forests, XGBoost, neural networks (TensorFlow/Keras), and stacking ensembles. He applies feature engineering, cross-validation, hyperparameter tuning, and model interpretability techniques like SHAP to understand and communicate model behavior.

Tools & Technologies: scikit-learn, TensorFlow/Keras, XGBoost, SHAP

Demonstrated in: Ames Housing Price Prediction, Spaceship Titanic Classification, Wine Quality Analysis, Housing Affordability & Commute Analysis


Data Visualization & Dashboards

Charles creates visualizations and interactive dashboards that make data accessible to decision-makers. He has built R Shiny dashboards with dynamic filtering and interactive tables, Tableau dashboards with parameterized views, and Python-based visualizations using Matplotlib and Streamlit. He focuses on clarity, appropriate chart selection, and making the story in the data easy to follow.

Tools & Technologies: Tableau, R Shiny, Matplotlib, Streamlit, ggplot2, Plotly

Demonstrated in: Global CO₂ Emissions Dashboard, National Parks Visitation Dashboard, World Happiness Dashboard, Synthetic Signal Observatory, Housing Affordability & Commute Analysis


SQL & Database Analytics

Charles writes SQL for data extraction, transformation, and analytical queries. He is comfortable with aggregations, window functions (RANK, ROW_NUMBER), CTEs, subqueries, joins, and set operations. He works with both traditional relational databases and modern analytical engines like DuckDB and Snowflake.

Tools & Technologies: SQL (MySQL, Snowflake, DuckDB)

Demonstrated in: Restaurant Sales Analysis, Baby Names Analysis, Motor Vehicle Thefts Analysis, Renewable Asset Performance Pipeline, Energy Analytics Pipeline


Spreadsheet & Business Analysis

Charles uses Excel as an analytical tool — not just for data entry, but for building structured analyses with pivot tables, VLOOKUP/SUMIFS, conditional formatting, Pareto charts, and heat maps. His spreadsheet work is focused on translating raw operational data into actionable business insights.

Tools & Technologies: Excel (Pivot Tables, Power Query, VLOOKUP, SUMIFS, Conditional Formatting, Combo Charts)

Demonstrated in: Manufacturing Downtime Analysis, NYC Collision Analysis


Data Wrangling & ETL

Charles regularly cleans, transforms, and integrates messy datasets from multiple sources. He works with tabular data, spatial data (shapefiles, GeoJSON), and API responses. He is experienced with both Pandas and Polars for dataframe operations, and GeoPandas for spatial joins and geographic analysis.

Tools & Technologies: Python (Pandas, Polars, GeoPandas), API integration, Census ACS, OpenStreetMap Overpass

Demonstrated in: Housing Affordability & Commute Analysis, Electricity Consumption Analysis, AirBnB Listing Analysis, Google Analytics Data Archive


Web Development

Charles built his portfolio website from scratch using vanilla HTML5, CSS3, and ES module JavaScript — no frameworks or bundlers. The site features responsive design, accessible markup (WCAG 2.1 AA), filterable project galleries with URL-driven filtering, and a testimonial carousel. He maintains the codebase with professional practices including linting, automated testing, and CI/CD deployment.

Tools & Technologies: HTML5, CSS3, JavaScript (ES Modules)

Demonstrated in: Portfolio Website


DevOps & Tooling

Charles uses modern development tooling to maintain code quality and automate workflows. He sets up CI/CD pipelines with GitHub Actions, writes tests with pytest and Jest, manages Python environments with uv, and enforces code standards with linters (ESLint, Stylelint, Ruff) and formatters (Prettier). He follows conventional commits and semantic versioning practices.

Tools & Technologies: Git, GitHub Actions, CI/CD, uv, pytest, Jest, Playwright, ESLint, Stylelint, Ruff, Prettier

Demonstrated in: Portfolio Website, Renewable Asset Performance Pipeline, Housing Affordability & Commute Analysis

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

cdcoonce/Portfolio_Website

Git commit workflow with enforced conventional commit style. Use when Claude needs to stage and commit changes, craft commit messages, or the user asks to commit, make a commit, or save their work. Ensures consistent commit message format, proper scoping, and atomic commits across the project.

cdcoonce/Portfolio_Website

AI-powered code quality analysis for Python, Markdown, and Mermaid diagrams. Use this skill when: (1) reviewing code for quality issues, (2) checking Python files for PEP8 violations, unused code, missing type hints, docstring problems, complexity issues, or potential runtime errors, (3) validating Markdown documentation for broken links, heading structure, or formatting issues, (4) validating Mermaid diagram syntax, (5) the user asks for a "code review" or "quality check", (6) analyzing code snippets pasted in conversation, or (7) suggesting and applying fixes for code quality issues.

cdcoonce/Portfolio_Website

Deploy the portfolio chat agent Lambda function to AWS. Use when the user asks to deploy, redeploy, push to Lambda, update the chat agent, or after updating context files or lambda_function.py. Rebuilds the knowledge base, packages dependencies, and deploys to AWS Lambda.

cdcoonce/Portfolio_Website

Generate multiple radically different interface designs for a module using parallel sub-agents. Use when user wants to design an API, explore interface options, compare module shapes, or mentions "design it twice".

cdcoonce/Portfolio_Website

Orchestrate the full GitHub-issues-driven development lifecycle. 7-phase pipeline from brainstorm through PR with state tracking and cross-conversation resume. Use when user says "dev cycle", "development workflow", "full development pipeline", or invokes /dev-cycle.

cdcoonce/Portfolio_Website

Production Python coding standards with automatic version detection (3.10-3.13). Use when writing, reviewing, or refactoring Python to ensure adherence to modern type syntax, LBYL exception handling, pathlib operations, ABC-based interfaces, and production-tested patterns. Not Dagster-specific - applies to any Python project.

cdcoonce/Portfolio_Website

Set up Claude Code hooks to block dangerous git commands (push, reset --hard, clean, branch -D, etc.) before they execute. Use when user wants to prevent destructive git operations, add git safety hooks, or block git push/reset in Claude Code.

cdcoonce/Portfolio_Website

GitHub CLI (gh) integration for managing issues, pull requests, branches,

cdcoonce/Portfolio_Website

Interview the user relentlessly about a plan or design until reaching shared understanding, resolving each branch of the decision tree. Use when user wants to stress-test a plan, get grilled on their design, or mentions "grill me".

cdcoonce/Portfolio_Website

Explore a codebase to find opportunities for architectural improvement, focusing on making the codebase more testable by deepening shallow modules. Use when user wants to improve architecture, find refactoring opportunities, consolidate tightly-coupled modules, or make a codebase more AI-navigable.

cdcoonce/Portfolio_Website

CEO/founder-mode plan review. Rethink the problem, find the 10-star product, challenge premises, expand scope when it creates a better product. Three modes: SCOPE EXPANSION (dream big), HOLD SCOPE (maximum rigor), SCOPE REDUCTION (strip to essentials). Use when the user asks for a plan review, CEO review, mega review, or wants a plan challenged/stress-tested before implementation.

cdcoonce/Portfolio_Website

Break a PRD into independently-grabbable GitHub issues using tracer-bullet vertical slices. Use when user wants to convert a PRD to issues, create implementation tickets, or break down a PRD into work items.

cdcoonce/Portfolio_Website

Turn a PRD into a multi-phase implementation plan using tracer-bullet vertical slices, saved as a local Markdown file in docs/plans/. Use when user wants to break down a PRD, create an implementation plan, plan phases from a PRD, or mentions "tracer bullets".

cdcoonce/Portfolio_Website

Generate or update the `.claude/docs/project.md` file that gives Claude project-specific context. Use this skill when the user asks to create, update, regenerate, or refresh project context, or says things like "update project.md", "generate project context", "this repo needs a project.md", or "Claude doesn't know about this project". Also trigger when onboarding Claude to a new repository for the first time.

cdcoonce/Portfolio_Website

Generate comprehensive, high-quality README.md files for code repositories. Use this skill whenever the user asks to create, write, generate, update, or improve a README for any project or repository. Also trigger when the user says things like "document this project", "write docs for this repo", "this repo needs a README", "help me onboard developers to this codebase", or asks for project documentation in markdown. Even if the user just says "README" or "readme" in the context of a codebase, use this skill.

cdcoonce/Portfolio_Website

Create a detailed refactor plan with tiny commits via user interview, then file it as a GitHub issue. Use when user wants to plan a refactor, create a refactoring RFC, or break a refactor into safe incremental steps.

cdcoonce/Portfolio_Website

Set up pre-commit hooks for the current repo. Use when user wants to add pre-commit hooks, configure commit-time linting, formatting, type checking, or testing. Triggers on "pre-commit", "git hooks", "linting hooks", or /setup-pre-commit.

cdcoonce/Portfolio_Website

Test-driven development with red-green-refactor loop. Use when user wants to build features or fix bugs using TDD, mentions "red-green-refactor", wants integration tests, or asks for test-first development.

cdcoonce/Portfolio_Website

Triage a bug or issue by exploring the codebase to find root cause, then create a GitHub issue with a TDD-based fix plan. Use when user reports a bug, wants to file an issue, mentions "triage", or wants to investigate and plan a fix for a problem.

cdcoonce/Portfolio_Website

Rewrites the prose sections of wiki pages in-place. Reads source files to understand current context, then updates only the content inside <!-- claude:prose --> ... <!-- claude:prose:end --> markers. Never touches <!-- generated:start --> ... <!-- generated:end --> blocks. Supports targeting a single page with /update-wiki {PageName}.

Related Skills