Summary
Overview
Work History
Education
Skills
Additional Information
Certification
Timeline
Generic

DARSHAN RATHOD

Mumbai

Summary

Proficient Data Analyst with a strong background in Computer Science Engineering. Skilled in data visualization, reporting, dashboarding, and leveraging data-driven insights to inform decision-making. Possess expertise in SQL, Excel, Power BI, and Tableau, along with a strong analytical mindset and problem-solving abilities.

Overview

6
6
years of professional experience
1
1
Certification

Work History

System Administrator

Wipro
11.2018 - Current
  • Implemented security measures, server monitoring, and user access management. Oversaw operations for key departments, including Finance and HR, handling daily support calls. Conducted malware analysis, vulnerability assessments, performance monitoring, and system development, along with implementing security controls.


  • As part of the Technical Support Group (TSG), handled escalation calls, guided L1 and L2 engineers, and led meetings to streamline processes. Generated the Management Excellence (ME) report for MIS and a daily SLA tracker report, detailing metrics such as violated calls, requests/incidents (daily, weekly, monthly), pending tasks, and SLA violations.


  • Supported the implementation of new technologies by providing technical expertise and training to colleagues as needed.


  • Collaborated with IT team to develop and implement comprehensive disaster recovery plans, ensuring minimal data loss during critical incidents.


  • Installed important security and functionality patches to maintain optimal protections against intrusion and system reliability.


  • Diagnosed and resolved complex technical issues through in-depth analysis, facilitating uninterrupted business operations.


  • Maintained a high level of customer satisfaction by providing rapid, accurate response to inquiries and concerns regarding system performance or functionality.

Data Analyst

PwC (Virtual Internship )
08.2024 - 10.2024
  • Utilized data visualization tools to effectively communicate business insights.
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
  • Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
  • Managed large-scale databases to ensure timely access to critical information for key stakeholders.
  • Created a Call Center analysis report with a 3.4/5 average customer rating to track performance trends through KPIs. Designed a Churn analysis report for 7,043 customers, revealing a 26.54% churn rate using charts and DAX functions to support data-driven decisions. Developed a Diversity & Inclusion report for a 500-employee workforce, focusing on gender balance

Education

Bsc IT - Information Technology

University of Mumbai
University Of Mumbai
10-2018

Skills

  • Advanced Excel
  • MySQL
  • SQL Server
  • Python
  • MS Office Suite
  • Data Modelling
  • Data Visualization
  • Data Cleaning
  • Data Storytelling
  • Strong experience with Business Intelligence tools like Power BI , Tableau for creating impactful visualizations
  • Excellent communication skills, both technical and non-Technical, with strong documentation capabilities
  • Strong organizational and time management skills, with ability to Prioritize multiple projects effectively
  • Proficiency in statistical analysis, data mining, and data cleansing, with Experience in advanced statistical techniques such as regression Clustering, and classification
  • ETL processes
  • Data Visualization and Presentations
  • Data Modeling
  • Google Analytics

Additional Information

Power BI Developer | PwC (Virtual Internship from Forage) | Certificate

  • Created a Call Center analysis report with a 3.4/5 average customer rating to track performance trends through KPIs. Designed a Churn analysis report for 7,043 customers, revealing a 26.54% churn rate using charts and DAX functions to support data-driven decisions. Developed a Diversity & Inclusion report for a 500-employee workforce, focusing on gender balance


Blinkit Outlet Establishment Analysis | Power BI | Link

  • Analyzed key metrics—total sales ($1.20M), average sale ($141), item count (8523), and rating (3.9)—to identify trends and improvement areas. Conducted in-depth analysis of individual outlet performance by type, location, and sales to pinpoint top and low-performing outlets.


Pizza Sales Analysis | SQL | Link

  • Utilized multi-level joins for complex multi-table queries, enhancing analysis and insights. This project strengthened my SQL skills and contributed to a 25% increase in revenue and a 15% reduction in customer complaints. Calculated each pizza type’s revenue contribution, analyzed cumulative revenue over time, and identified the top 3 most-ordered pizza types by revenue in each category.


HR Analytics Attrition Rate Data Analysis | Power BI | Link

  • Developed a comprehensive HR analytics dashboard to visualize and analyze employee attrition rates, identifying a 16.1% attrition rate across the organization. Conducted in-depth analysis of attrition rates by demographic factors (gender, age, education field) and job roles. Key findings include a higher attrition rate among younger employees (18-25) and in specific roles like Sales Representatives (33%)


Customer Segmentation Using Clustering Model | Python | Link

  • Employed clustering algorithms (e.g., K-means) to segment customers into distinct groups based on their characteristics and behaviors Characterized each customer segment based on key attributes such as demographics, purchase history, and spending patterns . Data visualization, clustering algorithms, customer segmentation, data-driven decision-making Python , Scatter plot , KMean .

Certification

  • Machine Learning & Data Science Training - GeeksforGeek , Aug 2024

Timeline

Data Analyst

PwC (Virtual Internship )
08.2024 - 10.2024

System Administrator

Wipro
11.2018 - Current
  • Machine Learning & Data Science Training - GeeksforGeek , Aug 2024

Bsc IT - Information Technology

University of Mumbai
DARSHAN RATHOD