Dylan W. Email & Phone Number

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

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

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