Resume · Stanley Tejakusuma

skills python · sql · snowflake · dbt · typescript · llm agents · rag

experience

Oct 2024 – May 2026

Built Snowflake + dbt medallion ELT pipelines across 10+ chains: NEAR, Solana, Aptos, Monad, Flow, Sei, and cross-chain protocols.
Shipped a pipeline "bugbot": failures on incremental runs feed a scheduled LLM agent that diagnoses the root cause and drafts the fix PR, human-gated.
Designed a cost-intelligence pipeline connecting Snowflake compute spend with CI runtime: outlier detection → root-cause diagnosis → proposed efficiency fixes.
Built a multi-agent "pipeline architect" for new-chain onboarding: parallel agents for context discovery (chain classification, transaction structure, RPC), model scaffolding, and ingestion.
Anchored the NEAR client relationship; shipped an Intents intelligence layer showing NEAR Intents acts as a cross-chain swap aggregator.
Shipped cross-EVM hot-wallet detection and a weekly external-parity audit cross-validating DEX, bridge, and lending coverage against DeFiLlama.

2022–2024

Led the delegations team overseeing $6M+ in governance votes across Optimism, dYdX, Stader Labs, and Origin. Personally ran the Optimism delegation with transparent voting rationales.
Built and taught the “Introduction to Blockchain” certification course (top chains, DeFi, stablecoins, DeFi vs CeFi vs TradFi) with bi-weekly forums.
Published bi-weekly research on Medium and Twitter backed by original Dune Analytics, including decomposing the Gains Network ($GNS) economic flywheel.

Dec 2021 – Jun 2022

Built automated business-line P&L trackers (financing, fulfillment, logistics) for a B2B freight marketplace. Metabase SQL piped to Sheets, then automated in Python.
Produced investor-relations analytics: GTV, disbursement, and NPL metrics, route-level profitability, and comparable-company benchmarking against 8 public comps.
Reported directly to the COO and finance team; researched cohort-retention and customer-lifetime-value models.

2021–2022

My first crypto role. Self-taught Dune Analytics on the job to pair data with the writing. Bi-weekly research theses across DeFi, NFTs, DAOs, and regulation for angel investors.
Built my first Dune queries (incl. a DeFi Pulse Index $DPI holder tracker) and a Python + Binance price-action screener.
Much of that research lives on in the musings archive here.

2021

Built electricity-usage prediction models covering the Midwest and South for the Midcontinent ISO (MISO).
Applied random forests and feature importance to model electricity-fluctuation edge cases.

2021

My first employment, ever. Survived the 7am rush. Turns out that was my first lesson in high-frequency order flow.

Aug 2020 – May 2024