Prateek Majumdar
Research Analyst
New Delhi
Summary
As a Research Associate at Current Global/Weber Shandwick, a global communications agency, I have had the opportunity to work with leading brands such as Jaguar Land Rover, Credit Suisse, and Omidyar Network India, Kotak Mahindra Bank and Bacardi. My expertise in media research and analysis has helped these brands increase their media presence in just a matter of months.
I am a highly motivated individual with a passion for research and data analysis. My ability to turn complex data into actionable insights has helped brands improve their media presence and increase their market share. I am always looking for new challenges and opportunities to expand my skillset and make a meaningful contribution to the success of any organization.
Overview
4
4
years of professional experience
5
5
years of post-secondary education
1
1
Language
Work History
Sr. Research Associate
Current Global, Weber Shandwick
New Delhi
05.2021 - Current
- Collected, organized, and analyzed data from various secondary sources and databases, customizing them as per project requirements
- Prepared Research Reports, conducted MIS report generation, and maintained project documentation
- Maintained detailed records of project data and materials, updating information when changes arose.
- Developed data collection strategies and monitored data quality for optimal research results.
- Achieved a 30% increase in media presence for Jaguar Land Rover, Credit Suisse, and Omidyar Network India through PR Performance Reports within 6 months
- Generated Marcomm Reports analyzing LinkedIn and Twitter data for Omidyar Network India, resulting in a monthly 5% increase in the marketing budget
- Prepared Daily Coverage Reports and monitors for media research projects involving Omidyar Network India, Credit Suisse, and LinkedIn
- Utilized PowerBI to transform raw media data into actionable insights
- Proactively addressed executional issues specific to media outreach, leading to a 25% improvement
- Maintained a high client satisfaction rate ranging from 90% to 95%
- Developed custom Microsoft Power BI dashboards, visualizations, and interfaces to deliver meaningful and actionable insights
- Skills : SQL, Microsoft PowerPoint, Microsoft Excel, Microsoft Power BI
Information Analyst
Impact Research and Measurement Pvt. Ltd
New Delhi
03.2019 - 05.2021
- Preparing Weekly, Monthly, Quarterly and Annual media research analysis reports for clients
- Preparation of Annual Review Reports for ZEE5 giving my clients an idea to increase their market share to 5-10%
- Recognised by clients with a satisfaction rate of 85-90%
- Scoring of data in Excel then presenting it in MS PowerPoint basis number of articles and circulation.
- Used database to research, gather, analyze and present data.
- Maintained historical records by documenting system changes and revisions
- Collected data by identifying information sources and designing survey and collection methods.
Project
Ikea
04.2021 - 05.2021
- Power BI Marketing Report on global stationary consumerables, Sales report on Global stationaries
- Top 5 profit and loss products
- Top sales by Market
- Top 10 customers
- Sales by Region
- Power BI Crypto Dashboard for
Project
BitDroplet
09.2019 - 02.2020
- Presented a thorough analysis of various cryptocurrencies
- Trend Coverage of Marketcap over the years
- Share of Voice of all cryptocurrencies
- Open and Close data
- Highest, lowest and average results of each cryptocurrency over specific years
- Trend coverage of highest and lowest data
Education
MBA - Business Administration And Management
05.2017 - 05.2019
Bachelor of Science - Hospitality Management
05.2014 - 05.2017
Skills
MS Powerpoint
Timeline
Sr. Research Associate - Current Global, Weber Shandwick
05.2021 - Current
Project - Ikea
04.2021 - 05.2021
Project - BitDroplet
09.2019 - 02.2020
Information Analyst - Impact Research and Measurement Pvt. Ltd
03.2019 - 05.2021
Guru Gobind Singh Indraprastha University - MBA, Business Administration And Management
05.2017 - 05.2019
Dr Ambedkar Institute of Hotel Management - Bachelor of Science, Hospitality Management
05.2014 - 05.2017
Similar Profiles
Nikita BhagatNikita Bhagat
Manager - People at IPG DXTRA – Weber Shandwick & Current GlobalManager - People at IPG DXTRA – Weber Shandwick & Current Global
Himani ChaudharyHimani Chaudhary
Senior Manager, Office Administration at Weber ShandwickSenior Manager, Office Administration at Weber Shandwick
Melanie BigelowMelanie Bigelow
Senior Manager, Social and Inuencer Strategy at Weber ShandwickSenior Manager, Social and Inuencer Strategy at Weber Shandwick