Zhanwei (Katharine) Wang
Lancaster,PA
Summary
Data-driven Financial & Data Analyst with four years of experience in FP&A, labor productivity modeling, budget administration, and operational reporting. Holds a B.S. in Actuarial Science and demonstrates technical proficiency in Excel, SQL, Tableau, and SmartView/Oracle. Skilled in querying complex databases, constructing financial reports, and optimizing budget and forecast workflows for executive leadership.
Overview
1
1
Certification
7
7
years of professional experience
Work History
Senior Financial Analyst
PENN Entertainment
06.2024 - Current
- Analyzed complex operational and financial datasets, converting raw metrics into executive summary reports and charts for senior leadership.
- Collaborated with cross-functional department heads (Marketing, Gaming, F&B) to develop structured Excel financial models that enhanced reporting accuracy and facilitated tracking of key operational metrics.
- Analyzed workforce productivity trends and labor reporting data in Excel to pinpoint cost-efficiency opportunities across operating departments.
- Guided junior analysts in standardized reporting workflows, data validation techniques, and spreadsheet best practices to strengthen overall team capabilities.
Financial Analyst
PENN Entertainment
12.2022 - 06.2024
- Conducted variance analyses in Excel across regional P&L accounts to identify expense trends and highlight cost-reduction opportunities.
- Managed regional budget uploads and forecasting templates using Oracle and SmartView, verifying data integrity across revenue, payroll, and expense lines.
- Utilized SQL and Tableau to query corporate databases for ad hoc requests, creating data visualizations in Excel and Tableau that provided actionable insights to department leaders.
- Rebuilt monthly financial reporting packages in Excel, standardizing data aggregation to enhance clarity for executive management reviews.
Table Games Dealer
PENN Entertainment
09.2021 - 12.2022
- Handled gaming transactions with high accuracy, enforced operational compliance, and provided exceptional customer service in a high volume environment.
Paralegal Financial Account Assistant
Hudson Legal Group
07.2020 - 07.2021
- Audited and verified payment records, sales invoices, and customer receipts in digital database systems, ensuring financial accuracy and compliance.
- Reconciled accounts and resolved billing discrepancies, streamlining customer account management and enhancing financial accuracy.
Actuarial Analyst Intern
Donegal Insurance Group
06.2019 - 08.2019
- Analyzed large insurance datasets in Excel using regression modeling and statistical analysis to evaluate loss reserves and risk trends.
- Compiled data from multiple internal databases to create analytical reports informing actuarial leadership decisions.
Education
Bachelors - Actuarial Science
Temple University
Philadelphia, PA05-2020
Skills
- Budgeting & Forecasting
- P&L Variance Analysis
- Financial Modeling
- Labor Productivity Modeling
- Operational Analysis
- Microsoft Excel
- SQL (Data Query & Extraction)
- Tableau & Power BI
- SmartView/Oracle ERP
- Data Analytics
- Process Improvement
- Problem Solving
Certification
- PENN Entertainment, Aces of PENN, 2023 Team Member of the Year
- Google Data Analytics Professional Certificate, Coursera
- IBM Data Warehouse Engineer Professional Certificate, Coursera
www.linkedin.com/in/zhanwei-katharine-wang-40aa8611b
Timeline
Senior Financial Analyst
PENN Entertainment
06.2024 - Current
Financial Analyst
PENN Entertainment
12.2022 - 06.2024
Table Games Dealer
PENN Entertainment
09.2021 - 12.2022
Paralegal Financial Account Assistant
Hudson Legal Group
07.2020 - 07.2021
Actuarial Analyst Intern
Donegal Insurance Group
06.2019 - 08.2019
Bachelors - Actuarial Science
Temple University