Jiwen Zhou
Clayton,VIC
Overview
1
1
year of professional experience
Work History
Audit Assistant
BDO China Shu Lun Pan CPAs LLP
Shanghai, China
02.2023 - 04.2023
- Formatted and prepared basic audit schedules and summary reports.
- Reviewed financial statements for accuracy, compliance, and consistency.
- Organized and distributed audit correspondence and client letters.
- Maintained work-paper files to support audit team and ensure timely document flow.
- Conducted physical inventory counts with audit team during on-site visits to verify reported figures.
Data Analyst Intern
H World Group Limited
Shanghai, China
06.2022 - 10.2022
- Developed and maintained complex SQL functions and stored procedures for operational data extraction, transformation, and loading from Huazhu platform into reporting datasets.
- Automated ETL workflows and standardized data imports into Excel, reducing weekly report preparation time by over 30%.
- Designed and delivered weekly Excel reports with dynamic visualizations to track key metrics, focusing on hotel inversion rate trends.
- Utilized tabular analyses and visual dashboards to create detailed customer personas, revealing consumption patterns and segment behaviors.
- Collaborated with regional managers to translate analytic findings into strategic recommendations that optimized pricing and marketing initiatives.
Education
Master - Business Analytics
Monash University
Clayton, VIC12-2025
Bachelor - Applied Statistics
Lixin University of Accounting and Finance
Shanghai07-2023
Skills
- Data analysis
- Statistical modeling
- SQL databases
- Data visualization
- R Studio
- Power BI
- Microsoft Office (Excel, PowerPoint, Word)
Languages
English
Professional
Mandarin
Native/ Bilingual
Timeline
Audit Assistant
BDO China Shu Lun Pan CPAs LLP
02.2023 - 04.2023
Data Analyst Intern
H World Group Limited
06.2022 - 10.2022
Master - Business Analytics
Monash University
Bachelor - Applied Statistics
Lixin University of Accounting and Finance
Similar Profiles
Junxiong WangJunxiong Wang
Risk Management Intern at Bank of ChinaRisk Management Intern at Bank of China
Song LingxuanSong Lingxuan
Senior Auditor at BDO China Shu Lun Pan CPAsSenior Auditor at BDO China Shu Lun Pan CPAs
Shiya FengShiya Feng
Auditor Intern at BDO China-SHU LUN PAN Certified Public AccountantsAuditor Intern at BDO China-SHU LUN PAN Certified Public Accountants
Ling XuLing Xu
Project Manager at Gush GlobalProject Manager at Gush Global
Jyoti JyotiJyoti Jyoti
Kitchen Hand at CHAI N CHILLI INDIAN RESTURANTKitchen Hand at CHAI N CHILLI INDIAN RESTURANT