Basavarajkp Patil

Data professional specializing in Fraud & Risk Management at Flipkart. Expert in building scalable data pipelines and identifying complex fraud patterns, specifically in Account Takeover (ATO) and Loss Prevention. Highly proficient in SQL, Python, and Big Data ecosystems, with a proven track record of optimizing query latency and mitigating financial loss through proactive threat detection and cross-functional engineering partnerships.

Data Analyst (Fraud & Risk) at Flipkart Internet Pvt. Ltd. (2024-09 – Present)

• ATO Mitigation: Prevented significant financial losses by identifying and freezing compromised accounts during the "incubation period"—the critical window between account takeover and cash-out.
• Vulnerability Resolution: Partnered with Product and Engineering to resolve a critical flaw in password-reset logic exploited for unauthorized access.
• Post-Mortem Analysis: Conducted technical post-mortems on successful ATO incidents to identify system gaps and implement long-term defensive upgrades.
• Threat Intelligence: Monitored external threat intelligence and credential leak sites to identify dumps, enabling proactive security measures for at-risk accounts.
• Real-Time Pipelines: Engineered live data pipelines using Kafka, feeding metrics to Tableau dashboards for real-time risk monitoring and ATO trend tracking.
• Query Optimization: Refined complex SQL queries and data transformations, resulting in a substantial reduction in query execution time and system latency.
• Detection Logic: Optimized False Positive Rates (FPR) by refining detection rules to accurately distinguish legitimate user behavior from malicious automated attacks.
• Big Data Processing: Leveraged Hadoop, Hive, and Spark to process multi-terabyte datasets for anomaly detection and machine learning feature engineering.
• Standardization: Standardized the ATO Incident Response (IR) playbook, significantly reducing the mean time to resolve and secure compromised accounts.

Bachelor of Computer Application in BCA – Mahamaya Technical University (2019)