Data Analyst Business Operations

SKILLS

Swati Deokar

Data Analyst

PROFILE

PROFILE

Experienced Tableau Developer with

3+ years of industry experience,

specializing in data analysis, complex

data modelling, and delivering projects

using Agile methodologies. Proficient

in SQL, MySQL, and Tableau desktop &

server, Excel with a deep

understanding of business operations

and analytics tools. I excel in providing

actionable insights, troubleshooting

data quality issues, and delivering

high-quality results for effective

decision-making.

CONTACT

ONTACT

PHONE: +91-842*******

ADDRESS: Pune, MH, India

EMAIL: *****.********@*****.***

LANGUAGES

English

Hindi

Marathi

WORK EXPERIENCE

S+M LLC Data Analyst

May 2022 – Jan 2025

Designed interactive, visually compelling Tableau dashboards with advanced chart types (Donut, Butterfly, Pareto, Bump). Merged and transformed data from MySQL, and Excel, using data blending and joins to meet visualization needs.

Collaborated with stakeholders to create KPIs-driven solutions, enhancing decision-making.

Developed derived fields, calculated functions, parameters, filters, and hierarchies to optimize dashboard functionality. Ensured accuracy through testing, issue resolution, and technical support.

Documented design, development, and maintenance processes. Enhanced interactivity with Action Filters and performed time- based calculations (MTD, YTD, PYT).

Demonstrated strong analytical and problem-solving skills with quick adaptability to new technologies.

USV Pvt. Ltd Research Analyst

Aug 2016–Jan 2019

Skilled in precise method development and drug analysis, focusing on meticulous data handling for accurate results. A depth at method transfer, ensuring data consistency through meticulous analysis.

A data-centric approach prioritizing precision and compliance. Education

M. Pharm North Maharashtra University (2014 - 2016) B. Pharm SGBA University (2010 - 2014)

90%

80%

80%

75%

75%

90%

Collaboration

Problem

Solving

Excel

SQL, MySQL

Tableau Server

Tableau

Desktop

Projects

Shared Mobility Deep-Dive Analysis Dashboard Aug 2024 to Dec 2024 Domain: Transportation & Urban Planning

KPIs Used: Total Trips Completed, Fleet Utilization Rate, Revenue, Profit Margin, CO Reduction, Fuel Savings, Customer Satisfaction Score, Average Wait Time Charts Used: Line Charts, Heat Maps, Bar Charts, Pie Charts, Geographic Maps, Time Series Analysis, Stacked Bar Charts

Description: Built a dashboard to provide insights into shared mobility services, tracking fleet efficiency, revenue trends, and environmental sustainability.

EV Charging Infrastructure Optimization Dashboard Jan 2024 to Jul 2024 Domain: Electric Vehicles & Charging Infrastructure KPIs Used: Charging Station Utilization Rate, Average Charging Duration, Energy Consumption per Session, Charging Station Downtime, User Satisfaction Scores, Revenue per Charging Session, Environmental Impact Metrics

Charts Used: Geospatial Heat Maps, Time Series Line Charts, Donut Charts, Bar Charts, Tree Maps, Heat Maps, Stacked Bar Charts

Description: Designed a dashboard to analyse EV charging station performance, optimizing placement and improving operational efficiency. Incorporated environmental impact metrics to evaluate CO2 emissions reduction.

Micromobility and Microtransit Integration Dashboard Jun 2023 to Dec 2023 Domain: Urban Transportation Planning

KPIs Used: Number of Micromobility Trips, Average Trip Distance, User Adoption Rates, Reduction in Short Car Trips, Environmental Impact (CO Emissions Reduction), Cost Savings per Trip, Infrastructure Utilization Rates

Charts Used: Heat Maps, Line Charts, Bar Charts, Geographic Maps, Pie Charts, Time Series Analysis Description: Developed an interactive dashboard to analyze the integration of micromobility options (such as shared scooters and bikes) and micro transit services within urban areas. The dashboard provides insights into user adoption trends, the impact on reducing short car trips, environmental benefits, and infrastructure utilization. It aids urban planners in making data-driven decisions to enhance sustainable transportation options.

Traffic Network Optimization Dashboard Feb 2023 to May 2023 Domain: Transportation & Urban Planning

KPIs Used: Average Traffic Speed, Congestion Levels, Travel Time Reliability, Incident Response Times, Toll Revenue, Lane Closure Frequencies, Parking Occupancy Rates, Public Transport Ridership Charts Used: Line Charts, Heat Maps, Bar Charts, Pie Charts, Geographic Maps, Time Series Analysis, Stacked Bar Charts

Description: Developed an interactive dashboard to monitor and enhance urban transportation systems, helping reduce congestion and improve commuter satisfaction. Strategic Mobility Service Optimization Dashboard Oct 2022 to Jan 2023 Domain: Shared Mobility & Public Transport

KPIs Used: Vehicle Demand Analysis, Utilization Rate, Fleet Optimization, Cost per Mile, Passenger Load Factor, Revenue per Trip, Environmental Impact

Charts Used: Lollipop Chart, Donut Chart, Pie Chart, Tree Map, Heat Map, Stacked Bar Chart, Bar Chart, Line Chart

Description: Developed an interactive dashboard to analyse and optimize public transport vehicle selection, providing insights on fleet utilization, cost efficiency, and demand trends. Integrated sustainability metrics for CO2 emissions and energy efficiency analysis.

Contact this candidate