Vishal Wagare
Data Analyst
Pune
Summary
Results-driven Data Analyst with 1.5 years of experience in transforming complex datasets into actionable insights. Proficient in SQL, Python, and data visualization tools like MS Power BI. Adept at collaborating with cross-functional teams, communicating findings, and optimizing data workflows. Proficient in utilizing Big Data technologies, such as Hadoop and Spark, for data processing and analysis. Committed to delivering high-impact contributions for informed decision-making.
Overview
1
1
year of professional experience
4
4
years of post-secondary education
Work History
Data Analyst
Techvant Software Technologies
11.2022 - Current
- Assembled, cleaned and organized large data sets, improving data accuracy and reducing analysis time by 30%
- Designed and coded complex SQL queries to produce actionable insights from internal databases, increasing data analysis productivity by 25%.
- Assisted senior team members in the data analysis process, contributing to a successful project that delivered impactful results to clients
- Optimized SQL queries for faster processing times, increasing overall productivity within the team.
- Applied Python for data manipulation, cleaning, and exploratory analysis.
- Identified trends and patterns in complex datasets through exploratory data analysis, leading to actionable insights.
- Designed and maintained interactive dashboards and reports using MS Power BI..
- Enhanced data visualization capabilities for better decision-making with the use of advanced BI tools.
- Designed interactive dashboards for stakeholders, simplifying the interpretation of complex data sets and facilitating communication between departments.
- Built data visualizations using Power Bi for KPIs that reduced manual reporting by 10 hours weekly.
Education
Post Graduate Diploma - Big Data Analytics
Centre For Development of Advanced Computing
Mumbai 03.2022 - 10.2022
Bachelor of Engineering - Electronics And Telecommunication
University of Mumbai
Kankavli 07.2018 - 06.2021
Skills
SQL
Projects
1.Stock Market Analysis and Real-Time Fluctuations:
Project Description : The aim of this project was to analyze historical sector-wise data and provide key insights through visualizations, enabling investors to make informed decisions while buying stocks. Additionally, the project involved real-time stock data fetched through the Yahoo Finance API, where investors received timely stock updates via notifications. Leveraged AWS services (S3, Lambda, EMR, CloudWatch) for data storage, scheduled updates, big data processing, and monitoring. Integrated Microsoft Power BI to create interactive dashboards, providing investors with actionable insights, timely notifications, and a holistic view of market trends, historical performance, and real-time fluctuations. Contributed to informed decision-making and enhanced investor engagement.
Key Technologies and Platforms:
- Python: Google Colab, Jupyter Notebook, Pandas
- AWS: S3, Lambda, EMR, CloudWatch
- Big Data: Apache Hadoop, Spark
- Visualization: Microsoft Power BI
Impact:
1. Historical Data Analysis: By examining sector-wise historical data, investors gained valuable insights into market trends, sector performance, and historical price movements. This information assisted them in making informed investment decisions.
2. Real-Time Fluctuation Notifications: Through real-time stock data updates and notifications, investors stayed up-to-date with the latest market movements and stock price fluctuations. This timely information enabled them to react quickly and make informed decisions.
3. Data Visualization and Insights: The visualizations and interactive dashboards created using Power BI provided a comprehensive view of the stock market and allowed investors to identify patterns, trends, and potential investment opportunities with ease.
2. Zomato Dataset Analysis for Bangalore Region :
Platform : Power BI
Developed a comprehensive Power BI dashboard for the Regional Manager of Zomato in Bangalore, providing in-depth analysis of the local restaurant industry. Conducted extensive research on online ordering and table booking trends, customer ratings, popular cuisines, and average costs for two people. The project aimed to deliver actionable insights to enable informed decision-making for optimizing the Zomato platform in Bangalore.
Timeline
Data Analyst
Techvant Software Technologies
11.2022 - Current
Post Graduate Diploma - Big Data Analytics
Centre For Development of Advanced Computing
03.2022 - 10.2022
Bachelor of Engineering - Electronics And Telecommunication
University of Mumbai
07.2018 - 06.2021
Similar Profiles
Nanthini GanesanNanthini Ganesan
Software Engineer at Mindsbeam Technology Software Engineer Software Engineer Mindsbeam Technologies Pvt Ltd (Lystloc)Software Engineer at Mindsbeam Technology Software Engineer Software Engineer Mindsbeam Technologies Pvt Ltd (Lystloc)
Suresh BhumireddySuresh Bhumireddy
Technical Specialist at Bosch Global Software TechnologiesTechnical Specialist at Bosch Global Software Technologies
MANISH KUMARMANISH KUMAR
Team Lead at Iris Software TechnologiesTeam Lead at Iris Software Technologies
Dreamly MondalDreamly Mondal
Infrastructure Platform Engineer at SLB (Schlumberger)Infrastructure Platform Engineer at SLB (Schlumberger)
Vaibhav SuryawanshiVaibhav Suryawanshi
UI Developer at Xcaliber Infotech Private LimitedUI Developer at Xcaliber Infotech Private Limited