Database

Expert guidance on private equity fund structure, deal sourcing, due diligence, transaction execution, portfolio company value creation, and exit planning across buyout, growth equity, and special situations strategies.

Expert guidance on startup evaluation, term sheet negotiation, portfolio construction, board governance, follow-on strategy, and the full venture capital lifecycle from fund formation through exits across seed, early, and growth stages.

Comprehensive guidance on portfolio construction, client advisory relationships, asset allocation strategies, estate planning considerations, and holistic wealth preservation for high-net-worth and ultra-high-net-worth individuals and families.

certified financial planner and experienced angel investor with over twenty years of direct startup investing experience. You have made over one hundred fifty angel investments across technology, heal.

certified financial planner with over fifteen years of experience integrating digital assets into comprehensive financial plans. You first encountered Bitcoin in its early years and have since guided .

certified financial planner and income investing specialist with over twenty-five years of experience building dividend portfolios for retirees, pre-retirees, and long-term wealth builders. You have g.

certified financial planner with over twenty-five years of experience in estate planning, having worked alongside estate attorneys and tax advisors to help families protect and transfer wealth across .

certified financial planner with over twenty years of experience helping clients achieve financial independence, many of them decades earlier than traditional retirement age. You have worked with high.

certified financial planner with over twenty-five years of experience advocating for evidence-based, low-cost investing strategies. You have helped hundreds of clients build and maintain diversified p.

certified financial planner and derivatives specialist with over twenty years of experience in options markets. You have trained institutional traders, advised high-net-worth clients on hedging strate.

certified financial planner and real estate investment advisor with over twenty years of experience helping clients build wealth through residential and commercial property. You have personally analyz.

certified financial planner specializing in retirement income planning with over thirty years of experience. You have helped hundreds of clients transition from accumulation to distribution, designed .

certified financial planner and startup advisor with over twenty years of experience helping founders raise capital across seed, Series A, and growth-stage rounds. You have coached over two hundred co.

certified financial planner and equity analyst with over thirty years of experience guiding individuals and institutions through public equity markets. You have navigated multiple bull and bear cycles.

certified financial planner and tax strategist with over twenty-five years of experience helping high-income professionals and business owners minimize their lifetime tax burden through proactive plan.

Activate this skill when the user is turning raw tick data or OHLCV bars into research-ready datasets for backtesting and needs to align series, set forward-fill rules, timestamp features correctly, prevent leakage and keep results reproducible. Triggers on "backtest data," "research dataset," "feature pipeline," "data alignment," "forward fill," "look-ahead," "data leakage," "versioned datasets," "reproducible backtest," "as-of join," or "data engineering ohlcv." Covers the raw-to-research layering, alignment and fill policies, event versus availability timestamps, leakage controls, dataset versioning with manifests, and cost-aware pipeline design.

Activate this skill when the user needs to adjust historical prices for splits, dividends, spin-offs or symbol changes, handle delistings, or build continuous futures series from individual contracts. Triggers on "corporate actions," "split adjustment," "dividend adjusted prices," "back-adjusted," "adjustment factor," "spin-off," "ticker change," "delisting," "continuous contract," "roll adjustment," or "adjusted OHLCV." Covers adjustment-factor math, back- versus forward-adjustment, applying factors to OHLCV and volume correctly, identifier management, and futures roll schedules with difference and ratio adjustment.

Activate this skill when the user needs to validate tick data or OHLCV bars before research or production use, build monitoring for a market data pipeline, or diagnose suspicious prices, volumes or quotes. Triggers on "data quality," "bad prints," "outlier trades," "stale quotes," "missing bars," "duplicate ticks," "negative spread," "zero volume bars," "data validation," "market data monitoring," "cross-venue consistency," or "pre-backtest checks." Covers gap and duplicate detection, robust outlier rules, staleness, spread sanity, bar-level invariants, cross-venue and official-figure reconciliation, severity and disposition rules, the metrics a monitoring dashboard should carry, and a checklist to run before any backtest.

Activate this skill when the user is building OHLCV bars from trades or tick data, choosing between time, tick, volume and dollar bars, or debugging why their bars disagree with a vendor's. Triggers on "OHLCV," "bar construction," "candles from tick data," "resample trades," "volume bars," "dollar bars," "VWAP," "session boundaries," "opening auction," "empty bars," or "data engineering ohlcv." Covers bar sampling schemes, exact field definitions and eligibility rules, session alignment, auction and out-of-sequence handling, VWAP, and resampling code in pandas and polars.

Activate this skill when the user is capturing, reconstructing, storing or deriving features from limit order book data at any depth. Triggers on "order book," "L2 data," "L3 data," "market by order," "book snapshot," "incremental updates," "book reconstruction," "crossed book," "locked market," "order book imbalance," "microprice," "depth data," or "book sampling." Covers L1, L2 and L3 distinctions, snapshot-plus-delta synchronization, deterministic reconstruction, crossed and locked book handling, depth-derived features, storage volume arithmetic, and sampling strategies that keep research tractable.

Activate this skill when the user is defining a historical universe, joining fundamentals or reference data to prices, or building a symbol master for backtests and needs to avoid look-ahead and survivorship bias. Triggers on "point-in-time," "survivorship bias," "as-of data," "delisted stocks," "restated fundamentals," "look-ahead bias," "index constituents history," "symbol master," "bitemporal," "vendor vintages," or "PIT database." Covers why the universe must be as-of, delisting handling, index membership history, restatement and reporting-lag rules for fundamentals, the leakage hidden in adjusted prices, the futures and crypto versions of the problem, and the design of a point-in-time security master.

Activate this skill when the user is consuming live market data over WebSocket, TCP or multicast, building feed handlers, distributing ticks to internal consumers, or aggregating bars in real time. Triggers on "streaming market data," "WebSocket feed," "multicast feed," "feed handler," "heartbeat," "sequence recovery," "backpressure," "fan-out," "real-time bars," "market data latency," "A/B feed arbitration," or "feed failover." Covers transport characteristics, heartbeats and liveness, sequencing and gap recovery, bounded queues and conflation, fan-out topologies, live bar aggregation with late ticks, latency measurement with synchronized clocks, and failover that preserves book state.

Activate this skill when the user is capturing, loading or normalizing raw tick data from exchange or vendor feeds into a research or production store. Triggers on "tick data," "tick data ingestion," "trades and quotes," "TAQ," "feed handler," "sequence gaps," "exchange timestamp," "nanosecond timestamps," "feed replay," or "idempotent loader." Covers trade, quote and book message types, sequence-number gap detection, the three timestamps every record needs, nanosecond precision, replay from raw captures, and loaders that can be re-run safely.

Activate this skill when the user is deciding how to lay out tick data, quotes, order book updates or OHLCV bars on disk or in a database for research and production. Triggers on "tick data storage," "Parquet market data," "Arrow," "partition by symbol," "kdb," "column store," "DuckDB," "ClickHouse," "compression for ticks," "schema evolution," or "data engineering ohlcv." Covers columnar formats and encodings, partition and sort layout, compression trade-offs, kdb-style and SQL column stores, versioned schemas, and matching the physical layout to the queries you actually run.

Activate this skill when the user is handling exchange sessions, holidays, half days, daylight saving transitions or timezone conversion in market data, or aligning tick data and OHLCV bars across venues that keep different hours. Triggers on "trading calendar," "exchange holidays," "half day," "market hours," "DST," "timezone," "UTC storage," "trade date," "session boundaries," "Globex hours," "crypto 24/7," "venue alignment," or "exchange_calendars." Covers session definitions for equities, futures and crypto, UTC-first storage with exchange-local session logic, trade date versus calendar date, DST asymmetries between regions, overlap windows across venues, and the traps in calendar and timezone libraries.

Script, root system, dialects versus MSA, and reading skills for Arabic language learning

Pronunciation, grammar, formal and informal registers, and cultural context for French language mastery

Cases, word order, compound words, and formal register for German language proficiency

Devanagari script, postpositions, verb forms, and formal and informal registers for Hindi learning

Pronunciation, gestures, regional dialects, and grammar for Italian language proficiency

Hiragana, katakana, kanji, keigo, and particle usage for Japanese language learning

Hangul, honorifics, sentence structure, and particle usage for Korean language learning

Tones, pinyin, characters, measure words, and HSK progression for Mandarin Chinese mastery

Brazilian versus European Portuguese, pronunciation, false cognates, and regional variation

Cyrillic script, case system, verbal aspect, and pronunciation for Russian language learning

ASL fundamentals, facial grammar, fingerspelling, and Deaf culture for sign language learning

Grammar, conversation, conjugation, and regional variants for Spanish language learning and teaching

Covers the fundamentals of attorney-client counseling, including intake interviews, expectation management, and decision-making guidance. Activate this skill when advising clients on their legal options, communicating case developments, or navigating the emotional dynamics of legal representation.

Provides guidance on drafting, reviewing, and negotiating enforceable contracts across commercial and corporate transactions. Use this skill when creating agreements from scratch, reviewing boilerplate clauses, structuring deal terms, or addressing risk allocation through indemnification and limitation of liability provisions.

Covers criminal defense practice from investigation through trial, sentencing, and appeal, grounded in constitutional protections. Activate this skill when handling cases involving suppression motions, plea negotiations, jury trial preparation, sentencing mitigation, or the collateral consequences of criminal convictions.

Provides techniques for taking and defending depositions in civil litigation, including witness preparation, questioning strategies, and document handling. Use this skill when planning deposition outlines, examining or cross-examining witnesses under oath, handling objections, or using deposition testimony for summary judgment or trial impeachment.

Covers employment law compliance and dispute resolution from both employer and employee perspectives, including discrimination, wage and hour, and workplace investigations. Activate this skill when drafting employment policies, advising on termination decisions, conducting workplace investigations, or handling EEOC charges and employment litigation.

Covers family law matters including divorce, child custody, property division, and support obligations, with emphasis on child-centered outcomes. Use this skill when navigating custody disputes, dividing marital assets, calculating support, preparing for family court mediation, or addressing domestic violence protective orders.

Provides guidance on U.S. immigration law including family-based and employment-based petitions, asylum claims, visa processing, and employer compliance. Activate this skill when assessing immigration eligibility, preparing USCIS filings, responding to RFEs, tracking visa bulletin priority dates, or advising employers on I-9 and H-1B obligations.

Covers intellectual property strategy across patents, trademarks, copyrights, and trade secrets, including portfolio management, licensing, and enforcement. Use this skill when conducting IP audits, filing patent or trademark applications, drafting licensing agreements, evaluating freedom-to-operate, or protecting trade secrets during employee transitions.

Covers systematic legal research methodology using both digital platforms and traditional sources, including case law analysis, statutory interpretation, and citator verification. Activate this skill when framing research questions, building case law strategies on Westlaw or LexisNexis, synthesizing authorities into memoranda, or verifying that cited authorities remain good law.

Provides principles and techniques for clear, persuasive legal writing across briefs, motions, memoranda, and client correspondence. Use this skill when drafting court filings, structuring legal arguments using IRAC, writing persuasive statements of fact, editing for concision, or ensuring compliance with court formatting and citation rules.

Covers end-to-end civil litigation strategy from case assessment through trial and post-trial motions, including discovery planning, motion practice, and settlement positioning. Activate this skill when developing case theories, planning discovery strategy, managing litigation budgets, preparing for trial, or evaluating settlement opportunities in complex disputes.

Covers real estate law across commercial and residential transactions, title examination, zoning and land use, and landlord-tenant matters. Use this skill when conducting title due diligence, drafting purchase agreements or lease documents, navigating zoning approvals, managing closings, or resolving boundary and title disputes.

Architectural visualization techniques across V-Ray, Lumion, and Enscape including material creation, lighting strategies, and presentation workflows.

Core AutoCAD skills for architectural drafting including drawing tools, layer management, block creation, dimensioning standards, and plot configuration.

Navigating building codes and regulations including IBC provisions, ADA accessibility, fire safety requirements, zoning compliance, and egress design.

Production of architectural construction documents including plan organization, detail development, specification writing, and code compliance documentation.

Architectural project delivery methods including design-bid-build, design-build, CM at-risk, and IPD approaches along with contract structures, risk allocation, and team coordination.

Building Information Modeling in Revit covering family creation, view management, schedules, worksharing, and level of development standards.

NURBS modeling in Rhino and parametric design with Grasshopper including definition structure, data trees, and computational workflows for architecture.

Architectural modeling in SketchUp including push-pull workflows, component organization, extension ecosystem, and V-Ray rendering integration.

Structural engineering fundamentals for architects including load path analysis, preliminary beam and column sizing, foundation types, and seismic design considerations.

Sustainable architectural design including LEED certification, Passive House standards, energy modeling tools, daylighting strategies, and high-performance building envelope design.

senior data engineer who has built and operated Airflow deployments orchestrating thousands of tasks across complex data pipelines. You have debugged scheduler deadlocks, designed DAGs that handle fai.