Summary

Overview

Work History

Education

Skills

Passions

Training

Software

Timeline

VIVEK R

Media Analyst

Summary

As a Analyst with 2 years of experience in analyzing large datasets and transforming complex data into actionable insights to drive business growth. Highly proficient in using tools like Excel (Advanced) , Power BI , and Google Analytics to create detailed reports, dashboards, and visualizations that support decision-making and strategic planning. Skilled in statistical analysis, trend identification, and forecasting, with a strong ability to enhance performance and maximize ROI. Known for collaborating effectively with cross-functional teams to optimize strategies and deliver meaningful business results. Currently expanding skills in SQL to enhance data extraction and querying capabilities for more advanced analysis.

Key Highlights :

Advanced Excel skills : Expertise in pivot tables, VLOOKUP, macros, and data analysis.
Proficient in Power BI : Skilled in creating actionable dashboards and data visualizations for stakeholders.
Data-driven insights : Experienced in using Google Analytics and statistical methods to improve marketing strategies and business performance.
Predictive analytics : Strong foundation in regression analysis and forecasting to drive decision-making.
Collaborative team player : Worked with marketing, sales, and product teams to deliver impactful business solutions.

Overview

years of professional experience

years of post-secondary education

Languages

Work History

Media Research Analyst

Tag Fact Services Pvt.ltd

02.2023 - Current

Analyzed large datasets from various media and marketing platforms, identifying trends, insights, and patterns that informed both media strategies and business decisions.
Utilized Excel (Advanced), Power BI to design interactive dashboards and visualizations, presenting actionable insights that influenced media campaigns and content strategies.
Collaborated with cross-functional teams (Marketing, PR, Product) to interpret consumer and media data, optimizing content strategies, media placements, and audience targeting.
Produced data-driven reports on key performance metrics such as engagement, ROI, conversion rates, and audience demographics, influencing strategic decision-making across departments.
Applied statistical methods (e.g., regression analysis, hypothesis testing) to assess media campaign performance and enhance forecasting accuracy for future projects.
Monitored industry trends and competitor data , providing insights that helped guide strategic decisions, improve market positioning, and optimize media coverage.
Learning SQL : Actively learning SQL to enhance data extraction and querying capabilities for more complex and customized reports.

Supply Chain Operations intern

Flipkart

09.2021 - 11.2021

Assist with Inventory Management : Support inventory tracking and control to ensure accurate stock levels and minimize stockouts or overstock situations.
Data Analysis : Analyze supply chain performance data, identify trends, and generate reports to assist in decision-making and process optimization.
Logistics Coordination : Help manage shipping schedules, track deliveries, and coordinate with transportation teams to ensure timely product movement.
Vendor Communication : Communicate with vendors and suppliers regarding order status, delivery timelines, and product availability.
Demand Forecasting Support : Assist with gathering and analyzing historical data to help predict demand and optimize order quantities.
Handled administrative and data entry work for staff.
Studied with senior staff to develop deep understanding of team processes and full operational activities.
Reporting : Support the creation of regular reports on key performance indicators (KPIs) such as order fulfillment rates, lead times, and inventory levels.
Assisted in managing inventory, preventing stock shortages or excesses.

Education

MBA -

Mangaluru University

11.2020 - 10.2022

Bcom - Commerce

Kuvempu University

01.2017 - 09.2020

PUC - Commerce

Department of Pre-university Education

01.2015 - 12.2016

Skills

Excel (Advanced): Pivot Tables, VLOOKUP, INDEX-MATCH, Conditional Formatting, Macros, Data Cleaning, and Analysis

Power BI: Creating dashboards and reports for data visualization and analysis

Google Analytics: Analyzing website traffic, user behavior, and campaign performance metrics

Data Visualization: Skilled in creating actionable insights and reports using Power BI and Excel

Data Analysis: Advanced Excel functions, regression analysis, A/B testing, statistical analysis

Reporting & Presentation: Strong skills in PowerPoint and Google Slides for presenting data insights to stakeholders