SP

Satyam Prajapati

Aspiring Data Science & AI Intern

Lucknow, Uttar Pradesh, India

@satyam_prajapati

0 followers

🎓 Bachelor of Technology (B.Tech.) in Computer Science and Engineering at I.K. Gujral Punjab Technical University, Jalandhar-Kapurthala · Graduating 2027

About

Aspiring data science and AI professional with hands-on experience in Python, SQL, machine learning, data analysis, and visualization. Has worked on data preprocessing, EDA, feature engineering, predictive modeling, and interactive dashboard development using tools such as Power BI, Pandas, and MySQL.

Experience

  • Data Analyst Intern
    Christina DeLeon Company
    Oct 2025 – Apr 2026

    Analyzed 10,000+ business and sales records using Python, SQL, and Power BI to identify trends and actionable insights. Cleaned, transformed, and validated datasets to improve data quality, consistency, and analysis readiness. Performed exploratory data analysis (EDA) using Pandas and Matplotlib to identify trends, patterns, and outliers. Built interactive Power BI dashboards to track revenue, profitability, sales performance, and KPIs. Developed SQL queries for data extraction, filtering, joining, and aggregation. Automated recurring reports using Python, reducing manual effort and improving reporting efficiency. Collaborated with stakeholders to convert business requirements into data-driven insights.

Education

  • Bachelor of Technology (B.Tech.)
    I.K. Gujral Punjab Technical University, Jalandhar-Kapurthala
    Computer Science · 2023 – 2027

Skills

Tools / apps / platforms

6 to 12 months 6 to 12 months Most of a year behind them.
Microsoft Power BI
<3 months <3 months Just getting started - under three months. This is also what shows when a level has not been set.
Git MySQL GitHub Tableau PostgreSQL Microsoft Excel Jupyter Notebook

Projects

  • Python, Scikit-Learn, Pandas

    Machine learning project to predict student performance outcomes using classification. Included exploratory data analysis, preprocessing, feature selection, model training, and evaluation.

  • Power BI, Microsoft Excel

    Power BI project analyzing sales performance across outlet types, sizes, locations, and product categories. Built an interactive dashboard and used Excel for data cleaning, transformation, and validation.

  • Power BI, Microsoft Excel

    Power BI project examining heart failure clinical records to identify patient demographics, survival outcomes, and major risk factors. Built an interactive dashboard and used Excel for data cleaning, transformation, and validation.

Courses & certifications

  • Microsoft Power BI · Microsoft · 2026
  • Microsoft Data Analytics Professional Certificate · Microsoft · 2026
  • SQL for Data Analysis · HackerRank · 2025

🏆 Achievements & awards

  • LeetCode and HackerRank DSA problems

    Solved 200+ DSA problems and earned a 5-star Problem Solving badge on HackerRank.

  • Kaggle competitions

    Participated in Kaggle competitions applying machine learning techniques for data modeling and evaluation.

Explore the Broxer community

🤖
Online · instant AI help
Broxer