Bruce Yan Email & Phone Number

Toronto, Ontario, Canada

• Reduced query run time by 20% and improve data accuracy by 13% through SQL optimization• Established self-service dashboards to track game performance, resulting 20% increase in user engagement and streamlined weekly and monthly reporting processes. • Revamped 5 legacy game dashboards into 2 comprehensive ones, via standardizing visualizations and logic in alignment with stakeholders' objectives, and reconstructed a robust SQL structure adaptable to dynamically evolving data pipelines.• Created easily understandable game scorecards to facilitate benchmarking and enable normalized performance comparisons.• Facilitated over 50 games launch by generating canary testing lists aligned with stakeholder requirements and ensuring the availability of accurate game properties data for dashboard automation.• Documented data sources, encompassing SQL, calculation logic, and terminology definitions, facilitating improved training effectiveness and fostering cross-team collaboration. • Boosted stakeholders’ data trust by facilitating bi-weekly stand-up meetings with stakeholders, include refining project scope and delivery processes, and offering clear data clarification in non-technical terms

Toronto, Ontario, Canada

• Constructed a 5 layers (from Impressions to Loyal Users) app conversion funnel enabling strategic improvements user acquisition and engagement. • Improved app store acquisition by analyzing over 500,000 user behaviour through platforms such as Google Play, App Connect, and Firebase. • Accomplished streamlined data extraction and transformation from app data warehouse, Shopify, and Google Analytics. • Managed user subscription lists and orchestrated marketing email schedules through iContact.• Analyze social media audience, impressions, reaches, and post/stories performance on Meta Business Suite.

Toronto, Canada Area

• Improved 15% energy consumption across more than 30 commercial buildings.• Managed accounts through Energy Star Portfolio Manager, producing monthly reports on energy bills and carbon emissions to ensure compliance with energy efficiency standards.• Developed regression models for forecasting energy consumption, implementing an automated Excel template to facilitate energy performance analysis.• Design energy reports and dashboards for client performance reviews, tailoring the analysis based on various clients’ environmental factors

Toronto, Canada Area

• Optimized retail energy consumption and retrofit costs, resulting in a substantial annual energy cost reduction of up to 30%.• Processed more than 300 retrofit program applications across Canada, securing pre- and post-installation approvals for all provincial retrofit incentives, and administered over 1 millions incentive payments.• Developed an Excel tracker to centralize information on incentive applications and enhancing efficiency.• Researched and compiled information on provincial energy policies and available incentives, facilitating strategic planning for retrofit projects and contributing to increased energy efficiency.• Facilitated communication between contractors, Local Distribution Companies (LDCs), and facilities managers for TJX Canada, ensuring streamlined operations and project coordination.

Toronto, Ontario, Canada

• Facilitated and documented coordination of multiple projects, including tracking goals, managing project administration, budgeting, and conducting data analytics. • Liaise with management and clients to identify and define project requirements, scopes, and objectives that align with organizational goals.• Coordinate with internal and external vendors to ensure projects adhered to established scope and timeline, ensuring successful project outcomes.

Toronto, Canada Area

• Provide multilingual customer service and managing 30+ daily call.• Handled various tasks, including addressing general inquiries, authorizing applications, editing applications, and approving incentives.• Managed and addressed a daily volume of 180+ application submissions received through various channels, including fax, mail, and email.• Developed and delivered comprehensive CSR training for multiple energy programs. • Improved calls logging procedure and customer service team efficiency by creating Google sheet tracker for rebate logistic.