Himanshu Singh

About

Results-driven Data Analyst with a B.Tech in Computer Science and hands-on experience in SQL, Python, Power BI, and Advanced MS Excel. Skilled in data cleaning, exploratory data analysis, ETL, dashboarding, and stakeholder reporting to turn raw data into actionable insights.

Experience

• Data Analyst Virtual Intern
  Deloitte via Forage
  Feb 2025 – Jun 2025

Education

• B.Tech
  Graphic Era Hill University
  Computer Science · Jul 2024

Skills

• SQL
• Data Preprocessing
• Data Visualization
• Python
• Power BI
• MySQL
• Data Cleaning
• Matplotlib
• NumPy
• Pandas
• PostgreSQL
• Power Query
• VLOOKUP
• Google Sheets
• Data validation
• Business Intelligence
• Data Modeling
• ETL
• Excel
• KPI Tracking
• Statistical Analysis
• Pivot Tables
• Reporting Automation
• Data Quality Control
• Dashboard Design
• Stakeholder Reporting
• XLOOKUP
• Eda
• Conditional Formatting
• Index-Match

Projects

• Employee Attendance Tracker
  MS Excel

  Built an automated attendance tracking system using advanced Excel formulas, data validation, and conditional formatting to monitor and report daily attendance records.

• Sales Report Automation
  MS Excel, Power BI

  Automated end-to-end sales reporting using advanced Excel functions and Power BI dashboards for revenue, growth, and KPI tracking. Improved report turnaround through data transformation and reporting automation.

• HR Analytics Dashboard
  Power BI, MS Excel, SQL

  Interactive HR analytics dashboard tracking attrition, retention, and performance trends by department, age group, and job role. Included data cleaning, preprocessing, ETL, and statistical analysis to deliver workforce planning insights.

Courses & certifications

• GenAI Powered Data Analyst Job Simulation · Tata via Forage · 2025
• Data Analyst Job Simulation · Deloitte via Forage · 2025
• Excel for Business (Intermediate) · Coursera · 2024
• SQL for Data Analytics · Great Learning Academy · 2024
• Data Analyst Certification · One Roadmap · 2024