Provide insights and analytics solution to 5Miles' top level decision making.Routine:Constantly explored new businesses and opportunities through regular data mining; Frequently tested hypothesis about new idea from CEO and COO.Created and designed business metrics and BI reporting dashboards, based on requirement from operation side.Worked with data engineers to maintain existing data warehouse, and communicate data collection needs.Projects & Achievements:Created segmentation for 5Miles' general user, paid user, and seller, enabled diversified strategies on each user segment.Continually optimized 5Miles' sales tools product, provided deep and multi-dimensional analysis on sales tools' performance, conversion funnel, user behavior...to help sales tools' growing and doubled revenue. Designed the listing fee model through data analysis on sellers' listing behavior, evaluated the potential demand and loss, forecasted the profit and measured the impact. Built predictive model based on all sorts of generic behavior variables, characteristics, to predict user's retention and conversion, discovered key factors or steps that really matters.Tools&Skills Used:Python, R, Mysql, Presto, Amazon EMR, Excel, GA

Responsible for global site search experience, built search terms segments, analyzed search failure and after-search behaviors, provided suggestions to increase site search conversion up to 23%.Developed and integrated the site search analysis into Power BI Dashboard, provided a monthly refreshable picture of whole site search story for every country, as well as deep actionable insights and solutions.Built 360° view for online customers, based on their demographics, site usage, search and shopping behaviors, customer life cycle and lifetime value, improved effectiveness for all sorts of marketing campaigns by 35%.Developed product data quality assessment process for all Rexel banners across the countries, and help with implementation of product data enrichment dashboard on Power BI. Built online customer churning model(works 80% accuracy) to predict customer churn, based on their past behaviors on the site. Analyzed campaign performance for targeted brand, identified the best opportunities to engage with customers. Performed association rules mining to enhance and validate current product recommendation functionality.Other responsibilities:Took care of all kinds of data pulling, data manipulation, analytics work according to requests, frequently work with various data sources, like Google Analytics, integrated data warehouse, local product information management, customer survey data, etc.Collaborated with people at all level in the team across the countries on different projects, via conference call routinely.Tools used: R,Excel,Google Analytics,Tableau, Power BI

Assessed candidates, recommending the best final candidates, filling the staffing needs within defined timeline. Evaluated recruiting cost by analyzing multiple recruiting channels, reduced cost per hire by 15%. Predicted employee churn (logistic regression) using Excel Solver, figured out factors causing employee to leave, helped working out the employee strategy that increased the retention rate by 18%. Made scheduled analysis reports via Excel Pivot Table and respond to any ad hoc report requests.

Designed and developed a website for a government program, using Linux+Apache+MySql+Php architecture. Determined the requirement specification, designed the database and website structureLed the team to implement it and met the government’s need within the deadline.