Data and analytics engineer with hands-on experience building end-to-end pipelines and dashboards (dbt → Postgres → Evidence; Snowflake medallion layers → Tableau) and conducting on-chain transaction analysis (Solana DEX/oracle alignment). Comfortable translating ambiguous questions into measurable KPIs, reliable datasets, and stakeholder-ready insights.
Lockfit
Remote
Improved onboarding measurement and iteration loop (AI-assisted product analytics coaching), contributing to a 30% sales increase through higher activation and better user flow decisions.
songndongpfeffer.de
Remote
Built and launched the website and analytics foundation; currently piloting marketing campaigns and analyzing sales/conversion by region in Germany and by ad network to optimize targeting and creative. Introduced AI workflows (e.g., Gemini) for faster analysis and improved product photography assets to support conversion.
Supra Oracles
Remote
Performed granular time-series and statistical analysis on 10k+ Solana DEX trades (same pair across multiple liquidity providers; e.g., SOL – RAY pairs) to identify arbitrageur behavior patterns and market structure signals. Calculated market vs. execution prices by synchronizing trade-level block timestamps with Solana oracle price feeds, enabling precise behavioral insights across multiple DEX pools. Investigated incentives driving arbitrageurs to prefer specific markets; contributed research inputs for the modeling and development of Supra’s Dynamic Function Market Maker (DFMM). Built core metrics dashboards (Tableau + internal datasets) to evaluate growth, performance, and adoption of the Supra blockchain for leadership and investors.
Freelance
Remote
Conducted protocol-level research by analyzing business logic and capital flows (inflows/outflows by asset, pool, venue, and time window) to define measurable growth metrics and identify market structure signals—supporting decisions around incentives, capital allocation, and investment opportunities. Built automated trading and analytics systems optimized for speed and discovery, including bots that detect newly created pairs before they surface in AMM UIs and execute based on pre-defined strategy and risk parameters. Developed wallet-level performance and PnL reporting: initially decoded Solana transactions directly (higher engineering effort), then migrated to DuneSQL-based extraction where decoded data improved iteration speed and reporting latency; delivered outputs that clients adopted for recurring performance reviews. Integrated multi-chain data sources (Solana/EVM tooling, Dune, RPC/APIs) and standardized outputs into reusable datasets and client-ready reports (Excel + Telegram delivery workflows). Emphasized reliability and reproducibility: logging/monitoring, backfills when data sources changed, and clear runbooks/documentation for repeatable reporting.
Tirla Technologies LTD
Douala, Cameroon
Delivered websites for niche SMB clients end-to-end: requirements gathering, site build (WordPress/Mobirise), and payment gateway integration to support online sales. Planned and optimized Google Ads + outreach workflows; produced performance reports and used campaign/web analytics to iterate on messaging and improve lead generation. Worked directly with business owners to translate goals into technical specs, ship quickly, and maintain systems post-launch.
M.Sc.
M.Sc.
B.Sc.
GPA 3.14
Built an end-to-end analytics engineering mini-project: transformed raw e-commerce data into clean, business-ready models in Postgres using dbt (including tests) and served KPI dashboards using Evidence. Modeled core gold datasets (fact/orders, dim/customers) and documented the architecture and reproducible local setup for reviewers.
Implement a Snowflake data pipeline using the Bronze/Silver/Gold (medallion) architecture, including ingestion, transformations, and data quality checks. Built reporting-ready gold aggregates/datamarts and published interactive dashboards analyzing revenue, occupancy rates, booking trends, and cancellations.
Developed a bot that automates retrieval and reporting of DEX transaction histories to streamline portfolio tracking and profitability analysis across Ethereum (ETH), BSC, and Solana. Leveraged Dune Analytics by crafting complex SQL queries for aggregation; formatted outputs into user-friendly Excel reports and delivered them through a Telegram bot interface.
Developed a bot to compute profit/loss ratio for Solana wallet addresses and generated detailed reports for analysis and copy-trade research. Built with Python, SQLite for storage, and solana-py for on-chain interaction.
Created reusable scripts for interacting with decentralized exchanges using web3.py, Solidity, and multiple APIs (Alchemy, Honeypot.is, GoPlus). Built token evaluation and monitoring utilities to screen out fraudulent ERC-20 tokens and track liquidity/scam indicators.