Bradley Pike

Senior Fraud Analyst

Commonwealth Bank of Australia•  September 2021 - Present

• Responsible for writing code that identifies fraud in real time, data analysis, debugging, building reports, and data engineering, via SAS, Oracle SQL, and Teradata SQL. • Created a real-time program that prevented $470,000 in fraud per week by identifying a pattern in the data and declining transactions that matched that pattern. • Built a tool that sped up SQL scripts by over 2000% across 8 teams by creating a method for linear-time joins without indexes. One script that took 4 hours now takes 7 seconds. • Built code that stores data more densely for real-time analysis. Now the team can use 8x as many datetimes and amounts, and 24x as many recipient keys, to catch more fraud.

Lead Programmer

Department of Human Services•  February 2018 - June 2020

• Responsible for designing a system that extracted, cleaned, and manipulated data from a large database to quickly answer requests, using Teradata SQL and SAS. • Reduced time to answer most requests by over 99% by creating a fast, modular SQL and SAS codebase. One request went from needing 2000 lines of code to using only 10. • Identified all bushfire-affected customers within an hour of the request using my codebase while extending it with the new code to make future data requests faster. • Built automated unit tests that identified errors rarer than one in a million records. • Built advanced SQL tools. Built code that reverse engineers database rules. Built code that recursively finds independent networks within an arbitrary set of nodes. • Created an alternative payment model and showed mathematically that it avoided the downsides of both the old and the new payment models, while retaining their benefits. • (Note: position was as an APS graduate from Feb 2018 to Nov 2018.)