Mrunal Singh

Data Analyst Intern

Unified Mentor Pvt Ltd•  January 2025 - Present•  Remote

Designed and developed interactive dashboards in Tableau to visualize key metrics and provide actionable insights and made them easily to understand for non technical individuals. Cleaned and processed large datasets in Python to uncover trends, optimize workflows, and identify meaningful insights. Learned statistical analysis in Python to identify relationships within data, generating visually impactful charts and reports.

Freelance Data Analyst

Travelersnestcommunity India Pvt Ltd•  September 2024 - December 2024•  Remote

Delivered insights using Google Analytics and Google Search Console to improve website traffic and user engagement through data analysis in MS Excel. Designed and developed dynamic dashboards and reports in Looker Studio and Tableau to track and visualize key performance metrics effectively. Applied Google Analytics tags and implemented tracking solutions using Google Tag Manager (GTM) to monitor website performance and user interactions. Added Microsoft Clarity tracking to websites, analyzing user actions to understand behavior and derive insights for improved engagement and usability.

SEO Analyst

Trycon Technologies Pvt Ltd•  May 2023 - March 2024•  Noida, Uttar Pradesh

Analyzed large datasets of website traffic and user behavior using tools like Google Analytics and Excel to identify trends and optimize performance resulting in increase in website traffic by 200%. Created Google data studio dashboards, enabling real-time tracking and analysis of overall performance, individual webpage metrics and cannibalisation explorer for data- driven decision making. Analyzed user engagement data from Microsoft Clarity heatmaps and session insights to guide UX improvements, ultimately improving average session duration by 25%. Performed in-depth analysis using SemRush and Ahrefs to adjust marketing strategies, increasing organic reach by 40%. Automated reporting and data cleaning processes using Excel scripts, reducing manual effort by 50%.

Marketing Analyst

HiveMinds Innovative Market Solutions Pvt Ltd•  July 2021 - July 2022•  Bangalore, Karnataka

Developed dashboards and reports using tools like Excel, Google Analytics & Google Data Studio to visualize key metrics such as customer acquisition costs, conversion rates, and revenue growth. Developed root cause reports to address problems with customer conversions, successfully revealing insights that boosted conversions by 30% Managed extensive Google Ads campaigns by analysing results from A/B testing to optimize ad performance, resulting in a 2X increase in overall ROI. Implemented conversion tracking and regularly monitored for any inconsistencies in the signups database. Acquired in-depth knowledge of Google Ads platforms, including Search, Display, Video, Discovery and Shopping campaigns.

Research Analyst Intern

SG Analytics•  September 2020 - January 2021•  Pune, Maharashtra

Conducted sustainability research and analysed ESG (Environmental, Social, and Governance) indicators across multiple sectors using desk-based research methods. Evaluated and aggregated information from various reports, including annual reports, CSR reports, and codes of conduct, to extract key ESG insights. Compiled and organized corporate data into databases, ensuring accuracy and consistency. Gained proficiency in data aggregation, analysis, and reporting to support decision-making.