Skip to content
View Devikalahari03's full-sized avatar
1 follower · 0 following

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.

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 ** 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 Tableau Power BI Excel Pandas scikit-learn Flask

📌 Featured Projects

💳 Credit Card Fraud Detection

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

🌫️ Air Quality Prediction

Tools: Python, Pandas, scikit-learn, Seaborn

  • Engineered AQI prediction model using 8 pollutants (PM2.5, NO2, SO2, CO, O3) across 5,000+ hourly readings
  • Tuned Random Forest regressor via GridSearchCV — improved early-warning alert accuracy by 15%
  • Built EDA visualizations surfacing seasonal pollution patterns for environmental reporting

📊 Sales & Finance Analytics Dashboard

Tools: Excel, Power Query, DAX, Pivot Tables

  • Automated a 4-year P&L dashboard tracking revenue, COGS, gross margin, and net profit KPIs
  • Reduced reporting prep time by 25% with dynamic slicers for region/product/time drill-down
  • Designed executive-ready waterfall charts and trend lines used in quarterly business reviews

🍕 Pizza Sales Analysis

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
  • Built Power BI dashboard for sales trends, category breakdowns, and hourly demand patterns

💼 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

Popular repositories Loading

  1. Devikalahari03 Devikalahari03 Public

    Config files for my GitHub profile.

    1

  2. 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

  3. Sales-and-Finance-Analytics-Report- Sales-and-Finance-Analytics-Report- Public

    1

  4. Credit-Card-Fraud-Detection Credit-Card-Fraud-Detection Public

    📝 Logistic regression fraud classifier on 284K+ transactions — 87% accuracy, 94% AUC-ROC

    Jupyter Notebook 1

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

    1

  6. 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