Devansh Bafna

Data Analytics · Finance · Business Intelligence

Hi, I'm Devansh

Econometrics graduate who turns messy data into clear, actionable decisions. Five internships across data analysis, financial research, and sales analytics — comfortable as the bridge between technical and business teams.

About Me

I'm an Econometrics & Quantitative Economics graduate from Loyola Marymount University who likes understanding the “why” behind the data. I dig into the operational story and turn technical findings into clear, actionable decisions for non-technical stakeholders.

With five internships spanning data analysis, financial research, sales/marketing analytics, and operations, I've built real tools and data pipelines with Python, SQL, and DuckDB — and I conduct independent equity research covering 40+ companies across 8 sectors.

Education

B.A. Econometrics & Quantitative Economics

Loyola Marymount University · May 2026

Location

Los Angeles, CA — open to relocation

LA, San Diego, Bay Area, Central Valley, or remote

Work Experience

Five internships across data analysis, financial research, sales analytics, and operations.

Sales & Marketing Analyst Intern

Devon Foods Ltd · Kochi, India

May 2025 – Aug 2025

  • Analyzed 500+ customer survey responses in Excel to identify demand patterns, informing pricing and launch timing for 2 new product launches.
  • Prepared performance reports and presented data-driven recommendations to senior leadership across cross-functional teams.

Sales Operations Intern

Zappyhire · Remote

May 2024 – Jun 2024

  • Built and managed a CRM database of 1,200+ leads across 4 markets with deduplicated, pipeline-stage tracking for the sales team.
  • Researched 30+ target accounts across 5 industry segments to focus outreach; supported closing 3 new enterprise clients.

Production & R&D Intern

Devon Foods Ltd · Kochi, India

May 2023 – Aug 2023

  • Analyzed production costs across 3 product lines in Excel; identified raw-material waste, driving a 12% drop in per-unit production cost.
  • Partnered with 8 supervisors across production, quality, and R&D to translate findings into operational changes.

Research Intern

Hedge Finance · India

May 2022 – Jun 2022

  • Pulled and analyzed financial data on 10+ companies across 3 sectors — revenue, margins, cash flow, and competitive positioning.
  • Delivered 6 research summaries and 2 presentations to senior management with clear takeaways.

Data Analyst Intern

Mindcurv · India

May 2021 – Jul 2021

  • Cleaned and validated datasets of 50,000+ records in Excel and Python, automating recurring manual cleaning steps to cut reporting turnaround.
  • Built 4 Tableau dashboards tracking 15+ KPIs for client projects across digital commerce and business operations.

Skills & Expertise

SQL & Databases

Joins & SubqueriesGROUP BY / HAVING / CASEDuckDBDBeaverDatabase DesignStar Schema

Excel & Modeling

PivotTablesVLOOKUP / INDEX-MATCHFinancial ModelsDashboardsData ValidationForecasting

Python & Data

PandasNumPyETL ScriptingData CleaningAutomationTransformation

BI & Visualization

TableauMulti-KPI DashboardsData StorytellingReporting

Tools & Platforms

CRM SystemsGitREST APIsAI-Assisted DevelopmentTally ERP

Domain & Communication

Financial MarketsEquity ResearchStakeholder CommunicationCross-Functional CollaborationData-Driven Recommendations

Certifications

Intro to SQL

Kaggle

Intermediate & Advanced SQL

DataCamp (in progress)

Excel Fundamentals

Corporate Finance Institute

Entrepreneurship in Emerging Economies

Harvard (online)

Let's Connect

I'm actively seeking Data Analyst, Business Analyst, Financial Analyst, and Operations Analyst roles. I'd love to hear from you.

Los Angeles, CA — open to relocation & remote