Zhongxiang(Joey) Wu
MSc graduate in Financial Analysis & Fund Management and CFA Level I candidate with experience in quantitative modelling and operational performance analytics. Applied Python for risk analysis and SQL for structured reporting. Seeking to support governance, performance tracking, and data-driven decision-making within a Strategy & Insight function.
Experience
Operations & Data Analyst
LIN TIAN MART
Portmore, Jamaica
Large multi-category supermarket managing high-volume retail inventory and daily consumer transactions, specializing in imported Chinese products and serving both individual customers and local retail shops through wholesale distribution.
- Standardized the onboarding process for new SKUs by validating product attributes against supplier documentation and structuring master data records in Excel, improving catalog accuracy and reducing pricing and inventory discrepancies across procurement workflows
- Conducted weekly cycle counts and reconciliations across 250+ SKUs to identify stock variances and recurring control gaps, increasing inventory accuracy by 15% and strengthening internal monitoring processes
- Built an Excel-based tracking model to align employee hours with sales patterns and operational demand, improving staffing efficiency by 12% and enhancing payroll accuracy through structured labor reporting
- Analyzed two years of transaction-level data to identify purchasing frequency trends and seasonal demand shifts, improving forecast accuracy by 12% and reducing stock-out occurrences by 15% through more proactive and data-informed replenishment planning
Executive Assistant to the President
WHOSWHO CULTURE MEDIA
Beijing, China
Long-established Chinese media and advertising company focused on CCTV platform content production, film and television programming, and national advertising placements, serving major corporate clients including Yunnan Baiyao.
- Built structured expenditure tracking dashboards in Excel to monitor travel and operational costs across departments, identifying abnormal spending trends and reducing discretionary expenses by 10% year-on-year through vendor benchmarking and cost visibility improvements
- Partnered with finance to reconcile cross-department budgets covering production, marketing, travel, and client servicing expenses, analyzing vendor contracts, booking platforms, and procurement channels to identify recurring cost inefficiencies, strengthening financial oversight across approximately £85k+ annual discretionary spend
- Collaborated with PR and executive teams to evaluate reputational risk for Yunnan Baiyao Group during the 2019 product controversy, analyzing 1,200+ digital mentions and detecting a 30% sentiment spike within 72 hours to support coordinated response planning
Education
University of Exeter
MSc
Merit
University of Exeter
Graduate Diploma
Merit
Skills
TECHNICAL PROJECTS & ANALYTICAL EXPERIENCE
Bond Portfolio Modelling & Risk Analysis
Python (NumPy, SciPy, Pandas) MSc
Built a Python-based yield curve modelling framework to analyze 27 corporate bonds across 1–25 year maturities, supporting scenario testing and structured interest rate impact analysis. Repriced bonds under simulated stress conditions to assess downside exposure and inform risk-aware portfolio adjustment decisions
Relational Data Analysis & Reporting
SQL (UC Davis Certification)
Queried and joined multi-table relational datasets to build structured analytical tables supporting revenue segmentation and transaction-level performance analysis. Applied data transformation and validation logic to improve reporting consistency and enable structured performance tracking across simulated business cases
CORE SKILLS
Data & Tools
Python (Pandas, NumPy, SciPy), SQL, Excel (Power Query, PivotTables), Stata
Business Analytics
KPI monitoring, forecasting, cost analysis, operational performance reporting
Language
English(Fluent); Mandarin(Native)