Lei Liu Email & Phone Number

Sydney, New South Wales, Australia

Managed month-end closing, revenue forecasting, and annual budgeting for Airbnb by conducting variance and trend analysis using Excel (VLOOKUP, Pivot Tables). Automated and standardized financial reporting processes using Macros.Utilized SAP for journal entries and month-end result reviews, preparing adjusting entries as needed. Managed reconciliation processes using SAP HANA, improving workflow accuracy by 10%.Collaborated with Sales & Marketing teams to identify AUD 200K in cost inefficiencies by analyzing actual and forecasted revenue and cost data. Revised supplier contracts, incorporating financial metrics analysis and renegotiations, reducing operational costs Implemented customizable Tableau dashboards to report on key KPIs (e.g., net margins, gross profit, and current ratios) across different product lines. Leveraged advanced analytics to visualize trends, optimizing resource management, and reducing inventory holding costs year-over-year by 10%.Conducted comprehensive ad-hoc profitability analysis and created monthly reporting packages for stakeholders. Delivered in-depth financial analysis, including product performance against targets, leading to strategic recommendations that improved profitability by 12%.

Sydney, New South Wales, Australia

Conducted financial analysis for film production budgets, ensuring cost efficiency across departments by comparing historical data and industry benchmarks, which resulted in a 12% reduction in projected costs for a $20M budget project.Collaborated with producers and finance teams to develop budget plans, tracked spending against allocations, and provided monthly variance analysis, improving overall budget adherence by 15% during pre-production and filming phases.Analyzed budget forecasts and production timelines, using scenario analysis to assess potential cost overruns, and recommended actionable strategies that successfully mitigated financial risks, ensuring projects remained within budget.Utilized financial modeling tools to project revenue streams for film projects based on market trends and distribution agreements, aiding decision-making for budget allocation and identifying potential cost savings during production and marketing phases.

Edmonton, Alberta, Canada

Manage the accounts receivable (A/R) process by issuing billing, applying customer payments accurately, and generating monthly A/R aging reports to collaborate with the sales team on collections.Process $15K per month in accounts payable (A/P) invoices, ensuring the accuracy and validity of invoices received, posting them to the correct expense accounts in QuickBooks, and issuing timely payments to suppliers.Perform month-end close activities including bank reconciliations, A/R and A/P account reconciliations, and posting necessary adjustments to ensure accurate financial reports, followed by generating monthly financial statements.Develop the $150K annual budget for operational expenses by analyzing historical trends, updating the Excel financial model to forecast expected expenses, and making adjustments for changing business conditions.Support the compilation of monthly financial reports, including financial statements, KPI metrics, and commentaries on performance drivers, and present these reports to management to support decision-making.

Suzhou, Jiangsu, China

● Examined the accuracy of documents and journal entries by reviewing 5k financial and accounting records● Collaborated with a team of auditors to execute annual audit and issue the reports for 30+ clients’ labor union department● Prepared and reviewed the financial statement for companies inspected by the local Industrial and Commercial Bureau

Master Of Commerce, Data Analytics For Business

Bachelor Of Science - Bs, Specialization In Mathematics And Economics

High School Diploma