Jade Chen Email and Phone Number

Analytics Capstone Lab(ACL)Project-Workplace Analytics

-Increased 10% logistic margin by creating monthly P&L reports with Excel to identify and measure cost reduction and margin improvements of 100+ key accounts and roll out contract renewals.-Achieved 90% on-time food delivery and improved on-time assignment of food delivery drivers by 3.5% by building analytics experiments and reports to adjust operation and launch tipping campaigns during lockdown in Taiwan.-Worked with data teams to automate standard reporting and improved reporting accuracy by 50% by ensuring data quality in Excel(index, conditional list, pivots, lookups) before updating the database.-Achieved decrease in incident rate by working with 2 main delivery partners in Taiwan to resolve customer complaints, negotiate compensations, and optimize internal procedures.

-Achieved 110% revenue target for 20 product lines in 2019 by analyzing historical data, setting budget, and providing weekly revenue insights to the CEO and executive team.-Optimized 10% of the supplier contracts and increased 8% annual profits by establishing supplier segmentation and applied classification to provide recommendations for supplier contract negotiations.-Achieved 15% margins for the ecommerce business unit by reviewing stagnant inventory and setting up key performance metrics with spreadsheet models.-Reduced the company’s annual logistics costs by 29M in 2019 by conducting exploratory data analysis, identifying key monitoring metrics and building an anomaly detection report.-Increased automated billing issuances by 21% in 6 months and saved a total of 600 hours/month of labor across 4 departments by initiating an internal paperless process.-Designed 3 automated reports in the internal database for teams across Sales, Finance, and Operation departments to use by identifying key metrics, building spreadsheet models and working with data teams.

-Identified top 3 sources of traffic for 5 products to improve search engine optimization by creating web traffic analysis(CTR, traffic sources, visits, conversion rate) using Google Analytics.-Established monthly regional marketing reports on trends and competitors for over 10 overseas branches by using Google Trends and Google keywords.-Developed 2 Facebook posts and reached 80k likes and over 100 shares for ASUS Global social media campaign to promote J.D. Power award recognition.- Assisted the execution of 2016 Computex seminars and press event.

- Coordinated social media campaigns on recruiting, activity promotions and web material designs.- Planned and executed new brand marketing strategy by interviewing 10 Taiwanese NPOs and published on NPOst.org column, increased future partnership opportunities and brand awareness.- Student consultant project on website optimization by conducting target audience interviews and website user interface case studies.