John Burke Email & Phone Number

Nashville, Tn, Us

Pleasanton, Ca, Us

Pleasanton, Ca, Us

• Generated 2024-2025 premium and loss forecasts, aiding in securing ~220m in capacity from GenRe and Allianz, potentially doubling company size over that same period.• Accelerated code production for automation efforts such as agency loss ratio, loss development forecasting, and competitive intelligence database setup and analysis by an estimated ~100% via effective prompt engineering with ChatGPT.

- Amazon Marketplace Business that has generated ~1.3m in revenue since 2014.- Rental properties in several SE states since 2020.- BTC Mining; ASICS located in TX, WA, IN, IA since 2021.

Nashville, Tennessee, Us

• Conducted extensive data-driven economic research on changes in market structure in the technology industry to understand the potential costs and benefits of anti-trust and broadband legislation at national, state, and municipal levels and its impact on key stakeholders. • Lead team of 2-3 research analysts to produce high-quality, technical, and data-driven research reports for clients such as Google, Amazon, X (formerly Twitter), Tik Tok, and Comcast. Deliverables included technical reports that relied on the creation of clean, auditable Excel files with effective charts, pivot tables, and extensive use of formulas. • Accelerated production time with effective use of ChatGPT by using it to help create content in early drafts as well as to reduce the number of drafts in final editing and revision process. • Interviewed executive leadership from Google, Amazon, and Comcast to understand key drivers of and challenges to their success, how their programs operate, and what has driven changes in their key performance metrics over time.• Communicated research to members of Congress and the Senate in one-on-on meetings in Washington, D.C.

Nashville, Tn, Us

• Automated ingestion and analysis of competitor quote data from multiple online raters to inform launch of independent agent program with annual revenue of ~$50m using Python’s Pandas, Numpy, Sci-py libraries.• Developed and implemented SQL training program for new hires and existing team members with varying degrees of programing experience. Upon completion of the training, continued to mentor team members and assist on SQL, Python, Excel, Tableau, and Alteryx-related projects.• Created clean and auditable Excel reports on a daily basis; regular use of formulas, pivot tables, and shortcuts. • Initiated and led department-wide effort to document projects in Confluence; created training materials and led multiple workshops catering to both technical and non-technical audiences.

Nashville, Tn, Us

• Predicted policy life expectancy (PLE) with a combination of Python, DataRobot, and r; engineered features with DataRobot’s machine learning capabilities; features informed an r-generated survival analysis model with right-censoring and Weibull distribution; validation of PLE predictions vs. fully-developed actual data sorted by decile indicated a ~50% reduction in median error compared to existing model. PLE predictions served as input to several lifetime value (LTV) models that informed ~$100m in national advertising buys for Marketing team.• Conducted topic modeling in Python with gensim’s Latent Dirichlet Allocation (LDA) model on text data from chat sessions in The General’s homepage and app to identify meaningful topics and terms; stopwords collected from combination of gensim’s default list, scikit-learn’s inverse document frequency (IDF) ‘weighted terms’ process and iterating on LDA model results; term visualization created with pyLDAviz to present results to business partners, who informed training of chat agents and improved user experience by identifying customer “pain points.”• Led workshop on lifetime value (LTV) models with executives and leaders from teams across the company

Nashville, Tennessee, Us

• Generated Gaussian-distributed multi-variable linear regression models with Python’s statsmodels and Pandas libraries that helped consistently forecast daily claims within ~1.5% of actuals for programs with combined annual revenue in excess of $1.5bn to Asurion.• Wrote and maintained stored procedures in SQL that populated a dashboard viewed by senior leadership on a daily basis; optimized inherited SQL code to increase the accuracy of data, adapt to regular program changes, and significantly reduce time devoted to reporting and analysis.• Created monthly forecasts for KPIs with Python and Excel that enhanced understanding across multiple departments which use different definitions of the KPIs. In the process, forecasts and regulatory reporting have been significantly improved.

Nashville, Tennessee, Us

• Researched the influence of fiscal, monetary, and regulatory policies on macroeconomic performance at state, national, and international levels under the guidance of economist Arthur B. Laffer, Ph.D.• Co-authored Kentucky: An Economic History and Prosperity Agenda, which provided a data-rich economic history of Kentucky and comprehensive tax reform plan intended to educate state & local policymakers. • Oversaw data collection and modeling by a team of research analysts for the 10th Edition of Rich States, Poor States, an annual assessment of state economic performance published by the American Legislative Exchange Council.• Used IMPLAN® software to conduct two impact analyses on behalf of the Walt Disney Company. Developed innovative practices with IMPLAN® that Disney incorporated into its guidelines for future impact analyses. • Authored a data-driven report assessing the efficacy of film tax incentives on behalf of the Motion Picture Association of America.• Developed software applications with Python that optimized routine data collection. For example, built web-scrapers that significantly reduced time analysts devoted to collecting data from the Bureau of Labor Statistics and Bureau of Economic Analysis.

Nashville, Tennessee, Us

• Assisted Arthur Laffer, PhD with collection of data and writing for his book The Wealth of States• Co-authored research paper assessing outlook for global economic performance due to changes in tax and regulatory policies

• One of 20 students chosen nationally to consult on a new edition of an economics textbook• Conducted primary research on how students pursue learning experiences• Collaborated on design of cutting edge digital tools for next-generation economics textbooks

Bachelor'S Of Business Administration, Economics

Hon. Associate Of Science (A.S.), Political Science