Gavin Hoffman
Newtown,PA
Summary
Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
2
2
years of professional experience
Work History
Derivatives SEC Reporting Associate
J.P. Morgan Chase & Co.
06.2023 - Current
- Analyze and forecast daily credit derivative activity to determine variances over a $5 million threshold which is communicated with senior management
- Develop and strengthen various unique code queries in Abacus data center to provide stakeholders with over 30 additional categorical data attributes
- Produce the credit derivatives section of the 10-Q which contains the firm’s exposure in credit default swaps, total return swaps, and other credit products
- Implement strategies and ideas to find efficiencies in daily ad-hoc tasks via Python, SQL, Tableau, and Alteryx
Treasury & Chief Investment Office Controller
J.P. Morgan Chase & Co.
08.2022 - 06.2023
- Managed federal reserve and derivative account reconciliations by posting entries in SAP to ensure that the ledger reflected daily trades totaling $6 million daily
- Implemented a daily foreign exchange currency tracker which showed if variances existed between databases that was used for daily business activity
- Owned 2000 monthly general ledger attestation records and provided support to explain variances for accounts that were above firm threshold
- Created 25 new SAP queries that were used in teamwide workflows in Alteryx which enabled our shareholders to obtain classification data
Cash Asset Class Control Analyst
J.P. Morgan Chase & Co.
07.2021 - 08.2022
- Investigated North America and Europe cash break reconciliations and effectively communicated with all lines of businesses to pinpoint entries causing float discrepancies
- Obtained statement and ledger balances for year-end PWC audits to ensure that accounts under team management are materially in line for reporting
- Conducted daily general ledger activity refreshes which provided live updates of current firmwide cash balances that were used in daily reconciliations
- Automated a reconciliation via Alteryx which identified cash accounts that netted to zero and created entries to eliminate unnecessary rows from the trial balance
- Composed and parked SAP entries during month end and intramonth to collapse stale cash balances
Education
MBA - Finance
La Salle University
Philadelphia, PA12.2024
Bachelor of Arts - Finance
Temple University
Philadelphia, PA05.2021
Skills
- Data Entry
- Process Improvement
- Attention to Detail
- MS Office
- Decision-Making
- Issue Resolution
- Automation
- Time Management
- Leadership
- Accountability
- Self-Motivated
- Integrity
Timeline
Derivatives SEC Reporting Associate
J.P. Morgan Chase & Co.
06.2023 - Current
Treasury & Chief Investment Office Controller
J.P. Morgan Chase & Co.
08.2022 - 06.2023
Cash Asset Class Control Analyst
J.P. Morgan Chase & Co.
07.2021 - 08.2022
MBA - Finance
La Salle University
Bachelor of Arts - Finance
Temple University
Similar Profiles
Brendy KambaBrendy Kamba
ASSOCIATE, CLIENT ASSOCIATE at J.P. MORGAN CHASE & CO. | JP MORGAN ADVISORSASSOCIATE, CLIENT ASSOCIATE at J.P. MORGAN CHASE & CO. | JP MORGAN ADVISORS
JOSEPH ALDWIN GATCHALIANJOSEPH ALDWIN GATCHALIAN
Asst. Manager - Operations at J.P. Morgan Chase & Co. / Chase BankAsst. Manager - Operations at J.P. Morgan Chase & Co. / Chase Bank
Cindy Marie ElliottCindy Marie Elliott
New Account Screening at J.P. Morgan ChaseNew Account Screening at J.P. Morgan Chase
SANAA RAOSANAA RAO
Asset Specialist at J.P. Morgan Chase & CoAsset Specialist at J.P. Morgan Chase & Co
Gary TomlinsonGary Tomlinson
Owner at Tomlinson Construction ServicesOwner at Tomlinson Construction Services