Yuting Li

Experience

• 

  Shanxi Guye Entity Ltd

  -

  Marketing Intern

  - Worked closely with and coordinated among administration, supply and internal marketing team.- Collaborated and built relationships with sales, product management and development and industry experts.- Monitored fundamental economic, industrial and corporate developments to determine the effect on company’s performance.- Provided leadership and analytic support in the marketing events.

• 

  New Thoth Company Ltd

  -

  Financial Analyst

  - Assembled spreadsheets and analyzed financial info to produce the new calendar year Capital Budget Forecast of business.- Performed financial analyses (cash-flow, what-if analyses, scenarios analyses) to illustrate technical reports.- Identified trends, reconciled data and made presentations of analyses and recommendations to senior management.- Assisted with checking credits and filling in transaction cheque and accounting voucher.

• 

  Thermatool

  -

  Marketing Data Analyst

  - Performed detailed sales, cost and profit analysis covering 5 years of data, sorting and summarizing it into a graphical format based on model, product mix and geography.- Utilized SAS to analyze data from various sources, and generated reports on a regular basis.- Developed SAS programs to segment, model and profile customer transaction data.- Improved productivity by developing automated applications (macros) and eliminating duplications.- Tracked financial status and marketing campaign effectiveness by monitoring variances from plan and analyzed plans and forecasts with actual results.- Used appropriate techniques e.g. the application of extensive predictive modeling to enable more effective data driven business decisions. 收起

• 

  BlueFocus

  -

  Data Consultant

   Support 2 data related systems: Marketing Data Platform and Influencer Monitoring Platform. Closely work with product managers and team members. Mainly responsible for analyzing data from multiple sources and presenting the result, including:a) Define, sanitize and standardize data structures from different data sources (social, research, DSP) to ensure data consistency and accessibility.b) Build business models/ metrics by adapting statistical methods that support marketing strategy and impact evaluation.c) Provide computational logics to developers or use Tableau for data visualization. Closely work with account team, understand the client demand and provide visually impactful reports with full understanding of the macro & micro environment the brands are facing and the customer they are dealing with, such as quantified the users’ feature and facilitate media strategy. Act as liaison between the business and data suppliers. Responsible for evaluating supplier data sources, understanding business demands and assisting in decision making on supplier selection.  Act as mentor in the ’BlueView Certificated Data Analyst Program’, mainly help account team member to better understand different data sources and introduce basic analytical skills and help perform deeper data application for their business problems. 收起

• 

  AdMaster

  -

   Provide social campaign consulting service, understand demand of client and intention of the campaign, help client better understand the social environment, then accordingly offer campaign tracking and evaluation service, crisis tracking analysis, spokesman evaluation, occasion study, KOL evaluation and suggestion, brand vs. competitors’ comparison analysis. Key clients including RB, Mars, GSK, Tencent and NBA. Manipulate large amount of data using excel from different sources, use KPI to analyze and evaluate performance and give out reasonable advice based on certain period of data independently and with team members in the form of PPT. Help brands measure the effectiveness of their digital marketing investment. Participate in the campaign of SNICKER Exam project, win the silver award in ROI Festival Give financial support including collecting financial support files, generating client contract and applying for invoice within team. 收起 AdMaster is China’s leading data solution provider specialized in data collection, analysis and management. By using cutting-edge, proprietary technology, we create value for businesses by turning big data into smart data and delivering it to them through our software-as-a-service platform, enabling them to make more informed decisions and gain a competitive edge.Our core services include third-party digital advertising verification, social media and e-commerce measurement, and data management – including data obtained from personal computers and mobile devices. 收起

  • Senior Analyst

    -

  • Data Analyst

    -
• 

  USANA Health Sciences

  -

  Business Intelligence Supervisor

   As the only BI team member based in China, closely work with Sales, Marketing, and Customer Service team, understand the business goals and translate them into measurable metrics and visualized reports. Main responsibility includes:a) Extract data and design business reports from internal data warehouse mainly for regular tracking of Key index to evaluate the growth and health of the Chinese market.b) Apply statistical methods to optimize marketing campaign promotions, define business metrics and create dashboards to evaluate campaign performance. c) Collaborate with engineers and database administrators to trouble-shoot and fix MSTR report issues.  Customer behavior analytics: provide customized data analytics such as customer profiling, customer loyalty study, customer retention, customer life cycle. Perform correlation analysis of promotion effectiveness and forecasting analysis of customer sales using R. Help the headquarter office understand China Market environment and China consumers digital behaviors. User experience optimization: Official Website/App analysis by detecting customer purchasing behavior and using Baidu analytic to track the website behavior to help improve the user experience. Provide essential training of BI tools (MicroStrategy, SSAS in Excel) to business teams in China Interpretation of the formatted reports and build out customized dossiers using the existing objects (attributes & metrics). 收起