Jing (Lexi) Cai Email & Phone Number

London, England, Gb

London Area, United Kingdom

• Provided and maintained comprehensive monthly and quarterly People Dashboard to monitor and analyze key HR metrics, including rolling turnover, headcount trends, absence analysis, and tenure distributions.• Proficient in Visualization tools such as Power BI and Excel to transform raw data into actionable insights, aiding leadership in strategic decision-making and workforce planning.• Developed and refined data validation processes to maintain high data integrity and support reliable… Show more • Provided and maintained comprehensive monthly and quarterly People Dashboard to monitor and analyze key HR metrics, including rolling turnover, headcount trends, absence analysis, and tenure distributions.• Proficient in Visualization tools such as Power BI and Excel to transform raw data into actionable insights, aiding leadership in strategic decision-making and workforce planning.• Developed and refined data validation processes to maintain high data integrity and support reliable reporting.• Spearheaded the transformation of the HRIS system, managing data migration, routine data audits, and serving as the Subject Matter Expert (SME) on HR reporting and analytics. Show less

London, England, United Kingdom

Shenzhen, Guangdong, China

• Led client research, including identifying, collecting and migrating data from various sourceswith tools of SQL and DBT, and conducting in-depth analysis of customer survey data toidentify trends and insights, thus giving invaluable insight to our marketing team.• Work closely with the data governance team to check data quality and validate processes toensure that data used is accurate, consistent and reliable• Managed a large-scale customer database, including customer… Show more • Led client research, including identifying, collecting and migrating data from various sourceswith tools of SQL and DBT, and conducting in-depth analysis of customer survey data toidentify trends and insights, thus giving invaluable insight to our marketing team.• Work closely with the data governance team to check data quality and validate processes toensure that data used is accurate, consistent and reliable• Managed a large-scale customer database, including customer demographics and purchasinghistory to create a comprehensive customer segmentation model that led to a 4x increase inmarketing efficiency.• Ran all meetings with stakeholders to define the scope of A/B testing, including KPIs,objectives, and established tracking mechanisms to monitor progress and ensure alignmentwith strategic objectives.• Built a dynamic Budget Portfolio Dashboard in Excel to support management and clients’reviews – significant boost to output.• Developed new summary reporting templates to drastically improve data quality and accuracythrough manipulating data in SQL. Show less

Melbourne, Victoria, Australia

• Processed, tracked and reported all transactions and other financial information in theERP system, including:• Maintained and reconciled general ledger on a monthly basis• Accounts receivable and accounts payable processes, prepare supplier payments incompliance with agreed credit terms and verify all invoices prior to payment• Maintenance of Fixed Assets Register and depreciation schedule; Track inventory ageing• Prepared the monthly financial reporting and statement… Show more • Processed, tracked and reported all transactions and other financial information in theERP system, including:• Maintained and reconciled general ledger on a monthly basis• Accounts receivable and accounts payable processes, prepare supplier payments incompliance with agreed credit terms and verify all invoices prior to payment• Maintenance of Fixed Assets Register and depreciation schedule; Track inventory ageing• Prepared the monthly financial reporting and statement analysis• Prepared budgets and ensured that any discrepancies are reported immediately• Management of petty cash and complete monthly petty cash reconciliations• Prepared the analysis the variance between forecast and actual• Management of the loan accounts and foreign currency accounts• Completed daily and monthly bank and credit card reconciliations• Calculated and process employee’s superannuation quarterly• Experienced with general accounting entries, account receivable and account payable• Handled expense claims, typing and filling, with great attention to detail, and ensurethat employees can get claims on time and accurately• Sorted and reply all incoming emails from clients and suppliers on time, which increasesthe satisfaction of clients Show less

Melbourne, Australia

Master'S Degree, Fintech With Bussiness Analytics, Distinction

Accounting And Finance, Complete

Accounting And Business/Management, Credit

Colleage Of Business, Accounting And Business/Management