Teaching college-level microeconomics and macroeconomics courses

⋅ Forecasted potential sales volume for new product offering by designing a train/test regression horserace algorithm in R to analyze purchasing behavior of related products using data for 1600 clients (>1.2M records)⋅ Constructed updating data and analysis structure consisting of 6 unique data sources averaging 17,000 records using SQL and R scripts with a README file that allows users to update analysis with more recent data⋅ Analyzed customer lifetime value to identify high growth potential customers, supporting front-end sales strategy, using 8 years of sales data joined via SQL, R, and Sisense BI&A software⋅ Served as team’s go-to BI Engineer; performed ad-hoc analysis evaluating financial and operational performance

⋅ Increased efficiency by >80% by developing a tool for users to perform back-end parallel execution of Stata imputation commands using the Linux cluster, Python, and Box API⋅ Designed and implemented pre-/post-treatment statistical model after feature selection and feature engineering in R; delivered data findings in 13-page report ⋅ Evaluated statistical models and assumptions through consultation meetings with researchers

• Investigated and prepared REDCap functionality to anonymously receive participant Apple watch data files for a study of the feasibility of using an Apple watch to collect heart rate data• Introduced a streamlined access feature for researchers using the REDCap mobile app by using multiple project arms to facilitate data entry in providing geographic unit at the beginning• Assisted with the Institutional Review Board approval process by explaining the REDCap anonymity options to all stakeholders, including the Office for Research Protections

• Pioneered quantitative spatial economics model using Julia to estimate the impact of the U.S. trade war on Chinese workers of different ages (see "Publications" below for abstract)• Transformed source data to desired shape and level of aggregation using R; data included Census PUMS and CPS, Bureau of Economic Analysis, and World Input-Output Database• Developed code flexibly using Git Version Control branch and merge, rebase, and log• Launched quantitative spatial economics model using Julia to estimate the impact of Chinese export increases from 2000-2007 on U.S. manufacturing and service sector employment

• Estimated 4000+ elasticities using Stata for analysis of city specialization in trade• Merged trade data with global territorial exchanges from 1870-2008 using Stata for analysis

• Constructed diff-in-diff and random coefficients regressions using Stata to analyze the effect of the 2008 financial crisis on mortgage and credit card debt in the U.S.• Analyzed past responses to revise CPRC’s public surveys for consumer payments researchers• Developed publication-ready figures using R ggplot2 library after transforming data

⋅ Reduced $300K cost by building a cost-comparison model enabling accurate evaluation of a third-party supplier solution versus an in-house operation solution using SQL/Access/Excel⋅ Transformed $450K loss into $240K profit by aggregating data from historical monthly P&L statements via advanced Excel/VBA techniques to reconcile estimated and actual operating costs and calculate rate increases⋅ Captured a 25% profit margin on new business by designing a pricing model based on standardized units

• Identified variables in text data by categorizing data types, providing a foundation for analysis• Wrote codebook for data on search behavior; used Entity Relationships for variable codes• Summarized antitrust case documents for a paper addressing ebook pricing concerns

• Illustrated econometric concepts through the use of both tangible and graphical examples• Reviewed statistical foundations for students to follow their econometric corollaries• Ten hours per week; both students passed the course, despite difficulty in similar courses