Business Analyst
Nineleaps · Jul 2025 – Present
- Developed scalable audience segmentation frameworks using behavioral and purchase signals, analyzing 40B+ rows of
- historical data across 1,000+ datasets to generate custom audiences for global ad campaigns, improving campaign reach
- and ROAS.
- – Developed self-serve audience generation SQL templates enabling Sales teams to generate audiences independently, re-
- ducing analytics dependency by 50% and campaign turnaround time by 40%.
- – Built backend data models and SQL pipelines powering 3 Tableau dashboards for global Ad Sales leadership, defining
- KPIs and computing metrics such as ad spend, impressions, clicks, CTR, CPC, CPM, ROAS, and attributed revenue across
- the advertiser → ad account → campaign → ad group → ad hierarchy.
- – Engineered ETL pipelines and managed deployments via Git-based version control workflows transforming raw trip,
- merchant, and campaign datasets into analytics-ready tables powering campaign performance dashboards.
- – Analyzed large-scale datasets (40B+ rows / 280GB hyperfiles) to derive campaign insights and optimize audience target-
- ing strategies.
- – Standardized taxonomy and category mappings using automations and LLMs to reduce audience noise by 30%, improv-
- ing targeting accuracy and increasing ad engagement by by 25%.



