Data Analyst - ETL Automation & SQL Optimization Expert

VEDANT BRAHMBHATT

San Jose, CA 214-***-**** ******************@*****.*** LinkedIn GitHub Portfolio SUMMARY

Data Analyst with 3+ years of experience driving business impact through ETL automation, SQL optimization, and interactive dashboards. Experienced in building scalable reporting pipelines, optimizing PostgreSQL and DynamoDB workflows, and designing domain-specific use cases, including GenAI-driven chatbot datasets, to improve data-driven decisions. Proven track record of increasing user engagement by 37% and saving 6+ hours weekly through automated reporting solutions. SKILLS

Analytics & Visualization: Power BI (DAX), Tableau, Excel (Pivot Tables, Power Query, Ad-hoc Analysis), Plotly, Streamlit, Dash, Looker Studio Programming & Data Processing: Python (Pandas, NumPy, SQLAlchemy, Scikit-learn, PySpark, NiceGUI), SQL (MySQL, PostgreSQL, ClickHouse), R Machine Learning & Statistics: Regression, Classification, Random Forest, XGBoost, Feature Engineering, Hypothesis Testing, A/B Testing Cloud & Tools: AWS (S3, EC2, DynamoDB), Render, SAP (Data Extraction), Docker, Git, Jira, Twilio API EXPERIENCE

Data Analyst

Saayam For All, San Jose, CA Oct 2025 – Present

● Optimize PostgreSQL and DynamoDB queries for internal dashboards, cutting dashboard query latency by 25% (8s 6s) across 100+ Help Request scenarios.

● Standardize AWS S3 data schemas and define microservice data contracts to enable real-time ML responses and accelerate MVP delivery.

● Curated and validated structured datasets across 9 elderly support categories, designing domain specific use cases and edge scenarios to support GenAI chatbot deployment and improve response accuracy and reliability.

● Packaged Flask dashboards and ML microservices in Docker for reproducible, scalable, and consistent deployment of real-time analytics. Analytics Engineer

Lariox Technologies, Surat, India Jan 2021 – July 2023

● Led marketing A/B testing by integrating social media and job board data into Power BI; standardized CTR, bounce rate, and conversion metrics using Python and DAX, driving a 37% increase in user engagement within 3 months.

● Engineered an automated CRM dashboard in Power BI by consolidating 2+ years of fragmented sales data from 15+ Excel sources into a normalized MySQL schema; built Python ETL pipelines using SQLAlchemy and Docker, saving 6+ hours of manual reporting effort weekly.

● Created dashboards tracking Twilio KPIs (latency, response time, call quality) to help engineering resolve 12+ system bottlenecks.

● Collaborated on a real time monitoring dashboard for PLC-based weighing systems; implemented SQL-based data validation to remove duplicate records and improve sensor to dashboard accuracy. PATENT

Recipe Recommendation System Patent Application No. 202********* (Published)

● Collaborated on an ingredient recognition pipeline using YOLOv5 and KNN trained on 50,000+ images, achieving 73% classification accuracy.

● Built a Flutter-Flask API integration to deliver real-time recipe recommendations based on detected ingredients.

● Improved ingredient detection performance through data augmentation and model optimization techniques. EDUCATION

University of Texas at Arlington

Master of Science in Information Systems Aug 2023 – Aug 2025 Relevant Coursework: Data Mining, Web Analytics, Advanced Analytics Methods, Cloud Computing Gujarat Technological University

Bachelor of Engineering in Computer Engineering Aug 2019 – Jun 2023 Relevant Coursework: Machine Learning, Data Structures, Database Management Systems PROJECTS

Real-Time Stock Market Dashboard

● Developed a Streamlit dashboard with a Python ETL pipeline pulling live data from Yahoo Finance API for stock analysis.

● Designed candlestick and line chart visualizations with fuzzy ticker search and real-time KPI tracking.

● Applied a Random Forest model to generate buy/sell signals based on historical price trends and financial indicators. Football Player Performance Analytics

● Conducted exploratory data analysis on Indian Super League player stats to identify trends in goals, assists, and fouls.

● Built an interactive Dash dashboard with Plotly visualizations and a modular ETL pipeline into ClickHouse for fast querying.

● Enabled real-time OLAP queries for team and player comparisons across multiple seasons. TFL Tube Line Monitoring System

● Built an ETL pipeline to collect, transform, and load London Underground disruption data into ClickHouse.

● Created Matplotlib visualizations to analyze service interruption patterns and predict delay trends.

● Implemented error-handling and alert notifications to ensure pipeline reliability. CERTIFICATIONS

● Power BI Certification – Great Learning – Apr 2025

● UI/UX Design Certification – Udemy – Nov 2022

Contact this candidate