Data Analyst - Hoora - Nagpur, Maharashtra
(2025-12)
- Analyzed end-to-end lead funnel (Lead → Qualified → PM → SP assignment → Booking completion) with focus on demand vs supply gaps
- Developed dashboards using Metabase directly on production databases to enable real-time tracking of operational metrics
- Identified operational bottlenecks where bookings exceeded SP capacity, causing delays and incomplete tasks
- Automated lead assignment process for sales teams, reducing manual effort and improving allocation efficiency
- Developed automated Google Sheets workflows for data entry and management, enhancing usability and data accuracy
- Improved reporting efficiency by streamlining data processing and reducing manual intervention
- Developed Power BI dashboards for multiple departments (RM, SP, Operations, Revenue) to track daily and weekly performance
- Built dashboards to monitor: RM performance (bookings, revenue, activity), SP lifecycle (training, onboarding, availability), Booking status (on-time, delayed, pending)
- Designed operations dashboards to track: Daily booking flow, Delay reasons, Completion rates
- Worked directly with decisionmaker levels to provide data insights for decision-making and operational planning
- Developed a mini-CRM system using Google Sheets and Apps Script for lead tracking, SP assignment, and status management
- Automated data workflows including data cleaning, validation, and duplicate detection
- Explored AppSheet-based solutions to digitize processes and improve accessibility for operations teams
- Collaborated with Ops, RM, and third-party teams to ensure data consistency and improve reporting accuracy
Data Analyst - Parekh Gadgets - Nagpur, Maharashtra
(2025-05 - 2025-11)
- Prepared and maintained daily, weekly, and monthly sales dashboards using Excel
- Analyzed product movement and sales trends to identify slow-moving stock and revenue opportunities
- Designed performance dashboards for dealer-wise and region-wise sales tracking
- Developed campaign trackers to measure target achievement and ROI during promotional events
- Consolidated multi-source data to generate management-level reports
- Collaborated with sales teams to ensure data accuracy and actionable insights
Associate - Data Mining & Management - Sagacious IP/ SagaciousElevate - Nagpur, Maharashtra
(2023-12 - 2025-03)
- Conducted deep-dive research on law firms and corporate clients to identify key stakeholders, decision-makers, and engagement trends using web scraping, Python, and structured search techniques
- Generated actionable business insights by analysing historical client data, project participation, and engagement frequency, helping sales and strategy teams improve targeting and outreach
- Collected, processed, and managed structured/unstructured data from various sources using Python, Excel & Power Query
- Automated data extraction and transformation using Python and Power Query to improve operational efficiency
- Developed interactive Power BI dashboards to track client engagement, inactive clients, project revenue, and sales performance
- Performed end-to-end data extraction, transformation, and cleaning using Advanced Excel and Python
- Reduced manual work by automating data cleaning and transformation, achieving a 40% time-saving through Python scripts
MIS Analyst - Wide Space Technosolution Pvt. Ltd. - Nagpur, Maharashtra
(2023-03 - 2023-11)
- Created MIS reports to track employee performance and project progress
- Analyzed operational and vendor data using Excel and Power BI
- Managed and maintained datasets related to vendors, materials, and project timelines
- Supported project teams with data insights for cost and performance tracking
