• Created database to evaluate performance of loans on day-to-day basis. At its peak, total assets exceeded $50.0M. Database was multiproduct and supported several businesses lines from credit to sales to collections to compliance and accounting. Database was used to provide reporting to servicing clients, outside dealers, purchasing parties, and company’s lender.• Created dashboards which included SQL tables, graphs, and widgets to monitor day-to-day performance, historical loan… Show more • Created database to evaluate performance of loans on day-to-day basis. At its peak, total assets exceeded $50.0M. Database was multiproduct and supported several businesses lines from credit to sales to collections to compliance and accounting. Database was used to provide reporting to servicing clients, outside dealers, purchasing parties, and company’s lender.• Created dashboards which included SQL tables, graphs, and widgets to monitor day-to-day performance, historical loan performance, collections, and repossession data. • Influence data using purchase model to price portfolios for potential purchase. Maintained the model and improved it as I learned from performance of assets and recognized trends in dealer inputs.• Facilitated system uploads in LMS (Autopal) which included creation of loans, loan setup in accordance with contract, updating/monitoring loan statuses, updating personal information and collateral, maintaining relevant repossession and bankruptcy fields, updating purchase information, and posting of notes relevant to the account.• Daily use of Excel using vlookups, pivots, and if functions. Used Excel when working with purchase files, loan creation, bankruptcy monitoring, payments, etc. Files were extracted in Excel from LMS and imported into database.• Built reporting tools to manage and support the expansion of insurance products to provide a net positive yield to the business• Built a complex system to support the credit bureau reporting process and ensure compliance of the same process.• Handled payment posting for new and existing loans (MoneyGram, Repay, PayNearMe)• Handled bankruptcy monitoring for existing loans (Lexis Nexis, TLO) Show less