Jing Liu Email and Phone Number

• Provided hospitals with margin analysis to optimize financial performance.• Assisted in funding negotiations by creating health fund revenue models.• Conducted public service contract pricing analysis to ensure profitability.• Managed clinical costing process and developed new Power BI dashboard.• Support hospital daily activity and revenue prediction model development

Manage clinical activity based costing model. Provide insights for hospital activity, costing and margin. Assist hospital in enhancing operation and costing efficiency. support HealthFund negotiation by providing revenue analysis and modelling

- Support Reforecast, annual budget and IOP exercises by collating and converting CPP (cost per premise) into a technology view including analysis and insights- Prepare monthly CPP performance reports including commtary analysis, and presenting highlights in review meeting- Perform in-depth ad hoc analysis on cost drivers to ensure effective and informed decision marking by senior management- Manage and maintain Hyperion model

- Provide consultantion on health data governance- Provide data validation/audit for regulated submitted report (eg:Apra 601/603/604)- Provide mentoring and training for SAS coding- Review and validate internal analysis report and highlight the key issues

- Develop and deliver Produce Monthly Dashboard and KPI reports- Identify and investigate the data, system and reporting issues- Develop and manage BI process to provide business insight- Reporting Process Improvement- Provide insight analysis to the business based on unstructured datasets by using SAS and Tableau- Analytical datasets development and improvement - Recognise new methods and improve measures of deriving information for use in reporting and to support decision making- Identify best reports to leverage across relative departments and engaging in stakeholders buy in- Explore appropriate BI tools for reporting and analysis- Automating BAU reports and dashboards to enable stakeholder self-service- Management junior staff in delivering BAU reports- Develop and maintain SharePoint Site for the team- Liaise with auditors and external regulators (APRA, state revenue office) for any data or reporting queries

-Assisting the Mass Reporting Manager to maintain efficient reporting and insightful analysis for the team-Provide ad-hoc information and analysis as required -Reporting on KPI and business metrics for the business such as Gross Written Premium, Average Selling Price, Written Units, Loss Ratios, Termination/Retention Rates, Cancellation Rate, Paid Rate, Conversion/Strike Rate, Incidence Rates-Design, develop and improve reporting and modelling methodology where appropriate-Review current report, identify and resolve data integrity issues-Recognise new methods and improve measures of deriving information for use in reporting and to support decision making-Proactively identify and provide advice on trends-Identify best reports to leverage across all the brands and engaging in stakeholders buy in-Assist in budgeting and forecasting.-Assist MIS strategy by providing ad hoc reports and data analysis.-Resolve multiple conflicting user requirements into a common acceptable solution-Created reporting process and provided training and supports to the overseas reporting resources.-Assisted in MIS new system implementation projects

Management and Analytical Reporting:-Provide and improve current monthly management reports and Regional Finance Performance Report with actual and budget data by using TM1, excel and database-Review and analyse financial data in network management reports and ensure the accuracy of the reports-Reconcile retail banking system with accounting reporting system, and ensure consistency of the system and integrity of the financial data-Collect data from various system, and develop analytical or summary reports for various stakeholder in assisting product analysis and credit risk analysis-Provide other ad hoc analytical reports to internal or external stakeholders-Update and document procedure files, and assist in improving existing reporting process.-Assist in regional budget allocation and adjustment-Follow up with the queries from branches on the finance or management reportsFinancial Accounting:-Complete month end intercompany, accrual, trust, and branch allocation journals within timeframe-Process general ledger and balance sheet reconciliation-General ledger maintenance -Run and review Trail Balance and P&L for divisions-Ensure the accuracy of intercompany accounts and clearing accounts-Prepare audit documents in the half year or year end audit-Provide supporting documents required by group statutory accountant-Submit monthly, quarterly, and annually data to Apra-Completed provision schedule for bad debt accounts-Provide daily trust funding movement reports to Treasury