Alan Wu

Alan Wu

Data Analyst

Followers of Alan Wu240 followers
location of Alan WuScarborough, Ontario, Canada

Connect with Alan Wu to Send Message

Connect

Connect with Alan Wu to Send Message

Connect
  • Timeline

  • About me

    Microsoft Certified: Power BI Data Analyst Associate; Intern @ City of Richmond Hill | Master's in Geomatics

  • Education

    • The University of British Columbia

      2022 - 2023
      Master's degree Master of Geomatics for Environmental Management 85.5%

      • Advanced Geographic Information Systems for Environmental Management• Advanced Earth Observation and Image Processing• Geospatial Data Analysis• Remote Sensing for Ecosystem Management• Linear Regression Models and Introduction to Spatial Statistics• Leadership and Sustainability

    • McMaster University

      2018 - 2019
      Bachelor's degree Environmental Science
    • Zero To Mastery Academy

      2023 - 2023
      Web development

      Focusing on the concept of web development, including JavaScript, HTML5, and CSS3.

    • University of Toronto

      2019 - 2022
      Bachelor of Science - BS Environmental Science & Mathematics-Double Major

      Relevant Coursework:• Complex Variables• Number Theory• Earth System Evolution

  • Experience

    • Beijing Sanjin Fengqing Catering Management Co., Ltd.

      Sept 2020 - Jun 2021
      Data Analyst

      • Cleaned and integrated data from company’s POS system with SQL and Python (Pandas) to enhance personalized guest experienceand raised Positive Ratings from 90% to 97% including order preferences, reservation habits, and demographics• Used Python and Excel to build predictive models to forecast future revenue with over 80% accuracy, reduce food waste by 30%, andpre-plan upcoming shifts by predicting customer trends and busiest time periods• Created Lunchtime Voucher named YinPiao with cross-functional departments like Marketing to enhance customer loyalty andgenerated around 3000 revisits and $42,000 in revenue over 3 months• Performed and delivered over 10+ interactive BI dashboards for managers that decreased manual reporting by 8 hours weekly Show less

    • Alpha Libertée

      Feb 2022 - Mar 2022
      Sustainability researcher

      • Created a transformer model to identify intents and entity extraction, including steps of data processing, data generation, modeling, and iteration, and tested machine learning algorithms to predict labels from features, tuning them for business needs, and validating them with 80% validation accuracy• Trained AI assistant Daisy with Chia Network’s use of low-capacity HDDs to keep low energy costs, and improved 25% accuracy of Daisy’s prediction on the most eco-friendly tokens on market and effective methods to reduce CO2 output of tokens• Developed a 20 pages report including a Dashboard and a predictive model via Python to conclude the best ways to limit emissions caused by electricity consumption of mining operations, increased data readiness and efficiency by 30% Show less

    • Blue Ventures

      Sept 2022 - Apr 2023
      GIS Analyst

      • Collected and Analyzed PlanetScope datasets covering over 10,700 sq km acquired in Planet data with R and ArcGIS pro to develop advanced and detailed multi-date maps of mangroves in Northwestern Madagascar with 100 times higher spatial resolution• Derived CRAs of different classes of interest and built maximum likelihood classification and random forest classification models with R to identify 9 classes of mangrove ecosystems on the refined map that produced overall accuracies of over 90%• Quantified dynamics across landscapes of ROI on Planet data maps and compared to GEE maps based on moderate Landsat data, ran hypothesis tests on R to conclude changes in the mangrove subtype, and visualized key findings in Tableau and Excel Show less

    • City of Richmond Hill

      Jan 2024 - now
      Intern

      - Manage databases and input information, data, and records. - Utilized Power BI to pull, clean, and visualize data.- Created dashboards on Power BI to generate insights for the Procurement manager.- Research and gather documentation related to the divisional function.- Assists in preparing information and research materials- Supports the organization of procurement documentation on the shared drive- Support the development of training materials – particularly online- Support the creation of a robust intranet for procurement Show less

  • Licenses & Certifications

    • Google Data Analytics Specialization

      Coursera | Google
      Nov 2022
      View certificate certificate
    • Google Finance Data Analyst Professional Certificate Specialization

      Coursera | Google
      Nov 2022
      View certificate certificate
    • Microsoft Certified: Power BI Data Analyst Associate

      Microsoft
      Apr 2024
      View certificate certificate
    • Microsoft Certified: Power Platform Fundamentals

      Microsoft
      Jun 2024
      View certificate certificate
    • Data Science and Machine Learning Fundamentals

      Corporate Finance Institute® (CFI)
      Oct 2022
      View certificate certificate
    • Data Analytics Consulting Virtual Internship

      KPMG
      Feb 2023
      View certificate certificate
  • Honors & Awards

    • Awarded to Alan Wu
      Graduated with Honours University of Toronto Jun 2022