- Own the design, implementation, and delivery of BI solutions for the business, oversee the design of data structure, create data pipelines, and manage Redshift cluster.- Collaborate with Product Manager on product launches, define business prerequisites, design metrics, generate targeting customers, onboard metrics pipelines, and launch business reports for every new launch.- Managing A-team Goals and business reports for strategic projects, delivering deep-dive business analysis including Customer Journey, Segment Analysis, Downstream Impact Analysis etc., innovating metrics for business healthiness and early success checking, providing business insights, and supporting the presentation in Executive meetings.- Manage priorities and roadmap for the BI team, create and own the review mechanisms with key stakeholders.- Innovate self-serving tool including Tableau dashboards, daily business flash, and campaign usage alerts for product team, developers, and partner teams.

- Generate business reports based on merchant-level data, providing valuable insights for seller onboarding strategy.- Deliver deep dive analysis, finetuned the seller success model, and refined the tracking metrics definitions.- Launched hits and missed charts for the sales team to evaluate the leads and merchant performance.

- Dive deep into transaction data and member level data, generate matrixes to point out issues and create thoughtful and robust business analysis (R and Excel)- Lead initiatives including Predictive Model, Factor Analysis, Store Clustering and Segmentation, Price Elasticity, Perspective Pricing Model etc (SQL, SAS, Hadoop / HIVE), build pricing model and Network Pricing Strategy - Build Promotion Calendar and AB testing for E-commerce and in-store channel, create and present weekly measurement dashboard (APT platform and Tableau) - Take part in monthly planning; collaborate with Merchants Team, Marketing Team, Customer Analytics and Store Operations teams for price coupon offer test, execute price strategy in timely fashion- Automate price execution and validation process, build template for merchants to better negotiate with vendors

- Delivered strategic recommendations for a content distributor client to strengthen its power position in the media ecosystem based on analysis of over eight billion rows of transaction data- Analyzed customer viewing behavior and profiled heavy users; drew insights and provided recommendations for bundled TV shows using Market Basket Analysis- Collaborated in a team of five using SAS, R and Excel to analyze data, generated Logistic Regression Model for predicting success of new shows at early stages to help content provider to manage schedule

- Delivered a product development plan to help generate $1.2 million revenue for the upcoming year- Segmented existing clients, analyzed client and user reviews of current product to redefine the target client - Built positioning map for new product; sized the market from three different approaches- Created pricing strategy (Tier Price and Bundled package); provided different scenarios of financial implications and recommendations

- Led team of two specialists, developed and executed promotional campaigns and brand events for in-store and e-commerce platform - Analyzed market and customer-level data, defined segmentation and targets using Excel, SPSS and R- Conducted weekly analysis report and provided strategic recommendation for top management; tracked annual P&L and marketing A&P- Took part in annual marketing planning, presented marketing performance and insights to GM of Asian area- Organized and implemented PR events as project manager, managed media and press coverage of product launches and brand events, established SEM strategy for beauty products brands