Wells Fargo · Senior Lead Data Analytics Engineer

The largest remediation in Wells Fargo's history

I was the lead analyst on the multi-year remediation that followed the bank's sales practices consent orders, the largest in its history. I wrote all of the SAS and SQL and investigated data across many databases to work out which customers were affected, by how much, and what the bank owed them, including Tier-1 programs worth more than $15M.

SAS

SQL

Python

Snowflake

Three questions for every customer

The sales practices consent orders led to the largest remediation effort in Wells Fargo's history, and it ran for years. I was the lead analyst on it. I wrote all of the SAS and SQL code and did the data investigation across many different databases to answer three questions:

Which customers were affected?
How much were they affected?
How much does the bank owe them?

No single system held those answers. Each one had to be pieced together from data spread across many databases.

Why it had to be right

Auditability and scale were hard requirements. If the analysis misses a customer, someone doesn't get the refund or correction they're owed. And every amount has to hold up when it's reviewed.