About

I am Shalom J, a 3rd-year B.E. Computer Science Engineering (AI & ML) student at Rathinam Technical Campus, Coimbatore, graduating in 2028. I have built projects in data cleaning, KPI dashboards using Excel, and sales data analysis using SQL, developing skills in data analytics, data visualization, and business insights. My strongest skills include Excel, SQL, and data-driven problem solving. I am aiming for a role as a Data Analyst, where I can apply my analytical skills to real-world datasets and contribute to data-informed decision-making.

Education

1. Rathinam Technical Campus

   B.E. Computer Science Engineering (Artificial Intelligence & Machine Learning)

   3rd Year Student

Projects

• Data Cleaning and KPI Dashboard Using Excel

  • Microsoft Excel
  • Pivot Tables
  • Charts

  Executed data cleaning, validation, and duplicate removal on raw business datasets to ensure data integrity. Developed Excel KPI dashboards using Pivot Tables and charts to track operational performance and support decision-making.

• Customer and Sales Data Analysis Using SQL

  • SQL
  • SELECT
  • WHERE
  • GROUP BY
  • JOINs
  • Aggregate Functions
  • Subqueries

  Queried customer and sales datasets using SQL SELECT, WHERE, GROUP BY, and JOINs to retrieve business records. Implemented aggregate functions and subqueries to evaluate purchasing behavior and extract actionable insights.

• Sales Data Analysis Using Excel

  • Microsoft Excel
  • Pivot Tables
  • Charts
  • Data Cleaning
  • Data Validation

  Cleaned and prepared sales datasets by removing duplicates, handling missing values, and applying Excel formulas and filters. Built Pivot Tables and dynamic charts to analyze sales performance, top products, and regional trends using calculated KPIs.