Summary
Overview
Work History
Education
Skills
Certification
Timeline

RAHUL GIRADKAR

Nagpur

Summary

Accomplished Data Analyst with 1+ year of experience in data cleaning, preprocessing, wrangling, andanalysis using Python, SQL, and Excel. Proficient in creating interactive dashboards and visualizationsusing Power BI. Skilled in database management and querying with MySQL. Experienced in improvingdata accuracy, efficiency, and database performance to support critical decision-making processes. Adeptat identifying improvement opportunities and suggesting strategies to enhance customer service and reducecosts.

Overview

1
1
year of professional experience
1
1
Certification

Work History

Data Analyst

Sapalogy Pvt. Ltd
04.2023 - Current
  • Improved data accuracy and efficiency by 20% through data cleaning and preprocessing using Python
  • Enhanced SQL database performance by 30%, supporting critical decision-making processes
  • Utilized Python, MySQL, and Excel for complex data analysis
  • Created interactive dashboards in Power BI, reducing operational costs by 15%
  • Conducted data wrangling tasks to ensure data accuracy for subsequent analysis
  • Implemented imputation techniques to handle 15% missing data, increasing overall data integrity by
  • Structured and transformed 500,000 records, facilitating the integration of three databases, and reduce-ing data processing time by 30%
  • Managed database operations in MySQL, ensuring accurate and efficient querying
  • Analyzed business operations with over 50 SQL queries, covering customer demographics, sales perform-manse, and more, resulting in a 15% increase in actionable insights for decision-making
  • Developed over 30 visualizations and reports using Power BI and Excel, utilized by 10+ departments,resulting in a 20% improvement in decision-making efficiency.
  • PROJECTS
  • House Property Sales Analysis using MySQL
  • Sales Analysis using Python
  • Amazon Web Scraping on Holi Products and Visualization on Power BI
  • Real Estate Visualization on Power BI
  • Data Analytics and Commercial Insights Simulation: Data preparation, customer analytics, benchmarkidentification, and strategic report creation
  • PwC Switzerland Power BI Job Simulation: Created dashboards to meet client data visualization needsand effectively convey KPIs
  • Loan Risk Analysis Project: Imported and cleaned datasets, conducted EDA, handled missing valuesand outliers, addressed data imbalances, and analyzed trends using Python
  • Created visualizations tocommunicate insights effectively.

Education

B.E - Mechanical Engineering

RTMNU University
2018
Secured 3rd Position in Symposium'17 for paper presentation on Fabrication of Tamarind ProcessingMachine, SVPCET. Presented paper on Fabrication of Tamarind Processing Machine at Addhyan, Priyadarshini Bhagwati

College of Engineering

Skills

  • Programming Languages:
  • Python (Pandas, NumPy, Seaborn, Matplotlib), SQL, MySQL
  • Data Visualization: Power BI, Advanced Excel
  • Data Analysis: Statistics, Data Cleaning, Data Preprocessing, Data Wrangling, Database Management
  • Additional Skills:
  • Git, Basic Machine Learning, Web Scraping

Certification

MySQL Advanced: HackerRank, Mar 2024 Business Analytics with Excel Beginner Course: Simplilearn, Mar 2024 Data Analyst Certification: IBM, Mar 2024 Data Analyst Job Simulation Certification: Forage, Apr 2024 PwC Switzerland Power BI Job Simulation Certificate: Forage, Apr 2024

Timeline

Data Analyst - Sapalogy Pvt. Ltd
04.2023 - Current
RTMNU University - B.E, Mechanical Engineering
College of Engineering - ,
RAHUL GIRADKAR