Your message was sent! I'll be in touch shortly.

Prabhu Subramanian

Sr. Data Analyst|Data Engineer

About

Hi  Hello! I'm Prabhu Subramanian — a passionate Data Analyst and Engineer. I analyze data meticulously to bring out its various potentials in building predictive models and producing efficient ways to explain data through EDA and visualizations. Expert in Python (PEP8), SQL, and Tableau.

I offer excellent analytical and communication skills. My drive is to learn, teach, and enhance my skills as an avid Data Analyst, Cloud Practitioner, and Machine Learning enthusiast with parallel knowledge of Data Engineering.

Location San Francisco, U.S.A
Current Role Sr. Data Analyst — Tesla
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

  • COMING SOON…
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.
  • Empowered analysts and business users to extract meaningful insights, reducing dependency on 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

  • Provided guidance as Subject Matter Expert (SME) for critical reports, aligning with business objectives for over 500 users.
  • Automated reports ensuring 100% end-to-end automation with dynamic daily/weekly/monthly/yearly reporting logic.
  • Innovatively designed and executed multiple POCs using Python, Alteryx, and ETL techniques.
  • 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.
Squark AI 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

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

References

Tableau Public Dashboard

Contact Me

Let's Connect

Start with "PortfolioConnect:" to help filter bots.

Find Me

San Francisco, U.S.A
prabhus165@gmail.com
Ask me a Question “Where do you work now?”
NOW PLAYING Not playing