LOAN SETUP ASSOSCIATE (PRE-UNDERWRITING) AND PFC CO-ORDINATOR | 02/2020 - 07/2022Altisource Business Solutions Pvt Ltd - Bangalore • Loan setup process is nothing Pre-Underwriting but the setup term ordering third party items and prepare the US mortgage file processing.• Reviewing the all-mortgage Documents like 10O3, Credit report, Loan Estimate, Checking Fraud Guard, Compliance Ease, Fennemae, Freddiemac Paystubs, Tax Returns and Wages.• Thorough experience end to end 4C's, • Expertise in FHA, VA, USDA and Conventional loan products.• As per Client request reviewing the scanned copies and verifying the loan applications.• Handling of new projects and delivers within the given time by client.• Review and update credit loan files.• Completing the Assigned task within the stipulated time.• Meeting Daily targets with the Best Quality of service.• Preparation of Management reports like production report, process accuracy reports of both internal and external findings and weekly report.• Providing feedback to the agents on their Impact and internal errors.• Pre-Purchase Reviewer is to review the closed loan file documents and ensure that the loan closed according to the approval, meets all federal, state, local and investor requirements and that the data in the LOS matches the data in the US mortgage loan documents.• Handling Advance excel V-lookup and Pivot Tables for using multiple criteria.• Knowledge on MySQL for writing complex queries.• Knowledge on Core Python for writing queries.PFC CO-ORDINATOR: PROJECT: US CLAIMS REPORTING| 08/2022 - 02/2023• SR report.• Daily dispute.• Ageing report – Summary Details.• Ageing report – Ticket Details.• Used Advance Excel, MySQL.• Power BI.