HIMANSHU SINGH

Data Analyst

https://www.opentalent.in/himanshu-singh-369366

Data Analyst with less than a year in data analysis & visualization.

Key Strengths

Strong foundational skills in data analysis tools including SQL, Python (Pandas, NumPy), Power BI, and advanced MS Excel.
Demonstrated experience in end-to-end data analysis workflows: data collection, cleaning, EDA, visualization, and reporting.
Proficient in ETL processes, data modeling, and KPI tracking, as evidenced by project descriptions.
Experience with dashboard design and reporting automation, delivering real-time business intelligence.
Good understanding of data quality control and data validation frameworks.

Cultural & Operational Fit

Cultural Fit Analysis

The candidate shows initiative through multiple certifications and virtual internships from reputable organizations (Deloitte, Tata, Coursera). The projects demonstrate a practical, results-oriented mindset focused on automation and delivering business intelligence. The breadth of tools and techniques used (SQL, Python, Power BI, Excel) indicates a willingness to learn and adapt, which aligns well with a dynamic data team culture. However, the lack of collaborative projects or team-based experience makes it difficult to fully assess cultural fit beyond individual drive.

Soft Skills & Operational Fit

The candidate's project descriptions indicate an ability to work on structured tasks, automate processes, and deliver actionable insights. The virtual internships suggest a proactive approach to gaining practical experience. However, without direct work experience, the ability to navigate complex team dynamics, handle pressure, or manage stakeholder expectations in a real-world, fast-paced environment is unproven.

AI is analyzing your overall score…

Identifying your key strengths…

Evaluating your skill match against the job requirements…

Assessing your cultural and operational fit

About

Results-driven Data Analyst with a B.Tech in Computer Science and demonstrated expertise in SQL, Python, Power BI, and Advanced MS Excel. Experienced in end-to-end data analysis workflows including data collection, data cleaning, exploratory data analysis (EDA), data visualization, and stakeholder reporting. Delivered 15+ automated KPI dashboards, validated 5,000+ records at 99% accuracy, and performed EDA on datasets exceeding 10,000 rows. Adept at ETL processes, data modelling, business intelligence reporting, and converting raw data into actionable insights to support data-driven decision-making.

Top Skills

SQLPythonPower BIGoogle Sheets

Projects

HR Analytics Dashboard

March 1, 2025 – July 1, 2025

Designed an interactive HR Analytics Dashboard in Power BI tracking employee attrition rates, retention metrics, and performance trends segmented by department, age group, and job role. Performed end-to-end data cleaning, data preprocessing, and ETL operations in Excel and Power BI, ensuring 100% data accuracy before analysis. Identified attrition patterns through statistical analysis and delivered actionable HR insights, enabling data-driven workforce planning and stakeholder decision-making.

Employee Attendance Tracker

January 1, 2025 – February 1, 2025

Built an automated Employee Attendance Tracking System in MS Excel using advanced formulas (COUNTIF, SUM, IF, VLOOKUP) to monitor and report daily attendance records. Applied data validation rules and conditional formatting to maintain data quality and consistency across all attendance records, reducing manual errors significantly.

Sales Report Automation

December 1, 2024 – February 1, 2025

Automated the end-to-end sales reporting process using advanced MS Excel functions (VLOOKUP, INDEX-MATCH, Pivot Tables, Power Query), eliminating manual effort and accelerating report turnaround. Developed dynamic Power BI dashboards to monitor revenue, sales growth, and KPIs, delivering real-time business intelligence and performance reporting to stakeholders. Conducted data cleaning and data transformation across all source datasets, ensuring accuracy, consistency, and reliability for downstream analysis and reporting.

Certifications

GenAI Powered Data Analyst Job Simulation

Tata via Forage

January 1, 2025 – Present

Data Analyst Job Simulation

Deloitte via Forage

January 1, 2025 – Present

Data Analyst Certification

One Roadmap

January 1, 2024 – Present

SQL for Data Analytics

Great Learning Academy

January 1, 2024 – Present

Excel for Business (Intermediate)

Coursera

January 1, 2024 – Present

Key Strengths

Strong foundational skills in data analysis tools including SQL, Python (Pandas, NumPy), Power BI, and advanced MS Excel.
Demonstrated experience in end-to-end data analysis workflows: data collection, cleaning, EDA, visualization, and reporting.
Proficient in ETL processes, data modeling, and KPI tracking, as evidenced by project descriptions.
Experience with dashboard design and reporting automation, delivering real-time business intelligence.
Good understanding of data quality control and data validation frameworks.

Cultural & Operational Fit

Cultural Fit Analysis

Soft Skills & Operational Fit

HIMANSHU SINGH

Key Strengths

Cultural & Operational Fit

About

Top Skills

Skills

Education

Projects

Certifications

Key Strengths

Cultural & Operational Fit