Tax Data Analyst
Current• Built Finance &Tax Data Lake from 0 to 1: overseeing the extraction, processing and optimization of data using Alteryx, Python, and PostgreSQL. Managed various data domains including tax, invoice, SAP accounting voucher, deemed sales logistics, R&D cost aggregation, ensuring meticulous integration and high data quality. Translated complex finance & tax requirements into effective data solutions.• Developed comprehensive Finance &Tax PowerBI Management Reports from 0 to 1: - Tax… Show more • Built Finance &Tax Data Lake from 0 to 1: overseeing the extraction, processing and optimization of data using Alteryx, Python, and PostgreSQL. Managed various data domains including tax, invoice, SAP accounting voucher, deemed sales logistics, R&D cost aggregation, ensuring meticulous integration and high data quality. Translated complex finance & tax requirements into effective data solutions.• Developed comprehensive Finance &Tax PowerBI Management Reports from 0 to 1: - Tax Report: Conducted statistical tracking and forecasting of company-wide taxes. - Tax Differential Analysis Report: Quarterly comparative analysis of sales revenue from VAT filings, VAT account details, and sales revenue account details, highlighting variances between VAT filing/invoicing revenue and accounting revenue. - Invoice Reconciliation Report: Utilized examples of typical expenses to trace transactions from accounting vouchers to input invoices and vice versa, ensuring accuracy in financial records and tax compliance - Business, Finance &Tax Analysis Report: Conducted index analysis of financial statements, coupled with sales reports and tax statistics to provide risk warnings for abnormal tax rates.• Implemented VAT automatic working papers and filing RPA, Real Estate and Urban Land Use Tax automatic working papers, Withholding Tax filing RPA, and HNTE auxiliary account automatic working papers, streamlining filing processes across 9 tax entities.• Led the planning and execution of Finance &Tax digital initiatives, including development of a tax digital roadmap and collaboration with suppliers to evaluate system solutions.• Managed the transition from Golden Tax System III to Fully Digitalized E-invoices, conducting comprehensive feasibility evaluation of Leqi solution.• Managed Qian Hu annual filings, monthly VAT forecast, tax funding forecasts, and tax filing reviews. Show less