Skip to content
View Devikalahari03's full-sized avatar

Block or report Devikalahari03

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Devikalahari03/README.md

Hi πŸ‘‹, I'm Devika Lahari

Data Analyst | Python β€’ SQL β€’ Power BI β€’ Tableau β€’ Excel

Email LinkedIn GitHub


πŸ‘©β€πŸ’» About Me

  • 🌍 Based in Hyderabad, India β€” open to US Remote roles
  • πŸ“Š I turn raw data into clear business insights through dashboards, reports, and predictive models
  • πŸ› οΈ Experienced in Python, SQL, Power BI, and Excel across finance, operations, and ML domains
  • πŸŽ“ Master's in Computer Science β€” Adikavi Nannaya University (2025)
  • 🎯 Seeking entry-level Data Analyst / Business Analyst positions

🧰 Tech Stack

Python SQL Power BI Tableau Excel Pandas scikit-learn Flask


πŸ“Œ Featured Projects

Tools: Python, scikit-learn, Pandas, Matplotlib

  • Built a logistic regression classifier on 284,000+ transactions with SMOTE to handle class imbalance
  • Achieved 87% accuracy & 94% AUC-ROC score, reducing false negatives vs baseline
  • Visualized confusion matrix and ROC curves for non-technical stakeholders

Tools: SQL, MySQL, Power BI

  • Queried 10,000+ order records using CTEs, window functions, and JOINs to find top SKUs and peak hours
  • Found top 3 categories drove 65%+ of revenue; Friday evenings = 22% of weekly orders
  • Delivered structured SQL scripts and PDF report covering revenue trends and category breakdown

Tools: Power BI, DAX, Data Modeling

  • Built end-to-end interactive Power BI dashboard analyzing credit card spending patterns across 4,000 customers in 5 cities
  • Identified high-spending customer segments and peak payment periods using DAX measures and dynamic slicers
  • Delivered executive-ready visuals supporting data-driven credit card product strategy

🌫️ Air Quality Prediction

Tools: Python, Random Forest, scikit-learn, Pandas

  • Built Random Forest regression model on EPA data predicting AQI from 5 pollutants β€” achieved RΒ² = 0.95 & MSE = 0.058
  • Performed end-to-end EDA, feature engineering, and StandardScaler normalization
  • Feature importance analysis revealed pollutant mean concentration as strongest AQI predictor

πŸ’Ό Experience

Role Company Duration
ML Research Intern GWT (Remote) Feb 2025 – Jun 2025
Data Analyst Intern MentorNess (Remote) Jul 2024 – Aug 2024

πŸ“š Certifications

Certificate Issuer
Data Analytics & Visualization Job Simulation Accenture (Forage)
Data Visualization: Empowering Business with Effective Insights TCS (Forage)
Power BI Virtual Case Experience PwC (Forage)
AI Skills Challenge Microsoft

🀝 Connect with Me

Pinned Loading

  1. Air-Quality-Prediction-and-Optimization Air-Quality-Prediction-and-Optimization Public

    AQI prediction using Random Forest on EPA data β€” RΒ² = 0.9541, MSE = 0.0586

    Python 1

  2. Credit-Card-Fraud-Detection Credit-Card-Fraud-Detection Public

    πŸ“ Logistic regression fraud classifier on 284K+ transactions β€” 87% accuracy, 94% AUC-ROC

    Jupyter Notebook 1

  3. Devikalahari03 Devikalahari03 Public

    Config files for my GitHub profile.

    1

  4. Mitron-Bank-Credit-Card-Analysis Mitron-Bank-Credit-Card-Analysis Public

    Interactive Power BI dashboard analyzing credit card usage of 4,000 customers across 5 cities β€” DAX, customer segmentation, spending insights

    1

  5. Pizza-Sales-Analysis-SQL-Project Pizza-Sales-Analysis-SQL-Project Public

    SQL analysis of 10,000+ pizza orders β€” revenue trends, peak hours, top-selling categories using MySQL

    1