Aditya Malode

Data Analyst (Data Scientist - Research) @University Of Georgia - Franklin College Of Arts And Sciences

Athens, GA, US

OverviewDrive university-wide analytics by architecting Power BI models, automating ETL, and tuning data workloads to deliver faster, trustworthy insights for academic leaders. Highlights Architected a Power BI star-schema model; migrated 500K+ legacy records, boosting reporting accuracy by 25% and enabling access for 20+ departments. Built automated ETL pipelines with Python (Pandas, NumPy) and SQL; standardized formats, imputed nulls, and de-duplicated records, cutting manual prep by 30%. Profiled queries and reworked joins; applied advanced indexing to reduce Power BI dashboard load times by 40% for 50+ concurrent users. Integrated U.S. labor data (BLS, O*NET) into a dimensionally modeled warehouse; dashboards informed 15+ academic program decisions. Implemented BI data governance (validation checks, role-based access, lineage controls) to maintain 99% data quality across reports. Tech & MethodsPower BI (semantic models, DAX) • Python (Pandas, NumPy) • SQL • Dimensional Modeling (Star Schema) • Query Profiling • Indexing • Data Quality Validation • RBAC SkillsPower BI • DAX • Python • Pandas • SQL • ETL • Data Modeling • Star Schema • Dimensional Modeling • Performance Tuning • Indexing • Data Governance • Data Visualization • BLS • O*NET