Back to Developers
Ajay Kumar

Ajay Kumar

Entry-level Data Analyst

Delhi, India 3+ yrs exp 92 · Outstanding

About

Entry-level Data Analyst with hands-on experience gained through internship, industry projects, and job simulations. Strong skills in Python, SQL, Excel, and Power BI with practical exposure to ETL processes, data cleaning, transformation, validation, and dashboard reporting. Ready to contribute to business analytics and reporting teams.

Skills & Expertise (19)

Pandas Intermediate
6.4/10
1
Years Exp
VLOOKUP Intermediate
6.4/10
1
Years Exp
Reporting Intermediate
6.4/10
1
Years Exp
Data Analysis Intermediate
6.4/10
1
Years Exp
Web Scraping Intermediate
6.4/10
1
Years Exp
Pivot Tables Intermediate
6.4/10
1
Years Exp
Excel Intermediate
6.4/10
1
Years Exp
Power BI Intermediate
6.4/10
1
Years Exp
Data Cleaning Intermediate
6.4/10
1
Years Exp
SQL Intermediate
6.4/10
1
Years Exp
NumPy Intermediate
6.4/10
1
Years Exp
Python Intermediate
6.4/10
1
Years Exp
Data Validation Beginner
5.0/10
1
Years Exp
MySql Beginner
5.0/10
1
Years Exp
Power Query Beginner
5.0/10
1
Years Exp
ETL Pipelines Beginner
5.0/10
1
Years Exp
Documentation Beginner
5.0/10
1
Years Exp
XLOOKUP Beginner
5.0/10
1
Years Exp
Excel Macros Beginner
5.0/10
1
Years Exp

Work Experience

Data Analyst Intern

Afame Technologies

May 2024 - Present

Analysed structured business datasets using Python and SQL. Cleaned data by handling missing values, duplicates, and formatting issues. Assisted in preparing reports and datasets for analysis. Supported insight generation for decision-making.

Service & Reviews Analysis

British Airways

Present - Present

Extracted large volumes of customer reviews using web scraping techniques. Cleaned and processed unstructured text data using Python (Pandas, NumPy). Performed sentiment analysis to classify customer feedback as positive, neutral, or negative. Analyzed trends related to service quality, delays, staff behavior, and onboard experience. Visualized sentiment distribution and key issues to highlight service improvement opportunities. Prepared insights to support customer experience and operational decision-making.

Power BI Job Simulation

PwC Switzerland

Present - Present

Designed interactive Power BI dashboards to track executive-level KPIs. Imported and transformed HR datasets using Power Query. Analyzed workforce data including gender diversity, promotions, and performance metrics. Created visual reports to identify leadership-level diversity gaps. Enabled data-driven decision-making through clear and actionable insights. Presented findings in a structured format suitable for business stakeholders.

Senior Process Associate

Suntec India

Feb 2023 - Jun 2024

Managed and analysed large operational datasets using Excel and SQL. Built automated MIS and performance reports using Pivot Tables, VLOOKUP/XLOOKUP, and Excel macros. Improved reporting efficiency and data consistency through standardized templates and automation.

Education

MBA (IT & Marketing) - Swami Vivekanand Subharti University

- · Afghanistan

B.A. - Delhi University

- · Afghanistan

Certifications

BCG X Data Science Job Simulation Certificate

· 2024

PwC Switzerland Power BI Job Simulation Certificate

· 2024

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 12/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 92/100

Profile Overview

Member sinceJul 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation