At Immunefi, I restructured BigQuery data warehouses and table schemas to support scalable analysis and lower query costs. I also optimized a scheduled scraper and AI pipeline connecting external APIs, internal systems, transformations, and a consumption-ready API.
I developed Python APIs and product-feature logic, integrating OpenAI-compatible APIs into AI/data pipelines. By reducing API calls and token usage by 80%, I lowered execution time and cost while preserving data integrity.
I designed Segment tracking plans, debugged ingestion, and improved downstream routing to Mixpanel. I built Looker dashboards used across company teams, with approximately 20 unique users accessing them daily; ad-hoc reporting fell 85%.
Earlier, I performed SQL exploratory analysis and maintained database inserts and data-cleaning routines for historical accuracy. I also initiated engagement-analysis projects and created a Discord bot to generate additional insights.
