Microsoft Excel (Advanced)
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
3
3
years of professional experience
8
8
years of post-secondary education
3
3
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
Passions
- Cricket
- Riding
- Travelling
Training
- Microsoft Office
- Power BI for Data Science
- SQL for Data Science (Currently Learning)
- Learning SQL (Currently Learning)
- UX Designer
- Figma for UI/UX Design
Software
Power BI
Google Analytics
SQL
Timeline
Media Research Analyst
Tag Fact Services Pvt.ltd
02.2023 - Current
Supply Chain Operations intern
Flipkart
09.2021 - 11.2021
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
Similar Profiles
Preeti GuptaPreeti Gupta
Account Executive in Procurement (Print/POSM/Packaging) at Tag India Pvt.Ltd.Account Executive in Procurement (Print/POSM/Packaging) at Tag India Pvt.Ltd.
Ryan ChetramRyan Chetram
CSR/Account Balance Specialist at WarAmps Key Tag ServicesCSR/Account Balance Specialist at WarAmps Key Tag Services
Deborah WeishaarDeborah Weishaar
Tag and Title Clerk at Terry's Tag and Title ServicesTag and Title Clerk at Terry's Tag and Title Services