Anuj Kumar Asthana

About

Data analyst and data engineer with experience in Python, SQL, Power BI, and big data technologies. Skilled in data analysis, ETL fundamentals, dashboarding, and translating business requirements into technical solutions.

Experience

• Packaged App Development Associate
  Accenture
  Sep 2024 – Jan 2026
• Data Analyst Intern
  Persistent Systems
  May 2023 – Aug 2023

Education

• B.Tech
  GL Bajaj Institute of Technology and Management
  Computer Science & Engineering (Artificial Intelligence) · Oct 2020 – Jun 2024
• Class XII
  Delhi Public School
  Science · Mar 2019 – Apr 2019

Skills

• SQL
• Git
• GitHub
• Python
• Power BI
• MySQL
• Feature Engineering
• Matplotlib
• NumPy
• Pandas
• PostgreSQL
• Power Query
• DAX
• Hadoop
• DBMS
• Plotly
• Scrum
• Data Modeling
• ETL
• Excel
• Statistical Analysis
• KPI reporting
• Query Optimization
• Agile
• Data Transformation
• Hive
• HDFS
• Eda
• MapReduce

Projects

• Student Performance Prediction & Intervention Analysis
  Python, Pandas, Scikit-learn, Plotly

  Performed EDA and feature engineering on student records; built a Decision Tree classifier identifying attendance and study hours as strongest performance predictors via correlation analysis.

• Swiggy Food Delivery Dataset Analysis
  Python, Pandas, NumPy, Power BI

  Conducted EDA on food delivery data to uncover peak demand windows, top cuisines by region, and restaurant performance tiers; built Power BI dashboards tracking order volume and revenue KPIs.

• E-Commerce Sales Performance & KPI Dashboard
  Python, Pandas, Power BI, DAX, Excel

  Designed a star-schema data model on transactional data; built Power BI dashboards with DAX measures for YoY growth, rolling averages, and CLV. Automated monthly KPI report generation using Python, reducing manual reporting effort from 6 hours to 30 minutes per cycle.

• Customer Churn Prediction & Revenue Impact Analysis
  Python, Pandas, Scikit-learn, Power BI, SQL

  Built a classification pipeline on telecom data using Random Forest; engineered features, applied SMOTE for class balancing, and visualised churn risk segments in a Power BI dashboard. Identified key churn drivers and translated model output into actionable customer retention recommendations.

🗣️ Languages

• English · Fluent
• Hindi · Native