Vedant Devhare — Business Analyst | Data Analyst Turning messy data & repetitive work into systems people actually use.

Fig. 01 — Records into structure 105 individual records arranged into five stacked columns, forming a bar chart. The tallest column is highlighted.
Fig. 01 105 records — sorted, counted, reported

I build dashboards and automation systems that help teams work more efficiently and make better decisions.

Download résumé (PDF)
Now
Executive, Vodafone Intelligent Solutions (VOIS)
Toolkit
Power BI · Power Query · Power Automate · SQL · SAP SuccessFactors Learning
Before
System Administrator, CAIT Edusys
Education
MBA, Business Analytics — Savitribai Phule University, Pune

In figures · as of Sept 2026

37automation and analytics solutions delivered since April 2025

  1. 2,815hoursof recorded time savings — a 9.2× return on build time
  2. 85%reduction in manual intervention in automated processes
  3. 3×Vodafone Stars Award winner

Selected work

Lead case study · Business intelligence

Dashboard for tracking Learning hours

  • Power BI
  • Power Query
  • DAX
Fig. 02 — Learning Hours dashboard Learning records with employee, manager, hours and month feed a reporting hierarchy covering direct and indirect reportees. Hours are summarised by month against a target, and the manager view highlights the team that is behind target. 01 · Learning records employeemanagerhoursmonth 02 · Reporting layers direct indirect 03 · Monthly hours vs target target M1M2M3M4M5M6 04 · Manager view team A team B team C behind target team D Illustrative diagram · no real data
  1. 01 Problem

    People Managers had no quick way to see learning hours across their direct and indirect reportees.

  2. 02 Constraint

    Built for managers without advanced filtering skills, and with limited data resources available.

  3. 03 Approach

    A Power BI dashboard that aggregates across reporting layers, shows monthly progress, and flags teams behind target.

  4. 04 Outcome

    Managers can spot lagging teams at a glance instead of filtering and interpreting manual reports.

    Read the full case study

Further case studies

  1. 2026 Process automation

    Automated Multilingual Email Flow

    Recurring email batches of 1,000+ recipients were prepared and sent by hand, across different languages and templates.

    Outcome Handles 1,000+ multilingual emails per batch and reduced manual workload by the equivalent of one FTE.

    • Power Automate
    • Excel
    • Outlook
  2. A product performance dashboard showed every filter and slicer at once and split comparisons across several pages.

    Outcome Less clutter, faster movement between views, and active filters visible without opening the pane.

    • Power BI
    • DAX
    • Bookmarks
  3. A dashboard depended on several source files with different structures, consolidated manually before each refresh.

    Outcome A refreshable, dashboard-ready dataset that updates when the source files change, with less manual preparation.

    • Power Query
    • Excel
    • Power BI
  4. In progress Reporting automation

    Automated Multi-File Excel Reporting with Python

    A recurring report had to be assembled by hand from multiple Excel files — merging columns and appending rows before reporting could start.

    Target Reduces report preparation from 12–16 hours of manual work to around 2 hours.

    • Python
    • pandas
    • NumPy
    • openpyxl
  5. In progress Text analytics

    eNPS Feedback Analysis with Python

    Natural-language eNPS feedback is hard to read at scale, so recurring themes in employee comments are easy to miss.

    Next (planned) Sentiment scoring — positive, neutral or negative — for each comment.

    • Python
    • pandas
    • scikit-learn
    • Plotly
    • openpyxl

Practice

The work moves in one direction: from raw inputs, to something people can read, to processes that run on their own.

  1. A · Power Query

    Prepare

    Pipelines that consolidate and transform messy, multi-source files into datasets a report can trust.

    See an example: Prepare with Power Query →
  2. B · Power BI

    Present

    Dashboards designed for the people reading them — clear KPIs, fewer filters, faster answers.

    See an example: Present with Power BI →
  3. C · Power Automate

    Automate

    Workflows that take repetitive operational work off people’s desks without asking them to learn new tools.

    See an example: Automate with Power Automate →

Record

Work Experience

  1. Vodafone Intelligent Solutions (VOIS)

    Executive

    April 2025 – Present

    Analytics & Automation

    • Gathered and documented requirements with cross-functional stakeholders, identifying process pain points and reporting gaps and translating them into Power BI dashboards, Power Automate workflows and structured datasets.
    • Delivered 37 automation and analytics solutions since April 2025, generating 2,815 hours of recorded time savings against 306 build hours (9.2x return); Power Automate used in 34 of the 37 deliveries.
    • Automated invitations, reminders, approvals, status tracking, meeting coordination and feedback capture by integrating Power Automate with Microsoft Forms, Excel, SharePoint, Teams, Planner and HTML emails, reducing manual intervention by 85% in automated processes.

    Learning Operations & SuccessFactors LMS

    • Administer SAP SuccessFactors Learning across markets: setting up items, curricula and programmes, scheduling offerings, managing registrations, assigning learning, recording completions and resolving ticket-based queries.
  2. CAIT Edusys Private Limited

    System Administrator - LMS and IT | Project Coordinator

    April 2022 – April 2025

    • Administered MySQL databases and Linux/Unix servers supporting the Learning Management System, including backup, recovery and access management.
    • Wrote shell and PowerShell scripts to automate system checks, backups and routine maintenance tasks.
    • Installed, configured and maintained operating systems, application software and network equipment.

Achievements

  1. July 2025

    Learning Hours dashboard for HR Services, with people-manager-level views for service leads.

  2. Vodafone Stars Award

    February 2026

    Consistent excellence on automation projects and upskilling the team on the function's tools.

  3. Vodafone Stars Award

    August 2026

    “Transforming with impact”: automation and dashboards across the L&D Admin, Talent Assessment and Skills Campaign teams.

Training Delivered

  1. 45+ hours of training at VOIS

    Delivered to 180 participants at Vodafone Intelligent Solutions (VOIS).

    • Power BI
    • Power Query
    • Power Automate
    • Advanced Excel
    • Power Pivot

Skills

  1. BI & Visualisation

    • Power BI
    • DAX
    • Power Query
    • Data Modelling
    • Data Visualisation
    • Dashboard Development
  2. Data & Databases

    • SQL (MySQL, PostgreSQL)
    • Advanced Excel
    • Power Pivot
    • ETL
    • Data Cleansing & Validation
  3. HR & Learning Systems

    • SAP SuccessFactors Learning (LMS) Administration
  4. Automation & Microsoft 365

    • Power Automate
    • Microsoft Forms
    • SharePoint
    • Teams
    • Planner
    • Office Scripts
  5. Programming & Web

    • Python (pandas, NumPy, scikit-learn, openpyxl, Plotly)
    • R
    • HTML
    • CSS
    • JavaScript
    • React
    • Astro JS
  6. Systems & Tools

    • Git
    • Shell Scripting (Bash)
    • PowerShell
    • Linux/Unix & Windows Server Administration

Education

  1. MBA, Business Analytics

    Aug 2024 – May 2026

    Savitribai Phule University, Pune · 7.57 CGPA

  2. BBA, Computer Application

    Apr 2020 – Oct 2023

    Savitribai Phule University, Pune · 7.58 CGPA

  3. Higher Secondary Education

    2016 – 2018

    Completed HSC

Languages

  1. English

    Proficient in English, with strong communication skills that enable me to effectively convey ideas and collaborate with diverse teams.

  2. Marathi

    Fluent in Marathi

  3. Hindi

    Fluent in Hindi

Writing

  1. 10 min read

    Building a Skill-Gap Analyzer That Runs Entirely on My Laptop

    How I built an offline workforce intelligence platform with Mistral 7B, FAISS and Streamlit on a 16 GB laptop: no GPU, no cloud APIs, no data leaving the machine.

  2. 5 min read

    Designing Power BI Dashboards That Non-Technical Managers Can Actually Use

    Practical principles for designing Power BI dashboards that are intuitive, clutter-free, and easy for non-technical managers to use.