Yunting Ines

- Optimized data resources using BigQuery and Google Looker, and ensured communication with business stakeholders across global L’Oréal divisions — Consumer Products Division, L’Oréal Luxe, Professional Products Division and the Dermatological Beauty Division - Conducted staging environment testing to identify and resolve data discrepancies, ensuring consistent availability and accuracy of datasets by partnering with external data providers - Managed Agile Sprint Backlogs by defining, tracking, and validating user stories, closely collaborating with developers to enhance functionality across Google Cloud Platform (GCP) and Looker

• Conducted data analysis on the five main Maisons of Kering (Gucci, Saint Laurent, Balenciaga, Alexander McQueen and Bottega Veneta), identified trends and patterns, prepared reports, and presented key findings to stakeholders and directors for data-driven decisions • Leveraged SQL and Python to extract, manipulate, and analyze data from Kering's internal database • Collaborated in the development of Tableau dashboards, contributing to data visualization efforts • Collaborated with cross-functional teams to gather and refine data requirements, ensuring data accuracy

• Represented my school and its values by serving as a student ambassador on Instagram, LinkedIn, Campus France and other platforms • Collaborated with faculty and staff to develop marketing strategies and create engaging content that reached a wider audience • Networked with other students and professionals to build relationships and expand my knowledge and skills • Contributed to a sense of community by working with other student groups and supporting their initiatives

• Conducted in-depth due diligence over enterprise clients’ financial status and operational performance: examined enterprises’ financial data, derived crucial conclusions by calculating financial indicators like leverage rate, evaluated the profitability using several metrics, including monthly/yearly growth rate of sales, and so forth • Provided necessary supports for over 50 individuals with their opening bank accounts and probed into their financial needs

• Responsible for payment and collection of foreign currencies for foreign trade companies in Wuxi City on a daily basis: examined these enterprise clients’ credit records, investigated payers’ associated risks, and classified the payments into different Balance of Payment items; dealt with more than 200 receipts to ensure the consistency, authenticity, and accuracy of over 1000 pieces of data, the error rate reached 0% • Frequently communicated with State Administration of Foreign Exchange to stay in tune with latest currencies regulation policies, get approvals for foreign exchange, ensure compliance of each transaction, and so forth • Worked collaboratively with colleagues from Financial Market Dept. to expedite their business operation process, including cross-border transactions in regard to wealth management products • Employed Excel to organize and compile over 10,000 pieces of transactional data and developed summaries derived data analysis

• Utilized SQL to retrieve, insert, update, and delete records related to advertising materials in the internal information system • Performed SEO to optimize our brand’s visibility online: published relevant and authoritative content, updated content regularly

• Kept real-time track of several stocks and industries, wrote and submitted more than 10 daily reports to supervisors • Assisted in colleagues’ work to prepare daily wrap-ups and relevant bulletins of the secondary market for the purpose of presenting to clients, investigated and compiled clients’ transactional data