• Evaluated commercial real estate mortgage requests for single assets ranging from $5 million to portfolios up to $100 million. Forecasted future net income, expenses, and property value using historical and pro forma data • Provided analysis in all aspects of the commercial mortgage loan origination process including economic analysis, borrower analysis, market analysis, and tenant lease review• Evaluated the level of risk for mortgage requests by determining the loan to value, collateral and guarantor strength, debt service coverage, and net operating income• Wrote detailed loan summaries and conducted presentations to the executive credit committee seeking formal approval of mortgage requests • Created and maintained a database of detailed insurance coverage information for approximately 500 loans with 1,600 separate coverages in the Commercial Real Estate portfolio with a balance of $8 Billion• Built database in Excel to track insurance coverage using macros, pivot tables, various if functions, and index-match. This database led to increased efficiency and mitigated risk leading to a 98.5% compliance rating• Assisted in house loan closing team through reviewing third party reports, updating economic information, and procuring necessary loan closing checklist items• Supported loan servicing team through maintaining borrower rent roll information, determining if property inspection data was correct, and contacted servicing correspondents if discrepancies were found• Aided portfolio analytics group while providing analysis and review of direct servicing commercial and hotel loans. Assessed data from borrower and property financial statements while coding each revenue and expense line item