Lead the business research and data analysis project for clients in the retail industries, conducted weekly meetings from scoping the project, to providing data-driven insights and proposing solutions for implementation Identify key metrics and construct various dashboards using Tableau and Google BigQuery to analyze customer behaviour from Google Analytics data, reducing management time cost by 30%Utilize expansive set of analytical methods such as cohort analysis, segmentation, AB testing etc. to streamline the clients’ decision making process and marketing resource allocation

1. Assisted the university faculty with the management of 3 undergraduate courses consisting of Media, Technology and Education classes with a total of 85 students2. Reviewed curriculum assignments (e.g. digital media artifacts and e-portfolio websites) and provided constructive feedback to promote their critical media literacy and cultivate professional technological practices3. Integrated diverse interactive technologies such as PearDeck, Kahoot and Minecraft to facilitate student collaboration, improve education accessibility for students with disabilities and establish flipped classrooms

1. Successfully led a research team to assess the e-commerce retail industry in the US stock market and provided 8 detailed reports, which involved cross-functional collaboration and timeline arragement2. Completed detailed analysis of the companies such as Amazon, Carvana, and Shopee by leveraging various platforms, e.g. Investopedia for financial reports, Finviz Screener for market cap, and Statistica for microeconomic data3. Applied Business Model Canvas and Porter’s Five Forces Model to investigate the financial performance of different companies, including ROI, GMV, net incomes and core competitiveness to predict future market size

1. Assisted the core development of the new human resources backend system using Oracle and PeopleSoft with other departments, maintained departmental database and wrote automated SQL queries for reporting, staffing analysis, and ad-hoc requests2. Identified and actively tracked the key performance metrics for the team, which helped managers to streamline staffing processes, such as employee onboarding, internal transfers, professional development programs, resignations etc.3. Maintained the employee dashboards, provided bi-weekly updates regarding action items to the manager and assisted the employment management and operations