Skip to content
View andrewsuadnya's full-sized avatar
🦾
...
🦾
...
9 followers · 12 following
  • Sam Ratulangi University
  • Manado, North Sulawesi, Indonesia
  • 08:24 (UTC +08:00)
  • LinkedIn in/andrewsuadnya

Achievements

Achievement: Galaxy Brainx2Achievement: Pair ExtraordinaireAchievement: Pull SharkAchievement: YOLOAchievement: Quickdraw

Achievements

Achievement: Galaxy Brainx2Achievement: Pair ExtraordinaireAchievement: Pull SharkAchievement: YOLOAchievement: Quickdraw

Highlights

  • Pro

Block or report andrewsuadnya

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
andrewsuadnya/README.md

github


Coding

💫 About Me:

Hi, I'm Andrew Suadnya

👀 I’m passionate about Data, with a focus on Data Engineering
🎓 I hold a Bachelor’s Degree in Informatics Engineering, Sam Ratulangi University
🌱 Data Engineer Bootcamp Graduate at Digital Skola
📫 Reach me at: andrewsuadnya@gmail.com

💻 Tech Stack:

Python Postgres MySQL MariaDB Google Cloud Alibaba Cloud Snowflake Elasticsearch Apache Kafka Apache Spark Apache Hadoop Apache Airflow Oracle Docker Kubernetes Anaconda Notion Adobe Premiere Pro Canva

📊 GitHub Stats

✍️ Random Dev Quote

🚀 Data Engineering Projects

📊 YouTube Live Chat Sentiment Analysis

A near real-time sentiment analysis system for YouTube live chat using a big data stack. Built with Kafka, Spark Structured Streaming, Elasticsearch, Kibana, Flask, and React.js to collect, process, and visualize live messages.

Repo

📰 Automated Financial News Sentiment Pipeline with Airflow

A fully automated data pipeline that ingests financial news from Finnhub API, stores it in MongoDB Atlas, performs sentiment analysis, and loads results into PostgreSQL — orchestrated using Apache Airflow.

Repo

💬 Real-Time Text Stream Analytics with Kafka & Python

End-to-end streaming pipeline using Kafka and Python to generate random sentences, publish to Kafka, and analyze their sentiment in real-time.

Repo

📈 Monthly Order Aggregation with Hadoop MapReduce

A batch ETL project using Hadoop MapReduce to transform and aggregate monthly order data from PostgreSQL into a data mart for reporting.

Repo

🔧 Flask RESTful API with PostgreSQL and Docker

A containerized CRUD API built with Flask and PostgreSQL. Includes RESTful endpoints for user management, health checks, and supports testing via Postman.

Repo

🛠️ ETL Pipeline: MySQL to PostgreSQL using Docker

A Dockerized ETL pipeline that extracts data from MySQL (CSV-based), transforms it using Python, and loads it into a PostgreSQL Data Warehouse.

Repo

📦 Batch ETL for Order Data to PostgreSQL Warehouse

Python-based batch ETL project that migrates and transforms order data from a PostgreSQL source to a data warehouse schema (dim_orders).

Repo

🧱 Building a Data Warehouse with DBT & PostgreSQL

A data warehouse project using DBT (Data Build Tool) for modeling, transformation, and testing on top of PostgreSQL.

Repo


Typing SVG

Profile Views

Pinned Loading

  1. YouTube-Live-Chat-Sentiment-Analysis YouTube-Live-Chat-Sentiment-Analysis Public

    A near real-time sentiment analysis system for YouTube live chat using a big data stack. Built with Kafka, Spark Structured Streaming, Elasticsearch, Kibana, Flask, and React.js to collect, process…

    Python 2

  2. FinalProject_DE_DigitalSkola FinalProject_DE_DigitalSkola Public

    A fully automated data pipeline that ingests financial news from Finnhub API, stores it in MongoDB Atlas, performs sentiment analysis, and loads results into PostgreSQL — orchestrated using Apache …

    Python 1

  3. PROJECT3-DataEngineering-DigitalSkola PROJECT3-DataEngineering-DigitalSkola Public

    Python-based batch ETL project that migrates and transforms order data from a PostgreSQL source to a data warehouse schema (dim_orders).

    Python 1

  4. PROJECT4-DataEngineering-DigitalSkola PROJECT4-DataEngineering-DigitalSkola Public

    A Dockerized ETL pipeline that extracts data from MySQL (CSV-based), transforms it using Python, and loads it into a PostgreSQL Data Warehouse.

    Python 1

  5. PROJECT5-DataEngineering-DigitalSkola PROJECT5-DataEngineering-DigitalSkola Public

    A containerized CRUD API built with Flask and PostgreSQL. Includes RESTful endpoints for user management, health checks, and supports testing via Postman.

    Python 1

  6. PROJECT8-DataEngineering-DigitalSkola PROJECT8-DataEngineering-DigitalSkola Public

    End-to-end streaming pipeline using Kafka and Python to generate random sentences, publish to Kafka, and analyze their sentiment in real-time.

    Python 1