Christopher Ha Email & Phone Number

Brisbane, Qld, Au

• Reporting– Establishment of reporting framework and implementation of Power BI and SQL database whilst delivering monthly, quarterly and annual corporate KPI reports.– Preparation of annual State Library of Queensland (SLQ) report for 10 public libraries in the council area.– Design of Google review dashboard for sentiment analysis using keyword searches. The report also categorises customer feedback to understand the areas of improvements in customer services.– Design of Moreton Bay region school catchment report in Power BI to highlight events & programming opportunities for cultural services venues.– Development of new library membership forecasting model to assist the senior leadership team and the department manager in resource planning in staffing and budget.• Data Analysis, Transformation & Integration– Designing, developing and supporting Extract Transform Load (ETL) processes to streamline data ingest from Spydus, Library Management System (LMS) to SQL database server via SSIS.– Setting up data pipeline using API for people counter and public WiFi usage at 10 public libraries, 3 galleries and 3 museums in the council area.– Assist with ad hoc data analysis and investigation.Designing, developing and supporting Extract Transform Load (ETL) processes to streamline data ingest from Spydus, Library Management System (LMS) to SQL database server via SSIS.– Setting up data pipeline using API for people counter and public WiFi usage at 10 public libraries, 3 galleries and 3 museums in the council area.– Assist with ad hoc data analysis and investigation.• Stakeholder Engagement– Identify opportunities, barriers and enablers of arts and culture events by summarising and delivering Creative Communities Engagement survey results for both external and internal stakeholders via Power BI Dashboard.– Provide Customer experience and engagement report to both external and internal stakeholders for an Art Exhibition, All the best from Martin Edge.

Brisbane, Queensland, Australia

• Power BI reporting – Maintenance and delivery of Revenue & Ticketing Dashboard for Senior leaders, GMs and MDs. (Power BI data connection: SQL, Excel (CSV) & API) – Development of interactive Profit and Loss statement & Balance sheet for finance team. Ability to drill down to transactional level data for further analysis whilst providing flexibility to slice and dice the data via custom filter. – Crisis reporting - Delivery of timely reporting to Senior leaders, GMs and MDs on COVID-19 lockdowns and its impact on Sales volumes and refunds.• Data Analysis & Transformation – KPI reporting (on Power BI platform) on 2nd level support team's chat function. Assisting team leaders to determine, assess SLAs. – Providing end to end solution for Power BI reporting whilst designing, developing and supporting Extract Transform Load (ETL) processes using SSIS. – Troubleshoot data issues, recommend, test and implement solutions. – Assist with data analysis and investigation. – Interact with cross-functional teams to ensure complete delivery of solutions.

Brisbane, Queensland, Australia

Crisis Management• Power BI reporting – Customer Refund Status Dashboard for internal stakeholders, KPI reportingon the refunds team to determine, assess SLAs and presenting summary of financial data to theexecutive officers, GMs and senior leaders. (Power BI data connection: SQL, Excel (CSV) & API)• Automation and streamline of customer refunds process, validation for dupe payments, overpayment check and other audit process via VBA. Processed payments over 700million dollars.• Team leading & Change management – Managing team of 12, establishing new customer refundprocess to respond to influx of refund requests from COVID.System Maintenance• Responsible for user security (Internal and external) management and monitoring for globalD365FO suite.• Maintain up to date configuration documentation and ensure configuration is version controlledand reflects the software release version.• Provision of 3rd level functional and technical support for Project and Regional support teams,including application support training and support throughout testing cycles.• Responsible for the master data management once defined and input into overarching datamanagement strategy.• Defining and management of Global and Regional SLA and OLA to guarantee service levels toend users.• Service requests around supporting infrastructure and applications (e.g. LCS, VSTS, BYOD)Deployment• Providing overarching guidance and support to regional teams (USA & Singapore) aroundconfiguration processes.• Liaise with the global project team to prepare test cases for new functions and features in thesystem.• Attendance at vendor management meetings to measure support against agreed service levelagreements and processes and identify/implement areas for improvement.

Brisbane, Queensland, Australia

Month-End Management Accounts• Analysis and interpretation of monthly results and follow up on significant variances in end ofmonth result with area/team leaders.• Quarterly Balance Sheet Reconciliation, collaboration with internal audit team.• Assist Finance Leaders on preparing general journal entries and necessary documents.Internal Audit• Store visit on a monthly basis and ensure compliance with company policies, relevant accountingstandards and minimum standards for financial systems and processes.• Conduct business reviews identifying productivity improvement opportunities for the stores.Cash / Revenue• Reconciliation of client trust accounts on a monthly basis and generate summary report for over$120 Million avg. per month.• Preparation of cash payments and receipts in the General Accounting System (GAS).• Distribution of monthly management fees and other internal charges for over 1000 stores.Projects• Design and implementation of a finance communication platform for over 1,000 retail stores wherefinancial information is available, updated and delivered to them in a timely manner.• POWER BI dashboard – Transfer Night Flash, summarises end of month result estimate for allretail stores in Australia. It shares information with operations leaders for store/staff performancereview and for buzz night (monthly staff recognition) award.• Review and improve accounting process in Marketing Finance whilst automating routine work inspreadsheets via writing script in VBA.• Monthly training sessions for 50 internal staff to ensure accuracy, consistency and completenessof EOM reporting.• Documentation of tasks and Service Level Agreements (SLAs) to implement standardisedbusiness process and for its continuous monitoring in finance function.• Secondment in Australian Reporting Team for 3 months, assisting commercial leadersHighlight• Flight Centre Global Gathering Award Winner in FY 17 – Attended Global Conference in Hawaii(July 2017)

Sydney Area, Australia

Month-end management accounts• Adjustment of accrued income, expense and overhead costs hence objective and clear view of profitability can be obtained.• Assist the Finance Manager on preparing general journal entries and necessary documents.Cash / Revenue• AR entry - producing invoices, receipting of cheques, EFT, credit cards. around August to mid-September. • Manual machine entry of credit cards (in the EFTPOS machine). • Assist with monitoring the daily cash flow and banking. • Maintain the various spreadsheets used to track invoices, banking and credit cards. • Process some AP invoices to be sent to Canberra (goods receipting or preparing paperwork for Canberra).

Month end management accounts.• Adjustment of Cost of Sales (COS) accrual, accrued income and overhead costs hence objective and clear view of profitability can be obtained.• Lodgement of GST returns for New Zealand account.Payroll & HR• Assist the finance manager for processing Australian payroll.• Process payroll for New Zealand employees whilst lodging Pay-As-You-Earn (PAYE) tax.• Accounts payable - Liaise with over 30 creditors at month end and provide payment plans to meet the payment terms for the vendors. This facilitates suppliers to continuously provide quality goods and services.• Balance sheet, general ledger and bank account reconciliation. Handle over 1000 transactions every month, daily banking reconciliation, daily cash, cheques and credit card transactions. Identifying errors and correcting them by comparing actual bank account balance to bookkeeping.• Managed the gift card programs - Liaise with gift card providers to setup the gift card activation and value loading terminal for over 10000 gift cards. The campaign schematic was to incentivise the customer with gift cards for buying certain products in a form of cash back. • Liaised with banks to setup or remove banking terminals - Merchant facility and virtual payment gateway setup. Establish banking terminals to offer convenient and fast payment process for customers and clients.Enterprise Resource Planning (ERP) system regional coordinator using Microsoft Dynamics NAV• Supervise the inputs of overall business activities, such as accounting/finance, inventory, HR, manufacturing, payroll and Customer Relationship Management (CRM) database for accuracy and completeness.• Individual training sessions every week to update the system. Accurate information can be extracted from the system when necessary.• Monitoring, investigating troubleshoots and reporting to the operations team.

Asa, Professional Level

Bachelor Of Commerce, Accounting

Highlights: - Completed a 3 year degree within 2 years. - Major Project on Business Forecasting, Forecasting of the National Expenditure.

Education record

- Completed Higher School Certificate (HSC)