Yi Sun Email & Phone Number

Shanghai, China

- Handled central data processing to facilitate diverse project data needs and analysis, ensuring data accuracy and timeliness as a data analysis intern from one of the China-leading E-Commerce platform- Utilized SQL for data extraction and analysis, organizing operational data to contribute actionable insights for decision-making- Conducted in-depth data analysis using Excel, creating reports and visualizations to assist the team in understanding market trends and user preferences- Functioned the Food Department in setting Q3 OKR and key brand operation targets to ensure alignment with overall strategic goals- Analyzed annual performance and operational data to help the Food and New Categories Department identify new strategic directions and operational priorities- Extracted external open-source data to identify high-value products, delivering timely insights for strategy formulation and implementation- Coordinated with the merchandise operations team and vendors, contributing data support to drive project execution and optimization

Canada

o Utilized audit experience to perform audit procedures that include collecting and analyzing data and documents received from clients and their supplierso Demonstrated aptitude in reviewing contract language in order to identify key, financial related provisions, reconciled supplier data support for invoicing and identified and captured relevant records that justify billable amounts.o Assessed for accuracy and appropriateness, resulting in submitting corresponding claims and discussion. Communicated the results of the analysis clearly and concisely, in both written and verbal forms, to internal, supplier and client personnel.o Utilized and demonstrated proficiency with audit tools, including MS Excel, Access, and others as appropriate. Perform data mining and analytics in order to verify and validate billing accuracy and compliance issues, and to support audit claimso Helped draft and issue audit reports that summarize completed audit activities and audit findings. Communicate Assisted in the development of training materials for other staff and faculty

o According to established guidelines, help McMaster staff/residence process payments and journal entries as a member of the Finance 2 Go team o Drafted, ran reports and performed standard financial analysis seasonally, updated and maintained files, correspondence and records according to established guidelineso Verified and reviewed various files, records and documentation as the department is receiving different financial support requirementso Coordinated with other teams to perform financial support duties of a similar nature, as required

o Contributed to internal communications and brand marketing projects, including updating content for websites, e-newsletters, print publications, video productiono Assisted program/department staff to plan, coordinate, and implement various communication projects and the departmental research, development and maintenance of communication contento Collected, drafted and wrote content utilizing provided templates for communication-related activitieso Compiled data detailing the use of communication outlets and provide suggestions for improvements based on observations o Contributed to the research webinar and knowledge labs, collected and made deep analysis on the data to draft a report for recording and future improvement o Edited basic HTML and CSS to help maintain and improve the department's web content quality and accessibility.

Master Of International Business

Bachelor Of Commerce - Bcom, Finance, Minor In Statistics