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

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.
• 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.
• 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.

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.
• 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.)