Mingyu Li Email and Phone Number

1. Tableau Server Data Source Maintenance: Maintained data sources on Tableau Server to ensure data availability and stability. Developed Tableau data sources based on business logic by writing SQL queries, meeting user requirements for building the CVA data dashboard.2. Dashboard Development: Successfully built FRTB SA CVA and CCAR CVA data dashboards, meeting user requirements for visualizing risk data. These dashboards include features like daily monitoring, drill-down queries, trend analysis, helping users better understand and analyze risk data, and supporting decision-making.3. Performance Optimization: Used custom SQL queries to construct data sources and optimized Tableau BI dashboard settings to enhance user experience and data analysis efficiency. Through performance optimization, ensured that data loading times for each dashboard remained within one minute, significantly improving user data access speed.4. User Support and Complex Report Creation: Assisted users in understanding CVA project data calculation logic and provided essential technical support. Additionally, aided users in creating complex risk data reports to meet CVA risk data monitoring requirements. Through close collaboration with users, ensured their effective analysis and utilization of risk data.

1. Daily preparation of operational data reports, monitoring the performance of branches, mainly focusing on the balance and changes in loans and deposits.2. Monthly compilation of branch assets, liabilities, and business development statistics, submitting various regulatory statistical reports to institutions like the People's Bank of China and the Banking and Insurance Regulatory Commission.3. Utilized VBA to automate the creation and verification of daily branch data reports and various regulatory reports, enhancing the efficiency of branch report statistics.4. Conducted monthly analysis of branch assets and liabilities to provide data support for the business development of front-office departments.

Provide cross-border finance solution, such as M&A, Investment & Financing, Syndicated Loan and so on.We are devoted to help capital floating with global investment.

1.Completed weekly market liquidity report through the economic data, policy and financial market2.Built U.S. macro-economic model, tracked gold price changes, and assisted in completed in-depth report 3.Analyzed the monetary policy of the Fed and PBOC, and gave macro event reviews