Skip to content
View Brightpmk's full-sized avatar
  • Bangkok, Thailand

Block or report Brightpmk

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
Brightpmk/README.md

Computer Engineering student focused on Data Analytics and Data Engineering.
I design structured data workflows using Python and SQL, build ETL pipelines, and develop AI-powered analytics systems.


🛠 Tech Stack

Python SQL PostgreSQL SQLite Pandas Streamlit Plotly

Core technologies I work with:

  • Python (Pandas, data processing)
  • SQL (CTEs, window functions, analytical queries)
  • PostgreSQL / SQLite
  • ETL pipeline development
  • Relational schema design
  • Interactive analytics applications

📊 Featured Projects

AI Analytics Assistant for E-commerce

AI-powered analytics application that converts natural language questions into SQL queries and generates charts and business insights.

Key highlights:

  • Built a natural-language-to-SQL system using LLMs
  • Implemented SQL safety validation
  • Built an interactive Streamlit analytics interface
  • Generated automated data visualizations and insights

Tech stack:

Python · PostgreSQL · Streamlit · OpenAI · SQLAlchemy · Plotly

Repository:
https://github.com/Brightpmk/ecommerce-ai-analytics-assistant


Olist E-commerce ETL Pipeline

Designed a modular ETL pipeline that processes relational e-commerce datasets.

Key highlights:

  • Extracted data from 8 relational datasets (100k+ records)
  • Performed data cleaning and validation
  • Loaded datasets into SQLite
  • Built analytical fact table (fact_order_item_sales)

Tech stack:

Python · Pandas · SQL · SQLite

Repository:
https://github.com/Brightpmk/olist-etl-pipeline


Olist E-commerce Data Analysis

Exploratory data analysis project focused on revenue trends, logistics performance, and customer behavior.

Key highlights:

  • Processed 100k+ transaction records
  • Built analytical datasets using SQL and Python
  • Created visualizations to analyze marketplace performance
  • Identified revenue concentration patterns across product categories

Tech stack:

Python · Pandas · SQL · Matplotlib · Jupyter Notebook

Repository:
https://github.com/Brightpmk/Basic_data-analysis-project_00


🔎 Technical Focus

Areas I am currently strengthening:

  • Advanced SQL querying
  • Data transformation using Pandas
  • ETL pipeline architecture
  • Relational schema design
  • Backend data workflows
  • AI-assisted analytics systems

🚀 Currently Learning

  • Data warehouse design (fact & dimension modeling)
  • Incremental data loading strategies
  • SQL performance optimization
  • Workflow orchestration concepts (Airflow)
  • Cloud fundamentals (AWS / Linux)

📉 GitHub Activity Graph

Activity Graph


🎯 Long-Term Goal

To become a data-focused engineer capable of designing scalable data pipelines, analytics systems, and AI-driven data platforms.

Pinned Loading

  1. ecommerce-ai-analytics-assistant ecommerce-ai-analytics-assistant Public

    AI-powered analytics assistant that converts natural language questions into safe SQL queries on PostgreSQL and returns charts and business insights.

    Python

  2. olist-ecommerce-data-analysis olist-ecommerce-data-analysis Public

    Data analysis of the Olist e-commerce dataset using SQL and Python to explore revenue trends, customer behavior, and marketplace performance.

    Jupyter Notebook

  3. olist-etl-pipeline olist-etl-pipeline Public

    Python-based ETL pipeline that processes the Olist e-commerce dataset and loads analytics-ready tables into SQLite for SQL analysis.

    Python

  4. 2110503-CEDT68/be-project-68-chawiss 2110503-CEDT68/be-project-68-chawiss Public

    be-project-68-chawiss created by GitHub Classroom

    JavaScript

  5. Bailse/NoTimeToGetBadge Bailse/NoTimeToGetBadge Public

    HTML