HARSHIL VADSARA

Data Analyst | Software Engineer

Pune, IN.

About

Highly analytical Data Analyst with over 1 year of experience leveraging SQL, Power BI, and Python to transform complex datasets into actionable strategic insights. Proven ability to deliver data-driven recommendations that resulted in a 15% increase in client sales and significantly improved operational efficiency across diverse organizations. Adept at developing interactive dashboards, building predictive models, and optimizing backend systems to drive business growth and informed decision-making.

Work

Freelancing

|

Data Analyst

Remote, ,

→

Summary

Led data analysis projects for a Lisbon-based client, delivering actionable recommendations and developing predictive models to enhance business performance.

Highlights

Analyzed Brazilian sales data and implemented data-driven recommendations that successfully increased client sales by 12% in Q1 2025.

Developed an interactive Power BI dashboard, reducing time to insight from 2 days to real-time, enabling leadership to track KPIs instantly.

Built predictive models using Python and Power BI, significantly improving demand forecasting accuracy by 25% for a key client.

KultureHire

|

Data Analyst Intern

Remote, ,

→

Summary

Analyzed Generation Z data to uncover career preferences and learning trends, supporting strategic insights for talent acquisition.

Highlights

Analyzed collected Gen Z data using SQL Joins and Aggregate Functions to extract valuable insights, identifying key career preferences.

Utilized Google Forms to efficiently gather comprehensive data on career goals and learning preferences for Generation Z initiatives.

Created dynamic Excel and Power BI dashboards, integrating Pivot Charts and Slicers to enhance data visualization and filtering across sales, customer relations, and finance domains.

PwC Virtual Case Experience Sweden

|

Data Analyst Intern

Remote, ,

→

Summary

Conducted in-depth data analysis for a call center, enhancing data integrity and identifying critical operational trends.

Highlights

Implemented robust data quality checks and validation procedures, significantly improving overall data integrity.

Investigated call center data using Excel and SQL, accurately identifying a rise in call abandonment during lunch hours to inform operational adjustments.

Conducted comprehensive trend analysis on 8 months' worth of call center records, processing large datasets to derive actionable insights.

Hyperlink Infosystem

|

Software Engineer Intern

Ahmedabad, Gujarat, India

→

Summary

Developed and optimized backend APIs and database schemas, enhancing application scalability and data management efficiency.

Highlights

Developed and optimized backend APIs using Node.js and Express.js, significantly improving application scalability and performance.

Designed and implemented robust database schemas and data modeling with MySQL & MongoDB, ensuring efficient data retrieval and storage.

Collaborated with cross-functional teams to translate complex business logic into precise SQL queries and APIs, ensuring accurate data delivery for analytics and reporting.

Enhanced API performance by implementing query optimization, caching systems, and indexing strategies, leading to improved system responsiveness.

Volunteer

Volunteer

|

NSS

→

Organized and participated in educational and donation camps, contributing to community development initiatives.

Highlights

Organized and actively participated in educational camps, providing learning support to underprivileged communities.

Contributed to donation camps, facilitating resource distribution and community outreach efforts.

Education

Gujarat University

Ahmedabad, Gujarat, India
→
Master's of Science Information Technology Grade: Class of 2023

Samarpan Science and Commerce College | Gujarat University

Ahmedabad, Gujarat, India
→
Bachelor's of Science Chemistry Grade: Class of 2021

Languages

English

Hindi

Gujarati

Certificates

Get Job Ready: Power BI Data Analytics for All Levels 2.0

Codebasics

Excel: Mother of Business Intelligence

Codebasics

Google Data Analytics Professional Certificate

Coursera

Accenture North America: Data Analytics and Visualization Job Simulation

Accenture

SQL (Basic)

HackerRank

Bloomberg Market Concepts Certification

Bloomberg

Data Science Virtual Experience Programme

British Airways

Skills

Data Analysis & Databases

SQL (Data types, Queries, Aggregate functions, Subqueries, Joins, CTEs, Window functions), Advanced Excel (Countif, Sumif, VLOOKUP, Index, Match, Macros, Pivot Table, Pivot charts), Data Modeling, Data Cleaning, ETL, MySQL, MongoDB.

Business Intelligence & Visualization

Power BI (Data Reporting, DAX, Data Modelling, Data Cleaning, ETL), Tableau, Interactive Dashboards, KPI Tracking.

Programming & Machine Learning

Python (Pandas, NumPy, Matplotlib, Seaborn, TensorFlow), JavaScript, C, Node.js, Express.js, Predictive Modeling.

Web Technologies & Tools

HTML/CSS, Git, GitHub, VS Code, JIRA, Wireframing, RESTful APIs.

Projects

IPL Insights: Cricket Dashboard

→

Summary

Developed a Power BI dashboard to analyze real-time and historical IPL match data, enhancing sports analytics.

User Engagement Analysis for Restaurants

→

Summary

Conducted an analysis of Yelp data to understand the impact of user engagement on restaurant success and provide strategic recommendations.

Bank Loan Analysis Dashboard

→

Summary

Designed an interactive Power BI dashboard to analyze loan distribution trends and provide financial insights.

COVID-19 Data Analysis

→

Summary

Explored relationships and trends within COVID-19 data, identifying high-risk areas and visualizing findings.

Event Decoration Business

→

Summary

Launched and managed an event decoration business, demonstrating entrepreneurial skills and operational excellence.