HIMANSHU RAJ

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

STUDENT PERFORMANCE ANALYSIS, Local Client's Project, Ranchi, Jharkhand, 

• Created a dashboard with Power Bi to help client compare between different students from classes 9 to 12.
• Revamped client data through strategic implementation of conditional columns and Excel, guaranteeing data integrity and completeness; this initiative led to a 30% surge in data accuracy and a 25% decrease in data discrepancies.
• Provided technical insights on how the client can fully utilize their data by introducing different technologies. Consulted with client to determine the best metrics to be displayed on final product. Improved decision-making efficiency by enabling the client to access real-time performance insights, leading to a 75% improvement in student outcomes.

WALMART SALES ANALYSIS, Personal Project, 

• Used Excel, MySQL and Power BI to perform sales analysis on 3 months sales data of the company. Crafted and executed SQL queries and Stored Procedures to efficiently handle large datasets, yielding an 86% acceleration in data processing.
• Delivered actionable insights into sales trends and patterns, contributing to a 90% enhancement in decision-making efficacy.
• Implemented a suite of interactive dashboards and reports in Power BI, resulting in a 37% increase in user engagement and a 23% reduction in decision-making time regarding sales data analysis, leading to more informed and timely business decisions. Presented findings and actionable recommendations derived from the analysis to key stakeholders, facilitating strategic planning and enhancing overall business performance.

SALES ANALYSIS OF AXON PVT.LTD, Personal Project, 

• Implicated Power BI and MySQL to analyze sales records of Axon dealing in classic cars segment.
• Utilized a combination of DAX functions, Measures, and SQL queries to accurately identify and address key business requirements, resulting in a 75% increase in data analysis efficiency and an 83% improvement in decision-making processes.
• Aggregated and visualized the data by using report generation and dashboard building to compile a professional report. Analyzed that the company's sales were reducing by 64% in September and figured out the solution for the same.

• Certified Data Science Professional - From ODIN SCHOOL
• SQL Beginner to Advance for Data Professionals - From Code Basics
• SQL and Relational Database 101 - From IBM
• Introduction to SQL - From Simple Learn
• Business Analysis with Excel - From Simple Learn
• Data Analytics Using Power Bi - From Tech-tip-24
• Python 101 for Data Science - From IBM
• Data Analytics Using Python - From IBM