Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

My Experience

Certificates

Contact

Vatsal Panchal

Vatsal Panchal

Data Engineer & AI/ML Engineer

[email protected]
Resume

Hello, I am

Vatsal Panchal.

1

Python
Project

1

PowerBI
Project

About Me

Hey there! 👋
Welcome to My Portfolio!
I’m a hybrid data professional with hands-on experience across the entire data lifecycle, spanning Data Engineering, Data Analytics, and Machine Learning.

Tools and Technologies I have worked with: Python - SQL - DBT - Databricks - PySpark - Tableau - Power BI - Postman - Streamlit
My Functional Areas:
- Data Modelling & Visualization
- ML Model Training and Testing
- Research and Development
- Problem Solving

I’m driven by discipline, efficiency, and dedication. I dive deep into challenges, learn on the go, and keep things authentic. ✨ Trustworthy and collaborative

Thanks for stopping by 🙏
Let’s connect and build something awesome! 🚀

Key Skills

Research & Development

Problem Solving & Debugging

Documentation

Data Modelling & Visualization

My Projects

PostgreSQL Integration via MCP Server Using Claude Desktop Client
PostgreSQL Integration via MCP Server Using Claude Desktop Client

Domain/Function: Data Engineering / Systems Architecture

Talk to your Data - An Open-source LLM-based PDF Chat streamlit application
Talk to your Data - An Open-source LLM-based PDF Chat streamlit application

Domain/Function: LLM Chat App

Sales Performance Dashboard
Sales Performance Dashboard

Domain/Function: Sales Analytics / Performance Management

My Experience

Aptologics,  Ahmedabad
Associate Data Engineer (Full-Time) Nov 2024 - Present
- Developed custom data extractors by exploring and testing Salesforce and Google Ads APIs using Postman.
Proactively owned the Tableau monitoring tool, using APIs and automated Databricks jobs to detect refresh failures and trigger alerts, improving reliability.
- Led R&D to automate QA across Dev/Prod Tableau, achieving 75% accuracy in detecting mismatches and reducing manual checks.
Explored multiple data models to identify key features and engineered variables. Conducted EDA to uncover patterns. Developed predictive models using logistic regression and XGBoost with over 85% accuracy. Created an interactive dashboard with KPIs and visuals to support business decisions.

Skills: Python, SQL, Salesforce, Databricks, PySpark, Git, Postman, Tableau, RESTful APIs, DBT, Logistic Regression, XGBoost, Decision Tree

DataSlush,  Ahmedabad
Associate Data Scientist (Full-Time) Mar 2024 - Sep 2024

- Built a system to classify marketing form inputs using Large Language Models (LLMs) to understand customer intent and feedback.
- Wrote a Python script to process and categorize the data.
- Used AWS tools like S3 to store data, SQS to manage message queues, and Lambda functions to run the classification automatically.
- Packaged the code and its dependencies in Docker containers for easy and consistent deployment on cloud services.
- Actively participated in client calls, gaining direct exposure to stakeholder requirements.
- Provided regular updates to clients, ensuring transparency on progress, challenges, and key deliverables.

Skills: Python, AWS S3 SQS, BigQuery, Git, Docker, GROQ API 

DataSlush, Ahmedabad
Data Science Intern (Internship) Sep 2023 - Feb 2024
- Worked on a real-world AI project in the EdTech domain, contributing to the development of an AI-powered math tutor aimed at enhancing student learning-problem-solving experiences.
- Acquired domain knowledge and created custom datasets through web scraping and preprocessing to support model training and evaluation.
- Hands-on experience with LLMs, exploring their reasoning, limitations, and use cases.
- Tackled hallucinations and improved output accuracy through prompt tuning and parameter adjustments.
- Worked with various prompt engineering techniques to build and optimize large, few-shot prompts for LLM-powered hint generation.
- Collaborated closely with the team to handle ad-hoc requirements, perform rigorous QA testing, and deliver iterative improvements in a fast-paced agile environment.
- Emphasized continuous learning and adaptability, transitioning from intern to an associate-level role through consistent contribution, ownership, and teamwork. 
- Conducted research, implemented, and tested various scripts.
- Worked closely with clients to ensure clear communication and boost project success by 15%.

Skills: Python, Regex, Sympy, OpenAI, Gemini, Prompt Engineering

Awards & Certificate

img

SQL Beginner to Advanced For Data Professionals

img

Python: Beginner to Advanced For Data Professionals

img

Excel: Mother of Business Intelligence

img

Get Job Ready: Power BI Data Analytics for All Levels 3.0

JP Morgan Software Engineering Virtual Experience

JP Morgan Software Engineering Virtual Experience

TCS iON Soft Skills : Young Professional

TCS iON Soft Skills : Young Professional

Databricks Fundamentals Accreditation

Databricks Fundamentals Accreditation

Get started with Databricks for Data Engineering

Get started with Databricks for Data Engineering

Introduction to Model Context Protocol

Introduction to Model Context Protocol

Model Context Protocol: Advanced Topics

Model Context Protocol: Advanced Topics

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.