Hardik Khandelwal
Jaipur
Summary
Detail-oriented Data Analyst with hands-on experience in SQL, Excel, Python, Power BI, and data visualization. Proven expertise in transforming raw data into actionable insights, optimizing database performance, and automating reports to drive operational efficiency. Strong background in Supply chain management and business intelligence, with a sharp focus on client satisfaction and customer-centric solutions.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Analyst
Axestrack Software Solution Pvt. Ltd.
Jaipur
04.2024 - Current
- Data Analysis & Visualization: Designed and implemented visually intuitive dashboards using Microsoft Excel,Power BI enabling stakeholders to easily track KPIs and make data-driven decisions.
- Process Automation: Automated data collection and reporting using Excel Macros, VBA, and SQL, improving accuracy and efficiency.
- Client Engagement & Business Analysis: Worked closely with top-tier clients such as Shree Cement, Nuvoco Cement, Desai Brothers Ltd., and Steel Authority of India to deliver strategic insights and resolve logistics challenges.
- Logistics & Supply Chain Optimization: Identified and addressed key supply chain issues such as vehicle detention and route deviation using Power BI dashboards and Excel-based reporting.
- Cross-Functional Collaboration: Collaborated with Customer Success, Operations, and IT teams to enhance and optimize the Axestrack Business Intelligence (BI) platform.
- Achievements & Impact: Contributed to cost savings and efficiency improvements across client supply chain networks through actionable analytics.
Data Analyst Intern
Global IT Providers Pvt. Ltd.
Jaipur
04.2023 - 03.2024
- Data Visualization & Management: Designed and developed interactive Power BI dashboards to streamline and enhance business reporting.
- SQL Optimization: Optimized complex SQL queries to improve data retrieval speed and efficiency, resulting in faster dashboard and report generation & Streamlined large datasets and joined multiple tables using query structuring techniques.
- Python Automation: Learned to automate repetitive data tasks using Python libraries such as Pandas, NumPy, and Matplotlib, enhancing efficiency and accuracy.
- Achievements & Impact: Successfully delivered data-driven solutions to clients & Acted as the single point of contact for multiple enterprise clients, ensuring timely resolution of issues and aligning analytics deliverables with business goals.
Education
Bachelor of Science - Mathematical Sciences
S S Jain Subodh PG College
Jaipur12-2018
High School Diploma -
Board Of Secondary Education Rajasthan
Bandikui04-2015
Skills
- Microsoft PowerBI & Excel: Data Visualization & Analysis
- SQL: Database Management,Query Optimization
- Python: Programming & Automation,API Integration,Data Presentation(Pandas,NumPy)
- Business intelligence: MIS Reporting, Dashboard Development, KPI Tracking
- Client engagement: Account Management,Client Relationship Management
- Problem resolution: Root Cause Analysis,Decision Making
Certification
- Advance Data Analysis Certification: Grrras Solution Pvt. Ltd. Jaipur
- Exploratory Data Analysis Certification: Techtip24 Jaipur
Accomplishments
- Gold Badge: Hacker Rank
- Silver Badge: Global IT Providers
Affiliations
- Optimized SQL Database: Reduced data retrieval times by 25% for real-time analytics.
- Automated Reports & Dashboards: Implemented automated MIS reporting, reducing manual effort by 40%
- Fleet Data Analysis: Provided actionable insights to optimize fleet management operations.
Timeline
Data Analyst
Axestrack Software Solution Pvt. Ltd.
04.2024 - Current
Data Analyst Intern
Global IT Providers Pvt. Ltd.
04.2023 - 03.2024
Bachelor of Science - Mathematical Sciences
S S Jain Subodh PG College
High School Diploma -
Board Of Secondary Education Rajasthan
Similar Profiles
ASHMITA AGARWALASHMITA AGARWAL
Senior Executive at Axestrack Software Solution Pvt. Ltd.Senior Executive at Axestrack Software Solution Pvt. Ltd.
Mahesh KumarMahesh Kumar
Solutions Manager at Axestrack Software Solutions Pvt. LtdSolutions Manager at Axestrack Software Solutions Pvt. Ltd
Rahul JatRahul Jat
Customer Success at Axestrack Software Solutions Pvt. Ltd.Customer Success at Axestrack Software Solutions Pvt. Ltd.
DIKSHA SHARMADIKSHA SHARMA
HR Executive at TTL Engineering Pvt LtdHR Executive at TTL Engineering Pvt Ltd
Tushar BishtTushar Bisht
Manager, Projects at La RealtorsManager, Projects at La Realtors