Yuchen Tan

Experience

• 

  Auckland University Chinese Student Society

  Jan 2018 - Dec 2018

  President
• 

  Pearl Standard

  Jul 2018 - Aug 2022

  Business Analyst

  • Develop effective data extraction, transformation and load (ETL) processes, to perform data analysis and prediction on product price, and present findings in a visual format.• Working closely with sales team to provide timely insight into performance and profitability goals and provide recommendations.• Developing and maintaining pricing and profitability models, performing monitoring of competitors pricing. • Providing leadership, training, and guidance to junior staff.

• 

  Bank of China (New Zealand) Limited

  Aug 2023 - Sept 2024

  Cash Management Associate

  • Managing client's internet banking, cash flow and cash pooling, and overseeing and troubleshooting financial operations of customers such as payroll, bulk payments, etc.• Migrating and rebuilding key customer models, translating raw data into actionable insights, inventing new excel worksheet for various teams which saved 90% of the time, • Data analysis and visualization of trading volume and active user number to support business initiatives and create insights and reports to stakeholders to optimise revenue and margin.• Project management including requirement gathering, process improvement, solution crafting and implementation of agile methodologies testing and training. Projects such as tax paying function and branch level Internet banking platform development. Show less

• 

  ASB Bank

  Sept 2024 - now

  Risk Data Analyst