Nikhil Gain

I’m a Computer Engineering graduate focused on turning complex data into clear, actionable insights. I bring hands-on experience in data analysis, data manipulation, and ETL pipeline design, with a strong emphasis on data quality and integrity validation.

I built an end-to-end Real-Time Credit Card Fraud Detection system on 248,000+ transactions, validating integrity across 31 features and addressing severe class imbalance. I trained an XGBoost model with 97%+ ROC-AUC, used Bayesian-informed thresholding to balance precision-recall, and added SHAP explainability to communicate results to both technical and non-technical stakeholders. I also deployed the solution through a FastAPI REST API and a Streamlit interface for real-time validation and inquiry.

I’ve also delivered analytics and reporting using Power BI and advanced Excel, and I’ve designed data warehouse-style SQL ETL integrations across 7 datasets (500,000+ records). By optimizing SQL performance, I reduced processing time by ~40% and identified/resolved 15+ data inconsistencies. I’m eager to apply this analytical expertise within the healthcare and pharmaceutical domain while building domain knowledge in clinical and commercial data environments.