Hardik Khandelwal
Pune
Summary
Results-driven Decision Analytics Associate Consultant at ZS Associates, skilled in Python and SQL, led a team to deliver actionable insights and integrated automation, enhancing operational efficiency. Adept at managing client relationships and requirements gathering, I excel in data visualization and strategic analysis to drive impactful business decisions.
Overview
4
4
years of professional experience
Work History
Decision Analytics Associate Consultant
ZS Associates
Pune
01.2026 - Current
- Analyzed client data using Python and SQL to identify trends and deliver insights.
- Directed team of six in end-to-end project execution, ensuring timely delivery and high-quality standards.
- Conducted requirement gathering sessions with new clients to define project objectives and business rules.
- Integrated robotic process automation across systems, streamlining operations and enhancing efficiency.
- Managed sales force operations for mid-sized pharmaceutical client, overseeing quota setting and annual awards.
- Designed parameterized systems for incentive goal setting, reducing future change efforts.
- Created automated Excel-based quality control tool integrated with Python, decreasing monthly operational effort by approximately 30%.
- Automated recurring executive reports by building centralized data pipeline, eliminating manual data entry and reducing human error risk.
Decision Analyst Associate
ZS Associates
Pune
07.2023 - 12.2025
- Analyzed large datasets using statistical methods and SQL queries for effective data management.
- Utilized Python libraries such as Pandas and NumPy for data manipulation and analysis.
- Employed advanced Excel skills, including pivot tables and complex formulas, for detailed reporting.
- Designed custom analyses in Power BI, SAS, Visual Basic, and Excel to fulfill client requirements.
- Created project deliverables and implemented solutions that aligned with client specifications.
- Restructured onboarding program for new joiners, incorporating documentation and a mentor-mentee model.
- Conducted thorough QA/QC testing of IC system and reporting dashboard data to ensure accuracy.
- Leveraged extensive experience with data sources like IQVIA, focusing on immunology and neurology.
Internship Trainee
Oil and Gas Corporation
Navi Mumbai
07.2022 - 08.2022
- Evaluated subsea pipeline operations in Mumbai High and Satellite fields, contributing to enhanced understanding of transportation and processing of crude oil and gas.
- Analyzed operations at ONGC Uran Processing Plant, identifying key insights for optimizing crude oil processing.
Education
B. Tech. - Applied Petroleum Engineering (Upstream)
University of Petroleum and Energy Studies
01.2023
XII (Higher Secondary) -
St. Anselm's Pink City Sr. Sec. School
01.2018
X (Secondary) -
Kerala Public School
01.2016
Skills
- Python scripting and SQL queries
- Data visualization and analysis
- Advanced Excel and Power BI
- Database management
- Market analysis
- Trend analysis
- Sales compensation strategies
- Team leadership
Certifications And Achievements
- UPES AAPG Student Chapter Logistics, Outreach & CSR Core Committees Member and Event Organizer for events conducted by UPES AAPG.
- Project published through Indo-US International conferences on Materials & Sustainable Engineering in Chemical and Allied Industry (MSECAI-2022).
- Project published through I-manager's Journal on Material Science[JISM] in September 2022 issue.
Timeline
Decision Analytics Associate Consultant
ZS Associates
01.2026 - Current
Decision Analyst Associate
ZS Associates
07.2023 - 12.2025
Internship Trainee
Oil and Gas Corporation
07.2022 - 08.2022
B. Tech. - Applied Petroleum Engineering (Upstream)
University of Petroleum and Energy Studies
XII (Higher Secondary) -
St. Anselm's Pink City Sr. Sec. School
X (Secondary) -
Kerala Public School