Sai Alekhya Kandula

Collaborated with the Qlik Dev Team to deliver 10+ stakeholder-specific reporting solutions by addressing prioritized user stories, identifying key data trends, and translating business requirements into actionable insights for the BI team. Conducted exploratory data analysis (EDA) for the EdAssist and College Coach Data Science Team using SQL and Python to identify historical patterns and validate KPIs, improving metric reliability by 25%. Performed data validation and unit testing for Qlik dashboards and reports, ensuring end-to-end accuracy by managing large-scale extracts with over 1M+ records and verifying data integrity from complex sources. Extracted and transformed data (ETL) into QVD generators using SSMS, loading it into Qlik UI while supporting efficient data modeling to streamline performance and improving reporting accuracy by 20%.

Designed and implemented 20+ Tableau dashboards to monitor KPIs, aligning with business goals and delivering actionable insights through stakeholder communication and cross-functional team collaborations. Built and maintained large datasets using SQL to track system issues, identify trends, and resolve root cause problems, reducing system hangs by 25% and ensuring reliable performance in high-pressure environments. Automated troubleshooting workflows using Python scripting and Alteryx, cutting ticket resolution time by 30%, boosting team productivity with a focus on process improvement and on-time project delivery. Performed statistical variance analysis using Python, SQL and Excel (Pivot Tables, Advanced Formulas), identifying trends and outliers that led to a 10% improvement in forecast accuracy for financial and operational planning.

Analyzed 100K+ scheduling records using SQL, Python (Pandas), and Excel to identify timing conflicts and underused slots, improving class scheduling efficiency by 20%. Built interactive Power BI dashboards with PivotTables, VLOOKUP, and conditional formatting to track faculty allocation and student preferences, reducing conflicts by 35%. Assisted faculty with curriculum planning and semester split-up structuring using Python scripts and Excel automation, improving planning efficiency by 30% and ensuring aligned academic execution. Documented and presented findings to senior staff, recognized for clear communication and analytical precision.