Cenlar FSBBusiness Analyst II
Sep. 2016 - Nov. 2019New JerseyWorked with GNMA, FNMA, FHLMC and Private Group investor reporting areas to identify process weaknesses and improve operational functions. Developed 8 custom dashboards for managers, accountants and recipients to support reporting functions. Constructed a Visual Basic database application to both deconstruct existing GNMA RFS files and create new GNMA RFS files. The application allows the GNMA team to quickly fix critical and time sensitive reporting issues. Established an automated Visual Basic database application to guide accountants through the GNMA pool cleanup process. The application has allowed the function to be performed by one accountant in a quarter of the time, as opposed to two accountants working a full month. Maintained and revitalized the monthly remittance process for improved reporting distribution and accuracy, through a VBA database app. Worked in conjunction with the private investor team to develop a tracking application in order to report KRI and KPI metrics. Developed a Visual Basic script that automatically pulls bank balances from HTML DOM and stores data in a secured database for querying and tracking. Created an automated process that pulls Enhanced Downloads from the FNMA SURF website for 209 Seller Servicers. The process logs, tracks and concatenates all the data in a secure database that allows the team to analyze the data.