Peyton Floyd Email & Phone Number

Tukwila, Wa, Us

• Manage projects related to the development and maintenance of technology solutions that facilitate Credit Risk related reporting and analysis activities using Microsoft SQL Server, Excel, Tableau, and Alteryx• Lead initiatives to enhance reporting and analysis capabilities within Credit Risk; collaborate with other business units in identifying best practices/platforms• Regularly consult with senior management to identify opportunities for technology solutions support identification, quantification, and solutions of business issues• Manage external vendors that support Credit Risk Infrastructure Solutions• Support enterprise-wide Data Governance program; assist with definition of data benchmarks, data quality and business rules and execution of data governance projects• Same duties as listed below in previous Sr. Credit Risk BI Developer role

Tukwila, Wa, Us

• Manage projects related to the development and maintenance of technology solutions that facilitate Credit Risk related reporting and analysis activities using Microsoft SQL Server, Excel, Tableau, and Alteryx• Lead initiatives to enhance reporting and analysis capabilities within Credit Risk; collaborate with other business units in identifying best practices/platforms• Regularly consult with senior management to identify opportunities for technology solutions support identification, quantification, and solutions of business issues• Manage external vendors that support Credit Risk Infrastructure Solutions• Support enterprise-wide Data Governance program; assist with definition of data benchmarks, data quality and business rules and execution of data governance projects• Same duties as listed below in previous Sr. Credit Risk BI Developer role

Tukwila, Wa, Us

- Engineers and maintains complex SAS and SQL ETL processes to optimize performance and scalability as department needs grow- Modifies and maintains the monthly flow of drivers across the enterprise from sources such as Oracle, SQL, datamarts, excel, Web based, Tableau, and manual files.- Identifies relevant data sources and sets to mine for client business needs, and collect large structured and unstructured datasets and variables- Consults with departments across the organization to stay aware of data changes - Aides team with automation of data logging, data sourcing, and processing as needed- Creates documentation of data sources, critical data elements, data dictionary, etc. to meet data internal quality governance requirements.

Tukwila, Wa, Us

- Runs monthly updates to OLAP cubes used enterprise wide up to senior leadership- Configures and tunes ETL infrastructure to optimize data warehouse architecture as issues are discovered- Defines, drives, measures and continuously improves development and implementation processes to raise efficiency and technology maturity- Collaborates with other business units and enterprise EDM in identifying best practices/platforms. - Manages smaller scale projects with internal and external departments supporting initiatives to enhance reporting and analysis capabilities within Credit Risk- Seasoned at espousing Credit Risk housed data with other sources from across the enterprise to provide ad hoc reports, databases, or incorporate with our data for end users to use- Works with business/technical development team/data stewards to clearly document source elements and ensure standardized values, formats, business rules/algorithms, metadata requirements, and data element relationships

Tukwila, Wa, Us

- Recruited to lead the preparation of monthly credit risk committee reports viewed by executive and senior management, and to create actionable ad hoc reports supporting business needs and strategy, both internally, within the department, and externallyUtilizes multiple computer programs including SAS, SQL Studio, Tableau and Excel to extract, aggregate, and distill large amounts of data- Mentored and coordinated coworkers and remote workforce along with supporting an internal database administrator with quality assurance and support of our SQL based credit risk database

Tukwila, Wa, Us

- Developed and administered Retail and Contact Center quarterly incentive plan for over 400 employees. - - Main driver in the creation, documentation, and profitability research of 2017 Retail Incentive Plan

Tukwila, Wa, Us

- Recruited by Treasury department to cover Cost and Profitability role while still maintaining current role in Secondary over the first year- Ran the month end reporting process providing institution wide statements used for financial soundness. I maintained a SAS suite of applications to ensure reports go out on time while completing ad hoc reports utilizing Access, BI, and SAS queries.

I worked closely with the company owner to enhance and update the company excel based pricing engine.

Tukwila, Wa, Us

-Heavy utilization of analytical and technical(excel and coding) skill to report, forecast, solve problems and help in automation, hedging, and reporting. -Sets daily mortgage rates based on competitors, current market environment, and application volume. -Creates, executes, and monitors all commitments to FNMA.-Forward hedges all salable loans in house accounting for market movement and portfolio needs.-Runs loan level pricing checks to ensure correct pricing from investors -Works closely with Shipping to ensure commitments go out in a timely manner.-Routinely consulted by other departments to help create tools and process flows for new or large projects.-Writes daily economic commentary with department highlights for managers and VPs.-Entrusted to handle select higher level department decisions during manager's absence.-Creates many reports for my department and others as needed.-Utilized by System Admin to build and enhance reports for company as needed.-Works on lock desk daily with other employees.

-Sets rate sheet prices to buy loans based on current MBS market -Appropriates and Monitors loans in commitments for many investors-Works with Hedge Company to plan the buying of loan to mitigate risk-Works closely with Shipping to ensure loans go out in a timely manner-Builds reports for my department and others using Excel VBA, Webfocus, and SQL-Built excel and access model decreasing a Shipping process from 2 hours to 45 minutes-Participated in building an Excel model that pulls and checks over 400 fields of data for, Cenlar, our new Loan Servicer-Responsible for preparing, transferring, and follow up for all Retail Loans sent to Cenlar -Responsible for finding and integrating a new macro program to automate many daily tasks for Secondary and Shipping

-Input sold loans into Citrix and DataTrac database on daily basis -Paid Mortgage Insurance Premiums on select loans -Solved negative escrow problems with loans on daily basis-Communicated with Investors on escrow problems with loans-Assisted borrowers with questions about their loans-Involved with delinquent loans and collections-Processed payments

-Entrusted by employer to oversee all daily tasks while he was away-Designed new treadle for automatic wash decreasing driver error with entering wash-Handled money with customersClean premises-Job preformed while working way through college