Ashish Meshram

Data Analyst with 2.5 + years of experience in business analytics, dashboard development, and process automation. Skilled in Power BI, Excel, and SQL for analyzing operational data, building KPI-driven dashboards, and generating actionable insights. Experienced in solving real-world business problems such as demand-supply gaps, performance tracking, and process optimization

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

B.E. - Mechanical Engineering - G.H. Raisoni Academy of Engineering & Technology