Karthick Raja

▸ Cleaned, validated, and transformed 600K+ records using Python (Pandas) and Excel — applying
deduplication, null handling, outlier detection, and type standardization to reduce data quality errors
by ~30% and deliver analytical-ready datasets for downstream reporting.
▸ Designed and deployed 5+ interactive Power BI dashboards featuring KPI cards, drill-through pages,
dynamic slicers, bookmarks, and conditional formatting — enabling self-service analytics and KPI
reporting for non-technical business stakeholders across Finance, Banking, and Sales domains.
▸ Developed 40+ optimized SQL queries including Joins, Aggregations, Subqueries, CTEs, and Window
Functions supporting KPI reporting, trend analysis, and ad-hoc analytical requirements with output
validated against source data.
▸ Built advanced DAX measures for MTD, QTD, YTD, Running Totals, SAMEPERIODLASTYEAR, MoM
Variance %, and Growth Rate calculations — powering time-intelligence reporting and enabling
period-over-period executive analysis across multiple business domains.
▸ Designed and executed end-to-end ETL pipelines using Python — data extraction, multi-step Pandas
transformations, loading into MySQL, and post-load validation checks — ensuring reliable, accurate
data models for Power BI consumption.
▸ Automated repetitive reporting and data-processing workflows using Python scripts — reducing
manual effort by ~40% and improving operational efficiency across the analytics team.