Email copied
Your email was sent.

Prabhu Subramanian

|

About

Hi  Hi, I'm Prabhu. I'm a Senior Data Analyst at Tesla on the Infrastructure Development team, where I build the reporting and automation behind Tesla's infrastructure projects, from capital spend to construction milestones.

I've spent over a decade across the whole data stack: software engineering at HP, machine learning and NLP at Squark AI, cloud data pipelines at PACCAR, and four years turning logistics data into decisions at Levi Strauss & Co. That range lets me take a problem from raw data to a pipeline, a model, or a dashboard people actually use.

I work mostly in Python, SQL, Power BI, Tableau and the Microsoft Power Platform. What I care about most is making data easy for non-technical teams to trust and act on, and I enjoy mentoring and teaching along the way.

Location San Francisco, U.S.A
Current Role Sr. Data Analyst — Tesla
Experience
Email prabhus165@gmail.com
Languages English, Hindi, Tamil, Malayalam

Professional Skills

Programming
Python SQL HTML CSS Java JavaScript
Databases
MySQL PostgreSQL Snowflake Redshift DynamoDB Teradata Oracle
Cloud
AWS GCP Azure Databricks
BI & Visualization
Tableau Power BI matplotlib seaborn Plotly
Version Control
Git GitHub Bitbucket SVN

Proficiency

Python9/10
JavaScript8/10
CSS7/10
SQL9/10
HTML8/10
C / C#5/10

Work Experience

May 2025 – Present Tesla

Sr. Data Analyst

  • Build and maintain the internal system Tesla Infrastructure Development uses to run its projects, on Power Apps and Dataverse, covering sites, capital planning, construction tracking and the full project lifecycle.
  • Automated project setup: names and IDs are generated from project details with duplicate checks, and one click turns a project into a new site record through Power Automate.
  • Wrote the date and status logic that keeps parent projects and their milestones in sync and flags projects that are in progress or out of date.
  • Built Power BI dashboards for capital spend, purchase orders and the infrastructure portfolio, and Tableau KPI dashboards for project delays and dead rent.
  • Use Python and pandas to clean, validate and backfill project data.
  • Partner with infrastructure operations, strategy, business planning, construction and IT teams.
Levi's April 2021 – May 2025 Levi Strauss & Co.

Sr. Data Analyst June 2024 – May 2025

  • Designed and implemented interactive dashboards providing real-time insights into key logistics metrics — inventory levels, shipping performance, demand forecasts, and delivery timelines.
  • Integrated multiple data sources including WMS, ERP, and transportation data into a centralized analytics platform.
  • Built self-serve reporting so analysts and business users could answer their own questions, cutting requests to technical teams and improving data literacy.
  • Implemented data-driven process improvements resulting in reduced lead times, enhanced forecasting accuracy, and streamlined logistics workflows.
  • Improved data accessibility by enhancing pipelines, standardizing reporting metrics, and optimizing visualization techniques.

Data Analyst April 2021 – June 2024

  • Subject Matter Expert for critical business reports used by over 500 people.
  • Fully automated those reports end to end, with daily, weekly, monthly and yearly logic and no manual steps.
  • Designed and ran proofs of concept in Python, Alteryx and ETL tools.
  • Utilized PySpark on Databricks to automate reporting solutions and visualize data on Power BI.
  • Developed an API bridging Alteryx and SharePoint, saving ~15 hours of manual data transfer per week.
  • Mentored peers and facilitated training sessions to enhance reporting capabilities.
January 2019 – December 2020 Squark AI

Graduate Programmer Analyst

  • Enhanced model accuracy by 70% through advanced NLP techniques — word2vec & BERT.
  • Developed production code integrating MinIO with AWS S3, reducing data access time by 50%.
  • Formalized subprocesses to execute the JVM H2O engine, increasing processing speed by 40%.
  • Developed multiprocessing and multithreading solutions to further enhance efficiency.
  • Implemented automation scripts using Python & CLI, reducing developer testing time by 90%.
  • Established testing logs and web interface through Grafana dashboard integration.
PACCAR January 2020 – June 2020 Peterbilt (PACCAR)

Data Engineer Intern

  • Optimized customer warranty data preprocessing by 50% using Python & SQL.
  • Enhanced NLP model accuracy with spelling dictionaries and manufacturing plant failure modes.
  • Administered data warehouse pipelines from Snowflake, Teradata, and Excel with Jenkins CI/CD.
  • Established a logging and notification pipeline for team communication using AWS services.
  • Deployed pipeline using Docker, Kubernetes (EKS), and AWS — SNS, SQS, SES, S3, EC2, Lambda.
Hewlett Packard
November 2015 – July 2018 Hewlett Packard

Software Engineer

  • Designed ERP dashboards for Supply Chain, Manufacturing, and Finance — increasing supply chain visibility by 20%, reducing manufacturing downtime by 15%, improving financial forecasting by 25%.
  • Achieved 68% improvement in application query optimization, reducing report generation time by 30%.
  • Improved Customer Self-Service by 30%, raising satisfaction ratings by 25%, reducing ticket resolution time by 20%.
  • Customized and deployed a Kanban process utilizing SQL functions and triggers.

Education

M.S. in Information Systems

Northeastern University

2018 – 2020

Data Management & Database Design, Data Architecture & BI, Big Data Architecture & Governance, Project Planning & Management

B.S. in Electronics & Telecommunication

University of Pune

2011 – 2015

Signal Processing, Communication Systems, Digital Signal Processing, Wireless Communication, Embedded Systems, Internet of Things (IoT)

Personal Projects

Recent Activities

Tesla Fremont Factory Visit

With Colleagues and Interns

Recent Award

Global MPIM "Innovation Champion" Award

LS&Co Community Day 2022

Community Outreach with Colleagues

Workshops at Northeastern University

AI Skunkworks Workshop

Recent Honor

Information Systems Teaching Assistant Award

Teaching Students

NEU Workshop

Graduate Student Ambassador

IS Representative at Northeastern University

Live Coding Activity

References

Tableau Public Dashboard

Contact Me

Downtown San Francisco, CA

View the code

Ask me a Question “Where do you work now?”
NOW PLAYING Not playing