Nicolette Guerra

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

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

Bachelor of Business Administration - Finance - Texas Tech University, Rawls College of Business (2023-08)