Andres Cordero

Business Analyst @Intellectual Property Ontario Ipon

Waterloo, ON, CA

Conducted data-driven analyses and internal and external data research to inform strategic initiatives that align IPON\'s priorities with Ontario’s economic development goals. This resulted in a 95% improvement in stakeholder engagement and decision-making- Migrated data systems from Excel to Power BI by designing ERD models, normalizing data with Power Query, and setting up relationships. Created six interactive dashboards that improved data access and usability for 10+ users-Defined and tracked KPIs to evaluate IPON\'s impact, value for money, and value creation for clients and the economy, improving reporting efficiency by 84%- Built and maintained reporting tools and dashboards in Power BI and Power Automate, giving 5 stakeholders real-time insights to monitor progress against targets- Worked with cross-functional teams to collect performance data, align metrics with strategic goals, and implement changes that improved data accuracy by 90%- Streamlined data processes to reduce manual effort by 5 hours per month and improve system efficiency, resulting in better service delivery.