• Gained exceptional consulting exposure via undertaking marketing research, data analytics, Power BI utilization, customer analytics w.r.t 26 L’Oréal brands/sub-brands in China, delivered 30+ data analytics reports, closed 3 strategy & 2 market research reports.• Reverted to existing branding strategy across various product mix, in light of market positioning, customer segments, peer comparison, resources allocation, etc. finalized 2 market research reports via the angles of sales CAGR, differentiation against peers using Excel.• Proactively elaborated the rationale behind significant data discrepancies such as seasonal matter, pricing & advertising expenses to outline the relationship against repurchase rate, frequency of revisiting and substitution effects, highly endorsed by managers on analysis.• Demonstrated high proficiency in Power BI, solicited feedbacks from managers on Dashboard requirements, data format and dynamic graphs, collaborated with IT in re-architecting the Power BI, successfully shortened processing time by 85% via 20+ modifications.• Developed sound communication skills, consolidated 3 PPT in regional communication with HK/TW/Japan/Korea teams in market updates in China, reported localization strategy and data reporting matters. Contributed to 2 meeting minutes writeups.

• Contributed to sales & post-sales analysis w.r.t market research on sales & customer analytics, involved in project initiation, due diligence, data analysis, brainstorming and solution formulations. Delivered 10 reports & PPT.• Blended sound analytical mindset with good business acumens to understand potential improvements from initial data analysis, conducted 5 branches due diligence and site visits to cross-validate the improvements.• Located major service hurdle in information disclosure, service profession and operational errors via interpreting customers complaints, deteriorating cost / new customer, proposed 20+ improvements.• Conducted market dynamics analysis, brand sales, research expenditure, CAGR and policy endorsement, to formulate fundamental data analysis in sales analytics report, composed a 30+ pages analysis on current market dynamics.

• Accumulated hands-on experience in wealth management, undertook quantitative analysis (Python) with respect to data visualization on 100+ companies, and ranked the stocks based on Analyst’s criteria.• Contributed to fund performance analysis, such as asset allocation analysis, market risk quantification, P&L movements, industrial developments, benchmark index and daily Bloomberg Corporate Action aggregation. • Composed periodical reviews on fund performance (against benchmark), provided preliminary analysis on the reasons of underperforming or outperforming the benchmark using tracking error analytics, to reflect funds’ resilience.

• Conducted research on non-ferrous metals sector, including raw materials cost, supply & demand analysis, electricity consumption, logistic matters and captive mines consumptions.• Developed strong analytical mindset per interpreting future price fluctuation of precious metals through aggregating current utilization of capacity and demand forecast.• Demonstrated mature writeup skills per composing reports on copper and aluminum under Rio Tinto’s structure.