Kunal Rakesh Jain

Business Intelligence Analyst @Iconsult Collaborative At Syracuse University

Syracuse, NY, US

Built real-time KPI dashboards in Excel and Power BI to track team performance, identify operational risks and align forecasting with business strategies, enabling improvement in strategic operations decisions- Led financial and scenario modeling for $650K+ budget alignment by developing Excel based financial and operational models for scenario analysis reports, supporting business decisions under shifting priorities- Analyzed 100K+ records of operational and cohort data to identify risks in engagement trends and patterns; performed data profiling and validation to support planning optimization- Developed predictive analytics models using Python and SQL to forecast resource demand and team capacity, improving resource allocation accuracy by 35% across 20+ customer-facing programs- Automated end-to-end risk mitigation data workflows using Microsoft Forms, PowerApps and Power Automate, reducing manual QA time and SKU analysis by 80%(6+ hours to under 1 hour per cycle) and improving data reporting- Collaborated with cross-functional teams to define data requirements, translate and present analytical needs into visual insights to technical and non-technical stakeholders and deliver actionable analytics aligned with strategic decision making.