devika lahari bandi

Devika Lahari Bandi

Data analyst — Python · SQL · Power BI · Tableau

I turn raw data into decisions. Entry-level analyst with internship experience building dashboards, automating reporting, and shipping ML prototypes for remote teams — based in Hyderabad, open to full-time remote roles.

0%AUC-ROC, fraud model
0K+transactions analyzed
0%less manual reporting
0certifications

Projects

Credit card fraud detection

view repo →

python · scikit-learn · pandas · smote

Logistic regression model trained on 284,000+ transactions to catch fraudulent charges in a heavily imbalanced dataset. Used SMOTE to correct class imbalance and reduce false negatives against the baseline.

87% accuracy · 94% AUC-ROC

Pizza sales analysis

view repo →

sql · mysql

Queried 10,000+ orders across four related tables using joins, CTEs, and window functions to find where the revenue and demand actually concentrate.

top 3 categories = 65%+ of revenue · Friday evenings = 22% of weekly orders

Mitron Bank credit card analysis

view repo →

power bi · dax

Interactive dashboard analyzing spending behavior across 4,000 customers in 5 cities, built to surface customer segments and monthly spending trends for a banking stakeholder.

identified high-spend customer segments

Air quality prediction

view repo →

python · random forest · scikit-learn

Random forest model predicting AQI from five pollutant readings using EPA data, with feature engineering and standard-scaler normalization ahead of training.

R² = 0.95 · MSE = 0.058

Experience

feb–jun 2025
remote

Machine learning research intern

GWT

  • Built rainfall-prediction models (random forest, KNN, Gaussian NB) on 10,000+ records, reaching 83.8% accuracy — including EDA, feature engineering, and UML architecture documentation.
  • Developed a Flask-based real-time prediction interface and delivered research documentation for internal and academic use.
jul–aug 2024
remote

Data analyst intern

MentorNess

  • Automated reporting pipelines, cutting manual processing by 20%, and delivered 15+ Power BI and Excel dashboards for senior leadership.
  • Implemented process improvements that raised productivity by 15%, validating data pipelines with cross-functional remote teams on shared KPIs.

Skills

languages & tools

Python SQL MySQL Pandas NumPy scikit-learn Power BI Tableau Excel Flask

analytics

EDA Feature engineering Predictive modeling KPI reporting Dashboard development DAX Power Query

soft skills

Cross-functional collaboration Remote & async communication Stakeholder reporting Technical documentation Problem-solving Time management

Certifications

  • Data Analytics and Visualization Job SimulationAccenture
  • Data Visualization: Empowering Business with Effective InsightsTCS · Forage
  • Power BI Virtual Case ExperiencePwC · Forage
  • AI Skills ChallengeMicrosoft

Education

Master's degree, Computer Science

Adikavi Nannaya University, Rajahmundry — Nov 2023 – Nov 2025

Bachelor's degree, Computer Science

Adikavi Nannaya University, Rajahmundry — Feb 2020 – Aug 2023