Director
CurrentDirector of Business Intelligance (March 2023 - Current) VP of Business Intelligance (April 2018 - March 2023) AVP of Business Intelligence (August 2016 - April 2018)- Managing internal remittance database, comprised of 100+ tables and 300+ stored procedures- Collaborating on creation of Enterprise Data Warehouse (EDW), a central hub of all servicer data- Building controls to automatically identify month-to-month changes to key loan characteristics- Writing VBA code referencing SQL procedures that automatically pull data into investor reporting- Creating mapping templates and processes to normalize data across multiple reporting formatsQuantitative Analyst (August 2014 - August 2016)- Maintained portfolio tape of 40,000+ assets, running monthly updates on active loan data- Exercised monthly quality control measures to ensure accuracy of investor loan data- Streamlined remittance reconciliation process, creating uniform structure for servicer reporting- Provided loan sale bid tapes, pool strats, delinquency analysis, and other ad-hoc reporting- On-boarded multiple clients/servicers, collaborated internally to create new customized reporting- Generated performance aggregation reporting, dashboards, and re-securitized deal summaries