initializing portfolio...
AVAILABLE FOR NEW OPPORTUNITIES

Hi, I'm Dhir Panchal

|

MS in Data Science student at Montclair State University with 3+ years of industry experience in data analytics, ETL pipelines, machine learning, and business intelligence. Passionate about building scalable data systems and AI-powered products.

Data Engineer
Data Scientist
AI Enthusiast
scroll
👨‍💻

Dhir Panchal

Data Scientist · Engineer

3+ Years
Experience
3.95
GPA
4+
Projects
0%
Time Saved
0%
Cost Reduced
About Me

Turning Data into Decisions

I'm a Data Science graduate student at Montclair State University (GPA: 3.95) with a deep passion for transforming raw data into actionable intelligence. My journey uniquely bridges automotive engineering fundamentals with cutting-edge data science.

With 3+ years of industry experience, I've built production-grade ETL pipelines, designed ML models at scale, and delivered interactive analytics dashboards that drive real business outcomes.

My current focus spans AI systems, ML infrastructure, and large-scale data platforms — where engineering rigor meets statistical insight.

Python & SQLETL Pipelines Machine LearningBigQuery & GCP NLP & LLMsBI Dashboards Apache SparkAWS
Work History

Experience Timeline

3+ years building data systems, pipelines, and analytics products across multiple industries.

Apex Technology Solutions

Data Engineer Intern

Jan 2026 – Present
  • Building robust data pipelines using Python and SQL for enterprise clients
  • Implementing data validation, deduplication, and anomaly detection workflows
  • Supporting ETL workflow orchestration and database query optimisation
  • Contributing to data quality frameworks and real-time monitoring dashboards
PythonSQLETLAirflow

S&P Global

Data Analyst

Dec 2023 – Dec 2024
  • Identified severe query bottlenecks: reporting pipelines across large-scale equity and fixed-income datasets were slow and unreliable, with ad-hoc queries routinely timing out during peak analytics windows
  • Tasked with re-engineering the SQL layer: to improve throughput, reliability, and scalability of the data warehouse for downstream BI consumption
  • Engineered complex SQL queries in BigQuery: using CTEs, window functions, subqueries, and advanced joins; introduced partitioned tables, incremental data loads, and indexing strategies; built Qlik Sense dashboards on top of optimised data models to deliver real-time KPI visibility to stakeholders
  • Improved query performance and data processing speed by 30%; reduced monthly reporting time from 10 hours to 2 hours, with Qlik Sense and Power BI dashboards enabling self-service analytics across business units
BigQueryQlik SensePower BISQL

Wiseworks

Data Analyst

Oct 2022 – Nov 2023
  • Built end-to-end data pipelines for UK-based clients across multiple verticals
  • Reduced infrastructure costs by 60% via architecture optimisation
  • Developed NLP-powered sentiment analysis pipelines for brand monitoring
  • Created multi-source dashboards integrating GA4, Shopify, LinkedIn, and YouTube data
NLPGA4ShopifyBigQuery
Portfolio

Featured Projects

Data engineering and ML projects spanning NLP, search systems, and analytics dashboards.

🧠
NLP · Data Engineering

Sentiment Analysis Data Pipeline

Automated ETL pipeline extracting patient reviews from Google Maps, performing NLP sentiment analysis via AWS Comprehend, and loading results into BigQuery with a healthcare insights dashboard.

PythonAWS ComprehendBigQueryRDSLooker Studio
🔍
Machine Learning · Search

Multi-Stage E-commerce Search Engine

Two-stage search ranking system using BM25 retrieval and a Learning-to-Rank model trained on the Amazon ESCI dataset with XGBoost for precision product discovery.

PythonXGBoostBM25FastAPIScikit-learn
📊
Analytics · Data Engineering

NHS Cancer Treatment Dashboard

ETL pipeline and analytics dashboard analysing NHS cancer treatment performance against national standards, enabling administrators to identify gaps and improve patient outcomes.

SQLBigQueryLooker StudioPython
🤖
Generative AI · Analytics

Gen AI Conversational Analytics

Natural language interface converting business questions into SQL queries using LangChain and OpenAI API, providing automated insights directly from BigQuery data warehouses.

PythonLangChainOpenAI APIBigQuery
System Design

Data Engineering Architecture

A visual representation of a modern data pipeline — from raw sources to actionable dashboards.

🗃️
Data Sources
APIs · DBs · Files
⚙️
ETL / ELT
Python · Spark · DBT
🏗️
Data Warehouse
BigQuery · Snowflake
🧪
ML Models
Scikit · TensorFlow
🔌
API Layer
FastAPI · REST
📈
Dashboard
Looker · Power BI
Google Cloud PlatformAWS Services Apache SparkApache Airflow DBTReal-time Streaming
Technical Stack

Skills & Technologies

A comprehensive toolkit spanning data engineering, ML, cloud platforms, and BI.

💻 Programming Languages

Python95%
SQL92%
JavaScript70%
Java / R / C65%

🤖 Machine Learning & AI

Machine Learning88%
NLP & LLMs82%
Predictive Modeling85%
Data Mining80%

📚 Libraries & Frameworks

PandasNumPyScikit-learn TensorFlowPyTorchMatplotlib PlotlyLangChainFastAPIXGBoost

🔧 Data Engineering

ETL Pipelines92%
BigQuery / Snowflake88%
Apache Spark75%
DBT72%

☁️ Cloud Platforms

Google Cloud (GCP)85%
AWS78%

📊 BI & Visualisation

Looker StudioPower BITableau QuickSightGrafanaData Studio
Academic Background

Education & Credentials

Combining data science expertise with an engineering foundation.

🎓

Montclair State University

Master of Science – Data Science

Advanced coursework in machine learning, statistical modelling, big data systems, and AI — focused on applied data engineering and intelligent systems.

GPA: 3.95 Jan 2025 – Dec 2026 New Jersey, USA
🔧

LJ Institute of Engineering & Technology

B.E. – Automobile Engineering

Strong engineering fundamentals in systems thinking, mechanics, and problem-solving — providing a unique cross-disciplinary perspective in data systems design.

2017 – 2021 Gujarat, India
Get In Touch

Let's Connect

Whether you have a project idea, job opportunity, or just want to talk data — I'd love to hear from you.

Email

dhirpanchal2730@gmail.com

Location

New Jersey, USA

Availability

Open to opportunities

Please enter your name
Please enter a valid email
Please write a message
Message sent! I'll get back to you soon.