StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries. InfoWorld’s 2023 BOSSIE Award for best open source software.

Personal Data Engineering Projects

Udacity Data Engineering Nano Degree (DEND)

A framework for rapid reporting API development; with out of the box support for high cardinality dimension lookups with druid.

Python scripts to set up a multidimensional model and run an ETL process for Ethereum data analysis.

Create Data Lake on AWS S3 to store dimensional tables after processing data using Spark on AWS EMR cluster

A project to design a fact and dimension star schema for optimizing queries on a flight booking database using PostgreSQL, a relational database management system. This schema is well-suited for a flight booking database, as it allows for efficient querying of data such as booking dates, flight routes, and passenger information.

This repository is a place for the Data Warehousing course at the Information Systems & Analytics department, Santa Clara University.

Data Warehousing (DW) Project Building and Analysing a DW for NatureFresh Stores in NZ, built using a high-performance Oracle database 12c, and Index-Nested Loops Join-Oracle.

Udacity Data Engineer Nanodegree - Postgres data modeling

Demonstrating the core skills acquired by making use of Advanced Database Modeling.

YAML format for star schema and snowflake schema

This repository is my final project for the Data Engineering Nanodegree Program.

This repository is about designing a database model for Global Super Store. This project is the final project of the 7th course "Advanced Data Modeling" of Meta Database Engineer Professional Certificate on Coursera.

This project encompasses the complete data lifecycle, from data extraction and transformation to in-depth analysis and compelling visualizations. The process is divided into three main phases

Data Engineering Projects including Data Modeling, Data Warehouse, Data Lake Development

This is a flask application that converts an informational model of a decision problem to a snow-flaked star schema

The main goal of this project is building up a data warehouse as a single-source-of-truth database by integrating data from different data sources for data analytics purpose and future backend usage.