E-Commerce Data Warehouse & Business Data Pipeline

Built and analyzed an ETL pipeline loading transactional order data into a PostgreSQL star-schema warehouse for structured business analysis.
Used SQL to validate order, customer, and transactional datasets and verify fact and dimension table integrity.
Performed data-quality analysis to identify duplicate, null, missing, and inconsistent records across staging and warehouse layers.
Validated incremental data loads through SQL reconciliation queries, achieving 100% row-count accuracy.