๐ŸŸขabbyramadan.com โ€” Excel
?
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
C1
fx
="Abby Ramadan"
A
B
C
D
E
F
G
H
I
J
K
1
ABBY RAMADAN
2
Capital Markets Associate ยท Financial Analyst ยท Structured Finance
3
Chicago, IL (open to relocation to Bay Area) ยท abbyramadan98@gmail.com ยท linkedin.com/in/abby-ramadan/
4
5
SUMMARY
6
Financial analyst specializing in forecasting, financial modeling, and data-driven analysis across $300MM+ portfolios. Skilled in financial modeling, cash flow forecasting, and interpreting credit agreements to support regulatory compliance, risk management, and funding strategy.
7
8
EXPERIENCE
9
10
Above Lending
Chicago, IL
11
Above Lending
12
Chicago, IL
13
Capital Markets Associate
January 2025 โ€“ Present
14
Capital Markets Associate
15
January 2025 โ€“ Present
16
โ€ข Built and enhanced financial models and SQL-driven reporting to forecast loan performance and cash flows for $300MM+ portfolios to support capital allocation and funding decisions
17
โ€ข Performed variance analysis on forecasted vs. actual cash flows to hone forecast accuracy
18
โ€ข Streamlined reporting processes by consolidating redundant workbooks and improving SQL code clarity, reducing reporting preparation time by 30%
19
โ€ข Analyzed credit agreements and corrected report logic, unlocking $500,000+ in additional borrowing capacity under warehouse facilities
20
โ€ข Enhanced loan allocation tools and aligned processes with legal documents to ensure regulatory compliance
21
โ€ข Collaborated cross-functionally to support strategic initiatives across Capital Markets and other teams
22
23
Golub Capital
Chicago, IL
24
Golub Capital
25
Chicago, IL
26
Structured Finance Analyst
September 2022 โ€“ December 2024
27
Structured Finance Analyst
28
September 2022 โ€“ December 2024
29
โ€ข Monitored and analyzed 10+ multi-million dollar asset-backed securities to ensure compliance with covenants
30
โ€ข Modeled projected asset performance and recommended portfolio trades to optimize returns
31
โ€ข Interpreted indentures and advised stakeholders on compliance, supporting treasury activities
32
โ€ข Collaborated with rating agencies and presented financial analyses to support transaction outcomes
33
34
CME Group
Chicago, IL
35
CME Group
36
Chicago, IL
37
Examiner
January 2022 โ€“ September 2022
38
Examiner
39
January 2022 โ€“ September 2022
40
โ€ข Reconciled firm financials and third-party documentation to validate accuracy and regulatory compliance
41
โ€ข Conducted testing and analysis of financial data in accordance with CFTC regulations
42
โ€ข Assisted in testing judgmentally selected samples and researching regulations as part of examination team
43
44
Examiner Intern
May 2021 โ€“ July 2021
45
Examiner Intern
46
May 2021 โ€“ July 2021
47
โ€ข Prepared workpapers for examinations under guidance of senior examiners
48
โ€ข Researched relevant CFTC rules for FCMs to support examinations
49
50
EY
Chicago, IL
51
EY
52
Chicago, IL
53
Regional Tax Intern
January 2020 โ€“ March 2020
54
Regional Tax Intern
55
January 2020 โ€“ March 2020
56
โ€ข Fulfilled client needs by documenting international tax rules for the Global Compliance & Reporting tax team
57
โ€ข Prepared and organized client workpapers and performed substantive analytical procedures
58
โ€ข Received training regarding corporate tax return preparation and computation of tax liability for different entities
59
60
R.J. O'Brien & Associates LLC
Chicago, IL
61
R.J. O'Brien & Associates LLC
62
Chicago, IL
63
Accounting Intern
June 2019 โ€“ August 2019
64
Accounting Intern
65
June 2019 โ€“ August 2019
66
โ€ข Monitored internal controls and utilized XML schema to streamline reporting of monthly regulatory reports
67
โ€ข Created and analyzed rolling charts in Excel for tracking trends of account balances and ratios
68
69
EDUCATION
70
71
Case Western Reserve University
Cleveland, OH
72
Case Western Reserve University
73
Cleveland, OH
74
Master of Accountancy
January 2021 โ€“ December 2021
75
Master of Accountancy
76
January 2021 โ€“ December 2021
77
Bachelor of Science in Accounting, Applied Data Science Minor
August 2017 โ€“ December 2021
78
Bachelor of Science in Accounting, Applied Data Science Minor
79
August 2017 โ€“ December 2021
80
81
SKILLS
82
83
Excel (advanced) ยท SQL ยท Tableau ยท PowerBI ยท Power Automate ยท R ยท Python ยท Forecasting ยท Treasury & Liquidity Management ยท Structured Finance
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
Ready|๐Ÿ”’ Sheet protected
Average: โ€“Count: โ€“Sum: โ€“|100%