Internships

Introduction IDP/OCR system development: Built OCR pipelines for bank statements; automated extraction of financial fields and transaction tables across 10+ banks, delivering end-to-end visualization and structured outputs on the production platform. Prompt engineering for credit risk: Designed prompts to extract delinquency and credit-risk signals from SLIK reports; fixed model misclassification issues and automated credit-risk extraction with GPT-4.1, improving accuracy and robustness of the SLIK parsing workflow.

Introduction Prepared daily, weekly, and monthly reports on the bond market: Daily: recorded and analyzed bond market transactions, government bond trends, as well as money and stock market activity and sentiment. Weekly: compiled interest rate briefs and drafted reports, including market liquidity review, central bank operations review, and market outlook analysis. Monthly: independently prepared macroeconomic data briefs and reports, covering interbank certificate of deposit trends, custody data analysis, institutional behavior reports, and commercial paper reports. Compiled and analyzed economic and financial data for monthly reports, including PMI, social financing, CPI & PPI, retail sales, industrial production, and import/export data, producing statistical analyses and commentary reports.

Introduction Managed and processed financial data exported from Kingdee and UFIDA systems, handling 10,000+ data fields daily. Automated real estate data auditing with Openpyxl and Pandas, achieving faster queries, reduced latency, and streamlined procedures.

Introduction Implemented automated ETL pipelines using WIND Excel plugin and templates to query and preprocess 80,000+ records daily for Deloitte IBond Smart Bond and CITIC Construction Investment teams. Optimized large-scale data retrieval and analysis pipelines with Python + SQL, improving processing speed and stability; proficient in WIND (Excel & Python integration).