HIMANSHU PAL

Proven ability in analyzing large datasets, debugging SQL queries, and transforming data to drive business decision. Proficient in creating compelling, interactive dashboard using Power BI, enhancing data analysis. Strong command over Excel, SQL, Power BI, and Python enables efficient data manipulation and analysis. Logical data analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with several years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.

English, Hindi

Blinkit Sales Dashboard using Excel :- Used bar charts, line graphs, and pie charts to represent sales trends and performance metrics. Leveraged pivot tables, conditional formatting, and data validation for efficient data manipulation and analysis. data analysis , data cleaning visualization, and reporting Improved understanding of sales trends and performance metrics. Enhanced decision-making through clear and actionable insights. Streamlined reporting for stockholders, Zomato Dashboard using Power BI :- Clean the raw data. Create a Data Model. Make calculations and parameters according to project details. Create an interactive Power BI report that will allow Zomato to quickly assess the required data. Import the data from all available Excel files. Data transformation. Remove any columns that aren't being used. Add a Rating color column in an appropriate table with the data rows in the format given. Create the following measures in the appropriate tables :- (A) Restaurant count. (B) Average cost. (c) Average rating (d) Cuisine count

• Training/Courses: - Auto cad , NCC ‘A’ Certificate, 15 Days Workshop in Building Work
• Awards/Activities: - Tesla Techvolution 2015 at MIT Pune secured AIR 1st in CONCRETO event. MEGALITH FEST 2016 AT IIT KHARAGPUR Secured AIR 7th in Model Making Exhibition event.