Product Analytics for the Decentralized Web
Building Trustworthy Data Systems & Experimentation Frameworks for the Web3 Era
Professional Portfolio
Databricks Genie Integration
Designed a natural language interface for complex enterprise datasets, enabling non-technical stakeholders to query member and product data via SQL generation. Bridged the gap between raw data and actionable insights.
- Text-to-SQL: Integrated Genie API for semantic querying
- Complex Data Matching: Fuzzy matching logic for entity resolution
- Scale: Handles bulk matching of thousands of rows
VOC & Buyer Journey Insights
Built a dual-brain architecture to analyze unstructured Buyer Journey documents. Combines SQL-based structured queries with RAG-based document retrieval to extract qualitative insights from customer feedback.
- Hybrid Retrieval: SQL + Vector Search routing
- Orchestration: LangGraph for stateful multi-step reasoning
- Data Quality: Automated validation of retrieved chunks
Marketing Experimentation Framework
Automated the statistical validation of marketing experiments. Implemented rigorous hypothesis testing methods (Z-test, Chi-square) to determine winners with confidence, ensuring data-driven decision making.
- Statistical Rigor: Automated Z-tests & Post-hoc Power Analysis
- Confidence Intervals: Visualizing uncertainty for stakeholders
- Python Backend: FastAPI service for real-time analysis
Ad Data Ingestion Pipeline
Engineered reliable ETL pipelines to fetch granular camapign usage data via LinkedIn Marketing APIs. Solves data granularity issues by bypassing UI export limits for precise measurement.
- Automated ETL: Daily extraction of campaign metrics
- Granular Data: Row-level data for precise attribution
- Entity Resolution: Enriched dataset with Organization names
GA4 Data Foundation
Built a robust pipeline to extract unsampled event data from Google Analytics 4. Bypassed UI sampling limits to deliver 100k+ row datasets for accurate user behavior analysis.
- Sampling Bypass: Accurate data extraction via Data API
- Event Logging: Full extraction of custom event parameters
- Validation: Ensuring data consistency between UA and GA4
Personal Portfolio
OpenClaw - Personal Productivity Agent
Personal family assistant for market intelligence. Synthesizes protocol updates, news, and market signals into clear daily briefs. Acts as an independent agent tracking diverse data sources across channels.
- Synthesis: Cross-channel market mesh
- Briefs: Automated market updates
- Cron Jobs: Protocol signal monitoring
Infinite Memory: Scaling Agentic Memory to 10M Turns
Discovery of the 'Discovery Cliff' in LLM memory scaling. Introduces Recursive Gated Consolidation (RGC) to achieve 100% signal recall at extreme scale ($10^7$ turns), maintaining O(1) memory scaling for production-grade AI agents.
- The Discovery Cliff: Identification of 17% recall collapse at scale.
- Recursive Gated Consolidation: Decoupling discovery from history depth.
- Hardware Grounding: TPU v4 OCS and SparseCore optimization analysis.
- Empirical Calibration: Cross-model validation (Gemini 2.5 - 3.1).
Personal AI Infrastructure (PAI v2)
A persistent, self-improving AI Operating System layer integrated across all local projects. Implements standard orchestration cycles and long-term memory via the Kai System for architecture-level persistence and session resilience.
- Orchestration: The Six Cycles of agentic workflow
- Shadow Profile: Secure execution via non-native rituals
- Kai System: Automated decision & learning persistence
- Session Resilience: 429/413 loop awareness & state preservation
Systemic Multi-Agent Coordination
Beyond Chatbots: A dual-layer architecture separating tactical execution from strategic oversight to ensure production-grade AI reliability.
- System 1 (Tactical): Persona-driven sub-agents executing high-velocity task loops (The "Inner Loop").
- System 2 (Strategic): Parent orchestrator enforcing quality gates and architectural safety (The "Outer Loop").
- Synchronized Reasoning: Real-time verification ensuring autonomous execution never breaks project intent.
Autonomous Trading System (V4.1)
Production-grade autonomous trading system managing a dual-track portfolio of Stocks and Crypto. The V4.1 'Steady Winner' strategy achieves 80.8% XIRR (60.3% Alpha over S&P 500) through dual-track asset allocation, Golden Cross momentum, and real-time Shadow Portfolio tracking.
- 80.8% XIRR (60.3% Alpha vs S&P 500)
- Dual-Horizon: Technical momentum vs. long-term fundamentals
- Shadow Tracking: Real-time statistical verification of trade signals
- Tax Efficient: Optimized execution for long-term capital gains
IDE-Agnostic Agent Orchestrator
An orchestration framework that unifies AI agent workflows across VS Code, JetBrains, and CLI. Decouples safety policies (runtime locks, circuit breakers) from specific IDE adapters.
- Policy-First: Mandatory safety and quality gates
- Tool Agnostic: Works across multi-IDE environments
- Circuit Breakers: Prevents infinite agent loops
Astrological Research Platform
Full-stack platform combining astronomical calculations (Swiss Ephemeris) with AI interpretations. Backed by rigorous statistical research with FDR-corrected significance.
- 5,885 figures + 239 countries analyzed
- FDR-corrected significance (q < 0.001)
- 14 yoga types and 6 dosha types validated
- Next.js + FastAPI + PostgreSQL
Philosophy Sage
AI-powered platform for ancient philosophy texts with GraphRAG architecture. Neo4j knowledge graph for contextual retrieval across the Mahabharata, Bhagavad Gita, and other classical texts. Sanskrit TTS integration.
- GraphRAG: Knowledge graph + vector search hybrid
- Neo4j: Entity relationships across 18 Parvas
- Sanskrit TTS: Audio playback of original shlokas
- LangChain: Conversational retrieval chains
Sonic Geometry Visualizer
Interactive exploration of Music Theory × Physics × Math. Real-time oscilloscope, spectrum analyzer, Lissajous figures, Circle of Fifths, and polyphonic virtual keyboard—all native Web Audio API.
- Real-time FFT: Spectrum analyzer + oscilloscope
- Lissajous Curves: Harmonic ratio visualization
- Circle of Fifths: Interactive music theory lab
- Zero Dependencies: Pure vanilla JavaScript
Technical Stack
Data Foundations
API-driven pipelines, Event Taxonomies, Schema Design, Data Monetization Strategy, Bulk Enrichment.
Product Analytics & Experimentation
Hypothesis Testing, A/B Analysis (Z-test/Chi-square), Funnel Optimization, Mixpanel/GA4, SQL/Python Mastery.
Agentic & GenAI
Databricks Genie, LangGraph, LangChain, RAG Architectures, Text-to-SQL, Vector Search, LLM Integration.