Devashish Rana
Indore,Madhya Pradesh
Summary
Detail-oriented Market Research Consultant and Data Analyst with 2+ years of experience managing large-scale Brand Health Tracking (BHT) projects, quantitative and qualitative research, dashboard reporting, and client communication. Skilled in survey design, data analysis, sampling methodology, and actionable insight generation across FMCG, Automotive, Beverage, and Social Networking sectors. Adept at delivering high-quality outputs under tight deadlines using Excel, Power BI, Survey Reporter, and SQL.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Research Consultant
Kantar (Certainty–Kantar Secondment)
10.2024 - Current
- Managed P&G Brand Health Tracking across 14 categories in KSA, UAE, and Kuwait, ensuring monthly and quarterly reporting cycles meet quality standards and client deadlines.
- Gathered client inputs, coordinated with scripting and field teams, and delivered actionable Excel reports and interactive dashboards.
- Led ad hoc research projects, including concept evaluation, pack testing, and product testing, improving client decision-making effectiveness.
- Ensured 100% on-time delivery across 12 consecutive waves by optimizing internal project workflows.
Senior Research Analyst
Certainty Infotech
05.2024 - 10.2024
- Spearheaded reporting activities, coaching junior team members and ensuring 98%+ data accuracy across all client deliverables.
- Developed impactful client reports, combining primary research insights with secondary data to enhance strategy recommendations.
Research Analyst
Certainty Infotech
05.2023 - 05.2024
- Supported client projects for brands like Jeep, Domino's, and Nestlé Confectionery, contributing to successful project delivery within deadlines.
- Designed survey instruments, analyzed datasets (sample sizes of 2,000–5,000 respondents), and developed client-ready dashboards, enhancing insight accessibility for stakeholders.
- Conducted secondary research and competitive intelligence reporting for new market entry projects.
Education
MBA - Data Analytics and Finance
Prestige Institute of Management And Research
Indore01.2023
BBA - Finance
St. Paul Institute of Professional Studies
Indore01.2021
Skills
- Quantitative & Qualitative Research
- Brand Health Tracking (BHT)
- Survey Design & Data Tabulation
- Dashboard & Report Creation (Excel, Power BI)
- Sampling Methodology & Fieldwork Monitoring
- Data Cleaning & Quality Assurance
- Client Communication & Stakeholder Management
- Secondary Research & Competitive Analysis
- Project Coordination and Team Leadership
TECH SKILLS
- Excel (Advanced Functions, PivotTables, VBA Macros)
- PowerPoint (Storyboarding, Visual Reporting)
- Power BI (Dashboard Building, Data Modeling)
- SQL (Data Extraction and Analysis)
- Survey Reporter (Survey Data Management)
- SPSS (Basics of Statistical Testing)
Certification
- Data Analysis Certification – Insta Analytics
- Advanced Excel Certification
- Market Research Foundations – LinkedIn Learning
Timeline
Research Consultant
Kantar (Certainty–Kantar Secondment)
10.2024 - Current
Senior Research Analyst
Certainty Infotech
05.2024 - 10.2024
Research Analyst
Certainty Infotech
05.2023 - 05.2024
MBA - Data Analytics and Finance
Prestige Institute of Management And Research
BBA - Finance
St. Paul Institute of Professional Studies
Similar Profiles
Raquel PachecoRaquel Pacheco
Content Marketing Author at KantarContent Marketing Author at Kantar
Subhayan BanerjeeSubhayan Banerjee
Senior Research Manager at KantarSenior Research Manager at Kantar
Stacey GoodmanStacey Goodman
Senior Manager Qualitative, Client Strategy at KantarSenior Manager Qualitative, Client Strategy at Kantar
Manivendra KumarManivendra Kumar
Senior Research Fellow, SHSS at Indian Institute of Technology IndoreSenior Research Fellow, SHSS at Indian Institute of Technology Indore
Yash NigamYash Nigam
SR. Specialist at QUALITEST INDIA PVT LTD.SR. Specialist at QUALITEST INDIA PVT LTD.