Transforming complex data into actionable insights through scalable pipelines, interactive dashboards, and intelligent automation
I'm a Data Analyst with 3+ years of experience delivering high-impact data solutions in fast-paced EdTech environments. I specialize in designing end-to-end ETL pipelines, building interactive dashboards, and creating automation systems that drive business decisions.
- 📊 ETL Pipeline Architecture: Built 20+ production pipelines processing millions of rows daily
- 📈 Dashboard Engineering: Created 30+ Metabase dashboards with 80% faster load times
- 🤖 Data Automation: Eliminated 20+ hours of manual work weekly through intelligent automation
- 🗄️ Database Optimization: Reduced pipeline count by 50% through analytics-ready schema redesign
📦 Data Infrastructure → Supporting 25,000+ active students
⚡ Performance Optimization → 80% reduction in dashboard query time
🔄 Pipeline Efficiency → 50% reduction in ETL pipeline count (40+ → 20)
⏱️ Automation Savings → 20 hours of manual work eliminated weekly
💾 Data Processing → Millions of rows processed daily
Data Analyst | Oct 2024 – Present | Bangalore
Building and managing data infrastructure that powers decision-making for 25,000+ students:
- 🏗️ Infrastructure Management: End-to-end data infrastructure across 50+ courses
- 📊 Dashboard Engineering: 30+ Metabase dashboards with 80% improved load times
- 🤖 Automation Systems: Google Docs API/Gmail API automation saving 20 hours weekly
- 🗄️ Schema Optimization: Redesigned database schema reducing ETL pipelines by 50%
- 🔄 Production Pipelines: 20 ETL pipelines processing millions of rows daily (MySQL/MongoDB → PostgreSQL)
🏆 Production ETL Pipeline Infrastructure
Tech Stack: Python • MySQL • MongoDB • PostgreSQL
A comprehensive data pipeline infrastructure that transformed data operations at scale:
- ✅ Developed 20 production ETL pipelines processing millions of rows daily
- ✅ Migrated data from MySQL/MongoDB to PostgreSQL for analytics
- ✅ Reduced dashboard query time by 80% through optimized data modeling
- ✅ Cut pipeline count by 50% (40+ → 20) while maintaining analytical depth
- ✅ Automated data validation and error handling for production reliability
Impact: Powers analytics for 25,000+ students with near-real-time data availability
📊 Student Lifecycle Dashboard
Tech Stack: Python • Metabase • PostgreSQL
Comprehensive dashboard system providing 360° visibility into student performance:
- ✅ Engineered 30+ interactive Metabase dashboards using Python
- ✅ Improved dashboard load times by 80% through query optimization
- ✅ Provides 100% visibility into student lifecycle for 40+ business users
- ✅ Real-time tracking of enrollment, engagement, and performance metrics
- ✅ Custom KPI calculations and automated reporting workflows
Impact: Enabled data-driven decision making across all departments
💰 Business Finance Analytics Tool
Tech Stack: Python • Google Sheets • API Integration
Automated financial tracking system for business intelligence:
- ✅ Built Python automation with session-based authentication
- ✅ Extracted data from myBillBook platform automatically
- ✅ Monitored INR 1M+ inventory across 400+ products
- ✅ Tracked pricing trends, sales performance, and P&L metrics
- ✅ Real-time dashboards updated via Google Sheets API
Impact: Eliminated manual data entry and provided real-time financial insights
🤖 WhatsApp Messaging Automation
Tech Stack: Python • Google Sheets • WATI API
Scalable communication automation system for student engagement:
- ✅ Created automated WhatsApp messaging system using WATI API
- ✅ Integrated with Google Sheets and Forms for data management
- ✅ Enabled instant and one-click message delivery at scale
- ✅ Supported targeted campaigns for student engagement
- ✅ Reduced manual communication time by 90%
Impact: Streamlined communication with thousands of students
🍔 Personal Food Ordering Analysis
Tech Stack: Python • Selenium • Excel • Google Sheets
Personal analytics project demonstrating web scraping and visualization skills:
- ✅ Deployed web scraping solution using Selenium
- ✅ Extracted 200+ personal orders from Swiggy platform
- ✅ Constructed interactive dashboard visualizing ordering patterns
- ✅ Analyzed spending trends and food preferences
- ✅ Built automated data collection pipeline
Impact: Showcased end-to-end data analysis and automation capabilities
|
|
|
🎓 Masai School - Data Analyst Bootcamp Apr 2024 – Sep 2024
🎓 CVR College of Engineering - B.Tech in Electronics & Communication Engineering 2018 – 2022 | Hyderabad
|
|
Most data analysts stop at insights. I go further:
| 🔄 End-to-End Ownership | 📊 Production-First Mindset | ⚡ Performance Obsessed |
|---|---|---|
| From raw data extraction to dashboard deployment | Code that runs in production, not just notebooks | 80% faster queries, 50% fewer pipelines |
Problem → Understand the business need, not just the data request
Design → Build scalable solutions that handle edge cases
Deploy → Ship production-ready code with error handling
Optimize → Continuously improve performance and efficiency
Bottom line: I build data systems that teams depend on, not just one-off analyses.
I'm always interested in discussing:
- 💡 Data engineering architecture & best practices
- 🚀 ETL pipeline optimization strategies
- 📊 Dashboard design & BI tool selection
- 🤖 Data automation opportunities
- 💼 Collaboration on data-driven projects
"Data is the new oil, but insights are the refined fuel that drives decisions."