Mansi More
Vadodara
Summary
Senior Consultant with over 9+ years of experience in Analytics and proficiency in Market Mix Modeling(MMM), model development, insights & recommendation generation, story building, presentation & stakeholder communication. Proven skills in people management and managing clients to ensure efficient and effective project deliveries under all circumstances.
Overview
10
10
years of professional experience
Work History
Senior Consultant
Analytic Edge
Bangalore
08.2022 - Current
- Working on executing MMM models for APAC region right from the data collection till report building
- Understand the trend of the sales, ATL & BTL data, look for missing value, outliers and suitable transformation method along with saturation parameters
- Making sure model is statistically and commercially robust with best R2 & MAPE
- Analyze results KPIs and build a comprehensive report presentation along with brand performance story
- Provide recommendations & insights to the client based on optimization and simulate results
- Provide data & excel trainings within team
Research Analyst
NielsenIQ India Ltd
Vadodara
10.2019 - 08.2022
- Carrying out end to end process of an ASO from Data extraction till results delivery.
- Assortment and Space Optimization for top CPG clients.
- Analyze the DEX information and segmentation of the category and items based on their distribution and detailed information
- Create scenarios and assess potential category versus current category state by testing the impact of different parameter settings before selecting an assortment for recommendation
- Continuous daily communications with counterparts to attain smoother delivery of projects through calls and emails
- Provide process training to new joiners and onboard them with the live project
- Review & Supervise the project work of the new joiners
- Continuous learning and practicing updated methodologies to provide better service to the client
Assistant Manager
Havmor Ice Cream Ltd
Ahmedabad
04.2019 - 09.2019
- Responsible for competition analysis using price and product Indian Population based data analysis such as store availability and future scopes identification
- Report making and analyzing monthly Nielsen sales data
- Help in strategy planning and sales forecasting
Business Analyst
TATA Consultancy Services
Gandhinagar
03.2015 - 03.2019
- Marketing Mix Modeling for top CPG clients
- Analyze the response of the customers of different demographics to the promotional activities of the clients based on the store sales data and define consumer purchasing behavior based on current market trend
- Build statistical model and answer the business questions of the clients based on qualitative analysis to optimize their return on investments
- Derive findings and insights from the model along with recommendations to improvise marketing strategies and budget
- Simulating and Forecasting past sales data for optimum utilization of media advertisement budget and marketing efforts
- Constant connect with onshore counterparts to attain smoother delivery of projects through daily calls and emails
- Continuous learning and practicing updated methodologies to provide better service to client
- Active participation in team huddles and other team bonding activities to increase inter-team connect and provide continuous support to team
- Provide training on MMM tools and methodology.
Education
MBA - Finance
L J Institute of Management Studies
Ahmedabad01.2015
BBA - Finance
NRIBM, Gujarat University
Ahmedabad05.2012
Skills
- Marketing Mix Modeling(MMM)
- Regression Analysis
- Exploratory Data Analysis
- Story Building
- Optimizations & Simulations
- Insights & Recommendation Generation
- Power-Point Deck Building
- Power-Point Presentation
- Advanced Excel
- Nielsen Analytics Tools
- Nielsen Data
- Stakeholder Communication
- Stakeholder Management
Languages
Gujarati
First Language
English
Advanced
C1
Hindi
Proficient
C2
Accomplishments
- Awarded Start of The Year - Bronze for 2017 from Nielsen
- Awarded 2 On The Spot awards from Nielsen
- Awarded Star of The Month in February 2017
Timeline
Senior Consultant
Analytic Edge
08.2022 - Current
Research Analyst
NielsenIQ India Ltd
10.2019 - 08.2022
Assistant Manager
Havmor Ice Cream Ltd
04.2019 - 09.2019
Business Analyst
TATA Consultancy Services
03.2015 - 03.2019
MBA - Finance
L J Institute of Management Studies
BBA - Finance
NRIBM, Gujarat University
Similar Profiles
Claudia DrakeClaudia Drake
Personnel Assistant I - Site Security Manager at Chenega Analytic Business Solutions, LLCPersonnel Assistant I - Site Security Manager at Chenega Analytic Business Solutions, LLC
Joseph VoreJoseph Vore
Software Engineer at Analytic IndexSoftware Engineer at Analytic Index
Athena BlueAthena Blue
Escort Support Personnel Assistant at Chenega Analytic Business Solutions LLCEscort Support Personnel Assistant at Chenega Analytic Business Solutions LLC