DHRUV KHANDURI
Gurugram
Summary
Results-oriented Data Analyst with over 4 years of experience enhancing business performance through analytics and process automation. Skilled in SQL, Python, Power BI, BigQuery, and Excel, with expertise across finance, supply chain, HR, and marketing. Focused on improving operational efficiency and optimising customer retention through innovative analytics solutions.
Overview
5
5
years of professional experience
Work History
Data Analyst
Katyayani Organics
05.2024 - 03.2026
- Automated enterprise-wide P&L reporting and developed executive profitability dashboards tracking revenue, margins, EBITDA, and operating expenses, reducing manual reporting effort by 80% while significantly improving reporting accuracy.
- Led logistics and supply chain analytics initiatives by developing warehouse planning dashboards, freight cost optimization solutions, and operational scorecards, reducing Return-to-Origin (RTO) rates from 23% to 18% and improving delivery SLA adherence by 5%.
- Designed inventory analytics solutions to monitor SKU-level stock availability, inventory aging, replenishment planning, stock movement, and inventory turnover, enabling more effective procurement and warehouse management decisions.
- Implemented a centralized Asset Management System to track the lifecycle of company-owned assets including laptops, desktops, monitors, mobile devices, and peripherals, reducing manual asset reconciliation efforts by 70%.
- Supported HRMS implementation and developed workforce analytics solutions tracking attendance, task completion, productivity, utilization, and employee performance KPIs, improving workforce visibility and operational efficiency.
- Developed lead management, agent performance, and events analytics dashboards to monitor acquisition funnel performance, productivity, engagement, and business outcomes.
- Built customer segmentation models using RFM analysis and clustering techniques in Python, contributing to a 15% increase in repeat customer revenue through targeted retention initiatives.
- Designed and executed A/B testing frameworks and pricing automation solutions to optimize promotional strategies, contributing to approximately 20% growth in returning customer revenue and improved marketing ROI.
- Developed centralized B2B and B2C executive dashboards and scalable SQL-based reporting pipelines, reducing report generation turnaround time by 40% while improving data accessibility across the organization.
Engineer-2
Congruex Asia Pacific
02.2021 - 10.2023
- Developed forecasting models and operational dashboards using Power BI and Excel, improving forecast accuracy by 22% and supporting 98% on-time project delivery across telecommunications infrastructure projects.
- Automated recurring reporting processes and developed KPI scorecards to streamline project tracking, resource planning, and operational performance monitoring.
- Established data validation and quality assurance frameworks for large operational datasets, ensuring reporting accuracy and minimising errors.
- Created standardized reporting frameworks and training documentation that reduced analyst onboarding time by 50% and improved team productivity by 28%.
- Collaborated with cross-functional stakeholders to translate business requirements into scalable reporting and analytics solutions that enhanced decision-making.
Education
Bachelor of Engineering - Mechanical Engineering
Lakshmi Narain College of Technology
Bhopal, MP01-2021
Diploma - Mechanical Engineering
Lakshmi Narain College of Technology
Bhopal, MP01-2018
Skills
- SQL
- Python
- BigQuery
- MongoDB
- Power BI
- Looker Studio
- Dashboard Development
- Statistical Analysis
- Data exploration
- Forecasting
- A/B Testing
- Data Validation
- Excel
- Google Sheets
- Google Analytics
- Stakeholder Management
- Requirement Gathering
- Process Improvement
- Google Sheets
- Google Analytics
Timeline
Data Analyst
Katyayani Organics
05.2024 - 03.2026
Engineer-2
Congruex Asia Pacific
02.2021 - 10.2023
Bachelor of Engineering - Mechanical Engineering
Lakshmi Narain College of Technology
Diploma - Mechanical Engineering
Lakshmi Narain College of Technology