RUPESH WAGHMARE

Data Analyst
Pune, IN.

About

Highly analytical Data Analyst with over 4 years of progressive experience in data analysis, visualization, and ETL processes, dedicated to transforming complex datasets into actionable business insights. Proven ability to design interactive dashboards, optimize data pipelines, and apply advanced analytics to drive strategic decision-making and operational improvements. Eager to leverage expertise in a dynamic role to contribute significantly to business success and foster a data-driven culture.

Work

ZS
|

Data Analyst

Pune, Maharashtra, India

Summary

Currently serving as a Data Analyst, optimizing ETL processes, developing interactive dashboards, and delivering actionable insights for specialty pharmacy projects to enhance operational efficiency and patient service strategies.

Highlights

Designed and optimized complex SQL queries to support efficient ETL processes, streamlining data extraction, transformation, and loading across large datasets.

Integrated diverse data sources into Tableau, developing real-time, interactive dashboards with calculated fields, parameters, and LOD expressions to enhance decision-making.

Created forecasting and analytical reports by combining SQL-based data modeling with Tableau visualizations, translating complex datasets into actionable business insights.

Gained domain expertise in SP/Hub data, delivering insights for operational improvements and patient service strategies in specialty pharmacy projects.

Delivered end-user training on SQL and Tableau, increasing BI tool adoption and fostering a data-driven culture across cross-functional teams.

Tata Consultancy Services
|

System Analyst

Pune, Maharashtra, India

Summary

Functioned as a System Analyst, developing interactive Tableau dashboards, conducting log analysis on Microsoft Azure, and automating tasks to enhance data accuracy, consistency, and reporting efficiency.

Highlights

Developed interactive Tableau dashboards utilizing heat maps, scatter plots, and dynamic filters to optimize data visualization and enable data-driven decision-making.

Conducted log analysis on Microsoft Azure with cloud-native tools, proactively monitoring system performance and increasing visibility into distributed data processing pipelines.

Extracted, transformed, and validated large datasets using complex SQL queries, enhancing data accuracy and consistency, and improving analytical workflow efficiency.

Automated repetitive tasks to streamline data management and reporting operations, leveraging deep application knowledge to enhance efficiency and scalability.

Delivered impactful PowerPoint presentations to communicate analytical findings, dashboard insights, and strategic recommendations to stakeholders, enhancing data storytelling and cross-functional alignment.

Accenture
|

Application Development Associate

Pune, Maharashtra, India

Summary

As an Application Development Associate, implemented data transformations, optimized ETL pipelines, and conducted statistical analysis to uncover actionable insights for key business decisions.

Highlights

Implemented data transformations to convert raw datasets into structured formats within a centralized data warehouse, ensuring consistency and scalability.

Developed and optimized ETL pipelines to streamline data integration and improve processing efficiency.

Leveraged SQuirreL SQL for complex queries and operations, enhancing data accessibility and usability across teams.

Conducted statistical analysis and generated data visualizations to uncover actionable insights, informing key business decisions.

Volunteer

NASHIB FOUNDATION
|

Volunteer

Pune, Maharashtra, India

Summary

Contributed to community health initiatives by raising COVID-19 awareness.

Highlights

Volunteered with NASHIB FOUNDATION to raise COVID-19 awareness, contributing to community health initiatives.

The Forum
|

Volunteer

Pune, Maharashtra, India

Summary

Participated in social responsibility initiatives focused on environmental sustainability and education support.

Highlights

Actively involved in social responsibility initiatives, including participating in a Plogging Drive to promote environmental sustainability.

Distributed school kits to underprivileged students, supporting education initiatives.

Education

Pune Institute of Computer Technology
Pune, Maharashtra, India

M.Tech

Computers

Grade: 8.22/10

GH Raisoni College of Engineering and Management
Pune, Maharashtra, India

B.Tech/B.E.

Electronics/Telecommunication

Grade: 8.38/10

Languages

English
Marathi
Hindi
German

Skills

Data Analysis & Visualization

SQL, Tableau, Excel, PowerPoint, Data Visualization, Python, Numpy, Pandas, Machine Learning, Statistical Analysis, Forecasting, Interactive Dashboards, Data Modeling, Exploratory Analysis, Predictive Modeling.

Data Engineering & ETL

ETL Processes, Data Extraction, Data Transformation, Data Loading, Data Integration, Data Warehousing, SQuirreL SQL.

Cloud & Enterprise Tools

Microsoft Azure, SAP, GitHub, Jenkins, Version Control, Automated Workflows, Geographic Information Systems (GIS).

Reporting & Communication

Stakeholder Reports, Analytical Findings, Data Storytelling, Cross-functional Alignment, End-user Training, Documentation, Project Reviews.

Interests

Data Science Community Engagement

Hacker Rank, Kaggle, Technical Events, Webinars, Hackathons.

Projects

Geo-Spatial Data Analysis for Disaster Impact Forecasting

Summary

Developed a framework for predicting disaster-affected areas and estimating potential damages by integrating satellite imagery, GIS, and machine learning models.

Intelligent Traffic Prediction System using Machine Learning

Summary

Developed an intelligent model using machine learning technology to provide accurate information to users and prevent unnecessary events.