Communicate effectively with businesses in uncovering requirements and strategically collaborate with developers and relevant team members in the planning, development, testing and release of data-driven IT solutions.• Developed reports via Report Builder, SSRS, and Excel VBA using complex expressions with relevant data fields to provide solutions for clients to make an informed decision • Access data using SQL Server Management Studio as a means of building queries, extracting data, and navigating stored procedures. • Provided hands-on training for business managers and staff members in use of ad-hoc reporting tools such as Report Builder and Encompass LOS pipelines. • Managed adding and removal of Encompass software data fields to and from reporting database and data warehouse in Development, UAT, and Production environments.• Collaboratively maintained company-wide websites containing over 100 reports and multiple data-driven solutions available for online access.

Coordinate the release of new loan product solutions using systematic procedures which include project management, product research, back-end systems setup, product training and presentation, and the production and publishing of online resources via SharePoint.Build complex database queries to identify active loan items of specific attributes using MS Report Builder and Excel to assist in data-based managerial decision making. Create regular monthly report for secondary marketing management using Excel pivot tables and formulas to detail fees charged by title companies nationwide for auditing purposes. Assist team members of various departments with Helpdesk inquiries related to loan programs, investor guidelines, and company underwriting policies to provide efficient and effective customer service.

• Manage high volume loan pipeline by planning daily and strategizing accordingly in order to ensure accurate and timely closing of 30 loan files per month. • Proactively collect and verify required documentation from borrowers and third parties in coordination with AUS findings prior to submission to underwriting. • Calculate borrower monthly income, loan to value and debt-to-income ratios in order to verify compliance of qualification standards. • Consistently recognized as top performer for number of loans funded monthly and average monthly quality scores.• Collaborated with settlement agent to ensure accuracy of final closing disclosure prior to borrower delivery of closing documents in accordance with closing date. • Conducted final review of loan documents to verify accuracy of vesting, escrow, title commitment, taxes due, HOA dues, and investor-specific documents.

• Comprehensive analysis of appraisal, credit report, title commitment, income, and relevant loan documents to ensure loan salability and prevention of fraud.

• Presented needs-based mortgage solutions to clients while providing exceptional customer service.• Recognized as top producer for regional monthly sales volume among a sales force of more than 40 loan officers.