Hello, I'm
Abhinav Varma Konderu
Data Analyst · M.S. Business Analytics @ CSUN
About Me
I'm a Business Analytics graduate student (M.S., CSUN) and data analyst who turns messy operational data into forecasts, dashboards, and decisions. Over two years at Indo Swiss Remedies I built SQL, Power BI, and Python workflows that cut stockouts, automated reporting, and gave leaders visibility across regions and product lines.
I've also co-founded a D2C brand, so I read numbers with a P&L in mind — acquisition, retention, margin, and what actually moves revenue.
SQL / MySQL / PostgreSQL / T-SQL / Repeat
Data Analyst Intern → Data Analyst
Indo Swiss Remedies Pvt Ltd
- Promoted from intern to full-time Data Analyst after strong performance in forecasting, reporting automation, and operational analytics.
- Built forecasting models with supply chain & operations that cut stockouts 18% and saved $20,000 in warehousing costs.
- Analyzed sales across 60+ pharmaceutical product lines in SQL, improving forecasting accuracy 12% and flagging underperforming segments.
- Designed executive Power BI KPI dashboards with drill-through, replacing manual spreadsheets across 10+ regions and saving 15+ hours monthly.
- Automated Python validation across 20+ recurring reports, cutting reporting errors 15% and freeing 6+ analyst hours weekly.
- Standardized reporting data across 60+ product lines, reducing downstream errors 22%.
Co-Founder — D2C Herbal Tea Brand
Butterfly Pea Flower Herbal Tea
- Scaled the brand to $70K revenue with 32% quarter-over-quarter growth via acquisition, retention, and sales analysis.
- Built Power BI dashboards on Shopify sales + customer data to track KPIs, revenue, and inventory for planning and investor decks.
- Closed repeat-purchase gaps with automated WhatsApp engagement, lifting repeat sales 40% while cutting COD/RTO losses.
- Guided inventory, marketing spend, and retention strategy from product, channel, and cohort trends.
Skills & Expertise
Selected Projects
Creator Economy & Algorithmic Performance Analytics
Regression analysis of 2,467 promotional posts across 800 influencers, quantifying how creator authority and early engagement drive amplification. Engineered normalized efficiency KPIs (CTR, clicks/1K reach, saves/1K reach) to expose a scale-efficiency tradeoff and guide creator selection.
Healthcare Cost & Pricing Intelligence
PostgreSQL pipeline standardizing 200+ hospital datasets into a 24-column model spanning 100K+ payer-procedure combinations, improving data quality 15%. Power BI dashboards surface insurer-level price variation for decision support.
E-Commerce Revenue Forecasting & Demand Analytics
Analyzed 100K+ orders and $15.4M in revenue to surface seasonality, demand patterns, and revenue concentration. Built a Power BI dashboard and forecasting model supporting inventory and revenue planning.
Retail Data Analytics (Python + SQL)
End-to-end retail analytics integrating Python and SQL across sales, inventory, and performance to surface operational insight.
ICU Mortality Analysis (Sepsis-ARDS)
SQL + Python cohort analysis of Sepsis-ARDS ICU patients — cohort building, cleaning, EDA, and outcome insight into mortality drivers.
Supply Chain Analytics — FMCG (AtliQ Mart)
Power BI supply-chain analytics for an FMCG distributor — tracking service levels, on-time/in-full delivery, and demand reliability.
Education
M.S. Business Analytics
California State University, Northridge
B.Tech. Computer Science
Anurag University
Certifications
Azure Fundamentals (AZ-900)
Power Platform Fundamentals (PL-900)
Google Data Analytics
Deloitte Data Analytics
Python & Data Science
Get In Touch
Open to data analyst and business analytics roles. Have a role, a question, or a dataset worth digging into? Let's talk.