Open to opportunities

Roderick McKinley

@roderickmckinley

I build on-chain risk systems and analytics that improve DeFi capital allocation and protocol oversight.

I've led risk and market-structure analysis for Solstice, a ~$500m Solana stablecoin ecosystem, where my DEX liquidity analysis helped free ~$11m of deployed capital while preserving execution quality. I build real-time monitoring, alerting, and live dashboards for liquidity, lending exposures, liquidation thresholds, stablecoin market structure, and market-maker performance.

Previously, I modeled a $1bn wind and solar portfolio at Mainstream Renewable Power / Actis, supported $410m of debt financing, and forecast global energy markets at Bloomberg New Energy Finance. I also build financial and token-economy models, have supported ~$70m in fundraising, and have taught financial modeling to 14,000+ students worldwide.

Experience

Work history, roles, and key accomplishments

Current

On-chain Risk & Analytics Consultant

Current

Independent

Jan 2020 - Present (6 years 7 months)

Lead risk and market-structure analysis for Solstice, a ~$500m Solana stablecoin ecosystem, freeing ~$11m of deployed capital. Engineered end-to-end data stack with Python, SQL, and dashboards.

Python SQL TimeScaleDB DBT Dune Solana EVM Ethereum DeFi Dex Liquidity Risk Stablecoins Market Maker REST gRPC RPC GraphQL Analytics Engineering Dashboarding

Current

Financial Modeling Consultant & Educator

Current

Independent

Jan 2017 - Present (9 years 7 months)

Built funding models for successful raises and delivered FP&A solutions for FMCG businesses. Taught financial modeling to 14,000+ students worldwide.

Financial Modeling FP&A VBA Power Query Excel Fundraising Real Estate SaaS FMCG Mining Renewable Energy Teaching

Tokenomics & Token-Fundraising Advisor

Independent

Jan 2020 - Dec 2023 (3 years 11 months)

Supported ~$70m in aggregate fundraising by identifying investor narratives and producing pitch decks. Designed model-backed token-economy plans and built supply, valuation, and treasury models.

Tokenomics Fundraising Pitch Decks Financial Modeling Valuation Treasury Investor Relations

Financial Modeler — Renewable Energy, Chile

Mainstream Renewable Power / Actis

Jan 2014 - Dec 2016 (2 years 11 months)

Priced winning bids for a $1bn wind and solar portfolio, building 15-year PPA project-finance models and supporting $410m of debt financing. Modeled node/locational price risk and structured tranched debt.

Project Finance Financial Modeling PPA Renewable Energy Wind Solar Risk Analysis Excel

M&A Analyst — Renewable Energy, UK

Climate Change Capital

Jan 2013 - Dec 2014 (1 year 11 months)

Supported the close of a £9m wind-farm transaction, including valuation, due diligence, and data-room management. Flagged client exposure to unintended default and proposed a refinancing structure.

M&A Valuation Due Diligence Wind Energy Renewable Energy Financial Modeling Refinancing

Analyst — Bloomberg New Energy Finance

Bloomberg

Jan 2011 - Dec 2013 (2 years 11 months)

Forecast global power markets, solar, and emerging cleantech, including emissions scrubbers and lithium-mining economics. Contributed long-term economic modeling to the flagship annual global energy outlook.

Energy Markets Forecasting Economic Modeling Solar Clean Tech Research Client Communication