Mrunal Singh

Senior Business Analyst

Dealshare•  March 2025 - Present•  Gurgaon

As a Senior Business Analyst – Operations at DealShare, I worked extensively with large-scale datasets (10M+ rows) using BigQuery and SQL to uncover trends across warehouse, inventory, and last-mile delivery operations. I built and optimized complex queries to support cross-functional data needs and designed automated dashboards using Tableau, Looker Studio, and Google Sheets—saving 4–5 hours per week in manual reporting. I also implemented a real-time alert system that reduced issue detection time by 60%, enabling teams to resolve rider and delivery issues within 30 minutes on average. My role involved conducting deep-dive analyses on performance, cost, and operational efficiency, forecasting key metrics, and translating data into actionable insights to support business planning and data-driven decision-making.

Data Analyst Trainee

Unified Mentor Pvt Ltd•  January 2025 - March 2025•  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.

Web Analytics Specialist

Travelersnestcommunity India Pvt Ltd•  April 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.