Nicolette Guerra
Financial Analyst I – Investor Reporting
Hire this person
Send a job offer directly to this candidate
About
Prepared high-level financial reports and strategic data analyses, enabling senior management to drive key business decisions and cross-functional strategy Generated monthly Asset-Backed Securitization (ABS) reports, Cumulative Net Loss/Liquidated reports, and trust certificates to maintain full investor transparency Wrote custom SQL scripts, Databricks queries, and VBA macros to streamline data pipelines and optimize resource allocation across the team
Experience
Financial Analyst I – Investor Reporting - GM Financial - Fort Worth, TX
(2024-07 - 2026-07)
- Prepared high-level financial reports and strategic data analyses, enabling senior management to drive key business decisions and cross-functional strategy
- Generated monthly Asset-Backed Securitization (ABS) reports, Cumulative Net Loss/Liquidated reports, and trust certificates to maintain full investor transparency
- Wrote custom SQL scripts, Databricks queries, and VBA macros to streamline data pipelines and optimize resource allocation across the team
- Quantified and tracked portfolio performance while building and maintaining dynamic cash flow models for corporate finance leadership
- Reviewed complex Indentures and SSEs, modifying trust documentation to align with legal requirements
Settlements & Service Analyst – IBD Operations - Goldman Sachs - Dallas, TX
(2024-01 - 2024-07)
- Resolved trade breaks and generated precise lender lists using advanced Excel functions (VLOOKUP, INDEX/MATCH)
- Evaluated borrower trend cards, accounts receivable, and inventory monthly to calculate borrowing bases for Asset-Based Lending (ABL) deals
Education
Bachelor of Business Administration - Finance - Texas Tech University, Rawls College of Business (2023-08)
