Zhao Chen

• Implemented SQL-based data analytics to improve organizational performance, reducing end-to-end latency by 40% and resulting in cleaner datasets with a 4.2% increase in internal communication efficiency.
• Utilized ERP software to compute expenditures. Developed a material tracing framework to compute material costs, resulting in a 20% reduction in updating time and eliminating the risk of entering errors compared to standard Excel input.
• Utilized Excel VBA to monitor material consumption. Generated a material consumption formula to calculate the cost of materials to promptly update the inventory. The time required for this task decreased by 40 minutes each day. Furthermore, enhancing the precision of data updates leads to a significant 80% reduction in updating errors.
• Conducted risk analysis of industry trends, the marketplace, and new market recommendations to identify and evaluate prospective business prospects for the online store. Hopefun Electronical and Mechanical have successfully launched two online stores on Alibaba and made in china.com, specializing in diamond credit, within two years.\

Leave Reason: Immigrate to Canada

• Improved operational efficiency by identifying and implementing process enhancements through the use of ERP software, and optimizing workflows using Homebase.
• Assisted in the development of long-term strategic plans aimed at improving overall company performance and profitability. Facilitated the successful expansion of 5 franchise stores for Hazukido.
• Analyzed data trends using multiple data visualization tools including Stata, SQL for informed decision-making, leading to cost savings and improved performance.
• Developed comprehensive reporting tools Vlookup to enhance visibility into key business metrics for stakeholders.
• Enhanced collaboration between cross-functional teams by establishing effective communication channels and facilitating meetings.

Leave Reason: Further education for Master's Program

• Cultivated and maintained solid connections with important clients to guarantee client satisfaction and allegiance. Engaged in daily communication project with accommodation property managers globally.
• Increased client satisfaction through the detection and resolution of problems and complaints. Customer satisfaction was 98% according to the review.
• Identified opportunities to upsell and cross-sell additional products and services to customers to increase revenue and maximize customer value. Achieved over 120% KPI.
• Evaluated client feedback and offered suggestions for improvements using the B Culture System to raise the standard of the overall customer experience.

Leave Reason: Booking.com shut down Toronto Office due to Covid-19.

• Collected documents included meeting notes, project updates, notification of adjustments, claims, and economics-related spreadsheets prepared with various Microsoft apps such as Excel and Word.
• Contributed to the data library of the project's labor contract, formed the labour contract account, and assessed the material purchase and mechanical lease agreements by Excel and Stata.
• Conducted monthly project cost analysis and assisted in compiling project completion documents and an economic analysis of construction costs. Generated cost data visualization modelling by Stata to optimizing company benefits.
• Obtained Awards of Best Performance Intern 2018.

Leave Reason: Completed Summer Intern