A Data Engineer with a Strong Software Engineering Background

SQL Data Warehouse

Brings ERP and CRM data together in a SQL Server warehouse for sales reporting and analysis.

• Bronze, Silver, and Gold layers for ingestion, cleansing, and validation.
• A star schema that turns source data into analytics-ready tables.

Sales Analytics Warehouse

Transforms e-commerce customer, product, and order data into a Snowflake warehouse for sales analytics.

• Incremental dbt models and tests for reliable transformations.
• Fact and dimension models with SCD Type 2 to preserve history.

Near Real-Time Retail Pipeline

Combines batch retail data and live clickstream events into query-ready datasets for e-commerce analytics.

• Kafka and Spark enrich live events with product and inventory data.
• Airflow orchestrates the batch and streaming workflows.

Healthcare Data Pipeline

Continuously ingests patient admission JSON into Snowflake and transforms it into structured healthcare datasets.

• VARIANT storage accommodates changes in incoming JSON schemas.
• Layered dbt models clean and validate data for a star schema.

Social Media & Productivity

Explores social media usage and predicts its impact on productivity through an interactive dashboard.

• Exploratory analysis of data sourced from PostgreSQL.
• Streamlit visualizations make patterns and findings easy to explore.