guangyupeng

• Data analysis. Analyze and transform complex financial data from legal documents, third-party reports, and vendor sources, ensuring accuracy and timeliness. • Process automation. Implement VBA and Python scripts to automate data processing workflows, reducing manual effort and improving data quality. • Customer support. Resolve client inquiries promptly, crafting detailed responses that address challenges and outline methodologies used for solutions. • Document sourcing. Procure critical financial documents through creative internet research and direct outreach to issuers and underwriters. • Process optimization. Contribute to ad-hoc projects, identifying workflow efficiencies that enhance data accuracy and accelerate time-to-market. • Data quality assurance. Validate and refine datasets, ensuring ICE’s products meet best-in-class standards for reliability and comprehensiveness.

• Sales analysis. Perform regional and brand-level sales analysis using Excel pivot tables and PowerBI, delivering insights to support strategic decisions. • Task automation. Develop VBA programs to automate repetitive Excel tasks, significantly reducing processing time and enhancing efficiency. • Budget preparation. Assist in drafting group budgets, aligning financial targets with organizational objectives and market conditions. • Financial statement consolidation. Support the preparation and finalization of group and subsidiary financial statements, ensuring accuracy and compliance. • Account management. Maintain accurate accounts for the Chinese subsidiary, coordinating activities for the newly established Japanese entity. • Ad-hoc reporting. Deliver tailored financial reports to senior management, addressing specific business needs and supporting strategic planning.

• Financial statement review. Check and reconcile monthly, quarterly, semi-annual, and annual financial statements of local banks, ensuring accuracy and compliance. • Risk analysis. Analyze critical financial ratios and items to identify material risks, providing actionable insights to mitigate potential issues. • Credit control. Monitor credit risk identification, assessment, and response processes, ensuring robust risk management practices in local banks. • Compliance auditing. Conduct audits of financial and non-financial information, focusing on AML, CTF, corporate governance, and internal controls. • Regulatory rating. Evaluate local banks using the CAMEL framework, preparing comprehensive annual reports to guide regulatory oversight. • Asset administration. Maintain the department’s fixed asset register, accurately recording and reporting asset movements.