Karthick Raja

Hi, I'm Karthick Raja

|

Data Analyst with 6 months of internship experience in Power BI, SQL, Excel, and Business Intelligence. Passionate about transforming raw data into actionable insights through dashboards and analytics.

Power BI SQL Python DAX Excel ETL Business Intelligence
About

About Me

CSE Graduate specializing in Data Analytics & Business Intelligence.

I am a Computer Science Engineering graduate with hands-on experience in Data Analytics, Business Intelligence, Power BI, SQL, Python, and Dashboard Development. During my 6-month internship as a Power BI Developer and Data Analyst, I gained practical experience in dashboard development, data visualization, SQL querying, ETL processes, and business reporting.

I enjoy transforming complex datasets into meaningful insights that help organizations make informed decisions. My expertise includes Power BI, SQL, Excel, Python, and data storytelling — with a portfolio of 8+ analytical projects across Banking, Retail, Customer Analytics, and IoT domains.

Education
B.E. Computer Science Engineering
Hindusthan Institute of Technology · 2022–2026
Based In
Chennai, Tamil Nadu, India
Specialization
Data Analytics & Business Intelligence
Open To
Full-Time Roles · Data Analyst · Power BI Developer
Professional Highlights

By the Numbers

Key metrics that define my professional journey so far.

6
Months Internship
Experience
8+
Analytical
Projects
150K+
Records
Analyzed
9+
Interactive BI
Dashboards Built
6+
Professional
Certifications
Experience

Work Experience

Hands-on professional experience in data analytics and business intelligence.

Power BI Developer & Data Analyst Intern
Data Analytics Firm — Chennai, India
  Jan 2026 – Jun 2026 · 6 Months
Full-Time Internship
Developed interactive Power BI dashboards for business reporting, enabling real-time KPI monitoring and data-driven decision-making across departments.
Created ETL workflows and data transformation processes using Power Query and SQL to extract, clean, and load data from multiple sources.
Designed and optimized data models using star-schema and DAX calculated measures to support complex analytical reports.
Collaborated with business stakeholders to gather requirements and built KPI cards, drill-through reports, and dynamic filtering dashboards.
Automated reporting processes using scheduled refreshes and data pipelines, improving data accuracy and reducing manual effort by 40%.
Worked on banking, retail, customer analytics, and IoT datasets — analyzing 50,000+ to 100,000+ records per project.
Power BI DAX Power Query SQL ETL Data Modeling KPI Reporting Excel
Skills

My Technical Skills

Technologies and tools I use to build analytics, BI dashboards, and data-driven solutions.

Business Intelligence
Power BI
DAX
Power Query
Data Visualization
Dashboard Development
Business Reporting
Database & SQL
SQL
MySQL
SQL Server
PostgreSQL
Data Analytics
Excel
Python
Pandas
NumPy
Matplotlib
Seaborn
Data Science & Machine Learning
Machine Learning
Scikit-Learn
Deep Learning
TensorFlow
Development Tools
Git
GitHub
Jupyter Notebook
VS Code
Projects

My Projects

Click on a project to see more details.

Hospitals lose crores to undetected fraud every year. ClaimVision is an executive-ready Power BI dashboard that gives healthcare organisations a 360° view of their claims data — covering 20K+ claims and ₹25Bn+ in claim amount with a 24.9% fraud detection rate. Six pages span patient demographics, provider risk scoring, claims trends, and fraud pattern analysis, all built on a star-schema data model with advanced DAX measures and Power Query transformations.

20K+ claims & ₹25Bn+ claim amount analyzed
24.9% fraud detection rate with provider risk scoring
6-page dashboard: patient demographics to executive summary
Star schema modeling with DAX & Power Query

An interactive Power BI dashboard analyzing business performance, customer behavior, revenue trends, profitability, and KPI metrics. Implemented advanced DAX calculations, dynamic filtering, drill-through analysis, and rich data visualizations to support strategic decision-making and performance monitoring.

Advanced DAX measures for revenue & profitability KPIs
Customer behavior segmentation & retention analysis
Dynamic filtering with drill-through capabilities
Strategic performance monitoring dashboards

A Power BI dashboard for banking analytics covering customer segmentation, loan performance, deposits, transaction trends, and financial KPIs. Utilized Power Query for ETL, DAX for complex calculations, and advanced data modeling to generate actionable business insights.

Customer segmentation & loan performance analysis
Deposit & transaction trend monitoring
Power Query ETL & star-schema data modeling
Financial KPIs with DAX calculated measures

An interactive Power BI dashboard analyzing 50,000+ IoT sensor records across industrial machines. Built KPI tracking, anomaly detection, machine health monitoring, and predictive maintenance insights with advanced DAX measures for operational performance analysis.

50,000+ IoT sensor records analyzed in real time
Anomaly detection & machine health monitoring
Predictive maintenance KPI tracking
Advanced DAX measures for operational performance

A Power BI dashboard analyzing sales, profitability, customer behavior, and regional performance across retail operations. Features drill-through reports, KPI cards, dynamic filtering, and time-intelligence calculations to support data-driven business decision-making.

Sales & profit margin analysis with KPI cards
Regional performance breakdown with geo-mapping
Time-intelligence DAX (YoY, MoM, rolling averages)
Drill-through reports & dynamic slicers

An interactive Power BI dashboard designed to monitor and analyze SLA, latency, and failure rates from 100K+ API log records. Features real-time monitoring and incident detection capabilities to improve system reliability.

SLA, latency, and failure rate tracking dashboards
Interactive visualization of 100K+ API log records
Real-time incident detection monitoring capabilities
Integration with automated ETL validation pipelines
Data Analytics GitHub Portfolio

A comprehensive Data Analytics and Business Intelligence portfolio on GitHub, showcasing Power BI dashboards, SQL analytics, Python-based data processing, ETL workflows, KPI reporting, and interactive BI solutions across Banking, Retail, Customer Analytics, and IoT domains.

Power BI dashboards across Banking, Retail & IoT domains
SQL analytics & data modeling projects
Python ETL workflows & data processing pipelines
KPI reporting & interactive BI solutions
Stock Portfolio Analysis

A comprehensive portfolio analysis dashboard built entirely in Microsoft Excel — designed to help investors track performance, visualize trends, and make data-backed decisions. Processes 10,000+ rows with advanced formulas and interactive visualizations.

Processed and analyzed 10,000+ rows using pivot tables
VLOOKUP and INDEX-MATCH for smart data consolidation
Interactive dashboard with charts and slicers
40% reduction in reporting time with trend analysis
API Performance Monitoring

An end-to-end ETL pipeline for 100K+ API log records with automated validation and data quality checks. Achieved 99.5% data consistency and designed dashboards to analyze SLA, latency, and failure rates with real-time monitoring and incident detection capabilities.

End-to-end ETL pipeline for 100K+ API log records
99.5% data consistency with automated validation
SLA, latency, and failure rate dashboards
Real-time monitoring and 30% faster incident detection
Bird Species Recognition

A machine learning model using MFCC-based audio feature extraction to identify and classify bird species from audio recordings. Trained on multiple bird species and deployed as an interactive Streamlit web application for real-time predictions.

MFCC-based audio feature extraction pipeline
Machine learning model trained on multiple bird species
Live Streamlit application for real-time prediction
Improved classification accuracy across species
ATS Resume Analyzer

A production-ready full-stack application that leverages LLMs to analyze resumes for ATS compatibility. It scores resumes against Data Analyst role profiles, extracts critical insights from PDFs, and generates intelligent rewrite suggestions.

Intelligent ATS scoring & keyword matching
PDF text extraction logic
AI-powered resume rewrite suggestions
Full-stack React, Express, and MongoDB architecture
Job Application Tracker

A full-stack web application to streamline and manage the entire job search process. Track applications across companies with status updates (Applied, Phone Screen, Interviewing, Offer, Rejected), priority levels, contacts, follow-up dates, and notes — all in one place. Features CSV export, smart filtering by status and region, and a clean dark-mode dashboard UI.

Full-stack Python/Flask app with PostgreSQL database
Real-time application tracking with status & priority management
Smart filters by status, region & search; CSV export
Dark-mode responsive dashboard with weekly stats & KPI cards

No projects available for this filter.

Certifications

Professional Certifications

Verified credentials in data analytics, Business Intelligence, and programming.

Microsoft Power BI Data Analyst
Microsoft — Credential ID: TYPPUPQXZ0T8
Certified
Data Analyst Certification
Besant Technologies
Certified
Career Essentials in Data Analysis
Microsoft & LinkedIn
Certified
Generative AI for Data Analysts
IBM — Credential ID: Q5AF9GPDM2LU
Certified
Harnessing the Power of Data with Power BI
Microsoft — Credential ID: FHTK7PQTG40Z
Certified
SQL (Intermediate)
HackerRank
Certified
Education

My Education

B.E. Computer Science Engineering graduate from Hindusthan Institute of Technology, Coimbatore.

2022 – 2026
B.E. Computer Science Engineering
Hindusthan Institute of Technology, Coimbatore
CGPA: 7.2 · Graduated 2026
2020 – 2022
HSC — Higher Secondary
Sri Ramakrishna Matric Hr Sec School, Perambalur
76.3%
Until 2020
SSLC — Secondary School
St. Paul's Matric Higher Secondary School
92%
Contact

Get in touch

Have a project or job opportunity? Feel free to reach out. I'd love to hear from you.

Open to Full-Time Opportunities

Ready for Data Analyst & Power BI Roles

Open to full-time opportunities in Data Analytics, Business Intelligence, Power BI Development, and Reporting Analytics. Let's build something impactful together!

Send a Message
Also download my resume
View Resume Download PDF
Email copied