a
aesirlau

Xiliang L

@aesirlau

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

Malaysia
Chinesisch, Englisch
Einige Informationen werden in englischer Sprache angezeigt.
Über mich
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.... Mehr lesen
a
aesirlau
Xiliang L
offline • 
Durchschnittliche Antwortzeit: 1 Stunde

Meine Dienstleistungen

Daten-Dashboards
I will do data analysis, cleaning, and build interactive dashboards
Statistische Modellierung & Analyse
I will run econometric regression, panel data analysis, and data cleaning in stata

Arbeitserfahrung

China_Civil Engineering Construction

Finance and data intern

China Civil Engineering Construction • Vollzeit

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.