At SiteMinder, I designed and delivered a production ELT pipeline from Heap Connect to Databricks Unity Catalog, feeding a governed warehouse and analytics and AI/ML consumers with 35M+ product analytics events.
I built and maintained dbt models and analytical datasets in a medallion architecture, and provisioned Databricks infrastructure with Terraform and Buildkite CI/CD. I also delivered a Salesforce CRM data model with dimensional modeling, integrity controls, and more than 100 column-level data quality tests.
I architected a serverless pipeline using AWS Lambda, S3, SQS, and Airflow that reduced lead processing time by 95%. At SiteMinder, I also used Snowflake Cortex AI to automate data quality validation, transliteration, and deduplication.
Previously, I engineered pricing-performance models and product analytics at SiteMinder, and built reporting and data automation in my Finance Data Analyst and Junior Data Analyst roles. My work included a Tableau and SQL sales pipeline report on 16M+ rows and an automated Excel-to-Tableau migration process.
