Chiranjiv Yadav

Data Analyst | Business Analyst

Gurugram, Haryana, India 0+ yrs exp 85 · Excellent

About

Detail-oriented Data Analyst and aspiring Business Analyst with a B.Tech in Computer Science Engineering (Amity University, 2026) and a strong foundation in SQL, Python, Excel, Power BI, statistics, and data-driven business analysis. Certified in SQL by HackerRank (Basic and Intermediate), Udemy (MySQL Bootcamp), and Microsoft Power BI for Business Intelligence (Udemy); currently pursuing an advanced Data Analytics certification covering Machine Learning and Cloud Deployment on Microsoft Azure. Hands-on experience in requirements gathering, analyzing 10,000+ row datasets, writing complex SQL queries, and building interactive Power BI and Excel dashboards — including data modeling, DAX measures, Power Query transformations, KPI cards, and slicers — that convert raw data into actionable, data-driven business insights. Skilled in data cleaning, exploratory data analysis (EDA), stakeholder reporting, and cross-functional collaboration, with a growing foundation in machine learning and cloud-based analytics.

Skills & Expertise (61)

Data Cleaning Intermediate

7.5/10

Years Exp

Python Intermediate

7.5/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

Problem Solving Intermediate

7.0/10

Years Exp

SQL Intermediate

7.0/10

Years Exp

Communication Intermediate

7.0/10

Years Exp

Data Wrangling Intermediate

7.0/10

Years Exp

Machine Learning fundamentals Intermediate

6.5/10

Years Exp

Business Analysis Intermediate

6.5/10

Years Exp

Seaborn Conditional Formatting Power Pivot XLOOKUP VLOOKUP Pivot Tables Exploratory data analysis Matplotlib Microsoft Excel Data Storytelling Drill-down reports Report Automation Power Query KPI Tracking Statistical Analysis Trend Analysis Requirements Gathering Business Intelligence Data-driven decision making Stakeholder Reporting Cross-Functional Collaboration Presentation Skills Team Leadership Project Management MySQL WorkBench Pandas NumPy Joins Subqueries CTEs Aggregate Functions Window Functions Views Indexes Stored Procedures Triggers Query Optimization MySql KPI Cards Relational Database Design Jupyter Notebook Regression Classification Clustering scikit-learn Microsoft Azure Blob Storage Model Deployment API Integration Data Modeling DAX Interactive Dashboards

Work Experience

Data Analyst Intern

Cubical Cubes

Jun 2025 - Aug 2025

Analyzed and cleaned 10,000+ rows of structured and unstructured sales and revenue data using SQL, Excel, and Python, improving data accuracy by 25% through systematic data cleaning and preprocessing techniques. Built interactive sales and revenue tracking dashboards in Power BI and Excel, enabling business teams to monitor 5+ key performance indicators (KPIs) in real time and support data-driven decision-making. Collaborated with a cross-functional team of 4-6 members to deliver weekly analytical reports, ensuring timely, accurate insights aligned with business objectives.

Education

Minor Degree, Marketing and Operations Management - Amity University

2023 - 2025 · Afghanistan

Bachelor of Technology, Computer Science Engineering (B.Tech CSE) - Amity University

2022 - 2026 · Afghanistan

Intermediate (XII) - Pathfinder Global School

2021 - 2022 · Afghanistan

Class (X) - Pathfinder Global School

2019 - 2020 · Afghanistan

Certifications

SQL (Basic)

HackerRank · 2026

SQL (Intermediate)

HackerRank · 2026

Microsoft Power BI for Business Intelligence

Udemy · 2026

The Complete MySQL Bootcamp: Go from Zero to Hero

Udemy · 2026

Excel Beginner to Advanced

Udemy · 2026

Completed an intensive Advanced Microsoft Excel course covering real-world business and data analysis applications. Developed expertise in data cleaning, data transformation, Pivot Tables, Pivot Charts, Power Query, Power Pivot, VLOOKUP/XLOOKUP, INDEX-MATCH, advanced formulas, Conditional Formatting, data validation, dashboard creation, KPI reporting, and automation techniques. Gained hands-on experience in analyzing large datasets, building interactive dashboards, and converting complex data into actionable business insights. This course strengthened my analytical thinking and reporting skills, enabling me to solve business problems efficiently using Excel and industry best practices.