At Broadsmart, I develop Python and Bash automation to streamline operational workflows and reduce repetitive manual processes. I also assist with data processing workflows for operational reporting and system monitoring.
I query, update, and validate business data using SQL databases, and assist with deploying and supporting cloud-hosted services in AWS. My work also includes monitoring system performance and investigating data-related issues.
I built an end-to-end Databricks pipeline for online retail data using the Medallion Architecture. It uses Auto Loader and streaming tables for incremental ingestion, then transforms raw transactions into analytics-ready datasets.
For the pipeline, I developed Silver-layer data cleaning and validation, and created a Gold-layer materialized view for daily revenue, order volume, unique customers, and items sold. I also designed a separate data warehouse and ETL project using Bronze, Silver, and Gold layers, with data quality checks and Microsoft SQL Server.

