`

Krishal Karna — AI & Data Science Engineer

Portfolio of Krishal Karna (Krishal), AI & Data Science Engineer.

View Projects Download Resume
Krishal Karna (Krishal) — AI & Data Science Engineer

Projects by Krishal Karna

Customer segmentation analytics dashboard for ML clustering

Customer Segmentation using RFM & KMeans

Segmented 10,000+ customers using RFM analysis and KMeans clustering to identify key customer groups and improve targeted marketing decisions. Tech: Python, Pandas, Scikit-learn, Power BI

View Project Details
Retail SQL analytics workflow with large-scale data

Production-Grade Retail SQL Analytics

Built and analyzed a retail analytics database with 1M+ records using advanced SQL, CTEs, window functions, joins, and statistical testing for business insights. Tech: SQL, Analytics, Statistics

View Project Details
Multilingual RAG assistant with vector search and LLMs

Multilingual RAG AI Assistant

Implemented a Retrieval-Augmented Generation assistant with multilingual support using vector search and LLM-based responses. Tech: RAG, LLM, NLP, Vector Database

View Project Details
Power BI data visualization dashboard for analytics

Tata Data Visualization Simulation

Created Power BI dashboards and business insight reports as part of a Tata virtual job simulation project. Tech: Power BI, Data Visualization

View Project Details

Impact Highlights

Impact highlight for customer segmentation with ML clustering

Segmented 10,000+ Customers

Applied ML clustering to identify actionable customer groups for targeted strategies.

Impact highlight for retail analytics using advanced SQL

Analyzed 1M+ Retail Records

Delivered advanced SQL insights across large-scale transactional datasets.

Impact highlight for multilingual RAG assistant

Built Multilingual RAG Assistant

Implemented vector search and LLM responses for multilingual information retrieval.

Impact highlight for SQL optimization and faster reporting

Reduced Reporting Time by 40%

Optimized SQL workflows to accelerate reporting and decision-making.

Impact highlight for executive Power BI dashboards

Delivered Executive Power BI Dashboards

Created KPI-driven dashboards for leadership visibility and performance tracking.

Technical Writing by Krishal

Technical writing on SQL and MySQL analytics

Learn MySQL — Complete Practical Series

A step-by-step MySQL learning and analytics blog series published on Hashnode.

Read SQL Blog Series

Skills & Expertise

Python

Data Science & Machine Learning

SQL & Advanced Analytics

Power BI / Data Visualization

Statistics & A/B Testing

RAG & LLM Applications

NLP & Vector Databases

fastapi

Model Deployment & ML Pipelines

Tools & Stack

Python

SQL

Pandas

Scikit-learn

Power BI

FastAPI

Vector Databases

LLM / RAG Frameworks

Git & GitHub

Jupyter Notebook

Data Experience

Retail transaction datasets for data analytics

Retail Transaction Datasets

Worked with 1M+ row retail datasets for revenue, cohort, and basket insights.

Customer segmentation datasets for ML modeling

Customer Segmentation Datasets

Built segmentation-ready feature sets using RFM and behavioral signals.

E-commerce order data for analytics and forecasting

E-commerce Order Data

Prepared order-level datasets for analytics, forecasting, and cohort analysis.

Knowledge base documents for RAG systems

Knowledge Base Documents for RAG

Curated and indexed documents to power multilingual retrieval pipelines.

Certifications

Advanced SQL certificate for analytics

Advanced SQL

Validated advanced SQL skills for analytics and database querying with real-world scenarios.

View Certificate
Python for data science and ML certificate

Python for Data Science, AI & Development

Completed hands-on training in Python for data science, AI, and application development.

View Certificate
Data fundamentals certificate for analytics

Data Fundamentals

Earned the IBM SkillsBuild Data Fundamentals credential for core data concepts and practices.

View Certificate
Generative AI certificate for applied AI skills

Generative AI

This certification showcases proficiency in modern AI tools and frameworks, emphasizing innovative applications using generative AI technologies.

View Certificate
IBM Applied AI certificate for machine learning

IBM Applied AI Certificate

Earned an industry-recognized credential by mastering essential AI concepts and tools, including machine learning and natural language processing.

View Certificate
Operating systems certificate supporting data engineering foundations

Certified OS certificate

Demonstrated expertise in operating system concepts, including process management, memory allocation, and file systems.

View Certificate
Graph theory certificate relevant to ML algorithms

Graph Theory Mastery

Gained expertise in graph algorithms and their applications through advanced projects and practical learning.

View Certificate
Microsoft AI fundamentals certificate

Microsoft AI Fundamentals

Acquired comprehensive skills in AI fundamentals, aligning with Microsoft's industry standards.

View Certificate
IBM database and transaction certificate for data systems

IBM DataBase and Transaction Practitioner

Demonstrated advanced proficiency in data science concepts, securing a prestigious IBM certificate.

View Certificate

Contact

Or reach me directly at: [email protected]