About Me
Experience
Data Analyst
Certified Kernel Tech LLC (CertiK) - - Now
职位: Data Analyst | 时间段: Oct.2022 - Apr.2024 | 工作内容: Developed a Social Listening Dashboard in Tableau using social media data (Twitter, News, Discord, etc.) to track key metrics such as engagement and sentiment, resulting in $25K/year in subscription savings and profitability. Onboarded on-chain data and token prices for 10+ blockchain networks using SQL and Python in Apache Airflow, synchronizing data across formats (JSON, Parquet, CSV) and platforms (Snowflake, TiDB, S3). Optimized ETL workflows by refactoring DAGs, enhancing logic, and improving the replication library, resulting in higher data integrity and workflow efficiency for 2 major products. Performed and delivered monthly usage analysis for all SaaS services (Snowflake, AWS, etc.) to optimize resource allocation and reduce costs. Developed Snowflake Usage Monitoring dashboards on Metabase and optimized company-wide queries, warehouses, tables, and ETL task scheduling, achieving 12% annual cost savings and a 50% boost in pipeline performance. Established Grafana dashboards for Airflow monitoring, enhancing visibility and control over 500+ workflows, and implemented data monitors (Monte Carlo) to identify and resolve 30+ data issues, improving operational oversight, data accuracy, and reliability. Authored comprehensive documentation for blockchain data (EVM, non-EVM, PoW chains, transaction logs, token transfers, liquidity pools, etc.) and contributed to 10+ platform guides on topics such as Airflow onboarding and query execution, significantly enhancing onboarding efficiency and knowledge sharing.
