NZ

Ni Zhan

ESG Data Analyst · KPMG

Torrance, CA

Work Experience

ESG Data Analyst

KPMG

2022 – 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 Parthenon

2021 – 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 Democracy

2021 – 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 Brasil

2020 – 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 Business

2022

Master of Science in Business Analytics

Bachelor of Science in Business

University of Minnesota, Twin Cities, Carlson School of Management

2021

Bachelor of Science in Business