Open to Work — Hyderabad

Pandala
Shiva

I turn raw data into decisions & ideas into automation.
Data Analyst · AI/ML Engineer · GenAI Developer · AI Automation
Building intelligent systems that actually matter.

12+
Projects
3
Internships
12+
Certifications
4+
Years Learning
Available for Work
🎯 Top 40 Intern — AICTE Shell
☁️ Google Cloud Certified
# shiva.py   class ShivaPandala:   name = "Pandala Shiva"   location = "Hyderabad"   skills = [    "Python","SQL","AI & ML", "Power BI",    "GenAI", "n8n", "Make.com",    "GCP", "IBM Cloud", "MCP"   ]   status = "open_to_work"

Who I Am

I'm a B.Tech graduate (2026) in Computer Science Engineering from MRCET Hyderabad, with hands-on experience in internships, freelancing, and building real-world AI & automation systems.

From building a GenAI-powered financial literacy chatbot using IBM Watsonx to automating full email outreach campaigns with Make.com and generating AI videos with n8n — I don't just learn tools, I build systems that work.

I've trained at Masai School, interned with Google Cloud, IBM, and AICTE-Shell, ranked in the top 40 interns nationally, and built real client websites for local businesses. Beyond tech, I actively analyze financial markets using both technical and fundamental analysis.

// currently leveling up
LangChain Advanced SQL Tableau MCP Data Engineering AI Agents
// data & analytics
PythonMySQLPandasNumPyPower BIAdvanced ExcelMatplotlibSeaborn
// ai & cloud
IBM Watsonx.aiVertex AIBigQueryGCPAutoAIRAGLangChainStreamlit
// automation & tools
n8nMake.comApifyElevenLabsNetlifyAI Automation
// statistics & ml
EDAHypothesis TestingRandom ForestRegressionCorrelation Analysis

Things I've Built

01
SBA Business Loan Approval Predictor
End-to-end SBA loan analysis and prediction app that combines analytics, machine learning, and an AI explanation layer for approving or denying business loans.
PythonStreamlitScikit-learnXGBoostGroq
02
AI Doc Analyzer
Streamlit-based document intelligence app for indexing, searching, and querying large PDF and text collections with embeddings and vector retrieval.
PythonStreamlitEmbeddingsVector SearchRAG
03
COVID-19 India Trend Analysis Dashboard
Analyzed 5,000+ records across Indian states. Built an interactive Power BI dashboard tracking vaccination rates, recovery patterns, and state-wise COVID trends.
PythonMySQLPower BIExcel
04
Digital Financial Literacy AI Agent
GenAI chatbot using IBM Watsonx.ai and RAG architecture that handles 10+ financial query categories such as UPI, frauds, loans, and investment guidance.
IBM Watsonx.aiRAGAgentic AIGraniteNLP
05
EV Adoption Forecasting using ML & Streamlit
Predicted EV adoption trends across Washington counties using Random Forest Regressor and built an interactive Streamlit app for infrastructure planning insights.
PythonScikit-learnStreamlitRandom ForestPandas
06
AI Study Planner
GenAI web application that generates personalized day-by-day study plans based on learning goals, skill levels, and custom study styles.
Groq APIStreamlitPythonPrompt Engineering
07
AI Code Assistant & Explainer
AI-powered coding assistant that explains code, detects bugs, and suggests optimizations across multiple programming languages.
Groq APIStreamlitPythonLlama-3
08
RAG with LangChain & IBM Granite
Full RAG pipeline using LangChain, IBM Granite models, and Milvus vector DB for semantic document retrieval and Q&A.
LangChainIBM GraniteMilvusRAGPython
09
Gemini PDF Chatbot
Streamlit-based chatbot powered by Google Gemini 2.0 Flash that answers questions from uploaded documents and exports the chat as a PDF.
Gemini APIStreamlitPythonFPDF
10
Math Mentor — Local RAG Assistant
Local RAG assistant using Streamlit, LangChain, FAISS, and Gemma via Ollama for querying math syllabus PDFs offline.
LangChainFAISSOllamaGemmaStreamlit
11
StockMentor AI Assistant
AI assistant for stock market beginners built on Meta LLaMA 3.3 70B, covering technical and fundamental analysis conversationally.
LLaMA 3.3 70BHugging FacePrompt Engineering

Workflows I've Automated

⚙️
Make.com · No-Code
Automated Client Email Outreach Campaign
Full end-to-end email outreach pipeline — reads leads from Google Sheets, filters invalid/already-contacted entries, downloads attachments from Drive, sends personalized HTML emails, and auto-marks rows as sent. Zero duplicates. Zero manual effort.
Google Sheets → Filter Invalid Leads → Google Drive Attachments → Personalized Gmail → Mark Row Sent ✅
Make.comGoogle SheetsGmailGoogle DriveHTTP Module
🤖
n8n · AI Automation
AI Video Generation & YouTube Upload System
Fully automated faceless content pipeline — generates viral video ideas using AI, converts them into cinematic prompts, generates videos, tracks everything in Google Sheets, and uploads directly to YouTube on a schedule. 90% reduction in manual effort.
Schedule Trigger → AI Idea Generator → Google Sheets → Prompt Generator → Video Gen → YouTube Upload ✅
n8nGemini/OpenAIYouTube APIGoogle SheetsRunwayML

Real Client Delivery

✅ Live Client Project
Moonlight Cafe & Arena
Built a complete responsive website for a real local business — a Coffee & Pizza Corner combined with Box Cricket and Gaming Arena in Sadasivpet. Delivered free of cost for a friend's business. Handled everything: design, development, deployment, Google Maps Business Profile setup, analytics, and SEO basics.
ReactTypeScriptViteTailwind CSSNetlifyGA4AI-Assisted
🌙☕🏏

Where I've Worked

Jul 2025 – Aug 2025
AICTE-Edunet-IBM SkillsBuild Internship
AI & Cloud Technologies
Developed a Financial Literacy AI Agent using IBM Watsonx.ai, Agentic AI, and cloud NLP tools. Delivered a fully functional agent capable of handling 10+ financial query categories using RAG architecture.
IBM Cloud · Watsonx.ai · RAG · AutoAI
Jul 2025 – Aug 2025
AICTE-Shell-Edunet Green Skills Internship
Sustainability & ML
Built an EV Adoption Forecasting model using Python and ML techniques. Ranked among the top 40 interns nationally out of hundreds of applicants across India.
🏆 Top 40 Nationally · Python · ML · Forecasting
May 2025 – Jul 2025
Google Cloud Summer Internship
Generative AI — L4G Program
Completed 45 hours of training earning 24+ skill badges across beginner to advanced GenAI tracks on Google Cloud Skills Boost. Explored Vertex AI, foundation models, BigQuery, and ML deployment workflows.
Vertex AI · BigQuery · Foundation Models · 24+ Badges
Feb 2023 – Sep 2023
Masai School
Data Analytics Training — 7 Months
Intensive data analytics training covering data preprocessing, visualization, and analysis. Worked on real-world projects using Python, Pandas, and Power BI. Built strong foundations in data-driven decision-making.
Python · MySQL · Power BI · Advanced Excel · 7 Months

What I've Earned

🗄️
SQL (Advanced)
HackerRank
View Certificate ↗
💻
Python
HackerRank
View Certificate ↗
🧩
Problem Solving
HackerRank
View Certificate ↗
🔗
Fundamentals of MCP
Hugging Face
View Certificate ↗
🤖
Getting Started with Artificial Intelligence
IBM SkillsBuild
View Certificate ↗
🌐
Journey to Cloud
IBM SkillsBuild
View Certificate ↗
🎯
Prompt Design in Vertex AI
Google Cloud Skills Boost
View Certificate ↗
🔍
Inspect Rich Documents with Gemini Multimodal RAG
Google Cloud Skills Boost
View Certificate ↗
☁️
Develop GenAI Apps with Gemini & Streamlit
Google Cloud Skills Boost
View Certificate ↗
🛡️
Cybersecurity Fundamentals
IBM
View Certificate ↗
🌱
Generative AI Literacy
NASSCOM FutureSkills
View Certificate ↗
🔌
CCNA: Introduction to Networks
Cisco Networking Academy
View Certificate ↗
💰
Financial Literacy Course for Bharat
SEBI / Fintech Program
📊
Digital Application Fundamentals (STEM)
NASSCOM
View all verified badges — Google Developer Profile with all badges earned from Google Cloud Skills Boost .
Google Developer Profile ↗
View all verified badges — Credly Profile with all IBM, Google Cloud & Cisco badges in one place.
View Credly Profile ↗

SaaS Ideas

01
Fithub — Multi-Gym Management SaaS
A multi-gym management SaaS built for gym owners to manage setup, members, plans, payments, attendance, renewals, and analytics from one secure workspace.
Next.jsTypeScriptSupabasePostgreSQLVercel

Let's Connect

Open to Data Analyst, AI/ML, GenAI, Data Engineering & AI Automation roles. Let's build something meaningful together.