AM

ASHVATH M

Analytics Engineer · Final-year Computer Science student

Tirupathur, Tamil Nadu, India

@ashvath07

0 followers

🎓 B.E. Computer Science & Engineering at Hindusthan College of Engineering and Technology · Graduating 2027

About

Final-year Computer Science Engineering student specializing in analytics engineering, with hands-on experience building ETL/ELT pipelines using Python, PySpark, SQL, and Databricks on AWS. Built medallion-architecture data lakes, automated data workflows, and delivered KPI reporting for business stakeholders.

Experience

  • Data Analyst Intern
    Null Class
    Jun 2025 – Jul 2025

    Cleaned and transformed raw datasets using Python and SQL, resolving inconsistencies and improving data quality for downstream analysis. Conducted exploratory data analysis to surface trends and presented findings through dashboards and structured reports.

  • Power BI Analyst Intern
    Unified Mentor
    Mar 2025 – Apr 2025

    Designed and deployed interactive Power BI dashboards using Power Query and DAX, consolidating KPIs across business functions. Automated recurring reporting workflows, cutting manual report preparation time by approximately 40%.

Education

  • B.E. Computer Science & Engineering
    Computer Science · 2023 – 2027
  • Higher Secondary
    Raji Garden Matric Hr Sec School
    Science · 2021 – 2023

Skills

Tools / apps / platforms

<3 months <3 months Just getting started - under three months. This is also what shows when a level has not been set.
S3 dbt Git MySQL GitHub Tableau Snowflake Databricks PostgreSQL Apache Kafka Google Colab Apache Airflow Microsoft Excel Jupyter Notebook Microsoft Power BI Amazon Web Services AWS

Projects

  • Customer Churn Prediction
    Python, SQL, Power BI, Machine Learning

    Built and evaluated machine learning models predicting customer churn with 90% accuracy; used SQL for data extraction and feature preparation. Developed Power BI dashboards showing retention trends and at-risk customer segments to support targeted retention strategies.

  • E-Commerce Data Engineering Pipeline
    Python, PySpark, Databricks, AWS, ETL, Power BI

    Architected an end-to-end ETL pipeline on Databricks to process millions of e-commerce transaction records into analytics-ready datasets. Automated data ingestion and transformation stages, reducing manual processing effort and enabling near real-time business reporting in Power BI.

  • Weather Data Pipeline & Analytics
    Python, PySpark, Databricks, AWS S3, Snowflake

    Built a scalable medallion-architecture ETL pipeline in PySpark on Databricks, ingesting JSON weather data from APIs into an AWS S3 data lake. Transformed data through Bronze, Silver, and Gold layers and loaded curated datasets into Snowflake. Trained a Random Forest model on the curated data to predict weather conditions.

Courses & certifications

  • Cloud Computing · NPTEL

🏆 Achievements & awards

  • National-Level Conference Presentation

    Presented research on a Computer Vision-based Automated Attendance System at a national-level conference.

Explore the Broxer community

🤖
Online · instant AI help
Broxer