• Creating and managing end-to-end complex databases for consumer product sectors such as Bakery, Confectionery, Meat, Health & Wellness, and Spirits – database involves the creation of comprehensive data sets for 50 countries covering market sizing (value and volume), key brands and distribution patterns.• Constructing data sets, modeling and forecasting on the basis of qualitative & quantitative factors.• Managing detailed industry forecast reports which focus specifically on key consumer trends impacting CPG industry - responsible for the overall quality standard and timely delivery of the reports. • Developing data visualization using Crosstabs, Heatmaps, Box and Whisker charts, Scatter Plots, Geographic Maps, Pie Charts and Bar Charts.• Developing tableau dashboards on the market data

• Analysing raw data, drawing conclusions & developing recommendations.• Responsible for loading, extracting and validation of client data. To extract company information, analyze content, industry data and project future growth rates to model a market in the CPG industry. Research, analyze and develop data on markets and sectors pertaining to Consumer and Packaged Goods globally.• Handling client queries – evaluating the existing data and bridging the gap between the client’s counter data and company’s data and responsible for the development of client data on current trends.• Market research: Analysing data using both quantitative and qualitative methods and making recommendations to senior managers based upon research findings.• To research and review on industries and countries so as to support the market modeling and thereby help publish a report.• Generated factually-supported recommendations for clients, highlighting promising areas for growth.• Analyzed and reported competitive, economic and industry trends to Marketing & Sales management.• To help review the data from various perspective viz. distribution channels, brand shares and market sizing.• Evaluate numbers using secondary sources and primary data to derive at a credible and authentic number for PCE and PCC of a country’s market.

-Preparing market research report on semiconductor & electronic industry through secondary research and primary research-Conducting secondary research through public databases like Factiva, Hoover's, Bloomberg and Business Week‎, journals, industry specific articles, and company’s annual reports-Conducting primary research by telephonic and video discussion with CEOs, Directors, Managers, Subject Matter Experts (SMEs), and Product Specialists- Profiling key players of respective market in market research report. Company profile includes business overview, products & services, key strategy, and SWOT analysis-Writing chapters of report as per TOC (table of content). Chapters are introduction, research methodology, executive summary, market overview, industry trends, market segmentation (by type, by technology, and by geography), and competitive landscape-Preparing Market Engineering (ME) by analyzing market trends and forecasting growth of market in terms of market size and CAGR (compound annual growth rate) -An analytical mind and have knowledge of Word, Advanced Excel, PowerPoint.

I did my Internship in Zydus wellness ltd . It is a FMCG company deals with four products; Sugar free, Nutralite, Everyuth, Actilife. In my internship,i am subjected to find the Brand penetration and Advertising Efficiency of Nutralite brand. In order to find those attributes, i prepared a structured questionnaire and interviewed 100 hotels and analyzed the results. Following the analyzed results Zydus wellness make some changes in their advertising spending to penetrate into Tier 2 and Tier 3 cities.