Public Profile

- I worked for Metro Cash & Carry Viet Nam as position Senior Controller around 8 years (01/2007 – 11/2014).

DETAILS OF WORKING:
1. Forecasting:
- Create all templates as PL, BS, Short PL/Notes, Investment, Capital Expenditures, Delivery / Field Force / Own Brand and Customers… for preparing next 3 years forecast
- Based on figures which were received from all related departments as well as history figures of previous years to prepare/update into the standard templates with reliable figures for next 3 years forecast
- Review/revise all figures as well as suitability with group targets, then upload data into management system (SAP: BW, ECCS)
- Based on forecast figures, actual figures of previous year and targets of next year to prepare budget for whole year at beginning of the year as details
+ Sales: work closely with sales function to forecast reliable monthly/yearly sales (incl. high volume sales, own brand sales and promotion sales) and front margin. Coordinate with marketing function such as promotion, event as well as Gift Voucher/ Sales Incentive Bonus to customer that impacted to Margin
+ PL: integrate the Sales (incl. gross profit, sales deduction, later income…), Costs (incl. cost of goods sold, personnel, leasing, and energy, advertising…) and others into the PL template in order to finalize the full PL with the reliable EBIT/EBIT MV
+ BS: based on PL, CAPEX, Working Capital (incl. inventory, payable/receivable...) figures as well as the beginning balance figures of BS to prepare/update for BS data
+ CAPEX: to prepare capital expenditures basing on the new investment figures, repair and maintenance budget
- Create tools which support for uploading and collect all related figures in order to upload into the management system.
- Based on budget figures and actual figures of previous months then do adjustment in order to prepare the best suitable forecast for each month during the year
- Check, review and get comments for all related business cases which are prepared and summited by other colleagues/depts.
- Prepare and summit to the management board the full investment proposal (IP) package of new investment cases (supper market centers) incl. investment expenses, PL statement, customer status, cash pay back, EVA, NPV… and then align with group controlling in order to get approval from group management board

2. Actual:
- Prepare all figures for pre-closing with some scenarios, as: PL, CAPEX, and BS
- Compare these actual figures with forecast figures in order to decide to do more accrual or release for suitability
- Upload data into the management system
- Run and send out the commentary package to region Asia and group controlling as well
- Provide the full PL report to stores (19 stores) variances of actual vs. bud, vs. forecast and vs. PY

3. Reporting:
To prepare all management reports as daily/weekly Sales, PL, BS, CAPEX, Customers, Inflation and Investment… including KPI analysis reports, slides for management meeting purpose
To analyze:
the stock incl. minus stock, old stock, average stock, stock aging, SVA…by store/category
the customer figures incl. # of buying/visit customers, sales/profit/margin/frequency/sales per visit/buying rate… per categories per stores
the sales/margin by store/category such as: daily/weekly sales commentary reports, high volume/own brand/promotion sales reports, margin report
the costs incl. rental expense, advertising expense, direct management/indirect management expenses, other expenses by store/ departs
the full PL (incl. EBIT MV), CAPEX, Customer and compare with the previous years and forecast figures, to find out the reason of deviation in order to explain/ propose the solution for next periods to the related dept. and the management level as well
Manage, control and compare the actual investment figures with the IP figures to explain the deviation and report to group controlling as well

To do another requirements (ad hoc) by Head of Controlling dept. / Management Board