Summary
Overview
Work History
Education
Certification
Applications
Timeline
Generic

Umarani Kothapally

Senior Commercial Underwriter
Flat 302, Maruti Residency, Komaplly village

Summary

Enthusiastic professional with experience over 8 years and has extensive knowledge on Underwriting, Financial Planning & Analysis of Commercial Real Estate deals. Highly analytical, organized and detail-oriented. Versatile professional with background in Canadian and US Markets.

Overview

7
7
years of professional experience
2
2
Certifications

Work History

Senior Account Processing Officer

CIBC
10.2022 - 04.2023
  • Completing in-depth loan analysis and underwriting for Commercial deals supported by due diligence and recommendation and presenting the loan for approval before loan adjudication committee.
  • Analysis rent roll, cash flow, lease documents, income documents, Appraisal, Environmental, Property condition reports for in-depth risk analysis.
  • Evaluating customer's data and financial details to identify exceptions to financial policies.
  • Work closely with branches and stake holders to obtain all the relevant information to underwrite the deal.
  • Train new hires and perform cross departmental training sessions

Senior Commercial Real Estate Underwriter

Situs AMC
04.2022 - 08.2022
  • Worked with Situs AMC Appraisal team while drafting Appraisal reports for clients and extended quality check support for the on-going reports and communicated deviations from the company standards.
  • Provided quality control assistance for Greystone sponsored Multifamily Asset Summary Reports (ASR) and worked over 20+ deals over the period of 3 months.
  • Prepared internal and regulatory financial reports and income statements.
  • Prepared Asset Summary Reports (ASR) for Client Key Bank, being exclusive to Property location, Market and Submarket analysis.
  • Prepared comprehensive financial reports by collecting, formatting and analyzing key data points.
  • Prepared monthly P&L statements and pro-forma financial models to assess current and projected financial performance.
  • Reconciled transactions by comparing and correcting data.
  • Prepared market analysis and market reports for Client Key Bank on adhoc basis.
  • Clients: Keybank, Greystone, Situs Commercial Underwriting Department and EU Situs reporting.
  • Resolved problems, improved operations and provided exceptional service.

Lead Operations Processor

Wells Fargo Solutions
05.2019 - 04.2022
  • Underwritten and developed Financial Models for over 300+ Commercial Real Estate properties and assisted US team meticulously by providing notable red flags, thereby improved the quality of the client service.
  • Drafted over 200+ ASR (Asset Summary Report) reports after the loan has been funded
  • Responsible to analyze and process property financial statement and loan related documents (e.g. rent roll, historical operating statements, appraisal reports collections and budget)
  • Responsible to prepare Asset Summary Report based on third party reports such as Appraisal Report, Property Condition Assessment, Environmental Site Assessment, Zoning and Seismic report.
  • Analysed Costar, Argus and REIS applications while preparing Asset Summary Report.
  • Responsible for monitoring and analyzing the property performance based on Tenants details, Property Cash Flows and provide the necessary recommendation to Prescreening/Underwriting team. Analyze and validate the loan documents and share all the inconsistencies to Reviewer/onshore as per the agreed procedure.
  • Reconciling Freddie Mac and Fannie Mae closed loans in respective websites.
  • Reconciled transactions by comparing and correcting data.
  • Used Vlookup and other MS Office tools to create financial models and to analyse the Rent Roll details.
  • Analysed monthly P&L statements and pro-forma financial models to assess current and projected financial performance.
  • Prepared Performance Report for team members and Monthly & Weekly reports for onshore partners. Responsible to groom new team members.
  • Closely worked with Risk and other operational partners in respect to avoid/mitigate any loopholes in the process and always adhere to the company polices
  • Developed monthly/yearly variance reports to highlight significant variances in Market reports from previous quarter/year.
  • Acted as a single point of contact for client for Asset Summary Report preparation.
  • Provided specialized financial planning support for clients with diverse portfolios and individual needs.
  • Provided Quality check and feedback to peers and associates. Provided Root cause analysis for errors and developed ideas to offset future occurrences.




Cash Administrations & Special Servicing

Wells Fargo Solutions
02.2016 - 04.2019
  • Handled Payments of Principal and disbursement of funds to third parties, changing the payment schedules, taking decisions and making changes as per borrower's request and ultimately answering the investors/Borrowers.
  • Reduced financial discrepancies, effectively reconciling client requests and organizing information into accounting software.
  • Responsible to follow procedures and handle confidential customer information.
  • Reconciled monthly Cash/Wire payments to Lockbox accounts at the company to prepare a report for Investor analysis and publications.
  • Reconciled accounts, managed audits and updated financial records with remarkable accuracy.

Education

MBA - Accounting And Finance

Osmania University
Hydeabad, India
07.2015 - 2017.05

Bachelor of Commerce - Accounting And Business Management

St. Francis College For Women
Hyderabad, India
06.2011 - 2014.05

Intermediate Education - Mathematics, Economics And Commerce (MEC)

St. Francis Junior College
Hyderabad, India
06.2009 - 2011.05

Certification

Commercial Mortgage Servicer Level - I, MBA Association USA

Applications

Costar and REIS

MS Excel and Word

Argus (Basic knowledge)

Timeline

Commercial certified Mortgage Servicer (CCMS) - MBA Association USA

12-2022

Senior Account Processing Officer

CIBC
10.2022 - 04.2023

Senior Commercial Real Estate Underwriter

Situs AMC
04.2022 - 08.2022

Lead Operations Processor

Wells Fargo Solutions
05.2019 - 04.2022

Commercial Mortgage Servicer Level - I, MBA Association USA

12-2018

Cash Administrations & Special Servicing

Wells Fargo Solutions
02.2016 - 04.2019

MBA - Accounting And Finance

Osmania University
07.2015 - 2017.05

Bachelor of Commerce - Accounting And Business Management

St. Francis College For Women
06.2011 - 2014.05

Intermediate Education - Mathematics, Economics And Commerce (MEC)

St. Francis Junior College
06.2009 - 2011.05
Umarani KothapallySenior Commercial Underwriter