Abhik Saran

About

Data Analyst with hands-on experience in SQL, Python, Excel, and Power BI across exploratory data analysis, dashboard development, and stakeholder reporting. Built through two data internships and multiple end-to-end analytics projects, with a strong focus on data cleaning, KPI tracking, and actionable insights.

Experience

• Data Science Intern
  Centre for Development of Advanced Computing (C-DAC)
  Jun 2025 – Aug 2025
• Data Engineering Intern
  Codroid Hub
  Jan 2024 – Jun 2024

Education

• Bachelor of Technology
  Amity University, Noida
  Computer Science Engineering · 2022 – 2026

Skills

• SQL
• FastAPI
• Python
• Java
• Data Cleaning
• Feature Engineering
• NumPy
• Pandas
• PySpark
• Databricks
• Data validation
• API Integration Understanding
• Statistical Analysis
• Delta Lake

Projects

• Scalable Big Data Analytics Pipeline — Brazilian E-Commerce Dataset ↗
  PySpark, Azure Databricks, Apache Hive, Delta Lake, Power BI

  Transformed 100K+ raw e-commerce records into analytics-ready tables using PySpark, Azure Databricks, Hive, and Delta Lake, enabling faster ad-hoc analysis. Built Power BI dashboards surfacing sales, revenue, and customer behavior trends, giving business stakeholders self-serve visibility into performance.

• Sentiment Analysis and Customer Feedback Pipeline — IMDB Reviews ↗
  Python, Scikit-learn, NLP, Power BI

  Cleaned and analyzed 50K text review records in Python to extract sentiment trends from customer feedback. Built a text preprocessing and feature extraction pipeline (tokenization, vectorization) to support sentiment classification. Delivered Power BI reports visualizing positive and negative feedback trends for customer experience decisions.

• Customer Retention and Churn Analytics Pipeline ↗
  PySpark, Azure, Delta Lake, Power BI

  Analyzed customer activity data using PySpark and SQL to identify behavioral patterns driving churn. Built analytical datasets with Delta Lake to calculate churn rate, retention rate, and customer lifetime value, flagging high-risk segments. Designed Power BI dashboards to monitor churn, retention, and CLV trends, translating findings into retention strategies.

Courses & certifications

• Oracle Cloud Infrastructure 2025 Certified Data Science Professional · 2025