Archana Arora

About Archana Arora

10 years’ experience in consumer insights, analytics, account management and project…

Experience

1. Group Manager - Marketing Analytics

   WNS

   Mar 2022 — Present · Houston, TX, US

   As a client engagement lead for Coca-Cola Latin America my key responsibilities include assisting client\'s marketing analytics team dive deeper into various data sources both Primary and Secondary, using different analytical tools and techniques to answer key business questions. Some of the key deliverables over the last year are - Key Deliverables:• A scalable automated Power BI dashboard to provide regular Categories Health Assessment for the team to help take data driven strategic decisions and design in-market plans. This partial automated solution greatly improved the turnaround time for the bi-monthly report. • Power BI based self-served automated solution for the Flavors team enabling their monthly reviews. This was developed directly in consultation with the key stake holder (Flavors brand team).• Bi-annual BEACH PowerPoint presentations for LATAM markets and Top Bottlers to facilitate business reviews between KO leadership and Bottler leadership. • Consumer analysis through BEACH data including opportunity sizing to support the LRP development. • Reported campaign analytics for ‘Magic Weekend 2.0’ in PowerPoint– currently leading the development of an automated dashboard for KPI reporting and deep dive analysis.

Education

• IMI Delhi

  Master of Business Administration - MBA, Marketing

  2003 — 2005

• University of Calcutta

  Bachelor's degree, Commerce

  2000 — 2003

Skills

• Segmentation
• Advertising Research
• Market Research
• Secondary Research
• Customer Insight
• Project Management
• Quantitative Research
• Marketing Research
• Primary Research
• Team Management
• Questionnaire Design
• Consumer Behaviour
• Competitive Analysis
• Market Intelligence
• Brand Equity
• Client Relations Skills