Senior Operations Data Analyst

• Jul 2023 - Present

Supply Chain Data Analyst

• Jul 2022 - Jul 2023

• Write SQL queries to extract data from multiple database tables, facilitating supply chain analysis and importing data into Power BI for report creation.• Build various Power BI reports tailored to diverse internal stakeholders, such as Supply Chain, Quality Assurance, and Merchandising teams, as well as external vendors, ensuring alignment with business requirements and specifications.• Develop new Power BI reports and optimize existing ones for the newly launched Supply Chain Planning System, delivering valuable insights to enhance supply chain operations.• Support and improve existing reports based on evolving business needs, providing actionable insights for decision-making.• Identify opportunities for continuous improvement and share valuable insights with leadership, focusing on enhancing data accuracy and reducing manual work to streamline processes.• Proactively summarize best practices in workflow and approach, standardize work processes, and share knowledge with coworkers and managers to promote a culture of continuous improvement. Show less

Data Analyst

• Sep 2021 - Jul 2022

• Extracted and cleansed data from multiple sources using SQL and Power Query to ensure data integrity. • Generated key data from complex data sets for marketing campaign performance reviews. • Created weekly sales analysis reports and derived valuable insights. • Provided weekly membership program performance reports. • Maintained accurate inventory data across all E-commerce channels by using a custom tool developed with Power Query to check for discrepancies and promptly resolved any issues to prevent short shipments and ensure timely order fulfillment. • Performed insights visualization for various analysis reports by creating charts, tables and dashboard using Excel and Power BI. Show less

Quality Specialist - Data Management

• Jul 2019 - Sep 2021

• Developed and maintained product lab testing results databases and set up evaluation criteria with KPI/Metrics to assess quality control performance. • Compiled data and analyzed analytical results and made reports for various projects. • Cooperated with multiple teams to provide data-driven product disposition recommendations based on the quality of the products to satisfy various customer needs. • Leveraged data analysis and reporting to bring continuous improvement in Quality Control • Project: Evaluation of Cannabis Stability Data with Statistical Approaches Show less

Research Assistant

• Feb 2018 - Apr 2019

• Developed research projects by analyzing industry data and extracting information. • Led and got involved in several research projects with excellent project management skills. • Wrote research briefings, reports, and papers based on data analysis results, utilizing excellent written communication skills. • Built statistical and econometric models with various modelling approaches to analyze data. • Presented research papers in academic seminars and conferences by utilizing outstanding oral communication skills. Show less

Customer Information Management Analyst

• Jul 2014 - Jun 2016

• Managed the customer information database and verified data integrity and accuracy. • Analyzed and identified customer information management requirements and consulted with and advised senior management and internal teams on customer information management strategies. • Created new analytical insights from large sets of customer data by performing data mining analysis. • Developed and maintained reports that provide reliable insights and visualization into business performance relative to key performance indicators and historical performance. Show less