Ray Z. - 15267 Business Intelligence Analyst from Waterloo

Data Analyst Intern , Lenovo New Vision Technology Co. Ltd., Chengdu, China - Monitored logistics operational data to track performance and market conditions - Conducted in-depth data analysis to identify performance drivers, diagnosed issues, and made recommendations on enhancements - Implemented business KPI dashboards using Power BI, highlighting key issues, latest trends, and actionable insights Financial Analyst Co-op , Henderson Partners LLP, Oakville, Ontario - Extracted, validated, and processed financial data for the audit team - Tested internal databases for client information, and identified areas of improvement - Prepared personal, trust and corporate income tax returns in a timely and accurate manner Financial Analyst Co-op, Graham Scott Enns LLP, St. Thomas, Ontario - Designed VBA programs to automate data extraction and validation processes, reducing runtime by 50% - Performed various compilation, review, and audit engagements for a broad range of clients including small to medium-sized businesses and not-for-profit organizations Finance Co-op , Brantford Public Library, Brantford, Ontario - Designed, developed, and implemented Microsoft Access databases for fixed assets and related costs - Identified, investigated, and resolved data quality issues, and made recommendations on data validation - Automated the reporting process for assets and invoice details, and identified abnormal trends