Lee Ehlert

VP of Secondary Markets at Hometrust Mortgage Company
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • Financial Services
    • 100 - 200 Employee
    • VP of Secondary Markets
      • Oct 2021 - Present

    • Secondary Markets Analyst/ Lock Desk Team Lead/ Junior Trader
      • Apr 2020 - Oct 2021

      • Update and deliver weekly and monthly department reports • Maintain and protect pricing margins and profitability expectations • Offer loan sales for bid to investors, analyze best executions and complete loan sales • Manage net exposure of pipeline and warehouse risk position within policy limits by executing appropriate MBS and Cash commitments • Provided support to Post Closing Department to ensure timely delivery to investors and the reconciliations of sales • Analyze best… Show more • Update and deliver weekly and monthly department reports • Maintain and protect pricing margins and profitability expectations • Offer loan sales for bid to investors, analyze best executions and complete loan sales • Manage net exposure of pipeline and warehouse risk position within policy limits by executing appropriate MBS and Cash commitments • Provided support to Post Closing Department to ensure timely delivery to investors and the reconciliations of sales • Analyze best execution for pooling of GNMA securities • Support Lock Desk in lead capacity, providing day-to-day operational and pricing inquiries from Lock Desk Associates and Loan Officers • Reviewed, analyzed and researched products and pricing related to FNMA, FHLMC, GNMA and Bond products • Manage rate locks of new lock requests, lock extensions, re-locks, scenario updates, rate and program changes, lock transfers, cancellations, concessions, etc. • Research and reconcile pricing issues • Manage investor pipelines for best effort locks • Provide support for team and Loan Officers as point of contact regarding Optimal Blue • Provide new and updated procedural documentation to team • Provide direct support to VP of Secondary Markets on daily operations

    • Secondary Markets Data Analyst
      • Jun 2012 - Jul 2019

      • Developed company specific and department ad-hoc reports in SQL, MS Access and MS Excel • Maintained up-to-date reports and reporting databases • Provided ideas for new reports and reporting functions/applications • Provided data pulls from database for use with reporting and pricing models • Provided support related to the pooling, trading, analysis and settlement of bulk loan sales and forward commitments • Prepared various internal monthly financial analysis reports and… Show more • Developed company specific and department ad-hoc reports in SQL, MS Access and MS Excel • Maintained up-to-date reports and reporting databases • Provided ideas for new reports and reporting functions/applications • Provided data pulls from database for use with reporting and pricing models • Provided support related to the pooling, trading, analysis and settlement of bulk loan sales and forward commitments • Prepared various internal monthly financial analysis reports and inventory reports • Reviewed, analyzed and researched products, exceptions and pricing • Acquired specialized data through several internal database systems and understands the business impact of relevant data points • Modified and created MS Access queries for internal department use • Supported lock desk as needed, locking loans and lock extensions • Provided support to mod loan buyouts, and generated special loan pools reports • Managed pooling of Ginnie Mae securities by creating trade pools, created trade data tapes, communicated with custodian bank, performed GinnieNet uploads, coordinated with post closing for timely file deliveries and tracking/reporting of exceptions Show less • Developed company specific and department ad-hoc reports in SQL, MS Access and MS Excel • Maintained up-to-date reports and reporting databases • Provided ideas for new reports and reporting functions/applications • Provided data pulls from database for use with reporting and pricing models • Provided support related to the pooling, trading, analysis and settlement of bulk loan sales and forward commitments • Prepared various internal monthly financial analysis reports and… Show more • Developed company specific and department ad-hoc reports in SQL, MS Access and MS Excel • Maintained up-to-date reports and reporting databases • Provided ideas for new reports and reporting functions/applications • Provided data pulls from database for use with reporting and pricing models • Provided support related to the pooling, trading, analysis and settlement of bulk loan sales and forward commitments • Prepared various internal monthly financial analysis reports and inventory reports • Reviewed, analyzed and researched products, exceptions and pricing • Acquired specialized data through several internal database systems and understands the business impact of relevant data points • Modified and created MS Access queries for internal department use • Supported lock desk as needed, locking loans and lock extensions • Provided support to mod loan buyouts, and generated special loan pools reports • Managed pooling of Ginnie Mae securities by creating trade pools, created trade data tapes, communicated with custodian bank, performed GinnieNet uploads, coordinated with post closing for timely file deliveries and tracking/reporting of exceptions Show less

    • United States
    • Financial Services
    • 700 & Above Employee
    • WSO Application Business Analyst
      • May 2009 - May 2012

      • Identified complex application issues arising in the course of business and proposed solutions to the WSO vendor • Tested upgrades and patches to WSO system for implementation • Provided documentation to Client Service teams on upgrades and functionality changes • Developed team specific reports in Crystal Reports, MS Access and MS Excel

    • WSO Support Business Analyst
      • Nov 2007 - Apr 2009

      • Provided support to Client Service teams on WSO Compliance application, Administrator application and Reporting application in regard to data related issues and application functionality • Maintained issue tracking database in MS Access • Created best practice compliance manuals for use across US entities • Provided class training and Q/A demo sessions on specialized proprietary applications

    • Financial Services
    • 1 - 100 Employee
    • Collateral Data Analyst I
      • Jan 2007 - Aug 2007

      • Provided reports for management through use of MS Excel, MS Access, SQL and Crystal Reports • Analyzed pricing models in MS Excel for correct pricing and updates to pricing adjustments • Maintained up-to-date reports and reporting databases • Provided ideas for new reports and reporting functions/applications • Provided data pulls from database for use with reports and pricing models • Provided support related to the pooling, trading, analysis and settlement of bulk loan sales… Show more • Provided reports for management through use of MS Excel, MS Access, SQL and Crystal Reports • Analyzed pricing models in MS Excel for correct pricing and updates to pricing adjustments • Maintained up-to-date reports and reporting databases • Provided ideas for new reports and reporting functions/applications • Provided data pulls from database for use with reports and pricing models • Provided support related to the pooling, trading, analysis and settlement of bulk loan sales and forward commitments • Prepared various internal monthly financial analysis reports related to loan sales and inventory • Reviewed, analyzed and researched products, suspense and pricing • Acquired loan level data through several internal database systems and understands the business impact of loan level data points • Provided loan level pricing and additional transaction fields for each sale • Pulled loan bid tapes through use of MS Access and worked with all levels of investors to answer data related questions/concerns • Modified and created MS Access queries for internal department use • Provided support on data fields in Aegis’ Loan Smith database

    • Reporting and Technical Applications Business Coordinator
      • Oct 2005 - Jan 2007

      • Provided reports for management and field level associates through use of MS Excel, MS Access, SQL and Crystal Reports • Provided reporting application training to field on use of Crystal Reports • Helped maintain and trouble shoot current reports • Provided ideas for new reports and reporting functions/applications • Provided customer support to branches and AWC personnel on reporting problems

    • Post Closing Shipping Coordinator Team Lead
      • Jul 2002 - Sep 2005

      • Managed a team of 4 direct reports and 1 indirect report • Maintained department reports using Microsoft Access and Excel • Coordinated on-time receipt and delivery of loan files • Informed senior management of operational problems

Education

  • Stephen F. Austin State University
    Computer Science

Community

You need to have a working account to view this content. Click here to join now