Meet Vaghasiya

Data Analyst

Surat, IN.

About

Highly analytical and results-driven Data Analyst with a year of experience, adept at transforming complex datasets into actionable insights and visually compelling reports. Proven ability to automate processes, significantly reduce manual effort by over 90%, and optimize operational efficiency, directly contributing to data-driven decision-making and substantial time savings. Eager to leverage expertise in Excel, Power BI, Python, and SQL to uncover critical business patterns and drive strategic growth within a dynamic organization.

Work

Star Rays

|

Data Analyst (Full-Time)

Surat, Gujarat, India

→

Summary

Spearheaded data analysis initiatives at Star Rays, focusing on process automation, efficiency optimization, and performance reporting to drive operational improvements and informed decision-making.

Highlights

Automated daily production and reporting tasks using Excel Power Query and Python, reducing manual processing time by over 90% (from 45 minutes to under 5 minutes) and significantly improving workflow efficiency.

Optimized diamond production tracking by automating the rough-to-polished stages, slashing average turnaround time by 55% (from 45 to 20 days) through process streamlining and duplication removal.

Designed and implemented monthly performance dashboards in Excel and Power BI, providing managers with transparent, data-driven insights into artisan performance across key KPIs (damage, quality, productivity, attendance) for fair evaluations.

Volunteer

Student Coordinator & Event Head

|

Sarvajanik College of Engineering and Technology

→

Coordinated and led key college events and activities, fostering community engagement and developing organizational and leadership skills.

Highlights

Coordinated the Annual College Tech-fest, managing logistics and engaging student participants to ensure successful execution.

Led the PY-IT college event, overseeing comprehensive planning, execution, and team management to achieve event objectives.

Demonstrated strong leadership, organizational, and problem-solving skills in managing diverse student activities and events.

Education

Sarvajanik College of Engineering and Technology

Surat, Gujarat, India
→
Bachelor of Engineering Information Technology Grade: 9.39 GPA

Certificates

PowerBI Data Analytics for All Levels

Codebasics

Excel: Mother of Business Intelligence

Codebasics

SQL For Data Science

Coursera (University of California, Davis)

Skills

Data Analysis & Reporting

Advanced Excel, Power BI, Google Analytics, Data Cleaning, Data Visualization, Data Profiling, DAX, Pivot Tables, Power Query, PowerPoint Presentation.

Programming & Scripting

SQL, Python, Jupyter Notebook, Pandas, NumPy, Matplotlib.

Projects

Namma Yatri Data Analysis - Transportation Business

→

Summary

Analyzed extensive transportation data for Namma Yatri to identify market growth opportunities and enhance competitive strategy in Bangalore.

Sales and Finance Analytics Report - Consumer Goods

→

Summary

Developed a detailed sales and finance analytics report for a consumer goods company, providing critical insights into financial performance and market trends.

Data Professional Survey Breakdown - Human Resource Analytics

→

Summary

Designed and implemented a Power BI dashboard for human resource analytics, visualizing survey results to provide insights into the data analysis profession.

EDA on various Datasets - EDA

→

Summary

Performed Exploratory Data Analysis (EDA) on diverse datasets using Python libraries, generating visualizations and statistical insights to uncover trends.