Work Experience
Coastal Community Bank – Credit Portfolio Analyst II
Everett, WA | Feb 2023 – Present
- Led initiatives in financial data reporting and risk monitoring for the MIS and reporting team.
- Delivered data insights for a $2B loan portfolio, producing monthly board-level reports and stress testing scenarios to guide strategic decisions.
- Used SQL and Python to create a Markov Analysis Model that would use fintech partner’s data to predict the probability of next month’s charge off amount. Resulted in a margin of error of 2%.
- Supported ad-hoc executive requests, transforming complex financial datasets into clear insights using SQL, Python, and Excel in a timely manner.
- Collaborated with Finance, Accounting, Product, Engineering, and Compliance teams to create portfolio analytics reports that met regulatory requirements.
- Mentored three analysts on data analysis and reporting tools.
Coastal Community Bank – Credit Analyst / Portfolio Data Analyst
Everett, WA | May 2022 – Feb 2023
- Produced monthly and quarterly financial reports for senior management and the board of directors.
- Automated data cleaning process for large fintech partners’ datasets using Python, reducing processing time and allowing for reporting capabilities for our executive team. Designed and implemented custom metrics to fill gaps in partner data.
- Led the portfolio reporting transition from Excel to Power BI.
- Automated Excel board reports using VBA, decreasing reporting time by 94%.
- Managed the bank’s Monitored Lines of Credit review processes, overseeing monthly collateral reviews and coordinating efforts among relationship managers, credit administration, and loan servicing.
Education
Eastern University
M.S. in Data Science, Aug 2022 – Aug 2024
Coursework: Python, SQL, R, Data Manipulation, Machine Learning
University of Washington
B.A. in Business Administration (Finance), Aug 2018 – Jun 2020