# Nikhil Gain

Nikhil Gain is a remote worker on Himalayas, Independent Data Analyst at Personal Project, based in Nepal.

Source: https://himalayas.app/@nikhilgain

```text
Data analyst using Python, SQL, and ETL to deliver healthcare insights.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | Nepal |
| Authorized to work in | Nepal |
| Job categories | Data Analyst, Data Analyst, Data Engineer, Machine Learning Engineer, Business Intelligence Analyst, Associate Data Analyst, Data Analytics Specialist |
| Skills | Data Analysis, Data Manipulation, Data Processing, Data Aggregation, Data Validation, Data Quality, Data Integrity, ETL, Trend Analysis, Python, SQL, MySQL, Power BI, Excel, Matplotlib, SeaBorn, Pandas, NumPy, Scipy, scikit learn, XGBoost, TensorFlow, Keras, PyTorch, SHAP, SMOTE, Bayesian Statistics, Feature Engineering, fastAPI, REST APIs, Streamlit, Database Schema Design, Git, GitHub |
| Portfolio | https://github.com/nikhil-gain |

## What I'm looking for

```text
I’m looking for a role where I can use Python/SQL and ETL to build reliable analytics and dashboards, collaborate with stakeholders, and grow domain expertise in healthcare and pharmaceuticals.
```

## About

```text
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.
```

## Experience

### Independent Data Analyst

Personal Project. Mar 2026 - May 2026

```text
Designed and executed an end-to-end real-time credit card fraud detection data analysis pipeline on 248,000+ transactions, applying data quality checks, SMOTE preprocessing, and an XGBoost model with SHAP explainability. Deployed the solution via a FastAPI REST API and a Streamlit web interface for real-time data validation and inquiry resolution.
```

Skills: Data-Analysis, Data-Manipulation, Data-Quality, Data-Validation, SMOTE, XGBoost, SHAP, Bayesian-Informed-Thresholding, REST-APIs, fastAPI, Streamlit, Real-Time-Fraud

## Education

### Institute of Engineering (IOE), Pulchowk Campus, Tribhuvan University

Bachelor of Engineering, Computer Engineering. 2022 - 2026

Activities and societies: Relevant Coursework: Probability & Statistics; Database Management Systems (DBMS); Data Structures & Algorithms; Artificial Intelligence; Computer Networks.

```text
Bachelor of Engineering in Computer Engineering at IOE Pulchowk Campus, Tribhuvan University (2022–2026), including coursework in Probability & Statistics, DBMS, Data Structures & Algorithms, Artificial Intelligence, and Computer Networks.
```

## Tech stack

- GitHub
- NumPy
- Pandas
- MySQL
- TensorFlow
- PyTorch
- scikit-learn
- Keras
- Streamlit
- FastAPI
- Microsoft Excel
- SQL
- XGBoost
- SciPy
- Seaborn

To contact Nikhil, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Yuvraj Giri](https://himalayas.app/@yuvrajgiri): Data Analyst Intern, Revenue Analysis Project
- [Harichandra Khatri](https://himalayas.app/@harichandrakhatri): Software Developer, Self Employed
- [Kaushal Niroula](https://himalayas.app/@kaushalniroula): Data Analyst (Intern), HCLTech India
- [Avishek Guragain](https://himalayas.app/@avishekguragain): Bachelor of Information Technology, Texas College of Management and IT
- [Dhawa Dorje Ghising](https://himalayas.app/@dhawadorjeghising1): Freelance Data Analyst, Self Employed
- [Manish Shiwakoti](https://himalayas.app/@manishshiwakoti): Data Analyst Intern, PyFix Data Analytics
- [sarthak Shrestha](https://himalayas.app/@sarthakshrestha1): C#/.NET Backend Developer, Jojolapa Innovation Tech Pvt Ltd
- [Yogesh Roy](https://himalayas.app/@yogeshroy): Associate Solution Architect, FlexTecs
- [dikshya User](https://himalayas.app/@dikshyauser3): Data Analyst, Central Campus of Technology
- [Prizzeshh 777](https://himalayas.app/@prizzeshh777): Intern Data Analytics, Dlytica Academy
