Summary
Overview
Work History
Education
Skills
Certification
Affiliations
Timeline
Generic

Aarthi Jain

Hyderabad

Summary

Dynamic Senior Commercial RE Portfolio Representative at Wells Fargo with expertise in financial analysis and effective communication. Proven track record in enhancing compliance and operational efficiency for LIHTC properties. Skilled in variance analysis and leveraging Microsoft Excel to drive results.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior Commercial RE Portfolio Representative

Wells Fargo
Hyderabad
01.2024 - Current

CLI TCAM: Community Lending and Investment - Tax Credit Asset Management Team.

  • Specializing in Low-Income Housing Tax Credit (LIHTC) properties, supporting affordable housing initiatives.
  • Reviewing and performing quality checks for financial documents, including rent rolls, historical operating statements, and ensuring compliance with regulatory and investor requirements.
  • Perform detailed variance analysis, evaluate the Debt Service Coverage Ratio of the property, and assess reasons impacting change in property operations, notifying observations to U.S. counterparts.
  • Performing a quality check of guarantor financials to assess if the requirements mentioned in the guaranty agreement for liquidity and net worth have been fulfilled.
  • Processing annual audits to analyze the annual performance and the debt service of the property, as this is reviewed by the external auditor.

Additional tasks:

  • Preparing TAT reconciliation reports to ensure all the deals have been completed in the assigned period.
  • Frequent contact with U.S. counterparties regarding new updates for multiple processes.
  • Prepared a SOP for one of the processes.

Senior Analyst

SitusAMC
Hyderabad
05.2022 - 01.2024
  • Credit Admin Process: Requesting monthly, quarterly, and annual financials from borrowers.
  • Effectively communicating the updated schedules with Asset Managers and different processes.
  • Developed the structure of the process for the department in alignment with its detailed description and steps.
  • SWAT process: Preparation and quality check of spreading for the Asset Manager in Microsoft Excel, using the Income Statement, Profit and Loss Statement, Budget, and Rent Roll.
  • Performed property performance using the spreading.
  • Managed an average of 3 projects: ESG Rating, Interest Rate Cap, and Preparation of QAR.

Financial Analyst

Berkadia
Hyderabad
07.2020 - 05.2022
  • Uploading financials received on a monthly, quarterly, and annual basis pertaining to personal financial statements, insurance, appraisals, legal loan documents, UCC, escrow, closing forms, and all the major third-party activities.
  • Verifying if all the information is compatible and accurate.

Education

MBA -

NMIMS
true
03.2025

St. Joseph Degree & PG College
Hyderabad
03.2020

Intermediate -

Tapasya Junior College
03.2017

MEC -

St. Paul's Model High School
03.2015

Skills

  • Salesforce
  • C3 Application
  • Real INSIGHT
  • Enterprise E!
  • Microsoft Excel
  • MS PowerPoint
  • MS Word
  • HTML
  • Financial analysis
  • Variance analysis
  • Effective communication
  • Analytical Problem Solving
  • Group Facilitation
  • Resilience in Adversity

Certification

  • Certificate course in RETAIL MANAGEMENT
  • Certificate course in BUSINESS ENGLISH CERTIFICATE PRELIMINARY (BEC) council of Europe level B1
  • Certificate course in ORACLE
  • Certificate of Organizing ICNH-19(International Congress on Nutrition and Health)

Affiliations

  • Food blogger
  • Cooking, baking, and culinary arts
  • Zumba and fitness
  • Music

Timeline

Senior Commercial RE Portfolio Representative

Wells Fargo
01.2024 - Current

Senior Analyst

SitusAMC
05.2022 - 01.2024

Financial Analyst

Berkadia
07.2020 - 05.2022

MBA -

NMIMS

St. Joseph Degree & PG College

Intermediate -

Tapasya Junior College

MEC -

St. Paul's Model High School
Aarthi Jain