Open To Work
Hemani Panchal
Bengaluru
Summary
Results-oriented Data Analyst with 3 years of experience in advanced Excel, Python, SQL, and Power BI. Developed actionable insights to enhance campaign performance and implemented automated solutions to support business growth. Skilled in data visualization and predictive analytics, utilizing large datasets to inform strategic decisions and optimize stakeholder engagement.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
InxiteOut
Bengaluru
10.2025 - Current
- Developed AI-based products for voice-to-text transcription and automated customer satisfaction reporting, generating qualitative and quantitative insights for leading automotive clients.
- Leveraged prompt web scraping and generative AI framework engineering to extract consumer insights from Team-BHP, YouTube videos, and social media platforms.
- Applied advanced analytical techniques to translate qualitative findings into actionable recommendations for clients.
- Created Power BI reports to visualize data trends, enhancing stakeholder decision-making processes.
- Conducted market research projects by analyzing qualitative inputs from in-depth interviews, discussion groups, and focus group discussions.
- Derived actionable insights across FMCG, media, and consumer products sectors based on comprehensive qualitative research analyses.
- Collaborated on market research initiatives, aligning deliverables with client objectives and industry trends to inform strategies.
- Synthesized insights from qualitative analyses to guide client strategies in various industries.
Data Analyst II
InxiteOut
Bengaluru
10.2024 - 09.2025
- Analyzed large datasets using SQL, Python (Pandas, NumPy), and Power BI for actionable insights.
- Automated reporting processes and developed dashboards to streamline client reporting and improve accessibility.
- Performed data manipulation to clean, transform, and aggregate data, enhancing campaign performance.
- Collaborated with clients and stakeholders to translate business challenges into strategic insights.
- Managed projects from concept to delivery, resolving data challenges in the automobile industry.
- Created executive-level presentations and data stories to facilitate rapid decision-making during product launches.
Data Engineer I
InxiteOut
Bengaluru
09.2023 - 09.2024
- Designed and maintained automated data pipelines using Azure Data Factory (ADF V2), Databricks, PySpark, and Azure SQL to integrate data from multiple sources into Azure Data Lake Storage (ADLS), improving data flow efficiency.
- Implemented Customer-360 project using Medallion architecture to streamline data access across teams.
- Utilised ADF components such as Pipelines, Datasets, Triggers, and PySpark to establish robust data recovery mechanisms and enhance pipeline monitoring.
Data Analyst-Trainee
InxiteOut
Bengaluru
12.2022 - 09.2023
- Connected Power BI to multiple data sources, enabling comprehensive data modeling for actionable reporting.
- Developed Power BI dashboards to visualize key business metrics for internal reporting.
- Collaborated with senior analysts to design interactive dashboards that enhanced data accessibility.
- Utilized Python (Pandas) for data cleaning and automation, improving data processing efficiency.
- Monitored data refresh schedules and troubleshot minor ETL issues, ensuring timely data availability for analysis.
- Supported integration of Excel and SQL-based data into Power BI, gaining exposure to data pipelines.
Education
M.E - Signal Processing and VLSI Technology
Vishwakarma Government Engineering College
Ahmedabad06-2017
Skills
Data Analysis & Manipulation: Advanced Excel (VLOOKUP, Pivot Tables, Power Query, Data Models), Python (NumPy, Pandas)
Data Visualization & Reporting: Power BI (DAX, Data Modelling), Excel Charts, PowerPoint (Data Storytelling)
ETL & Data Engineering: Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Azure Databricks (ADB), Azure SQL
Database & Querying: SQL (Joins, Subqueries, Aggregations, CTEs, Window Functions)
AI & GenAI Tools: Prompt Engineering, Generative AI, Gemini, Claude, ChatGPT, Microsoft Copilot
Domain Expertise: Automotive Industry (ICE, EV, and LCV vehicles), FMCG (Product Performance & Market Analysis), B2C Market (Consumer Behaviour Analysis)
Other Skills: Jupyter Notebook, Git, Requirement Gathering, Stakeholder Management, Problem Solving
Certification
- Applied Business Analytics, Pursuing, Indian School of Business(ISB)
- Excel Skills for Business, Coursera
- SQL for Beginners: Learn SQL using MySQL and Database Design, Udemy
- Azure Data Factory for Data Engineers - Project on COVID-19, Udemy
- Python A-Z: Python for Data Science with Real Exercises!, Udemy
Awards
- “Extra Miller” award for meeting tight deadlines and handling multiple clients at a time
- “Rising Star of the Year” for outstanding contribution to the project
- “Customer Hero” award for consistently delivering exceptional client support and enhancing customer satisfaction.
Hobbies and Interests
- Swimming
- Cooking
- Trekking
- Reading
Languages
- English
- Hindi
- Gujarati
Accomplishments
Culture Champion Award - Q2 2025
Work Preference
Job Search Status
Open to workWork Type
Full TimeLocation Preference
RemoteSalary Range
₹199000/yr - ₹200000/yrTimeline
Senior Data Analyst
InxiteOut
10.2025 - Current
Data Analyst II
InxiteOut
10.2024 - 09.2025
Data Engineer I
InxiteOut
09.2023 - 09.2024
Data Analyst-Trainee
InxiteOut
12.2022 - 09.2023
M.E - Signal Processing and VLSI Technology
Vishwakarma Government Engineering College