Wyun Ng
Associate Data Analyst at New Forests- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
New Forests
-
Australia
-
Investment Management
-
1 - 100 Employee
-
Associate Data Analyst
-
Aug 2023 - 5 months
North Sydney, New South Wales, Australia Responsibilities: • Model Translation: Took charge of translating intricate Excel-based financial and investment models into scalable multi-dimensional frameworks using Pigment and Power BI. Work was done in close collaboration with the Manager of Data Analytics and Investment Analytics team members. • Data Preprocessing: Conducted meticulous data cleaning and wrangling to prepare datasets for analytical modeling. Ensured high data integrity and reliability for downstream… Show more Responsibilities: • Model Translation: Took charge of translating intricate Excel-based financial and investment models into scalable multi-dimensional frameworks using Pigment and Power BI. Work was done in close collaboration with the Manager of Data Analytics and Investment Analytics team members. • Data Preprocessing: Conducted meticulous data cleaning and wrangling to prepare datasets for analytical modeling. Ensured high data integrity and reliability for downstream analytics. • Training: Actively participated in on-the-job training sessions to master the usage of Pigment and other analytics tools critical to New Forests' data-driven strategies. • Documentation: Spearheaded the development of written procedures and documentation to enable end-users to understand and utilize the financial and investment models effectively. Created FAQs, user manuals, and best-practice guidelines. Skills: • Excel & Financial Modelling: Advanced skills in Excel, particularly in complex formulae and financial modeling concepts like discounted cash flow analysis, financial statements, and internal rate of return. • SQL Proficiency: Strong SQL skills, comfortable with creating, modifying, and running queries for data extraction and manipulation. Understanding of database design and the ability to optimize for performance. • Power BI & Advanced DAX: Hands-on experience in developing PowerBI dashboards from scratch. Skillful in employing Advanced DAX, Power Query, and performance tuning to create highly efficient dashboards for data visualization and business intelligence. • Time Management: Excellent organizational and time-management skills, enabling the juggling of multiple projects and deadlines effectively. • Team Collaboration: Built strong relationships within cross-functional teams, showcased effective communication and problem-solving skills in a collaborative environment. Show less
-
-
-
-
Experienced Private Tutor (Elementary & High School)
-
Aug 2020 - 3 years 5 months
Greater Sydney Area As an experienced private tutor in elementary and high school education, I have successfully guided students through various exam curriculums and levels, focusing on enhancing their understanding and problem-solving skills. I offer both one-to-one in-person and virtual tutoring sessions, tailoring my approach to accommodate each student's individual needs. My tutoring experience covers: • HSC Year 10 and 11 Mathematics Standard (2022-2023) • HSC Year 11 and 12 Information Processess… Show more As an experienced private tutor in elementary and high school education, I have successfully guided students through various exam curriculums and levels, focusing on enhancing their understanding and problem-solving skills. I offer both one-to-one in-person and virtual tutoring sessions, tailoring my approach to accommodate each student's individual needs. My tutoring experience covers: • HSC Year 10 and 11 Mathematics Standard (2022-2023) • HSC Year 11 and 12 Information Processess and Technology (2022-2023) • IB Year 12 Computer Science Higher Level (2022-2023) • HKDSE Form 2, 5-6 Information and Communication Technology (2020-2023) • HKDSE Form 2-3 Mathematics and English Language (2020-2021) • HK Primary 6 English Language (2022) • HK Primary 5 Chinese and English Language and Mathematics (2020-2021) Show less
-
-
-
Optiver
-
Netherlands
-
Capital Markets
-
700 & Above Employee
-
Project Team Member, Optiver Interdisciplinary Partner Project at UNSW
-
Jan 2023 - Apr 2023
Sydney, New South Wales, Australia • Worked closely with a team of 5 on developing a stock volatility prediction model for Optiver • Conducted feature engineering to enhance the performance of the EWMA and LightGBM models • Developed a hybrid model using Bayesian averaging, achieving an R2 of 0.878 and RMSPE of 0.196, surpassing Optiver's Naïve Model's performance • Optimized model runtime at 16.008 seconds, accounting for Bayesian averaging's fast computation • Participated in weekly team meetings to discuss… Show more • Worked closely with a team of 5 on developing a stock volatility prediction model for Optiver • Conducted feature engineering to enhance the performance of the EWMA and LightGBM models • Developed a hybrid model using Bayesian averaging, achieving an R2 of 0.878 and RMSPE of 0.196, surpassing Optiver's Naïve Model's performance • Optimized model runtime at 16.008 seconds, accounting for Bayesian averaging's fast computation • Participated in weekly team meetings to discuss actionables, share findings, and refine the model's development • Engaged in 4 client meetings, incorporating valuable feedback to further improve the model • Identified and mitigated risks associated with data quality, computational resources, and heteroskedasticity through pre-processing and code optimization • Prepared and submitted a comprehensive technical report detailing the model's development, parameter explanations, results, limitations, and recommendations for improvement • Created a concise slide deck for presentation to colleagues and stakeholders at Optiver Show less
-
-
Education
-
UNSW
Bachelor's degree, Data Science and Decision