Alan Wu

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