Yu Wangcong
Finance & Business Analytics Professional
Finance and business analytics professional with 5 years of industry experience across audit,
financial analysis and business intelligence, with a Master of Science in Business Analytics (NUS).
Always on the lookout for ways to improve current processes, with a proven ability to turn complex
financial data into actionable insights — from resolving a $2M inventory reporting gap to building
full-stack AI tools to aid real estate investment decisions.
Education
Work Experience
- Developed a full-stack AI tool to predict co-living rental prices in Singapore and South Korea, delivering data-driven insights to support investment decision-making.
- Applied web scraping techniques to harvest large volumes of property and hotel market data across two markets.
- Built a tree-based ML predictive model with explainability features (SHAP) to estimate rental prices.
- Designed an HTML5 dashboard with Python backend to visualise market data and serve as an interface for transaction analysts to query the predictive model.
- Enabled a shopping mall to make informed decisions on tenant acquisitions and store reorganisations by applying quasi-experiment designs, Pearson correlation, and Jaccard-based shop synergy analysis.
- Led worldwide inventory forecasting and reporting by collaborating with multiple regional finance teams across business units to address excess & obsolete inventory issues and ensuring accurate inventory recognition every quarter.
- Identified and resolved a $2M reporting gap caused by an overlooked system migration mismatch, restoring data integrity and preventing recurrence.
- Determined regional operational budgets by collaborating with global operations teams to improve order fulfilment while keeping inventory holding costs low.
- Forecasted APAC inventory quantities and cost-of-sales impacts on a quarterly basis using Power BI and internal tools, enabling the operations team to achieve optimal inventory levels.
- Built a financial impact simulator (HTML5, Python/Flask, SQLite) that improved UX by reducing load time over the legacy Microsoft Access tool.
- Built a semi-automated inventory reconciliation tool (Microsoft SQL Server) that cut reconciliation time from 8 hours to under 2 hours.
- Drove a 3-month global initiative to accurately account for inventory impairment in line with audit standards.
- Analysed client process inefficiencies and proposed AI/ML product solutions to streamline workflows and accelerate sales growth.
- Acted as bridge between clients and data engineers, translating requirements into detailed prototypes and product specifications.
- Strengthened client relationships through needs analysis and continuous engagement throughout project delivery.
- Led a team of 3 as a senior, performing financial audits on listed and non-listed companies, ensuring compliance with IFRS standards.
- Automated GL cleaning and consolidation via a custom VBA script deployed across client entities, saving approximately 2 days per audit engagement.
- Executed audit procedures for public and private sector clients across diverse industries.
Skills
Technical
SQL & Python
pandas · scikit-learn
R (statistical modelling)
Power BI & Tableau
Machine Learning & SHAP
Web Scraping
HTML5 · Flask · SQLite
Microsoft SQL Server
VBA & Excel (advanced)
Soft Skills
Data Storytelling
Stakeholder Communication
Cross-functional Collaboration
Analytical Problem-Solving
Project & Timeline Management
Client Needs Analysis
Awards
Finalist — SG Innovation Challenge 2025
Built an LLM-enabled HR onboarding tool from concept to working prototype.
2025
Volunteering
Food for the Needy
Delivered food for families in need with HP.
2021 – 2024
Student Befriender
Taught students with mild learning disabilities to prepare for employment.
2019 – 2021
Interests
Tennis
Table Tennis
Piano