RUY GUERRA

Senior Analyst at Nossa Senhora das Graças College

Senior Data Analyst with 15+ years of experience in data analysis, BI, and systems development. Skilled in delivering data-driven solutions that convert information into strategic decisions. Based in São Paulo, specialized in Power BI, SQL, Python, and ETL processes. In the education sector, developed a predictive model with 90% accuracy to forecast student failures, using key variables like grades, attendance, participation, academic history, and socioeconomic data, helping reduce dropout rates. Designed Power BI dashboards that increased student retention by 15% by monitoring enrollments and re-enrollments. Automated data workflows using Python and SQL Server, cutting report delivery times by 30%. Created over 50 reports and data cubes with TOTVS RM BI to enhance operational intelligence. Proficient in Power BI, SQL Server, Oracle, MySQL, Python (Pandas, NumPy), DAX, T-SQL, SSIS, Tableau, Qlik, and TOTVS RM BI.