• Engineered the Auto Analytics DataMart (AAD), an automated analytical solution utilizing Git, Shell and SAS. This replaces manual deployment and execution, freeing analysts to focus on high value tasks.• Developed a validation process that provides statistical and metadata feedback on modifications to AAD which mitigates the operational risks of distributed development.• Rebuilt an inefficient and sporadically refreshed data library with a daily execution ready for analyst consumption at login• Partnered with subject matter experts to maintain accurate and best practice data transformations within AAD, which standardized interactions with data and provided a single source of truth for complex calculations• Coordinated data exchanges with outside vendors to create a complex data model used to develop and validate the credit risk model for Auto Originations

• Utilized time series and Markov Chain (Progression Matrix) methodologies to model inflows, outflows, and daily volume of customers within Default Servicing Home Preservation• Monitored forecast performance for outliers, seasonality, trends and high variance error for identifying model enhancements• Automated manual processes into SAS which resulted team members increased bandwidth to focus on analytics and forecast improvements• SAS/Teradata training lead for a team of 13 members providing mentorship on advanced SAS/SQL techniques• Performed statistical and exploratory analyses within operation data to identify trends, patterns, and relationships to improve business results• Presented forecasts and analyses to senior leaders for the planning of staffing and identify areas for business improvements

• Created reports/analyses with SAS on the trends and relationships of operation data and for business analysts to evaluate program success• Mentored two junior analysts in the growth of their SAS/SQL analytics and reporting skills• Developed forecasts for customer call and document volume using Erlang-C and time series models to assist with planning FTE need while balancing costs and meeting service level objectives• Designed multiuser Access database used for data entry, process management and reporting for the quality assurance department resulting manual workflow tracking and assignment to be automated

• Coordinated and compiled the collection of student level data from the 500+ school districts and charter schools in Pennsylvania to generate annual reporting for the monitoring of dropout and graduation rates• Enhanced the cohort graduation collection/reporting using advanced SQL techniques to identify duplicate student records and resolve data quality issues to meet regulatory requirements of the Federal Department of Education• Created webinar and face-to-face trainings with active learning methods to improve school district administrators’ understanding of the cohort analysis methodology resulting in high data quality in student level data submissions• Forecasted district level enrollment by grade using historical pull-through rates to provide districts information for the planning of expansion/contraction of school infrastructure

• Optimized and automated the annual collection of probation data from the 67 counties in Pennsylvania which reduced the need of an FTE to conduct the survey• Forecasted parolee caseload with a combination of ARIMA/Exponential Smoothing models in ForecastPro and Markov Chain in Simul8 for the planning of parole agent hiring needs and balancing risks of recidivism• Utilized a combination of SQL, Crystal Reports and Excel to create reporting/analyses which increased that agencies understanding of operational performance and trends

Assisted professors with the examination of Statistics and Macro-Economic homework and testsPrepared class materials for professor