a
aesirlau

Xiliang L

@aesirlau

Data Analyst, Power BI, SQL, Python, Stata and Excel Expert

Malesia
Cinese, Inglese
Alcune informazioni sono riportate in lingua inglese.
Chi sono
Hi! I am a Data Analyst and Econometric Researcher specializing in Stata, Power BI, SQL, Python, and Excel. With a strong quantitative background in Economics and hands-on financial analytics experience, I help businesses and researchers with econometric regression, panel data modeling, data cleaning, and interactive dashboards. Expect clean documented scripts (.do/.pbix), publication-ready tables, and fast, reliable communication in English and Mandarin.... Continua a leggere
a
aesirlau
Xiliang L
offline • 
Tempo di risposta medio: 1 ora

Consulta i miei servizi

Dashboard dati
I will do data analysis, cleaning, and build interactive dashboards
Modello statistico e analisi
I will run econometric regression, panel data analysis, and data cleaning in stata

Esperienza lavorativa

China_Civil Engineering Construction

Finance and data intern

China Civil Engineering Construction • Full time

Sep 2026 - Present • 2 mos

Fund Planning & Financial Control: Reviewed project fund plans to identify potential overpayments, budget overruns, outstanding invoices, and data discrepancies. Coordinated with project commercial and procurement managers to verify and correct financial information. Cash Flow Forecasting: Prepared cash inflow and outflow forecasts based on project fund plans and actual bank transactions. Consolidated financial data, performed calculations, and followed up with project managers to ensure timely submission of forecasting information. Accounts Receivable Monitoring: Assisted in preparing the Q4 Key Project Collection Progress Report, consolidating receivables information and tracking payment collection progress across major projects. Supplier Financial Management: Assisted in reviewing financial evaluations of potential strategic suppliers and consolidating outstanding payables to downstream subcontractors and suppliers, covering balances exceeding RMB 10 million. Accounting & Document Verification: Performed bank transaction reconciliation, prepared accounting vouchers, and reviewed overseas invoice receipt forms and settlement documents. Coordinated with relevant departments to resolve discrepancies and ensure documentation accuracy.