Ankit Kumar

Data Analyst

Uttam Nagar, New Delhi $3/hr Work from office 90 · Outstanding

About

Aspiring Data Analyst with hands-on experience in Microsoft Excel, SQL, Python (Pandas), and Power BI. Skilled in data cleaning, data modeling, Power Query, DAX, dashboard development, and data visualization. Passionate about transforming raw data into actionable business insights.

Skills & Expertise (35)

Power BI Intermediate

5.5/10

0.33

Years Exp

Data Cleaning Intermediate

5.5/10

0.33

Years Exp

Microsoft Excel Intermediate

5.5/10

0.33

Years Exp

SQL Intermediate

5.5/10

0.33

Years Exp

Data Analysis Intermediate

5.5/10

0.33

Years Exp

Data Visualization Intermediate

5.5/10

0.33

Years Exp

Python Intermediate

5.5/10

0.33

Years Exp

Data Modeling Intermediate

5.0/10

0.33

Years Exp

Jupyter Notebook Intermediate

5.0/10

0.33

Years Exp

Git Intermediate

5.0/10

0.33

Years Exp

NumPy Power Query Dashboard Development KPI Reporting Pandas Aggregate Functions Data Manipulation Oracle Database GitHub Visual Studio Code DAX Window Functions CTEs Subqueries HAVING GROUP BY Joins Select Oracle SQL MySql Charts Conditional Formatting VLOOKUP XLOOKUP Pivot Tables

Work Experience

Data Analyst Intern

Krutanic Solutions

Present - 3 Months

Worked on real-world data analysis projects using Microsoft Power BI and Microsoft Excel. Performed data cleaning, transformation, and modeling using Power Query. Created interactive dashboards and reports to visualize business insights. Applied DAX functions such as SUM, AVERAGE, MTD, and YTD. Analyzed sales and customer data to identify trends and patterns. Worked on multiple projects including Diwali Sales Analysis Dashboard.

Data Analyst Intern

Codec Technologies India

Present - 1 Month

Worked on real-world data analytics projects using Microsoft Excel, SQL, Power BI, and Python. Cleaned, organized, and analyzed datasets to generate meaningful business insights. Built interactive dashboards and visual reports for performance tracking. Assisted in data visualization and reporting to support business requirements. Strengthened analytical and problem-solving skills through practical assignments.

Education

Bachelor of Computer Applications (BCA) - Teerthanker Mahaveer University

2023 - 2026 · India

Higher Secondary School - Janta High School +2 Musepur

2021 - 2023 · India

Certifications

programming in java

nptel · 2026

Successfully completed the NPTEL Programming in Java course with a score of 90%. Gained knowledge of Java programming, Object-Oriented Programming (OOP), exception handling, collections, file handling, multithreading, and Java application development.

data analyst

codec technology · 2026

Successfully completed a Data Analyst training program covering Microsoft Excel, SQL, Python, Power BI, data cleaning, data visualization, dashboard development, and business data analysis. Gained hands-on experience in analyzing datasets, creating interactive dashboards, and generating data-driven insights for decision-making.

data analyst

krutanic · 2026

Successfully completed a Data Analyst internship focused on Microsoft Power BI, Microsoft Excel, SQL, and Python. Performed data cleaning, transformation, and analysis using Power Query and DAX. Developed interactive dashboards, created KPI reports, and analyzed sales and customer data to generate actionable business insights using real-world datasets.

DSA USING JAVA

NPTEL · 2025

Successfully completed the NPTEL Data Structures and Algorithms Using Java course with a score of 58%. Gained knowledge of arrays, linked lists, stacks, queues, trees, graphs, sorting, searching, recursion, and algorithm design using Java.