Hai Dao Email & Phone Number

Canada

Canada

Hanoi, Hanoi, Vietnam

- Manipulated data by SQL and excel to build automated daily loan and cards reports for CEO and sales department (by regions, channels and Sips) with metrics like daily disbursement, month on month (MOM), month/year to date (MOD/YTD), target, KPI achieved, forecast, approval rate etc. to give out descriptive analysis and warnings of SIPs/Region having low performance. - Made weekly and monthly sales report with interactive visualization in Power BI for sales department and CEO’s meeting in regard to metrics like sales revenue, team-size, productivity, operating sales, operating rates and other ad-hoc requests by sales directors.- Proposed monthly Sales contest: Running simulation (estimated budget), getting approval, updating sales contest results with interactive visualization, calculated and made payment for more than 2,000 sales (incl. RSM, ASM, Team-leader. DSA and FDSA).- Handling daily ad-hoc requests assigned by sales director (DPD, insurance rate, fraud, FPD 5+, MOB4 report etc.) for sales push.- Responding and handle sales’ queries regarding incentives, sales contest and sip contest - Setting condition for min target allocated to SIPs, updating their target monthly on SQL server for all automated reports.- Employing SQL to update reconciled cases on data-warehouse (DWH) for Incentive and Sales Contest calculation.- Proposing SIP contest budget monthly. Calculating sales’ results and making payment.- Migrating data from old server to new server (DWH). - Top 5 students of Lotte Finance data club with certificate granted

Thụy Khuê, Hanoi, Vietnam

- Providing consultation services to students and parents regarding British Council courses (myClass, IELTS etc.) - Employing CRM to monitor daily sales performance so that appropriate actions can be taken (e.g making sales report, prioritizing call list, follow up customers)- Manage inventories of promotion gifts, notebooks, folders and brochures - To handle cash desk in the system accurately and payments received correctly for course registrations/placement test/examination registration and other products/services

- Providing consultation services regarding undergraduate, postgraduate and pre-university programs for parents and students- Employing CRM to follow up and make sales report to line manager.- Making reports to manager by survey to gather student’s responses after school visit experiences (facility, programs, faculties etc.) - Weekly meeting with marketing & IP team to figure out the best action for previous & upcoming events.- Organizing and leading school tour for high school students to BUV (making checklist, coordinating with IT and faculties, rooms booking, picking up students & teachers, leading tours and supporting faculties like translating)Taking part in the organization’s internal and external events like sales events such as Open day, Info day, Open ceremony, parents meeting etc.- Achievements: consulted and enrolled of 55 students in 2019

Hanoi

● Conducting market research with Nielsen, Ipsos and Kantar- Concept test and product taste test: brainstorming concepts (product, insight, slogan), consumer test (type: focus group), current usage/ trigger & barriers of consumers. - Quantifying the data of the research with visualization for decision-making.● Yearly campaign: built integrated marketing strategies (communication roadmap), including:- Made creative brief for agencies, pitching & selecting, selecting promotional gifts, visibilities design (e.g poster, wobbler)- ATL channel: media booking, PR, viral clips production, Key visual production, OOH and LCD bookings- BTL channel: planning & executing on-ground activation: sampling & selling, games & redemption, on-pack promotion, monthly promotion programs for retailers.- Digital: managed social media channels like Monte fan-page and ensure the KPI of all metrics: page likes, google display network, mini games, content ads, microsites etc.- Made weekly marketing reports to sales director of different channels like number of hits through sampling, activation activity, number of customer visits and likes in social media with interactive visualization.● Handle custom data (volume of imported product monthly) with data analysis and graph visualization for BODs.● Proposed suppliers’ quotation to finance department, marketing director and chairman for approval.● Created purchase request, get approved, making purchase order and GR (for final payment) on SAP system.● Achievement: - Successfully organized such campaigns as Monte re-launch, Thank You Mom with the growth of 120% KPI in sales revenue.- Presenting an integrated marketing plan and receive sponsorship of 75.000 euros from the distributor (Zott)

Post-Graduate Certificate, Business Analytics, Gpa: 4.0

- Statistics and applied math like Anova, Correlation Coefficient, Linear regression etc. - Learning SAS. SQL and Python for statistical.

Bachelor Of Science In Business And Economics, Economics

- Statistical analysis - Macro and micro-economics - Corporate finance