Ni Zhan
ESG Data Analyst · KPMG
Torrance, CAWork Experience
ESG Data Analyst
KPMG2022 – 2022
Identified the current state of ESG and strategized how it would be incorporated into the operating model by building a chatbot using IBM Watson and Python for the rebate program to respond carbon related questions, such as all the lifecycle emissions from wide range of car collections, expected rebate percentages, suggested alternatives for more savings, etc, as well as an embedded emission calculator, which informed the global ESG team how individual behavior drives company carbon footprint and inflection points to anchor an action plan
Business Analyst
Ernst & Young Parthenon2021 – 2021
• Compiled desk research for online video platform market using Strategic Position and Action Evaluation Matrix and the Gallup Path to develop strategic plans • Analyzed business requirements and provided end-to-end solution design for data foundation builds including SQL Data Marts, e.g. constructing ERD and then converted it to the relational database, DDL, and DML • Formulated business personas and client personas by gathering data from statistical analysis, focus groups, frequent tags, and validating hypotheses through survey • Employed programming proficiency in R/Tableau to clean historical data and deliver data visualization for 45 stores to assess 3 promotional activities and weekly turnover, hence ran funnel analytics to boost conversions and growth
Fundraising Coordinator
Sierra Leone Foundation for New Democracy2021 – 2021
• Facilitated virtual fundraising events with businesses and other nonprofit organizations for 20,000 books on the ground in Sierra Leone and raised funds to complete preschool classrooms • Responsible for monitoring transactions in Quickbooks and creating P/L statement; helped to file IRS Form 990
Data Analysis Assistant
Traive Brasil2020 – 2020
Connected farmer creditors to qualified lenders and leveraged Tableau to visualize data from work pilot projects with large-scale Brazilian financial institutions • Performed in-depth research on industry landscape and benchmarking against competitor software • Queried data in SQL and improved a machine learning-based credit risk assessment model, which successfully resulted in 15% more farmer creditor acquisition, and mapped farmers to the best lenders with higher relevance and efficiency
Education
Master of Science in Business Analytics
University of California, Irvine, Paul Merge School of Business2022
Master of Science in Business Analytics
Bachelor of Science in Business
University of Minnesota, Twin Cities, Carlson School of Management2021
Bachelor of Science in Business