Karthick Raja

Hi, I'm Karthick Raja

|

Data Analyst & Power BI Developer with hands-on expertise in Power BI, SQL, and Business Intelligence. Proven track record of optimizing commercial workflows and reducing reporting turnaround time. Based in Dubai, UAE.

Power BI SQL Python DAX Excel ETL Azure Business Intelligence
About

About Me

Data Analyst & Power BI Developer.

Data Analyst & Power BI Developer with hands-on expertise in Power BI (DAX, Star Schema, Power Query) and Advanced SQL (CTEs, Window Functions, Data Modeling) to build business intelligence dashboards and reporting solutions.

Proven track record of optimizing commercial quotation workflows, tracking AED 15M+ sales opportunities, and reducing reporting turnaround time by 70%+. Based in Dubai, UAE, and available for immediate joining.

Education
B.E. Computer Science Engineering
Hindusthan Institute of Technology · 2022–2026
Location & Contact
Dubai, UAE · +971 502567444
Visa: UAE Visit
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
Enjay Engineering — Dubai, UAE (Remote)
  Aug 2025 – Jul 2026
Professional
Designed and deployed an end-to-end Quotation & Commercial Pipeline Dashboard in Power BI, consolidating sales data across UAE emirates and providing C-suite visibility into AED 15M+ in active bids.
Engineered robust Star Schema data models and 30+ custom DAX measures (Time Intelligence, YoY growth, win loss conversion ratios, and quotation aging buckets).
Automated weekly quotation ETL workflows using Power Query, eliminating manual Excel compilation and saving 12+ hours of reporting time per week.
Analyzed regional product demand (steel grades, volume, pricing margins), identifying margin leakage and helping sales teams prioritize high-value commercial bids.
Implemented Row-Level Security (RLS) to ensure regional sales managers had secure, role-based access to their respective branch data.
Data Analyst Intern
Besant Technologies — Chennai, India
  Jan 2026 – Jul 2026
Internship
Built and optimized end-to-end BI reporting solutions across Retail, Banking, and Supply Chain datasets from raw extraction to Power BI dashboard delivery.
Authored optimized SQL queries using CTEs, multi-table joins, and window functions to clean, aggregate, and validate 500K+ transactional records across relational databases.
Configured automated scheduled gateway refreshes and report distribution in Power BI Service, cutting departmental report generation lag by 35%.
Conducted Exploratory Data Analysis (EDA) in SQL and Python (Pandas) to uncover sales trends, customer churn indicators, and fulfillment bottlenecks.
Skills

My Technical Skills

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

BI & Data Visualization
Power BI (Desktop & Service)
DAX
Power Query (M-code)
Star Schema Data Modeling
Row-Level Security (RLS)
KPI Scorecards
Drill-through Reporting
Looker Studio
Databases & Querying
SQL
PostgreSQL / MySQL / MS SQL Server
Complex Joins & CTEs
Window Functions
Aggregate Queries
Database Normalization
Data Engineering & ETL
Data Cleansing & Validation
Automated Refresh Gateways
Azure Blob Storage
Pipeline Automation
Analytical Techniques
Exploratory Data Analysis (EDA)
Sales Pipeline Analytics
Customer Segmentation
Margin & Variance Analysis
Cohort Analysis
Tools & Programming
Python (Pandas, NumPy)
Advanced Excel
Git
JIRA
Projects

My Projects

Click on a project to see more details.

Reduced weekly sales reporting time by 12 hours and improved sales conversion by 15% through real-time UAE emirate-level tracking. Built a 5-page Power BI dashboard with KPIs tracking quotation value, win/pending opportunities, win rate, customer performance, product demand, steel volume, and UAE emirate-level activity.

Reduced weekly sales reporting time by 12 hours
Improved sales conversion by 15% via UAE tracking
5-page dashboard for KPIs, win rate, and product demand
Cleaned/transformed raw data with Power Query

Analyzed $2.3M revenue and $286K profit across 9,994 orders, enabling data-driven decisions that improved customer retention and YTD performance. Designed a Star Schema and developed 20+ DAX measures covering revenue growth, profit margin, average order value, and customer retention.

Analyzed $2.3M revenue and $286K profit across 9,994 orders
Star Schema reporting model from multiple Azure sources
20+ DAX measures for revenue growth, retention & YTD
Interactive drill-down reports by customer & region

Identified ₹4.87B in transaction value and 150K+ transactions, enabling the bank to optimize fee structures and reduce high-failure segments by 25%. Built Power Query ETL pipelines and SQL validation workflows using joins, CTEs, aggregations, and window functions.

Identified ₹4.87B in value across 150K+ transactions
Reduced high-failure segments by 25%
Power Query ETL & SQL validation (Joins, CTEs, Window Functions)
4-page interactive time-based and regional dashboard

Analyzed .3M revenue and profit across 9,994 orders, enabling data-driven decisions that improved customer retention and YTD performance. Designed a Star Schema and developed 20+ DAX measures covering revenue growth, profit margin, average order value, and customer retention.

Analyzed .3M revenue and profit across 9,994 orders
Star Schema reporting model from multiple Azure sources
20+ DAX measures for revenue growth, retention & YTD
Interactive drill-down reports by customer & region

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
Certified
Microsoft Azure Fundamentals (AZ-900)
Microsoft
Certified
Google Business Intelligence
Google
Certified
Generative AI for Data Analysts
IBM
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%
Languages
English | Tamil | Malayalam
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