Expériences professionnelles
Data analyst (north asia indirect sourcing)
L'Oreal China Co. Ltd. , Jing'an qu - CDD
De Mars 2022 à Juillet 2023
Data Management
1) Established a centralized procurement hub by organizing data from various systems which enables smooth downstream analytics
2) Launched North Asia procurement Power BI Workspace : managed published apps, permissions, roles and RLS, notifications
3) Built monthly updated dashboards Saving Performance & Indirect Sourcing Monthly Spend & Vendor Compliance Dashboard that report different sourcing business performance metrics to purchasing team of five Asia markets; designed report structures and model connections to ensure BI analytics can be automatically refreshed via raw data downloaded from different systems; enabled personalised views for users through Tabular Editor
4) Authored SQL scripts that automate sourcing metrics computation (e.g. aggregated spend from SAP PO list, hierarchy mapping)
5) Deployed Macro for catalog CIF file conversion and improved catalog penetration rate by 5% in PO creation
6) Oversaw data quality through entire Procurement-to-Pay cycles to ensure meeting digital KPI (e.g. unclassified spend
Merchandising intern
PRADA Fashion Commerce (Shanghai) Co. Ltd., , Jing'an qu - Autres
De Septembre 2021 à Décembre 2021
1) Consolidated and summarised weekly sales recap report using various Excel models, combined with analyzing fashion market trends to forecast buying needs per SKU in OTB planing
2) Assisted the retail merchandising manager in monitoring inventory to ensure appropriate markdown, promotion, price changes
3) Coordinated with warehouse and stores to ensure appropriate levels of stock of designated products are maintained 4) 4) Worked closely with Retail Operations, Visual Merchandising departments and Stores to make improvements on displaying and replenishment to maximise sales potential and profit within the region; Conducted competitive product research and trend reports on best-sellers; assisted the department to deliver training materials translation;
Parcours officiels
Langues
Français - Courant
Anglais - Courant
Japonais - Technique
Chinois - Langue maternelle