Dolly Kumari

📊Power BI & Data Visualization

• Designed interactive Power BI dashboards to track outreach performance, client segmentation, and campaign effectiveness.
• Transformed raw data from Google Sheets, HubSpot, and Excel into dynamic reports for SDRs and AEs, enabling real-time decision-making.
• Integrated enriched contact data from Apollo, ZoomInfo, and LinkedIn into Power BI for comprehensive lead analysis.
• Leveraged filters and slicers to segment clients by industry, employee size, and decision-maker roles for targeted outreach.
• Presented insights from surveys and focus groups using Power BI visualizations to guide product launch strategies.
• Automated reporting workflows by connecting Excel models and CRM data to Power BI, reducing manual effort and improving accuracy.
  

🔍 Client Research & Segmentation

• Conducted in-depth research on prospective clients by analyzing use cases and aligning them with product offerings.
• Mapped client organizations by industry, employee size, and business needs to ensure strategic product fit.
• Identified and targeted decision-makers across industries and sub-industries to optimize outreach and conversion.
• Conducted detailed market segmentation studies to enhance customer targeting for marketing campaigns.
  

📈 CRM & Outreach Optimization

• Managed and updated account/contact records using Google Sheets and HubSpot to maintain data accuracy and accessibility.
• Assigned SDRs and AEs to retarget high-potential accounts via HubSpot and SalesHandy, improving engagement rates.
• Generated daily performance reports tracking outreach activities, targeted accounts, and team follow-ups.
• Enriched contact data using tools such as Apollo, Sales Navigator, ZoomInfo, Lusha, Skrapp, GetEmail, and others.
  

🧮 Advanced Excel & Data Analysis

• Utilized advanced Excel functions (VLOOKUP, XLOOKUP, HLOOKUP, COUNTIF, SUMIFS, INDEX, MATCH) for data analysis and reporting.
• Built complex pivot tables and applied conditional formatting, macros, and data validation for reporting efficiency.
• Collected and verified data from LinkedIn and reputable websites to identify key decision-makers and company insights.
• Organized companies by industry and role hierarchy, ensuring structured and actionable outreach strategies.
• Cross-referenced multiple data sources to ensure accuracy and relevance in research outcomes.