Arohi Agrawal

• Launched and scaled a data-driven Amazon brand, achieving 30–35% month-over-month revenue growth within first 6 months
• Managed full product lifecycle: sourcing, supply chain, inventory, vendor coordination, reducing stockouts by 35%
• Executed pricing strategy, A/B testing, and promotions, boosting conversion by 20% and sales volume by 25%
• Created and managed creative assets and Amazon PPC campaigns, optimizing ACOS by 25%
• Built dashboards to track sales, margins, inventory, and customer behavior, enabling 15% improvement in profitability and decision speed

Semantic Layer & KPI Standardization

• Designed and maintained Looker views and joined models across sales, finance, editorial, and video teams, enabling 25% faster insights delivery
• Defined standardized metrics and naming conventions adopted company-wide, reducing reporting errors by 20%
• Integrated cross-team data into reusable models, providing stakeholders with consistent, actionable KPIs

Dashboard Performance Optimization

• Partnered with data engineers to restructure queries and optimize joins, reducing dashboard load times by 35% and lowering query costs by 30%, resulting in approximately $50K in annual operational savings.
• Implemented deduplication and deterministic ranking logic using SQL window functions
• Validated new ELT pipelines in BigQuery before exposing data to Looker dashboards

KPI & Reporting Automation

• Automated recurring executive reports using validated Looker models with deduplicated data, saving 10 hours per month
• Delivered insights that informed editorial, social, and ad spend allocation, improving campaign efficiency by 15%

High-Traffic Editorial Campaign Analytics

• Led analysis of major editorial campaigns and cover launches, identifying engagement and conversion drivers that contributed to an 8–12% lift in reader engagement (MoM)
• Forecasted 2-year audience traffic using Google Analytics and lightweight Python, improving campaign planning accuracy by 10%
• Delivered MoM and YoY executive reports, standardizing insights for editors, social, and ad teams
• Provided actionable recommendations to social media and advertising teams, improving campaign ROI by 15%

• Redesigned website structure and content using Google Analytics, increasing lead conversion by 15%
• Proposed CTA and content changes adopted by founder, improving engagement by 12%
• Supported client acquisition initiatives using data-driven UX improvements

• Produced reports on website traffic and engagement trends, guiding marketing and outreach initiatives