Sr. Data Analyst | Quality Control Specialist
Mission Global (A Division Of Marcus & Millichap)
A third-party reviewer specializing in the re-underwriting of residential mortgages for securitization.Designed and coded a comprehensive quality control process for third-party mortgage reviewer, writing hundreds of queries and functions in the process. Collaborated in the preparation of final reports for delivery to the rating agencies. Began learning Python, Tableau and Power BI.Accomplishments: ^ Engineered the interface between LauraMac, the Access databases and Excel worksheets, automating the entire process, saving hours per day in processing time.^ Used Visual Basic in Access and Excel, plus SQL in MySQL Workbench, to code each step in the process. ^ Automated labor-intensive reporting tasks, such as redaction, leading to an impressive 75-80% reduction in the typical processing time.^ Created a report that our loan software vendor offered to produce at a cost of $100 per hour and 40 hours (the vendor’s minimum ad hoc report fee), spending approximately 1.50 hours on the effort.^ Anticipated and wrote ad hoc queries to address observed anomalies in completed datasets.