a
aesirlau

Xiliang L

@aesirlau

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

Malasia
Chino, Inglés
Parte de la información aparece en idioma inglés.
Sobre mí
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.... Lee más
a
aesirlau
Xiliang L
desconectado • 
Tiempo medio de respuesta: 1 hora

Revisa mis servicios

Panel de datos
I will do data analysis, cleaning, and build interactive dashboards
Modelado estadístico y análisis
I will run econometric regression, panel data analysis, and data cleaning in stata

Experiencia laboral

China_Civil Engineering Construction

Finance and data intern

China Civil Engineering Construction • Tiempo completo

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.