Divine Ogieva

Divine Ogieva

$30/hr
Blockchain data analyst specializing in on-chain analytics, SQL, Python & DeFi research insights.
Reply rate:
-
Availability:
Hourly ($/hour)
Location:
Ikotun, Lagos, Nigeria
Experience:
2 years
DIVINE AIMUAMWONSA OGIEVA https://www.linkedin.com/in/divineogieva |-| https://flipsidecrypto.xyz/deevhyn/dashboards | https://github.com/Deevhyn | -, - SUMMARY Crypto Data Analyst with 2+ years of experience in on-chain analytics and DeFi research. Expert in SQL-based blockchain analytics using Dune and Flipside platforms, with Python skills for data analysis and visualization. Created dashboards used by 100+ and automated workflows that improved operational efficiency by 50-75%. WORK EXPERIENCE Second Mountain HQ, Remote Research Analyst & AI Automation Specialist • • • • • • Conducted on-chain and market research to support treasury growth (from $75K toward $200K target). Built frameworks analyzing TVL, active addresses, stablecoin transfers, and DEX volume across BTC, ETH, BSC, and Optimism. Developed the Crypto Daily Digest Workflow: Scrapes news from Cryptopanic via HTTP tool, summarizes content, and exports to Google Sheets for marketing and content teams. This reduced the content team’s research timeframe by 75% and improved engagements on social media by 30%. Extended workflow pushes summarized news and memes to Discord and Telegram via bots, streamlining content delivery for social media. Created Research driven blog posts Built the Artemis Metrics Scraper Workflow: Automates daily extraction of on-chain metrics (price, % change, TVL change) from Artemis into Google Sheets. Analytic Sages, Remote Data Analyst & Community Contributor • • Jan 2025 - Sep 2025 Jan 2024 – Present Mentored new analysts on SQL querying and dashboard design for Flipside and Dune. Organized research-driven AMAs and analyst workshops, improving engagement by 30%. EDUCATION University of Benin Benin City, Nigeria B.Sc., Actuarial Science (2.1) Graduation Date: May 2022 Accounting Technicians Scheme, ICAN Member, Accounting Technicians Scheme Induction Date: June 2021 PROJECT EXPERIENCE Whale Activity vs. Price Movement (Python, GitHub) Analyzed the relationship between large wallet transactions and token price volatility, using pandas and matplotlib for correlation analysis. Project link: https://github.com/Deevhyn/Whale-Activity-vs-Price-Movement PnL Wallet Explorer (Python, GitHub) Collaborated on a multi-chain tool for calculating realized and unrealized wallet-level P&L across 6+ blockchains. Project link: https://github.com/FirstBML/PnL-Wallet-Explorer Uniswap Fee Change Analysis (Uniswap Bounty #35) Ranked in the Top 30% of entries for analyzing user response to new 0.15% & 0.25% fees on Uniswap DEX. Project link: https://flipsidecrypto.xyz/deevhyn/user-behaviour-on-uniswap-fee-changes-rfSpQP Axelar Cross-Chain Innovation Earned a community shoutout for dashboard showcasing interchain messaging adoption trends. Project link: https://flipsidecrypto.xyz/deevhyn/ax3lar-at-the-frontier-of-interchain-innovationJaVxgv Chain Token Analytics Dashboard Compared BTC, ETH, Optimism, and BSC using TVL, active addresses, stablecoin flow, and transaction volume to track network adoption. Project link: https://dune.com/smoperations/chain-token-analytics SKILLS & INTERESTS • • • • • • • • AI Automation & Workflow Orchestration (n8n, HTTP requests, Google Sheets API, Discord/Telegram bots, automation pipelines) On-Chain Data Analysis (Flipside, Dune, SQL, DeFi protocol metrics, NFT marketplace insights) Programming & Data Tools (Python, Pandas, Matplotlib, FastAPI, Web Scraping, GitHub, Excel, Tableau) Blockchain Analytics (Wallet behavior, whale activity tracking, cross-chain adoption, liquidity analysis) Visualization & Dashboards (Interactive dashboards for protocol performance, token flows, and user metrics) Soft Skills (Research writing, collaboration, community engagement, clear communication) Languages: English (Fluent) Interests: Web3 Research, DeFi Analytics, Tokenomics, AI Automations, Mathematical Statistics
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.