Open to opportunities

Prerana B

@preranab

Message

Consumer Insights & Data Analyst turning customer data into growth.

India

Message

What I'm looking for

I’m looking for a consumer insights/data analyst role where I can build Power BI dashboards, turn customer and market data into actionable intelligence, and partner with marketing and sales to drive measurable growth.

I’m a results-driven Consumer Insights & Data Analyst with experience across FMCG and hospitality, recognized for proactive problem-solving and managing multiple priorities in fast-paced environments. In my current role, I leverage Power BI and advanced Excel to analyze customer behavior and purchase patterns—identifying 25% growth potential—while building automated KPI dashboards that streamline data-led decisions for marketing and customer performance.

I also bring deep market intelligence: I’ve analyzed 10K+ customer data points alongside category and competitor signals to track menu and food trends and translate complex datasets into actionable insights for marketing and sales teams. Beyond analytics, I’ve supported product strategy and launch phases through performance benchmarking and NPD collaboration, and I’ve upheld rigorous food safety and quality compliance through data-backed corrective actions and major audits (BRC and Red Tractor).

Experience

Work history, roles, and key accomplishments

Current

Consumer & Market Analyst

Current

Wishing Well Marketing

Dec 2024 - Present (1 year 5 months)

Used Power BI and advanced Excel to analyze customer behavior and purchase patterns, identifying 25% growth potential. Built automated KPI dashboards and performed market analysis on 10K+ customer data points to deliver actionable menu and food trend insights for marketing and sales.

Power BI Excel KPIs Market Intelligence Data Visualization Trend Analysis Competitor Analysis

Product Specifications Analyst

Bon Bons Wholesale

Feb 2024 - Jul 2024 (5 months)

Conducted product performance benchmarking and sales analysis to support New Product Development (NPD) and launch-critical activities across technical teams. Managed product specifications, artwork, and compliance processes to ensure 100% adherence to quality management systems and health & safety standards.

Product Specification Sales Analysis Benchmarking New Product Development Compliance Management Quality Management Systems Health & Safety Data Analysis Excel

Shift Analyst - Fresh Produce

Morrisons

Jul 2022 - Feb 2024 (1 year 7 months)

Built and maintained Power BI and Excel KPI dashboards that transformed raw production data into visual insights for food safety and quality compliance. Performed trend and root-cause analysis to implement corrective actions and supported BRC and Red Tractor audits using technical data to validate global food safety benchmarks.

Power BI Advanced Excel KPIs Root Cause Analysis Food Safety Analytics Quality & Compliance Trend Analysis Audit Support

Sales & Marketing Executive

Taj Hotels

Dec 2018 - Oct 2020 (1 year 10 months)

Analyzed customer booking patterns and purchase triggers to refine service strategies and optimize pricing. Used qualitative feedback and market data to improve customer engagement and identify new revenue streams.

service strategy Market Research Customer Engagement Revenue Growth Excel

Education

Degrees, certifications, and relevant coursework

Sheffield Hallam University

Master of Science, Consumer Marketing

2021 - 2022

Earned a Master of Science in Consumer Marketing, covering consumer insights, analytics, digital marketing strategy, brand management, and qualitative/quantitative research methods.

Christ University

Master of Business Administration, Business Administration

2016 - 2018

Completed a Master of Business Administration focusing on business strategy, marketing management, and commercial operations, including market entry and commercial decision-making in the Indian retail landscape.