Selected work
Threat Intelligence Investigation
A take-home assessment for CHEQ's interview process, run on real data: I connected to CHEQ's servers and used Python and SQL to analyze 126,959 e-commerce sessions for bot traffic and ad fraud, quantify the financial impact, and build a prioritized mitigation strategy to protect checkout, login, and advertising spend.
The Problem
E-commerce platforms are a high-value target for automated abuse, and most of it is invisible at first glance. Bots mimicking legitimate user behavior inflate traffic metrics, drain advertising budgets, hoard inventory, and stuff credential databases, all while flying under the radar of conventional monitoring. CHEQ's take-home handed me real session data and a question that's harder than it sounds: which of these 126,959 sessions are actually human?
What’s Included
- Python and SQL against CHEQ's servers to pull and query the session data
- Behavioral signal analysis across 126,959 e-commerce sessions to identify automated bot traffic
- Multi-signal correlation including datacenter ASNs, headless browser indicators, timezone mismatches, and interaction speed analysis
- Bot-driven attack pattern detection targeting checkout, login, and product endpoints
- Ad fraud quantification across paid Google and Bing search traffic consumed by automated sessions
- Prioritized mitigation strategy covering ASN blocking, device fingerprint detection, rate limiting, and MFA enforcement
Impact
Identified that 25.51% of all sessions, roughly 1 in 4, were automated bot traffic. The analysis estimated $3,362 to $13,448 in advertising spend wasted on bots interacting with paid search campaigns, and surfaced attack patterns consistent with two of the most revenue-critical threats on any e-commerce platform: inventory hoarding and credential stuffing at the checkout and login layers. I wrote it up as a presentation for the interview.


$ cat stack.txt





















