Goal-driven Analyst polished in managing and breaking down large volumes of information. Proactive at heading off issues in operations, workflow and production by uncovering trends affecting business success. Over 20 years of experience in Retail, Wholesales, Trading, Manufacturing & Service industries.
Overview
23
23
years of professional experience
Work History
Freelance Analyst
Various Companies
Hong Kong
08.2022 - 10.2023
Provides analytical function for various companies including job for data visualization & data automation for various report ,i.e
Dashboard setting & implementation; Big Data Data Visualization
FP& A function including Business process improvement project, data automation & for various report i.e
Key metric report, financial result & variance analysis.CAPEX Big Data Analysis
Provide Accounting function support for AR, AP & GL
Financial Reporting - Analysis & Modeling
Property Leasing Administrator
Lee Family
Hong Kong
02.2020 - Current
Manage all leasing and tenancy matters including tenancy administration, daily operation of the leasing properties
Responsible for tenancy terms negotiation
Build business network and maintain good relationship with tenants, property agents, developers and stakeholders
Founder
LL Beauty
Hong Kong
02.2019 - 10.2023
Create a wholesales & retail cosmetic on- line business
All-in one business for customer service, sales, shipping & logistic to customers in local and oversea
Assistant Business Planning Manager
HKT Teleservices
Hong Kong
08.2016 - 02.2019
A key player in producing the P&L analysis and forecasting reports for overall 20+ business units (BU) across the business
Partner with the senior management for the development of Annual Operation & Business Plan
Prepare the forecasts, annual budget and business plan in conjunction with all to facilitate Senior Management Team’s sound decision making to support the aggressive business expansion across the region
Project Management for Cathay Pacific Asia Miles Program
Other responsibilities include management/ KPI reporting, forecasting and analysis, financial modeling and reviews, sales and bidding support, client contracts management, commission schemes management as well as M&A project support
Perform financial planning & analysis in order to provide up to date recommendations for decision making
Compile financial data to facilitate regional leaders’ decision making, optimize business performance and drive long term business growth
Carry out financial analysis on balance sheet and P&L for cost control
Reports & Analysis Includes: Connected Party Transactions, Internal Audit for Commission calculation, CAPEX Calculation, Sales Contract Review, Revenue & Cost Provision, Monthly Consolidation for different BU & subsidiaries included PRC and Oversea subsidiaries
Other Analysis includes: Liaison & Commission calculation for Managerial grade or above; Provide financial data and forecasts on key metrics of business performance (including Sales, GM, OPEX and EBITDA) on weekly and monthly basis; Project management for major client
System: Oracle, Hyperion & Access , SQL, Marcos
Business Analyst
Hop Lun Hong Kong Ltd.
Hong Kong
07.2015 - 06.2016
Responsibility for monitoring & analyzing for Financial (Sales & P&L Analysis) and Inventory related projects
Created various financial models to accurately forecast sales, revenue, margin and expense
Standard Cost calculation, Margin forecast, and Scenario Summary for Seasonal Cut-off categories includes detail cost analysis
Review existing materials and process costs (SMV cost) periodically, analyses the variances between standard costs and
Analyze sales and business performance providing insights and action plans to senior management and stake holders
Interpret custom data into easily understandable reports for senior management and stakeholders
Analyze sales and business performance providing insights and action plans to senior management and stake holders
Analyzed unstructured data to build customers behavior models
Automated various reports that increased accuracy while decreasing reporting time
Revised business performance metrics in collaboration with IT, which increased transparency on sales key factors
Collaborate with Sales team and other branch offices to improve the business performance
Example includes assist in develop and executive credit control policy to improve AR cycle, reduced and monitored unshipped inventories, reduced obsolete inventories to enhance cash flow
System: ACCPAC
Senior Financial Analyst
TGT Sourcing Asia Ltd (Subsidiary of Target Australia)
Hong Kong
11.2013 - 12.2014
Provided financial support focusing on several areas including budgeting, planning, and analysis
Identify trends, measure performance KPI’s and drive revenue growth and expense savings through analysis and liaison with team and operational managers
Work with the manufacturing business, supply chain and pricing team and continually review and enhance the planning and budgeting process take ownership to produce financial reports, communicate and clarify deliverables and standards of performance to senior management
Prepared periodic management and variance reports tracking actual compared to budget results
Coordinated cross-functional teams to meet external customer/consumer needs while meeting financial targets
Drive the effective implementation of a market oriented business intelligence system and establishment of a database to track relevant KPI
Developed weekly/monthly book reporting of key performance indicators helping division heads to more effectively evaluate productivity, operations and sales
Reports includes top products analysis by different categories
Developed accurate, timely and comprehensive financial reports to facilitate management decisions
Collaborated with business partners in building forecasts and business plans; analyzed revenue trends and general business conditions
System: SAP FIFO, TM1, ODMBS, iTrade
Costing Analyst
Newry Group
Hong Kong
09.2009 - 11.2013
Product Costing Analysis function included Pre-shipment Costing Analysis, Post-shipment Costing Analysis and Variance Analysis
Pre-shipment Costing Analysis for Risk assessment and profit forecast
Develop, enhance and prepare management reporting systems, report for any abnormal changes on timely basis
Post-Shipment Costing Analysis for performance evaluation
Prepare timely management reports
Ensure for accurate, correct and complete information to obtain sufficient and appropriate information for post shipment evaluation
Variance Analysis for analyze variance between Pre-shipment and post shipment data to provide details for such variance to management to implement better cost control solution
System Implementation – SAP Costing System: Coordinate with IT Department on application support and business team develops, coordinates, and implements plan to test costing process during system development and assurance testing
Successful implemented Pre-shipment Costing system and Post-shipment Costing System
Skillful analysis the variance between the pre-and post-shipment and in-turn help up the management to overcome the cost variation
Streamline the finance management system to synchronous with costing
Streamline internal control procedure to strengthen the management system
Work closely with senior managements and handle management directives in a cost effective and efficient manner
System: SAP Business One , ACCPAC
Financial Analyst
General Mills Hong Kong Ltd
Hong Kong
11.2004 - 05.2006
Core responsibilities included business development financial analysis
Evaluated Business Performance by performing Transaction Analysis, CEP Analysis, KPI Analysis, and conducting Business Scorecard, Sales Flash, and Shop Benchmarking
Accountant and Administrator
Staff Management Consultancy Ltd
Hong Kong
06.2005 - 02.2006
Core responsibilities including responsible for the Full set accounting (AR/GL, AP/GL and GL function) and Payroll administration, performance assessment and staff activities
Assistant Accountant
American Bureau of Shipping (ABS)
Hong Kong
09.2001 - 11.2004
Account Receivable and Billing: Reconciled revenue to client accounts, responsible for bank reconciliations & journal entries
Financial & Project Analyst
Unique Timepieces Watch group
Hong Kong
11.2023 - 04.2024
Sales Analysis by Different Sales Channel, Brands, Catergories
Rolling Forecast Update
Month end Report and Budget variance
Analyzed project requirements and developed detailed plans for successful implementation.
Identified potential risks and created contingency plans to address them.
Provided regular progress reports to stakeholders on the status of the project.
Evaluated performance metrics to identify areas needing improvement within a project.
Created templates and processes for tracking data related to projects.
Education
Student Member, Completed Module C,D -
HKICPA
10.2020
Bachelor of Commerce -
University of Auckland
01.2001
Skills
Microsoft Office
Excel
VBA
SQL
Access
Power Point
Power BI
Data Visualization
Dashboard
Hyperion
TM1
SAP
Oracle
ERP System
KPI
CAPEX
Big Data Analysis
Financial Reporting - Analysis & Modeling
Budgeting & Forecasting
Business Process Improvement
Sales Performance Analysis
Commission Analysis
Trends Analysis
Top Products Analysis
Top Clients Analysis
System Implementation
Data Analytics
Financial Statements Expertise
Financial Management
Cost-Benefit Analysis
Account Reconciliation
Budget Forecasting
Data Processing
Data Modeling
Data Mining
Finance
Languages
Cantonese, Native or Bilingual Proficiency
English, Full Professional Proficiency
Mandarin, Full Professional Proficiency
Timeline
Financial & Project Analyst
Unique Timepieces Watch group
11.2023 - 04.2024
Freelance Analyst
Various Companies
08.2022 - 10.2023
Property Leasing Administrator
Lee Family
02.2020 - Current
Founder
LL Beauty
02.2019 - 10.2023
Assistant Business Planning Manager
HKT Teleservices
08.2016 - 02.2019
Business Analyst
Hop Lun Hong Kong Ltd.
07.2015 - 06.2016
Senior Financial Analyst
TGT Sourcing Asia Ltd (Subsidiary of Target Australia)