At Bank of America, I build reporting frameworks with finance, risk, compliance, and operations teams. I developed AWS Glue and PySpark pipelines processing about 3 million records daily, and standardized trading and portfolio reporting with dbt models in Snowflake.
I also publish Snowflake reporting tables and Power BI dashboards for executive KPIs, risk metrics, and operational performance. By tuning Snowflake, I cut the main executive dashboard’s load time from about 12 seconds to 5.
At Wells Fargo, I analyzed banking data in Azure Databricks and built Power BI dashboards for customer behavior, payment milestones, and digital banking activity. Source-to-target reconciliation raised reporting data accuracy to 98%, while Snowflake improvements brought the month-end loan report from about 22 minutes to 13.
At Prudential Financial, Inc, I supported the migration of 87 tables to AWS S3 and Redshift and built validation frameworks for data consistency. I also automated reporting with Python, saving about 6 hours of manual work per week, and created reconciliation logs to quarantine malformed records.
