Victoria Lorenzo
New York
Summary
Financial Analyst with expertise in SQL and financial modeling, skilled in leveraging time-series and regression analysis to forecast P&L and deliver data-driven insights that support executive decision-making, with a strong interest in global financial markets and macroeconomics.
Overview
3
3
years of professional experience
Work History
Financial Analyst
American Express
New York
03.2025 - Current
- Forecast P&L for CIF (Cards in Force): Analyze historical time-series data and build multivariate regression models (factors include card acquisitions, attrition, etc.). Forecast monthly, quarterly, and 3-year values with deviations typically only $3K on a $15M base (~99.98% accuracy).
- Billing Volume Insights: Extract and parse split-level billing data from multiple different data sources (by product/region/segment etc.). Prepare and distribute segmented views to marketing, finance, and IR teams for earning calls - ensuring consistent reporting and correct billings allocations.
- CFO Dashboard Design: Develop monthly Excel-based dashboards focused on CIF metrics - integrating time-series plots, variance heat maps, and performance summaries to support executive-level insights.
- Cross-functional alignment: Partner with finance and business stakeholders to calibrate model assumptions, validate inputs, and reconcile projections - achieving agreement on key forecast drivers and outputs.
Financial Analyst Intern
American Express
New York
06.2024 - 08.2024
- Independently reviewed a Process Risk Self-Assessment by analyzing high-risk data distributions across business units, identifying three potential sources of misstatements, and recommending two control enhancements.
- Researched SOX Act compliance requirements in collaboration with the SOX team and presented findings to process owners and Operational Excellence leadership, strengthening internal risk management practices.
Health IT Intern
MiHIN
Remote
03.2023 - 01.2024
- Collaborated with IT teams to analyze over 50,000 data entries across 10+ hospitals, assessing compliance with data security standards. Identified key areas for improvement and presented audit findings and strategic recommendations to senior management, contributing to enhanced data governance and operational improvements.
- Developed Excel dashboards using PivotTables and charts to evaluate patient criteria and recommend blocking or permitting data exchanges, enabling secure information flow decisions across hospitals.
Education
BS - Finance
The University of Texas At Dallas
Dallas12.2024
Skills
- SQL and advanced Excel
- Data analysis with PivotTables
- Power Query and VBA
- Tableau and Power BI
- Financial forecasting techniques
- Time series analysis
- Sensitivity and scenario analysis
Websites
Timeline
Financial Analyst
American Express
03.2025 - Current
Financial Analyst Intern
American Express
06.2024 - 08.2024
Health IT Intern
MiHIN
03.2023 - 01.2024
BS - Finance
The University of Texas At Dallas