Data manager of the Viewpoint CMBS application. Manage all application tables, analyzing, creating and updating records through SQL statements. Manage new deal import process, historical and present pari passu data, tenant mappings for tenant normalization, distinct properties for historical transactions, and all UI analytics. Created API import process to ingest data from vendor, resulting in a much more efficient process, with exception reporting. Created VBA application, built to analyze data inconsistencies and duplications accepted through the ETL process, and dynamically create update statements as a result of the analysis. Maintain and run stored procedures in order to promote data from source data tables to application data tables. Ensure data normalization across tables within the Company. Work with developers to enhance application UI/UX. Work with ETL developer for the enhancement and correction of the current ETL process. Worked with software developer to create an ingestion, cleansing, validating and load API, and UI, for any data type with errors and warnings considered.

Investor Management Services, Inc.Data Manager• Served as a crossover between the business and development teams in order to pinpoint and develop application enhancements in an Agile environment, working in two week sprints. • Built strong relationships in both the business and development teams in order to effectively understand, define and communicate business objectives.• Strategically planned the framework for the data on-boarding process.• Part of the “G9”, the top 9 most influential people of the Company, where I planned, created and presented market and product training to the rest of the Company. • Managed a team of data analysts, responsible for on-boarding client data.• Utilized JIRA to manage workflow and business priorities.• Wrote SQL queries to analyze data exceptions and anomalies within the polymorphic Oracle database.• Wrote SQL queries, advanced Excel formulas and VBA to transform data within the polymorphic Oracle database.Fairview Real Estate GroupData Manager• Managed the data tables for the Oracle database in connection with Fairview Real Estate’s Trader Tool application, built for CMBS depositors, investors and stakeholders.• Worked with the development team in order to correct / enhance the ETL process built for CMBS.com, as well as internally created, data sets.• Analyzed/scrubbed large data sets to ensure completeness and accuracy.• Worked with the development team to create new fields / calculations to enhance the data sets received in order to display additional information / metrics within the Trader Tool application.• Created Data Lineage and Transformation visualizations as training tools for the Company.• Wrote multiple Excel web crawlers/ scrapers to access information relating to property and market information used as base lines for property and market analytics.

• Managed a portfolio of $13.1 billion in principal balance, spread across nine commercial mortgage pools.• Point of contact for the legacy portfolio of assets, sold in June, 2013, in charge of Portfolio Management, Special Asset Group and Enterprise Management. • In charge of bidding on new business for the growth and sustainability of the business unit. Created detailed models, representing the expected revenue streams, based on the bid tape provided by depositors. Created bid templates based on Management expectations of interest rates / required internal rates of return.• Provided OCC and Mortgage Bankers Association reporting and CREEAS data validation for the Enterprise servicing portfolio, ensuring that data was reported in a consistent manner and representative of the collateral, and terms as underwritten. • Managed data tables, queries and reporting, utilizing Microsoft Access, for third party servicing portfolio not serviced on the system of record. • Analyzed real estate collateral data including financial statements, appraisals and inspections. • Provided solutions and intricate strategies for credit committee concerning credit analysis, debt assumption/property sales, release of holdbacks and reserves, lease reviews and debt service covenant analysis. • Created and presented the Monthly Management report to upper management and colleagues. Performed complex analytics and risk analysis on the portfolio universe, representing $140 billion in principal balance.

• Responsible for researching, and creating budget assumptions through modeling, using Microsoft Excel, for 190 owned and managed commercial real estate properties nationwide. • Modeled and explained pro forma and year over year variances for management fees, construction, mezzanine and amortized loans, property taxes and other expenses. • Wrote VBA macros to identically enhance models across all properties. • Implemented automated, security protected, processes utilizing macros and SQL/Access queries. • Responsible for information management of $500 million, libor based, subscription financing database for housing fund, built in Microsoft Access. • Tracked equity backed loans by property, tranche maturity, and IRR. Managed the reporting of subscription financing information to the Chief Financial Officer.

• Provided fundamental research from a top-down approach. Investment criteria emphasized major economic themes impacting the landscape of financial markets. • Spoke with Research Analysts on a daily basis, developing an in depth knowledge of market, sectors and individual securities financial outlook. • Worked with Portfolio Manager to coordinate investment themes, and timing of capital deployment.

Worked closely with client's management teams to gain understanding of their business models, and to manage strategic relationships. Developed client business plans, financial models, firm valuations and viable exit strategies. Prepared offering memoranda widely distributed to potential investors. Created Management Presentations and performed data room work during bidding processes.

Assisted with the management of the daily operations of the Equity Research Liaison team. Worked closely with Director to ensure the eight person team provided the highest level of service to the retail sales force. Provided stock recommendations, detailed analysis of stock price movement, in-house research marketing materials, and interpretation of news items and market trends to the sales force. Communicated daily with research analysts to obtain insights into market movements.