Ayan Mullick

Associate Consultant

Kolkata, West Bengal, India6 yrs 10 mos experience
AI EnabledAI ML Practitioner

Key Highlights

  • Expert in Primary and Secondary Market Research.
  • Proficient in Data Analysis and Visualization tools.
  • Strong leadership in cross-functional team collaboration.
Stackforce AI infers this person is a Market Research Analyst with strong expertise in Data Science and Analytics.

Contact

Skills

Core Skills

Market ResearchData AnalysisData VisualizationData Integration

Other Skills

Accident InvestigationAmazon Web Services (AWS)Analytical SkillsArtificial Intelligence (AI)Azure DatabricksBrand AwarenessBrand StrategyBrand TrackingBusiness AnalysisBusiness InsightsCampaignsChatGPTChatbotsCommunicationComputer Ethics

About

Hey, I am Ayan 👋 currently working in Kantar as a Associate Research Manager with expertise in Primary quantitative research (Brand tracking, Product testing, Concept testing), Data Analysis and Secondary research for various FMCG clients. I'm always passionate about Market Research. A person who enjoys working with numbers, a keen observer who can effectively manage competing priorities and can perform under pressure. Professional Summary: 👁️‍🗨️Hands-on experience in Market Research, Primary Quantitative and Secondary Research. 👁️‍🗨️Hands-on expertise in carrying out Data Analysis.. 👁️‍🗨️ Competency in Microsoft applications including Word, Excel, PowerPoint & Outlook. 👁️‍🗨️Experienced in creating and delivering dashboards using BI tools - PowerBI &Tableau 👁️‍🗨️ A strong business sense & critical thinking mindset with the ability to work equally well within a team and independently with minimal supervision. 🙋‍♂️Prior to Praxis Business School, Ayan was a Crash Analyst at JP Research based in Kolkata, worked cross-functionally with business roles, technical roles ( Government officials and various automotive clients on Business Intelligence, and other Data-to-Insights initiatives ). Used to collect and analyze real road accident data to reconstruct crashes, improve outcomes and solve problems in the accident research of project RASSI (Road Accident Sampling System - India) I also completed higher studies (PGP) in Business Analytics from Praxis B-School, Kolkata. My major area of interest was Market Research and statistics with deep expertise in Primary Quantitative Research and Secondary Research. Passionate about developing scalable market research studies for strategic brand management in the FMCG sector. Furthermore, I had actively volunteered for several NGOs, which helped me build empathy, compassion, and a desire to positively impact society. 🏃🏻‍♂️Feel free to connect at ayanmullick96@gmail.com. I am always up for a coffee chat.

Experience

6 yrs 10 mos
Total Experience
1 yr 2 mos
Average Tenure
1 yr 8 mos
Current Experience

Kantar

Associate Research Manager

Oct 2024Present · 1 yr 8 mos · Kolkata, West Bengal, India · Hybrid

  • Spearhead the development of proposals and design of questionnaires to ensure project alignment with client objectives.
  • Collaborate with the Fieldwork team to coordinate seamless data collection processes.
  • Leverage in-house software, Excel, and SPSS for comprehensive data analysis.
  • Deliver insights and findings through professionally crafted PowerPoint presentations, ensuring clarity and actionable recommendations
Primary Quantitative ResearchSPSS StatisticsBrand TrackingConsumer InsightBusiness InsightsMarket Research+1

Topmate.io

2 roles

Top 1% Club

Promoted

Jan 2024Aug 2024 · 7 mos · Remote

  • Promoted from Mentor to Super Mentor and stepped into Top 1% Club
Market ResearchStrategic ThinkingDecision-Making

Mentor

Jul 2022Jan 2024 · 1 yr 6 mos · Remote

  • Data Science, Resume Writing, Career Development
CommunicationResume ReviewAnalytical SkillsData ScienceDecision-Making

Wns

2 roles

Analyst- RNA- Research and Analytics

Promoted

Oct 2023Sep 2024 · 11 mos · Pune, Maharashtra, India · On-site

  • Key Responsibilities:
  • Owned and maintained multiple Power BI products, ensuring high-quality and actionable insights for market research stakeholders
  • Collaborated with market research leaders to understand requirements and develop product roadmaps
  • Led cross-functional teams, including data engineers, analysts, and researchers, to deliver product features
  • Designed and implemented data visualizations, reports, and dashboards using Power BI to analyze market trends, customer behavior, and competitor activity
  • Conducted market research analysis, identified key findings, and developed actionable recommendations for business stakeholders
  • Worked closely with data engineering teams to ensure seamless data integration and quality
  • Conducted user acceptance testing, gathered feedback, and iterated on product improvements
  • Developed and maintained technical documentation for Power BI products
  • Market Research Responsibilities:
  • Conducted market analysis, competitor analysis, and customer segmentation
  • Developed and maintained research reports, dashboards, and presentations
  • Collaborated with cross-functional teams to integrate market research insights into business decisions
Market ResearchConsumer InsightMicrosoft Power BIMicrosoft ExcelBrand StrategyBrand Tracking+2

Analyst- Data Science

Mar 2023Oct 2023 · 7 mos · Pune, Maharashtra, India · On-site

  • Conducted Brand tracking, Product testing, and Concept testing for Retail and FMCG clients. Done Primary quantitative research as well as secondary research for multiple FMCG clients.
  • Conducted comprehensive market research studies to identify trends, customer preferences, and competitive landscape
  • Analyzed large datasets using statistical techniques and data visualization tools to derive actionable insights
  • Presented research findings and recommendations to stakeholders, including senior management and clients (FMCG Brands)
Data ScienceMicrosoft AzureMarket ResearchArtificial Intelligence (AI)Market AnalysisBrand Strategy+10

Jp research india private limited

Junior Engineer Associate

Dec 2020Jan 2022 · 1 yr 1 mo · Kolkata, West Bengal, India · Hybrid

  • Investigated accident affected vehicles and the place of occurrence with assistance of Kolkata police officials and forensic team. Analyzed for few black spot areas in National highway and implemented better road infrastructures to reduce accidents. Provided the safety measures to be implemented on vehicles in order to reduce accidents.
Team LeadershipData AnalysisAnalytical SkillsMicrosoft ExcelData CollectionDecision-Making+2

Garuda power private limited

Graduate Engineer Trainee

Jun 2019Aug 2020 · 1 yr 2 mos · Greater Kolkata Area · Hybrid

  • ETL & Data Quality Developer - for one of USA’s leading Manufacturing company.
  • > The main objective of the client was to perform the 6 Dimensions of Data Quality checks on Manufacturing and Sales data stored in SAP S4 Hana and generate Power Bi reports based on the Data Profiling tasks.
  • > Involved in capturing Business Rules based on KPIS from SMEs and converting them into logical Data Quality rules for analysing.
  • > Involved in executing ETL jobs from SAP S4 Hana to MySql database using SQL..
  • > Involved in generating Power Bi reports to the business with logical understanding based on the Data Profiling results.
SQLMicrosoft Power BIData VisualizationData IntegrationExtract, Transform, Load (ETL)

Lloyd electric & engineering ltd

Associate Project Engineer

Jul 2018Apr 2019 · 9 mos · Kolkata, West Bengal, India · On-site

  • Worked in KMRC project on RMPU system in Kolkata Metro Carshed, Noapara.

Sociowash

2 roles

Panasonic Student Marketer

Feb 2018Apr 2018 · 2 mos · Kolkata, West Bengal, India

  • In this Program I was associated with Social Media Marketing Team for Panasonic India with Sociowash.

Hypstar Campus Ambassador

Dec 2017Jan 2018 · 1 mo · Kolkata, West Bengal, India

  • In this Campus Ambassador Program I was associated with Social Media Marketing Team for Hypstar with Sociowash.

National institute of technology raipur

Summer Intern

Jun 2017Aug 2017 · 2 mos · Raipur, Chhattisgarh, India · On-site

  • Attended a summer research internship program in Bio-Medical Research lab of NIT, Raipur for a duration of 1.5 months in the field of design and analysis of Biomedical Engineering.
Microsoft Office

Education

Praxis Business School

Post graduate program — Business Analytics ( Data Science)

Jan 2022Nov 2022

The Indian Institute of Social Welfare & Business Management

Advance Diploma — Fire Safety and Management

Sep 2020Feb 2022

MCKV Institute of Engineering

Bachelor of Technology - BTech — Mechanical Engineering

Jan 2014Jan 2018

Howrah Zilla School

WBCHSE — Science

May 2001May 2013

Stackforce found 100+ more professionals with Market Research & Data Analysis

Explore similar profiles based on matching skills and experience