Juan Borque

Senior Data Analyst @Evergy

Kansas City, MO, US

I develop data strategies to expand program participation, optimize outreach, and elevate the performance of customer-facing energy programs. By identifying high-impact audiences and improving access to critical insights, I strengthen program adoption, support regulatory approvals, and surface measurable results for economic assistance initiatives.Key contributions include:• Achieved an 18.8% increase in smart thermostat enrollments through targeted outreach powered by predictive modeling.• Built Python-based ETL pipelines and ensemble ML models (KNN, Logistic Regression, Random Forest, Gradient Boosting) to identify high-likelihood participants.• Automated extraction and delivery of three years of hourly energy usage data using Python and SQL, reducing daily processing time by 5–6 hours.• Integrated SharePoint and Power BI to stabilize analytics and enable segmentation of solar customers and energy flow across agreements.• Replaced legacy HTML forms with Microsoft Forms; centralized responses via SharePoint for Power BI analysis.• Developed dashboards to surface customer needs and assess economic program impact across regional offices.• Analyzed service cut patterns among participants vs. non-participants in assistance programs, identifying a 200% increase in pre-cut notifications and 400% improvement in disconnection prevention.• Supplied data to support program expansion and inform regulatory reporting.

Rockhurst University

Master of Science, Business Intelligence and Analytics