Saved 4M a year in staffing efficiencies by maintaining an ETL for 200+ time series models Reduced 300 queries, 130 temp tables daily and 1550 unnecessary lines of code the daily ETL via consolidation into a star schemaCreated python scripts to intake CSVs from external vendors saving 2 hours of manual work per week

Created a time series anomaly detection tool to simultaneously monitor 100+ hospitals at once, to ensure daily claim volume was appropriate. Used time series model to detect create a counter factual, taking into account weekly and yearly seasonality and other trends, then found outliers. Located 100,000+ in affected revenueHelped test out R Services in SQL Server 2016, along with assisting in finding relevant documentation for the DBAs to implementCreated financial dashboards to monitor client health and also optimized SQL queries

• Created a lesson plan for 2 recitations of 35 students in introductory economics a week• Communicated and simplified economic jargon and models to be understood by students

On site consultant at Caterpillar Logistics Services providing expertise in cost analysisUsed simulations of various transportation providers to help optimizing shipping costs in Microsoft ExcelUsed financial simulations to estimate the future cost of proposed rates and to help inform negotiations in Microsoft ExcelPerformed ad-hoc queries and utilized data analysis via Microsoft Access in order to manage the transportation networkHelped make a more user friendly transportation bidding interface

• Held office hours to communicate mathematical terminology and jargon to students, up to 5 student at a time.• Graded calculus tests and assignments for all 25 students

Received a grant to conduct a Research Project on the relationship between an immigrant's human capital and health insurance coverageGathered Data from the American Community Survey from IPUMSCleaned large data sets, with up to 2,000,000 observations in SPSS and StataUsed a probit model to expound the likelihood that documented immigrants obtain health insurance coveragePresented my results at the Missouri Valley Economic Conference and published them in the Undergraduate Economic Review