At Capital One, I design and maintain Snowflake and dbt models for credit-risk and financial reporting across customer, account, and lending data. I converted full-refresh models to incremental models, improving reporting query time and warehouse compute cost.
I built SCD Type 2 snapshots and conformed dimensions for point-in-time risk reporting. I also implemented dbt tests, lineage documentation, and GitHub Actions checks to improve data quality, while Airflow orchestration supports on-time reporting delivery.
At Deloitte, I developed Alteryx and Python ETL workflows for Azure-based reporting environments. I also wrote SQL reconciliation queries and built Power BI and Tableau dashboards for operational KPI tracking.
On my AI-Enabled Credit Risk Analytics Platform project, I modeled customer, transaction, and loan records in a Snowflake/dbt star schema, trained a credit-default classifier, and used Snowflake Cortex AI to summarize portfolio trends. I hold an M.S. in Business Analytics from University of Maryland.
