Peter Finseth, Mba Email & Phone Number

Dallas-Fort Worth Metroplex

• Manage the business intelligence and technology/reporting platforms utilizing multiple technologies: SQL Server, Power BI, TIBCO Spotfire, Power Apps, and SharePoint• Manage the SQL Server database including table management, creation of views, stored procedures, and triggers• Create efficient, optimized processes and solutions throughout the company to improve data sharing across business units (One-Stop Data Shop)• Perform detailed, complex budget and other financial modelling allowing users to manipulate variables to view financial impacts instantly• Manage project development and build processes to work with 3rd party systems to provide aircraft valuations through multiple platforms• Provide monthly Aircraft Portfolio valuation updates to clients including Fortune 100 corporations in the Asset Management or Flight Department platforms totaling close to $1 Billion in assets• Develop detailed analytics and reporting for the business units including Executive ManagementOur Mente Group team of aviation experts and solutions enthusiasts go above and beyond to ensure your success. Mente Group is held by Aquila Aviation Ventures, an investment company formed to serve unmet industry needs and leverage resources across entities to scale for future growth.Today’s private aircraft owners, operators and users must make informed, time-sensitive, and financially significant decisions about the aviation solutions that best meet their needs from selling and buying aircraft, fleet planning, appraisals, and forecasting aircraft values.We are a team of experts, each focused on a unique aspect of business aviation, standing beside you as we work toward a common goal: your success. Discover a higher standard of service with Mente.From navigating transactions to managing your aircraft portfolio, Mente Group is an all-in-one solutions team with your success in mind.

Dallas-Fort Worth Metroplex

• Build analytical tools, dashboards, models, and reports regarding property valuations using Spotfire Reporting, Tableau Reporting, SQL, and SAS• Developed the Automated Designation platform using SAS back-end and Spotfire front end interface for daily assignment of approximately 1,000 property appraisals for auto designation, outsourcing, or analyst review• Developed the Alternative Disposition Sales Pool platform using SAS and Spotfire to allocate up to 2,000 properties on a monthly basis to determine eligibility for alternative disposition, sales re-evaluation, or appraiser re-evaluation• Developed the analytics for the quarterly Non-Performing Loan Sales and Re-Performing Loan Sales through SAS, Spotfire, and Tableau for pools of 5,000 to 10,000 or more loans ($500M to $1B+) to ensure the values received are within management’s risk tolerance or the loans get reviewed by appraisal analysts• Presented a monthly analysis on the top 50 MSAs to ensure properties are correctly valued and values are strategically changing due to seasonality, unemployment, and other specific market conditions• Designed an intuitive Key Performance Indicator dashboard for management through Tableau to evaluate market performance and evaluate performance of 40+ valuation analysts utilized in their monthly analyst/manager meetings

Dallas-Fort Worth Metroplex

• Team lead for Servicing projects to gather business requirements for programmers• Built reporting, analytics, and dashboards for Servicing Projects through Spotfire• Assisted in migration of code (SDLC) and reports from Development to UAT to Production including testing

Dallas-Fort Worth Metroplex

• Managed a team of two requirements analysts and one SQL developer• Created process to provide daily workout information to Freddie Mac• Managed recurring and ad-hoc reporting and development for Freddie Mac

Dallas-Fort Worth Metroplex

• Managed 4 developers who created 70+ accounting models/reports using SQL, MS Access, Excel, SAS, Business Objects, and Crystal Reports• Automated quarterly disclosure reporting processes into SQL/SAS to reduce turn-around time from 2 weeks to 2 days• Enhanced ability for accounting to view a loan’s transactional history from multiple queries to an instant push-button• Coordinated closing execution timelines and deliverables with accounting management• Greenbelt Six Sigma Team lead in Six Sigma greenbelt project to decrease time to complete monthly close and improve data quality

Dallas-Fort Worth Metroplex

• Perform analytics for monthly Collateral Valuation Oversight Committee to ensure proper valuation of loans• Prepare quarterly accounting disclosures related to Valuation, Interest Charge-offs, and FAS 157• Develop the reporting platform for the Single Family REO Accounting function through a combination of reporting tools • Responsible for month end data validation from multiple source systems (G/L, Operations)

Dallas-Fort Worth Metroplex

• Team leader in development of MSR (Mortgage Servicing Rights) data-mart project and report creation using SQL• Developed and automated the Business Line P&L to break out the different business lines: Mortgage Banking, Trading,Servicing, and Warehouse• Run the quarterly Static Pool Analysis model to evaluate the P&L impact of a given set of loans

Dallas-Fort Worth Metroplex

• Managed report development for business units using Microsoft Reporting Service• Managed development of Secondary Marketing Database to track loans sold and stipulation requirements in Whole Loan Sales• Designed a model to help forecast delinquencies which aids in determining necessary servicing headcount• Senior Strategic Planning Analyst for 3 years responsible for 5 year budgeting and forecasting:• Automated the Corporate Planning Model through Excel, VBA, and TM1

Dallas-Fort Worth Metroplex

• Built and managed corporate P&L model through Excel and VBA programming for 5 year budgets for Income Statement, Balance Sheet, and Cash Flow Statements• Run multiple “what if” P&L scenarios to reach hit financial targets (ROA, ROE, Capital Asset Ratio)• Provided Rate/Receivables variance analysis for Executive Management• Designed an Access model to estimate expected loss on REO loans

Dallas-Fort Worth Metroplex

• Developed an Excel model to forecast when a securitization trigger would fail to allow time to renegotiate trigger levels• Used Crystal Reports to perform Exception Reporting on Underwriting, Appraisal, and Sales• Improved efficiencies on selling loans to 3rd parties by using Crystal Reports to summarize loans in inventory• Performed detailed stratification analysis on loan characteristics such as FICO, CLTV, and Credit Grade

Dallas-Fort Worth Metroplex

• Supervised the Investor Reporting group on seven Master Trusts totaling $65 Billion in receivables and providing monthly reports to Executive Management showing Trust performance including Default Rates, Spread and Reserve account levels• Assisted Structured Finance with new securitization legal agreements as well as the new Master Owner Trust logistics• Provided recommendation to Executive Management on what database management system to use• Performed role of Database Administrator – managed enhancements, security, and reporting

Dallas-Fort Worth Metroplex

• Created Investor Reports to be issued to trustees, investors, rating agencies, and Bloomberg• Monitored and analyzed trust performance including amortization schedules and trigger analysis• Project Manager for the implementation of five Master Trusts to the database system• Coded the securitizations’ waterfall logic into the system• Performed stress testing to help determine when a securitization trigger would fail

Dallas-Fort Worth Metroplex

• Prepared wires for principal and interest payments to investors• Reconciled trust accounts to ensure appropriate cash movement to and from trustees • Served as system liaison with First Data Resources

Bachelor Of Business Administration (B.B.A.)

Master Of Business Administration (M.B.A.)