Mahendra Singh Rajput

About

Detail-oriented BCA student with hands-on experience in Python, SQL, Excel, and Power BI for data cleaning, analysis, and visualization. Built multiple end-to-end analytics projects across sales, HR, and customer churn, with a strong foundation in statistics and problem-solving.

Education

• Bachelor of Computer Applications
  Bachelor of Computer Applications (BCA)
  Computer Applications

Skills

• SQL
• Python
• Statistics
• Data Cleaning
• Exploratory Data Analysis

Projects

• Excel Sales Dashboard
  Microsoft Excel

  Created a dynamic sales dashboard using Pivot Tables, Pivot Charts, and formulas to summarize revenue and sales performance for quick management review.

• SQL Database Analysis
  MySQL

  Wrote optimized SQL queries to extract, join, and aggregate data from relational databases, generating business insights from multi-table datasets.

• Customer Churn Analysis
  Python (Pandas, NumPy)

  Analyzed customer churn dataset using Python to identify key churn drivers, applying data cleaning and exploratory data analysis to uncover patterns among 1,000+ customer records.

• HR Analytics Dashboard
  Power BI

  Built an HR analytics dashboard tracking employee attrition, headcount, and performance metrics, helping visualize workforce trends across departments for data-driven HR decisions.

• Sales Performance Dashboard
  Power BI

  Designed an interactive Power BI dashboard analyzing sales trends across regions and products, enabling faster identification of top-performing categories and improving reporting turnaround by an estimated 30%.