SCOR SE

Built a SQL ETL pipeline and analyzed claims and policy data in Python for 20 Life & Health clients, reducing analysis time by 50% and informing client segmentation and marketing strategy. Built Power BI dashboards for Life & Health portfolio reporting and experience analysis, with automated quarterly refreshes for recurring performance monitoring and reporting. Deployed a Qwen-powered AI agent to collect insurers’ solvency reports and extract and validate key data, reducing report-processing time by 70% and supporting market solvency analysis.

Siemens

Deployed Selenium crawlers and AWS pipelines to automate macroeconomic data collection; optimized PySpark workflows, improving resource utilization by 30% and reducing processing time by 45%. Cleaned and migrated COPA data with pandas and delivered CPD reports to business teams, supporting performance analysis and decision-making. Developed scripts to scrape, structure, and ingest million-scale business documents into a RAG knowledge base supporting Siemens’ in-house LLM and grounded, domain-specific responses.

Peking University International Hospital

Worked with reimbursement and finance teams to validate quarterly inpatient data and resolve discrepancies across more than 2,000 records, reducing errors by 32%. Presented DRG/DIP reimbursement analyses to visiting faculty and the dean, explaining stakeholder trade-offs and financial implications for hospitals, patients, and insurers.