Hanyu Li

Experience

• 

  ICBC International

  Jan 2016 - Mar 2016

  Credit intern

  • Analyzed credit card transaction data for Shanghai and Jiangsu area, including clients’ trading behaviors and potential investment demands• Collected 50,000 users’ responses on the new Wechat platform, along with the routine administration and maintenance work

• 

  Jiangxi University of Finance and Economics

  Sept 2016 - Dec 2017

  Teaching Assistant

  Teaching assistant for Microeconomics/Macroeconomics/Econometrics/Linear Algebra/Probabilities

• 

  安永

  Jan 2017 - Mar 2017

  Auditing Intern

  • Conducted due diligence for a top energy resource company and its 8 subsidiaries as part of the annual auditing process, including making and sending over 60 confirmation inquiry letters to banks and cooperative partners, with a recovery rate over 95% • Ensured the balance of auditing work papers on cash, trading and notes accounts, checked the authenticity of journal entry samples; decided critical control points in substantive systems by analyzing the assurance case of comparable companies in the same industry• Served as a liaison among the law professionals, investment bankers and client financial department to collect materials and check progress, largely smoothing the information flow Show less

• 

  Accenture

  Jun 2017 - Sept 2017

  Management Consulting Intern

  • Researched user requirements to customize the workflow-automation system for a large group including 100+ subsidiaries, improved 20% efficiency by conducting data-driven consulting and providing digital transformation solutions• Ensured the quality of data, cleansed and processed data from disparate sources with SQL, crosschecked the consistency with other 9 systems by Python, and drafted the report of data management and interpreted to system engineers• Designed A/B test to validate 4 functional modules of a mobile APP which is for client’s internal use, drafted the wireframes and interface sketches to propose valuable thoughts, boosting approval system efficiency by 25%• Developed ad-hoc analysis to monitor KPIs data and other metrics, facilitated the client’s human resource department to address management problems and make decisions Show less

• 

  Guotai Junan Securities Co., Ltd

  Dec 2018 - Feb 2019

  Industry Research Intern

  • Conducted industry research in the vehicle industry, including collecting and filtering listed company information, acquiring an overall understanding about industry policy and investment environments, then assisted to write in-depth research report• Collected data using Wind and developed industry databases by SQL to manage sales data in 3 business lines and monitored the monthly changes, built predictive models of regional sales to help decide investment strategy

• 

  MassMutual

  May 2019 - Aug 2019

  Wealth Management Advisor

  Private wealth management

• 

  ICBC（USA）

  Jul 2019 - Sept 2019

  Marketing Analyst, Consumer Banking

  • Analyzed card business performance in NYC, NoCal and SoCal areas, prepared 60+ pivot tables of market statistics, contributed to deciding marketing strategies and budget allocation, leading to the card business growth by 6.8%• Performed Marketing Mix Modeling (multivariable regression models) in R to evaluate the effectiveness of different marketing tactics, and presented the findings and results to the audience from both technical and business teams• Conducted analysis for marketing campaigns performance, generated Tableau dashboards for informative visualizations along with a detailed report to deliver key insights and recommendations to the marketing manager Show less

• 

  Microsoft

  Sept 2019 - Dec 2019

  Data Analyst-Capstone Project

  Machine learning on time series forecasting

• 

  Nuvei

  Feb 2020 - Apr 2021

  Business Analyst

  • Provided clients with optimal payment solutions based on the analysis of the financial and operational status, lowered the interchange costs by 40% and decreased cash conversion cycle by 5 days, helping clients improve business processes• Prepared monthly statements of billing and reporting, managed the retrieving, extracting and transforming of a large volume of data with SQL and Python, consolidated it in excel and utilized VBA to automate some data process• Queried 100k+ abnormal transactions data with SQL and collaborated with engineers to validate the fraud modeling performance, mitigated the risk for clients by ensuring standards for risk management are followed Show less

• 

  上海市大数据股份有限公司

  Apr 2021 - now

  • Product Manager

    Jul 2022 - now

  • Big Data Engineer

    Apr 2021 - Jul 2022