Data Sales
Resume:
SCOTT A. SCHREMS
*** *. **** ******, *** #*C, New York, NY 10028
aco8le@r.postjobfree.com
Summary
Analytic and dynamic business professional with experience in data analysis, mortgage sales and
securitizations, statistical programming, financial analysis, front-end software development, and
mortgage collateral analytics seeking a fast-paced position in an exciting and creative environment
Relevant Skills
R Programming Data Visualization Stata Programming
Mortgage Collateral Statistical Analysis Litigation Support
Data Analyisis GUI Software Design Asset Securitization
Experience
J.P. Morgan Securities, LLC, New York, NY
Executive Director – Securitized Products Group May 2007 – April 2014
• Led MBS collateral group of six data analysts working on MBS transactions and whole-loan
acquisitions, sales, securitizations, and analysis including mortgage pool analytics and
reporting, tying out deal documents with accountants and counterparties, providing statistical
inputs for structuring and bond modeling, and inventory management for trading desks
• Was main contact for initial design and testing of mortgage data section of JPM’s internally
developed, life-of-loan inventory management system for whole-loan trading which involved
creating and executing test scenarios and reporting the results of the testing to ensure all
issues identified were addressed by developers
• Was primary collateral contact for whole-loan financing including setting up data consistency
checks, reporting systems for monitoring line usage, ensuring pledged collateral matches legal
documents, and updating systems as new assets were financed or removed from the line
• Led mortgage resolution securitization team by working extensively with internal and external
counsel to provide analysis and deal performance reports to resolve JPM’s mortgage litigation
and inquiries by various governmental and regulatory organizations
• Designed the front end and implemented a proprietary database system for JPM’s mortgage
resolution effort to enable reporting on 795 legacy JPM, Bear, and WAMU securitizations
utilizing monthly trustee remit data, metadata from scanned shared drives, and due diligence
results into reports to provide a comprehensive view of securitizations for JPM legal defense
• Integrated data and inventory systems between JPM and Bear trading positions
(approximately 13,000 assets by 450 data points) to create a universal data position for all
whole-loan positions, crafted data export to board JPM’s loan position into SBO 2000 for
servicer balancing, and created data feeds from SBO 2000 to JPM’s whole-loan inventory
system for monthly servicing updates for inventory management purposes
Ameriquest Mortgage Company, New York, NY
Associate – Secondary Marketing & Valuation January 2006 – March 2007
• Structured $9.75 billion of subprime mortgage securitizations by analyzing collateral, sizing
debt and equity tranches, optimizing REMIC structures, assigning derivatives, determining
the optimal mortgage insurance populations, and pricing bonds
Worked extensively with CAS and origination templates to automate the collection of error-
•
free, analyzable production data to mark pools for profitability analysis, and hedging purposes
Coordinated with internal deal managers, bankers, legal counsel, and accountants to facilitate
•
the deal process including creating rating agency packages, generating tables and exhibits for
legal documents, and tying out cash flows and collateral characteristics
Optimized loan portfolio by running loan-level models, creating pools, and running
•
executions to maximize total portfolio execution resulting in a pickup of 10-15 bps per month
Tested different internal models on $90 billion of collateral for congruent and consistent
•
collateral reports, bond and collateral cash flows, rating agency optimizations, repline
generation, derivative schedules, and estimated executions
Ameriquest Mortgage Company, Irvine, CA
Transaction Manager – Collateral & Data Management August 2003 – January 2006
• Managed the collateral side of $35 billion of securitized transactions and approximately $10.2
billion whole-loan trades including collateral selection, deal reporting and tying out deal-
related legal documents including ProSupps, Term Sheets, and 8Ks
• Created pricing allocation model used to distribute $4.9 billion of whole-loan sale profits to
each Argent/Ameriquest line of business
Welch Consulting, Santa Monica, CA April 1998 – July 2001
Economic and statistical consulting firm providing analysis utilizing econometric modeling
and quantitative analysis for the purposes of expert witness testimony
Associate Economist
• Created econometric models, ran regression statistics, and wrote Stata/SAS programs on large
data sets for clients involved in class-action lawsuits regarding wage and hour claims,
employment discrimination, and calculated potential economic damages
• Worked with economists and legal counsel to create exhibits and reports showing the results
of our analysis for clients and for inclusion in court documents
Education
Kelley School of Business, Indiana University, Bloomington, IN May 2003
Master of Business Administration, dual majors in Finance and Accounting, minor in Decision
Support Modeling
• Investment Banking Academy, faculty-selected member
University of Wisconsin-Milwaukee, Milwaukee, WI December 1996
Bachelor of Business Administration, majors in Finance and Economics
Other
• Skilled in RegEx, Stata/SAS, Excel, SQL, Linux/Unix, R, and VBA
• Enjoy English Premier League soccer and supporting rescue dog charities
Contact this candidate