Kumar Mangalam

KM

Looking for a job

Kumar Mangalam

@kumarmangalam1

Data Analytics Intern at CodeAlpha who cleaned datasets and created automated Excel reports and interactive dashboards.

At CodeAlpha, I cleaned and standardized datasets in Excel and Power Query, then used PivotTables, charts, and slicers to explore trends and distributions.

For my Advanced Excel & Data Analytics Capstone at Masai School, I created an interactive sales dashboard and automated summary reports. I also used Excel statistical tools to test business assumptions.

Experience

Work history, roles, and key accomplishments

CO

Data Analytics Intern

CodeAlpha

Apr 2026 - May 2026 (1 month)

Cleaned and standardized datasets in Excel and Power Query, built PivotTables and slicer-driven summaries, and applied lookup and conditional-aggregation formulas to automate calculations and present actionable recommendations.

Excel Power Query Pivot Tables Pivot Charts XLOOKUP Index Match Sumifs COUNTIFS Excel Analysis ToolPak Descriptive Statistics Data Validation REST APIs

Education

Degrees, certifications, and relevant coursework

SU

Sandip University

B.Tech, Computer Science & Engineering (AI & ML)

Pursuing a B.Tech in Computer Science & Engineering with a focus on AI & ML, expected to graduate in April 2028.

EX

ExcelR

Certification, Business Intelligence

Completed certification in Business Intelligence using Advanced Excel & Power BI in March 2025.

VP

Vishlesan i-Hub, IIT Patna

Certification, Data Analytics

Completed certification in Data Analytics with Gen & Agentic AI.

Tech stack

Software and tools used professionally

NumPy

Pandas

MySQL

SQLite

Python

Google Sheets

SQL

Power BI

Availability

Looking for a job

Location

India

Authorized to work in

Salary expectations

70k+ INR

Social media

Job categories

Data Analyst Data Analytics Intern

Skills

Data Analysis Excel Data Cleaning Data Visualization Pivot Tables Pivot Charts Excel Dashboard Power Query Power Pivot DAX XLOOKUP V Lookups HLOOKUP Index Match

Interested in hiring Kumar?

You can contact Kumar and 90k+ other talented remote workers on Himalayas.

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!