Research and analytics1. Tailor-made research studies (industrial and competitor analysis, media strategy analysis) for an Internet Giant company, helping client explore pain points and opportunities, which earned client’s recognition and new contract2. Led 3 big-data-related research projects to understand consumers’ purchase journey, media behaviors and Ad position effectiveness of e-Commerce retailers3. Provided recommendations and suggestions on blockbuster TV shows for media planning and buying by developing consumer insights from holistic media data incl. social listening→ Conduct analysis to provide clients and planning team with consumer understanding through client service, project management, data analytics and reportingProject/ Team Management (Data reconstruction/ Process optimization/ BI product)1. Lead a team of 4 co-workers, delegating tasks according to their strengths and capabilities2. Manage and facilitate projects through pre-assessment according to clients’ need, on-going supervision, communication and coordination with other departments and companies3. Supervise project team to build up and optimize BI product, bringing in usage uplift of 40%4. Guide project team to design and construct databases for process optimization, leading to work efficiency increase of 30%5. Maintain relationship with suppliers, incl. relationship building, communication, capability assessment• Proficient in SQL，ACCESS，VBA, basic of Python

1. Involved in project design, proposal writing2. Analyzed data, wrote reports and provided recommendations3. Monitored project process, controlled project quality, identified and solved problems promptly4. Designed questionnaires and hosted project briefings

→ Mainly served Colgate, Wrigley, Heinz on product tests, concept tests, name tests, copy tests and U&A, etc.