About Skills Projects Experience Education Contact
KK
Bhubaneswar, India · Open to relocate

Kavyanjali Karan

Business Intelligence Analyst — SQL · Python · Tableau · AWS

I turn raw data into decisions stakeholders can act on without me in the room.

Six projects. All deployed live.

Scroll
01 / About

Still finishing the degree. Already shipping the work.

I'm a final-year Computer Science student in Bhubaneswar who treats projects like products, not assignments. I write the SQL, build the model, ship the dashboard, and hand stakeholders something they can use without waiting on me again. Every project below is live — not a notebook, not a slide deck. When I saw an open BA Internship at Amazon, I didn't just apply — I built and submitted a full RFM and funnel analysis on my own initiative, unsolicited.

0
Projects deployed live, end to end
0%
Less analyst time per retention intervention — Churn Autopsy
$0/mo
Recoverable revenue surfaced — SaaS Funnel Intelligence
Gold
HackerRank SQL badge — advanced proficiency verified
02 / Skills

The toolkit, grouped honestly.

Not a wall of logos — what I actually reach for, by category.

SQL

Window FunctionsCTEsMulti-table JoinsSubqueriesAggregationsRanking Functions

Python

PandasNumPyScikit-learnSHAPMatplotlibSeabornPlotlySciPy

BI & Visualization

TableauPower BIQuickSightStreamlitGoogle Analytics

Cloud & Databases

AWS RedshiftGoogle Cloud / Vertex AIMySQLPostgreSQL

Machine Learning

Logistic RegressionRandom ForestGradient BoostingKMeansSMOTECross-validation

GenAI / LLM

LangChainRAG PipelinesFAISSGroq LLMGemini APISentence Transformers

Excel & Reporting

PivotTablesPower QueryXLOOKUPINDEX/MATCH

Business Skills

KPI DefinitionFunnel AnalyticsRoot Cause AnalysisA/B TestingStakeholder Comms
03 / Projects

Six builds. All deployed live.

No mockups, no slide decks — every link below opens a working product.

01Apr 2026

Churn Autopsy — Customer Retention Classifier

Predicts at-risk telecom customers and delivers plain-language churn reasons any team can act on — no analyst required.

~80% less analyst involvement per intervention

FastAPIScikit-learnSHAPStreamlit
Live demo
02Mar–Apr 2026

E-Commerce Revenue Analysis

Surfaces top-revenue SKUs across 8 categories in an interactive dashboard — no SQL access needed by end users.

60+ min SKU review cut to under 10 min

SQLWindow FunctionsPlotlyStreamlit
Live demo
03Mar–Apr 2026

SaaS Funnel Intelligence Tool

Pinpoints exact funnel drop-off stages, quantifies revenue loss, and ranks what to fix first for leadership decision-making.

$8,828/month recoverable revenue isolated

PythonPlotlyPandas
04Apr 2026

Bhubaneswar Retail Price Intelligence

Compares grocery prices across 4 local sources; tells households exactly where to shop and how much they save per year.

Rs. 14,856/year savings opportunity quantified

PythonKMeansPlotlyStreamlit
Live demo
05Dec 2025

Customer Segmentation System

Groups customers into 5 named business profiles with auto-generated strategic recommendations at prediction time.

5 segments, each with a built-in action plan

Scikit-learnKMeansStreamlitJoblib
Live demo
06Mar 2026

Amazon BA Intern — Proactive Analysis Submission

Unsolicited BI analysis built and submitted as a supplement to a formal Amazon BA Intern application.

RFM + funnel + revenue study, self-initiated

SQLPythonPlotlyRFM Segmentation

Also deployed: AI PDF RAG Chatbot (LangChain, FAISS, Groq) · Mental Health Workplace EDA · AI Career Path Simulator · CSV Analyzer Pro

04 / Experience & Recognition

Where the work got noticed.

McKinsey Forward Program Selected 2026

Structured problem-solving, data-driven decision making, and stakeholder communication in global cross-functional environments.

Google Gen AI Academy APAC Selected 2026

Invite-only cohort covering LLMs, prompt engineering, and production AI deployment on Google Cloud.

L&T Techgium National Round 2 Qualifier Oct 2025

Led solution architecture and system integration for a 4-person team.

Guidewire DevTrails Hackathon Seed 2 Qualifier 2026

Advanced past the seeding round of Guidewire's national hackathon track.

HackerRank SQL Gold Badge

Advanced SQL proficiency verified — window functions, CTEs, and complex joins.

05 / Education & Certifications

Foundations.

Education

B.Tech, Computer Science & Engineering
ITER, SOA University, Bhubaneswar
2023 – 2027 (Expected)
Relevant coursework: Machine Learning, Data Structures & Algorithms, DBMS, Python Programming, Statistics for Data Analysis.

Certifications

Tata GenAI Powered Data Analytics
Forage
Feb 2026
Deloitte Data Analytics
Forage
Oct 2025
AWS Solutions Architecture
Forage
Feb 2026
AI for Beginners
HP LIFE
Feb 2026
06 / Contact

Let's build something that ships.

Open to Business Intelligence Analyst roles, open to relocation. Reach out — I reply.

Email Me