Xinyue Chen Email & Phone Number

Toronto, Ontario, Canada

• Update weekly dashboards and productionize ad-hoc reports in Looker, design 40% of new metrics for the LCU dashboard, and guarantee the output to help stakeholders evaluate important metrics.• Initiate QA process to monitor significant metrics such as sales, test each version before launch, design logs to ensure functionality and track failure, and reduce sanity check time by 50%.• Optimize dashboard performance by launching cost analysis, remove duplicated metrics that cost 30% of… Show more • Update weekly dashboards and productionize ad-hoc reports in Looker, design 40% of new metrics for the LCU dashboard, and guarantee the output to help stakeholders evaluate important metrics.• Initiate QA process to monitor significant metrics such as sales, test each version before launch, design logs to ensure functionality and track failure, and reduce sanity check time by 50%.• Optimize dashboard performance by launching cost analysis, remove duplicated metrics that cost 30% of extra computing power to maintain efficiency and control costs. • Perform ad-hoc analysis using SQL, Python, and Web analytical tools, and collaborate with cross-functional teams to troubleshoot the problems, and deliver insightful stories.• Clean competitor merchant lists with 1M+ inputs, design a workflow to match competitors with transactions, compare competitors’ order volume, sales and AOV to investigate the reason for competitor outperformance.• Hold three Q & A sessions to coach 150+ internal users to manipulate the dashboard.• Conduct price monitoring by comparing CTR prices with Amazon and Google, and monitor product popularity and price across different periods.• Retrieve Amazon Top 100 products key information (ASIN, regular and promo price, rank, URL) using Python scrapers (Selenium, BS4), and construct ETL pipelines in Apache Airflow for process automation.• Designed a dashboard highlighting top trending products with promo prices within the last 4 weeks, and recommended the promotion of 50+ products, which generated $3M+ sales during the promo period. Show less

Canada

• Developed a scraper in Python using BeautifulSoup and Selenium to automatically retrieve daily new job posting information, including job title, description, URL, etc.• Developed a rating algorithm from the client requirements to assign scores to resumes based on keywords overlapping with different open positions.• Built an ETL pipeline to store the information in the AWS MySQL database and send the top 10 matching positions to the client every day, achieving 100% efficiency in job… Show more • Developed a scraper in Python using BeautifulSoup and Selenium to automatically retrieve daily new job posting information, including job title, description, URL, etc.• Developed a rating algorithm from the client requirements to assign scores to resumes based on keywords overlapping with different open positions.• Built an ETL pipeline to store the information in the AWS MySQL database and send the top 10 matching positions to the client every day, achieving 100% efficiency in job searching. Show less

Master Of Engineering - Meng, Electrical And Computer Engineering, 3.8

Activities and Societies: Data analysis & Knowledge Discovery (A) Stochastic Processes (A+) Digital ASIC Design (A)

Bachelor'S Degree, Microelectronic Engineering, 3.6

Activities and Societies: Xiamen University Alumni Scholarship (Top 10 %)