Jasper Vault - Crypto Analytics & Trading Research

Overview

As a Business Analyst Intern at Jasper Vault Technology, a Singapore-based crypto fund, I developed analytics dashboards, optimized data workflows, and researched algorithmic trading strategies to support investment decision-making.

The Journey

1. Problem Identification

Challenges in Crypto Fund Management:

• Complex on-chain data scattered across multiple sources
• Need for real-time market intelligence
• Manual data retrieval and analysis was time-consuming
• Required actionable insights for weekly investment meetings
• Needed to identify smart money movements and trends

Goals:

• Centralize crypto market analytics
• Automate data collection and analysis
• Provide actionable insights for fund management
• Enable data-driven investment decisions

2. Dune Analytics Dashboards

Developed comprehensive dashboards for:

Ethereum (ETH) Staking Analytics

• Staking metrics and trends
• Validator performance analysis
• Network health indicators
• Yield analysis and projections

Smart Money Holdings Analysis

• Whale wallet tracking
• Large holder movements
• Position changes and accumulation patterns
• Risk and opportunity identification

Crypto Market Trends

• Market sentiment indicators
• Trading volume analysis
• Price correlation studies
• Sector-specific performance metrics

Technologies: Dune SQL, Data Visualization, Blockchain Analytics

Application:

• Presented insights in weekly investment meetings
• Supported fund management decisions
• Identified market opportunities and risks
• Tracked portfolio-relevant metrics

3. Data Workflow Optimization

Problem:

• Multiple API providers with different formats
• Manual data retrieval was inefficient
• Needed consistent data pipeline

Solution: Streamlined data workflows by:

• Integrating various API providers
• Automating data retrieval with Python scripts
• Standardizing data formats with Power Query
• Creating reusable data pipelines

Technologies: Python, Power Query, API Integration

Benefits:

• Automated data collection
• Consistent data formatting
• Reusable workflows
• Significant time savings

4. Algorithmic Trading Research

Objective: Explore AI-powered algorithmic trading strategies

Activities:

• Researched machine learning applications in crypto trading
• Developed trading strategies on TradingView
• Backtested strategies with historical data
• Optimized parameters for performance
• Analyzed risk-reward ratios

Platform: TradingView with Pinescript

Focus Areas:

• Technical indicator optimization
• Entry/exit signal generation
• Risk management strategies
• Performance metrics evaluation
• Market regime adaptation

Insights:

• Identified viable trading strategies
• Understood market microstructure
• Evaluated strategy robustness
• Assessed implementation feasibility

Technical Skills Demonstrated

Blockchain & Crypto Analytics

• Dune SQL: Complex on-chain data queries
• Blockchain Data: Understanding of Ethereum ecosystem
• Market Analysis: Crypto market dynamics and trends
• Smart Money Tracking: Whale behavior analysis

Data Engineering

• API Integration: Multiple provider consolidation
• Python: Data processing and automation
• Power Query: Data transformation
• ETL Pipelines: Automated data workflows

Trading & Strategy

• Pinescript: TradingView strategy development
• Backtesting: Historical performance analysis
• Parameter Optimization: Strategy tuning
• Risk Management: Portfolio risk assessment

Business Analysis

• Dashboard Development: Executive-level reporting
• Presentation: Weekly investment insights
• Investment Research: Market opportunity identification
• Stakeholder Communication: Technical to business translation

Key Achievements

Analytics Impact:

• Created production-grade dashboards for fund operations
• Enabled data-driven investment decisions
• Provided weekly actionable insights
• Identified market trends and opportunities

Operational Efficiency:

• Automated manual data collection processes
• Established reusable data pipelines
• Reduced time spent on data preparation
• Improved data accuracy and consistency

Research Contribution:

• Explored AI-powered trading strategies
• Completed comprehensive backtesting
• Optimized strategy parameters
• Built knowledge base for trading systems

Domain Knowledge

Crypto & DeFi

• Ethereum staking mechanisms
• DeFi protocols and metrics
• On-chain analytics interpretation
• Crypto market dynamics

Fund Management

• Investment decision support
• Portfolio analytics
• Risk assessment
• Market research

Technical Trading

• Algorithmic strategy development
• Quantitative analysis
• Backtesting methodologies
• Risk-reward optimization

Context

Jasper Vault Technology Pte Ltd is a Singapore-based cryptocurrency investment firm. This role was my Business Analyst Internship from May 2023 to October 2023, where I contributed to the firm’s data infrastructure and investment research capabilities.

Technologies Used

• Analytics: Dune Analytics, Dune SQL
• Data Processing: Python, Power Query
• Trading: TradingView, Pinescript
• APIs: Various crypto data providers
• Visualization: Dashboard development tools

Impact

This internship provided:

• Deep understanding of crypto markets and on-chain analytics
• Practical experience with financial data workflows
• Exposure to quantitative trading research
• Business analysis skills in investment context
• Foundation for data-driven decision making