Data Analyst

• Mar 2023 - Present

Account Management - Case study development

• Apr 2022 - Aug 2022

* Customore, service company for clients, distributors in Ecommerce platforms in SouthEast Asia which provides wide range solutions to help business. Offering not only Visualization Dashboard Report but also advanced analytics help clients insights and solutions such as promotion mechanics, market share, best bundle combination analysis, buyer analysis, forecast, media, etc * Case study development: - Get and cleaned raw data using SQL, Power query from database, exported data (source: Shopee Brand Portal , Lazada Seller Center) - Analysis using pivot, power query to help finding insights, answering business questions, business problems, outcome and taking action,... - Wrote the content for case studies which are used for publication on website, clients sharing, digital content. (Finished 8 case study contents) * Understanding e-commerce clients in Southeast Asia ( FMCG categories): - Joined meetings with clients Nestlé, Colgate, Mars, Unilever... from South East Asia countries. - Supported Strategic Account Manager for meeting catch-up. - Worked with Data analysts/ Data scientist to solve client's requirements as well as business problems from brands, categories, e-commerce platforms. - Followed up tasks using Notion, Slack to easily communicate, manage the process with other teams * Other Ad-hoc tasks: Ad-hoc analysis, client management supports, front-end checking report to make sure data availability, raised tickets of bugs if needed to Data Analytics team. Show less

Assistant Area Manager

• May 2015 - Dec 2015

Assisted for region manager in all action plan which support store opening included: - coordinated with legal department for contract procedures. - supported HR department for new recruitment. - planned and followed up timeline to achieve store opening schedule. - Worked and supervised regional teams (store managers, store assistant managers in Vung Tau, Phan Thiet) on behalf of region manager. - Worked with other departments (Finance, Admin, Safety, Training) for smooth and fast process. - Dealt with landlords to sign the contract which will be allied with company legal. And other related tasks for store opening preparation. Show less

Field Operation Supervisor

• Oct 2010 - Mar 2013

Assisted Field Operation Manager on supervising, coaching sale teams to make sure visit plan, daily-weekly-monthly target. - Action plan for sale improvements through customer visit, events, price and promotion program, payment control,... - Dealt with others department (Finance, Purchasing) for better price, order, payment between customers and store. - Analyzed data and supported manager for action plan to team's target. Assisted Field Operation Manager on supervising, coaching sale teams to make sure visit plan, daily-weekly-monthly target. - Action plan for sale improvements through customer visit, events, price and promotion program, payment control,... - Dealt with others department (Finance, Purchasing) for better price, order, payment between customers and store. - Analyzed data and supported manager for action plan to team's target.

Asistant brand manager

• Jul 2007 - Oct 2010

Handled and assisted all marketing ATL (Above the line) and BTL (Below the line): planned and executed to marketing plan, media, research, product development, promotion, event, sale analysis. • New product development: new recipe, new package design for products launching. Responsibility included: - worked with RD and production for product development - made the detailed plans for media, research (product, packaging evaluation among target customers) •Research approach: planned, briefed, observed with agency for all research such as media evaluations, brand equity, marketing plan, new product launch, new Ads, new recipe,... •Promotion: included attached promotion, events: - Prepared promotion item: dealt with suppliers in term of contract, delivery, payment - Coordinated with production team, sale team for promotion scheme - Evaluated the effectiveness of promotion scheme to have next action plan. - Events: consumer events in nationwide, observed the event execution and evaluated the effectiveness. •Media tracking: billboard, TV channel approach: - billboards: checked the appearance, location, competitiveness for better budget allocation. - TV plan: set target, budget for media plan. Briefed and checked proposal from agency. Evaluated base on TNS tracking and other brand research. • Plan: made the marketing plan, sale analysis (sale data and Nielsen data) Show less