Open To Work
Jack HERTKORN
Trapp
Summary
Results-driven professional with experience at KPMG and Lehigh Valley Health Network, specializing in financial analysis and audit procedures. Expert in data management and advanced Excel skills, achieving significant improvements in revenue integrity. Proven collaborator with senior leadership, delivering strategic insights and fostering effective communication.
Overview
5
5
years of professional experience
Work History
Audit Associate
KPMG
Philadelphia
10.2025 - Current
- Performed risk assessments for various clients across different industries, enhancing audit efficiency.
- Led client walkthroughs to assess effectiveness of internal controls, identifying discrepancies in financial statements.
- Conducted substantive procedures, testing samples and vouching support to ensure compliance with GAAP.
- Collaborated with real estate and healthcare teams during the internship program, assisting in various audit processes.
- Organized inventory counts, collected data, and presented findings to senior leadership.
Internal Consultant
Lehigh Valley Health Network
Allentown
06.2021 - 10.2024
- Conducted financial analysis and assisted the Revenue Integrity team, collaborating daily with senior leadership.
- Completed COVID purchase reimbursement projects, compiling invoices that secured up to $6 million from FEMA and PEMA.
- Analyzed hospital visit data in Excel to identify at-risk insurance reimbursements, saving 5.3% in Net Patient Revenue.
- Coordinated with finance and revenue vice presidents on budget projects, improving earnings/cost ratio by 58% for FY21.
Education
Master of Science - Accounting
The Pennsylvania State University
State College, PA08-2023
Bachelor of Science - Accounting, Information Systems Management
The Pennsylvania State University
State College, PA05-2022
Skills
- Financial analysis
- Data management
- SQL
- Pivot tables
- Formulas
- Microsoft Office
- Effective communication
- Regulatory compliance
- Excel
- Data visualization
- Advanced functions
- Macros
- PowerPoint
- Team collaboration
Campus Involvement
Penn State Abington Martial Arts Club, Vice President and Volunteer Instructor
Led training and warm up exercises.
Taught students martial art and self-defense techniques.
Helped run the recruiting booth to encourage new members to join.
Work Preference
Job Search Status
Open to workWork Type
Full TimeLocation Preference
HybridSalary Range
$66000/yr - $200000/yrTimeline
Audit Associate
KPMG
10.2025 - Current
Internal Consultant
Lehigh Valley Health Network
06.2021 - 10.2024
Master of Science - Accounting
The Pennsylvania State University
Bachelor of Science - Accounting, Information Systems Management
The Pennsylvania State University