Wendy Kim
Deal Advisory Strategy & Analytics
Valencia,CA
Summary
Motivated associate with experience in cleaning and manipulating large datasets in order to perform business analytics. Extremely detail-oriented and eager to learn new skills.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
2
2
Certificates
Work History
Associate, Deal Advisory Strategy & Analytics
KPMG
Los Angeles, CA
01.2021 - Current
- Provide deep business insights for 20+ financial due diligence and strategy buy-side and sell-side deals by leveraging advanced analytics tools including Alteryx, SQL, and Excel.
- Work with multiple Deal Advisory service lines to provide data-driven business KPIs using the company's proprietary software (e.g. SPI) to identify trends and opportunities.
- Transform, clean, and manipulate messy transactional data into consistent, workable dataset to perform analyses.
- Educate new hires on company policies and procedures by designing and developing training program.
Apprentice Teacher
Lehigh University
Bethlehem, PA
01.2020 - 08.2020
- Produced and graded multiple Java programming assignments for 35 students, often dedicating 3-5 hours per day on top of daily university work.
- Coded solutions for assignments and debugged students' programs to provide helpful feedback.
- Collaborated with teaching staff to implement coordinated educational strategies and student support networks.
Assistant Accountant
Lehigh University Office Of Student Engagement
Bethlehem, PA
09.2016 - 08.2020
- Allocated reimbursements, cash advances, and deposits for over 150 student organization and clubs.
- Reconciled student club account entries that were improperly entered into system by practicing proper organizational methods and extreme attention to detail.
- Balanced working 5-10 hours per week while taking 16-18 credits of courses during the academic semester.
Intern, Deal Advisory Strategy & Analytics
KPMG
New York, NY
06.2019 - 08.2019
- Supported data and analytics projects for M&A deals by cleaning, transforming, and manipulating large datasets in Alteryx.
- Built project-relevant databases, workflows, and visualizations through Excel and Tableau to assist ongoing deals with clients.
- Tested over 30 leases in KPMG Leasing Tool (KLT) in a week to assess tool's accuracy and reliability for client satisfaction.
Education
Bachelor of Science - Business Information System
Lehigh University
Bethlehem, PA 08.2016 - 05.2020
Skills
Alteryx - Data Cleaning/Manipulation
Tableau/PowerBI - Data visualization
Basic knowledge of SQL, R, and Python
Microsoft Excel
Certification
Alteryx Core Designer Certificate
Timeline
Alteryx Core Designer Certificate
03-2021
Associate, Deal Advisory Strategy & Analytics
KPMG
01.2021 - Current
Business Analytics Certificate
08-2020
Apprentice Teacher
Lehigh University
01.2020 - 08.2020
Intern, Deal Advisory Strategy & Analytics
KPMG
06.2019 - 08.2019
Assistant Accountant
Lehigh University Office Of Student Engagement
09.2016 - 08.2020
Bachelor of Science - Business Information System
Lehigh University
08.2016 - 05.2020