Available for opportunities

Hi, I'm CharanTeja Vallabhaneni.
Data Analyst

Data Analyst with hands-on experience building Power BI dashboards, ETL pipelines, and advanced SQL analysis — turning complex data into decisions that move businesses forward.

$24.9M
Revenue Analyzed
50K+
Transactions Processed
40%
Reporting Time Saved
CharanTeja
About Me

Data Analyst with a
Business Mindset

I'm a Data Analyst with experience building Power BI dashboards, developing ETL pipelines, and performing advanced SQL analysis. I've worked with real clients — including a winery in Virginia — to design KPI frameworks and deliver self-service reporting that stakeholders actually use.

Before analytics, I worked at BOSCH analyzing automotive system test data, identifying defect patterns, and generating structured performance reports in Agile environments. That background gives me a strong foundation in data quality and systematic thinking.

I hold a Master's in Data Analytics Engineering from George Mason University and I'm actively seeking a full-time Data Analyst role where I can drive meaningful business impact.

Most recently, I've extended this analytical foundation into AI — building an end-to-end Retrieval-Augmented Generation (RAG) system, and integrating AI-powered insights (Key Influencers, Smart Narrative) directly into Power BI dashboards to help stakeholders act faster on the data.

📊
Dashboard Development
Power BI dashboards with DAX and Power Query for real-time self-service reporting
🔄
ETL & Data Engineering
Python-based ETL pipelines with API integration — reduced manual reporting by 40%
🔍
SQL & Data Analysis
Advanced SQL for segmentation, ranking, and trend analysis across 100K+ records
Tools & Technologies

My Technical Stack

🗄️
SQL
Joins, CTEs, Window Functions
🐍
Python
Pandas, NumPy, ETL Pipelines
📊
Power BI
DAX, Power Query, Reports
📈
Tableau
Visual Analytics, Dashboards
📗
Excel
Pivot Tables, Advanced Functions
❄️
Snowflake
Cloud Data Warehousing
🔬
Statistics
EDA, Regression, Clustering
🔁
ETL
API Extraction, Data Pipelines
🤖
AI / LLMs
RAG Pipelines, Vector Search, OpenAI API
Work

Featured Projects

Power BI
AdventureWorks Sales Dashboard
End-to-end sales performance dashboard tracking revenue trends, product category performance, and return rates for a bike shop operation.
$24.9M revenue · $10.5M profit tracked
25.2K orders · 2.2% return rate
AI-powered Key Influencers & Smart Narrative for automated insights
Power BI · DAX
Maven Market Performance Dashboard
Multi-region retail dashboard with brand-level KPI tracking, geographic sales mapping, and revenue vs target analysis across USA, Canada & Mexico.
113.6K transactions · $449K profit
59.94% profit margin achieved
USA identified as top revenue market
SQL
SQL Data Analysis Pipeline
End-to-end SQL analytics project transforming raw sales data into actionable business insights through customer segmentation, revenue trend analysis, and product performance reporting.
100K+ records processed end-to-end
Customer & product report deliverables
Segmentation, ranking & trend analysis
PostgreSQL · ETL
SQL Data Warehouse Project
End-to-end data warehouse solution consolidating sales, customer, and product data from multiple source systems into a clean, analytics-ready star schema — built for scalable business reporting.
Medallion Architecture — Bronze, Silver and Gold layers
6 source tables integrated from CRM & ERP
Star schema with dimension and fact views
Python · RAG · LLM
Apple 10-K Q&A — RAG Assistant
End-to-end Retrieval-Augmented Generation system answering natural-language questions over Apple's SEC 10-K filings, with citations back to exact source pages. Combines hybrid search (vector + keyword) with cross-encoder reranking and a live usage-monitoring dashboard.
100% Recall@5 on custom evaluation set
Hybrid retrieval + cross-encoder reranking
Live usage dashboard tracking queries & latency
Education

Academic Background

George Mason University
M.S. in Data Analytics Engineering
GITAM University
B.Tech in Computer Science & Engineering
Certifications

Credentials

🎓
Google Data Analytics
Google · Coursera
📊
Microsoft Power BI Desktop
Microsoft
📈
Data Visualization
Coursera

Open to Data Analyst Roles

I'm actively seeking full-time opportunities. If you're looking for a data analyst who's passionate about turning numbers into business impact, let's talk.