Dylan W. Email & Phone Number

Merrick, Ny, Us

New York City Metropolitan Area

• Managed all technology, commercial real estate, and financial modeling inquiries for twenty clients• Trained over fifty clients on how to use RealINSIGHT’s technology by leading both group and individual training sessions• Centralized ten of our client’s data sources and created custom integrators to feed data from our SQL back-end intoRealINSIGHT’s proprietary technology• Centralized ten of our client’s data sources and created custom integrators to feed data from our SQL back-end into RealINSIGHT’s proprietary technology• Automated client-specific financial models to systematically deliver a push-button reproducible product on a periodic basis• Leveraged R and VBA to normalize unstructured financial data produced by borrowers and produce monthly reporting for clients

Greater New York City Area

• Published both commercial real estate and structured finance research to provide prospective and current clients with industry insight• Developed an ARIMA Model to forecast the average loan spreads and debt yields for newly originated commercial mortgage-backed securities with 93% accuracy• Automated workflow processes to reduce both day-to-day and ad-hoc data processing time from 23 hours per month to 4 hours per month• Increased year-over-year client engagement metrics by 56% through targeted research pieces• Collaborated across Trepp’s bond finance and systems departments to deliver timely and accurate risk retention reports to clients

1800 M Street Nw Washington Dc

• Developed economic models to support expert witnesses in major financial litigation• Reviewed loan and supply agreements to assist in underwriting a 250 million dollar loan • Cleaned and analyzed large datasets using statistical computing packages, including R and VBA• Compiled and summarized market and industry data to be presented to external clients and counsel• Drafted figures and text based on quantitative and qualitative analysis for inclusion in reports and presentations

Jersey City

• Monitored the daily capital levels of DTCC’s three main subsidiaries • Mapped out policies and procedures for the department’s regulatory capital monitoring into a standardized process to improve efficiency • Organized DTCC’s presentation to Standard & Poor’s related to its credit ratings• Managed a team of three interns for a company-wide competition, conveying the department’s strategy to reduce costs and terminate unnecessary bank accounts

Greater New York City Area

• Transformed 600 data points within daily T&E expense report data into succinct information used to conduct audits within Cantor Fitzgerald• Modified the Internal Audit Department’s presentation for the Board of Directors illustrating their plan to integrate new SEC regulations• Conducted standard Sarbanes Oxley testing for GFI Group Inc.

Bachelor’S Degree, Economics, 3.89

Activities and Societies: Phi Sigma Pi National Honors Fraternity George Washington University Tour Guide The National Society.

Bachelor Of Science (B.S.), Economics, 3.89

Activities and Societies: Dean's List The National Society of Collegiate Scholars Phi Sigma Pi