• Collaborated on CBA’s evaluating three competing vendor products by joining external datasets to internal data and determining the change in segmentation, premium levels, and costs associated with each product• Wrote reusable script in R to check datasets containing underwriting variables and used in production • Wrote functions in R with embedded SQL queries for analysis of policyholders with special life circumstances and for other analysts to use in later analyses• Estimated the number of policyholders that become widowed on GEICO books and the share of those that have other changes to their policies on the same day or soon after• Helped onboard new hires by answering questions on databases, internal resources, and ongoing projects• Independently documented new IT processes relevant to the team to reduce duplications of efforts researching data security protocols, software requests, and common IT bugs

• Employed SQL to join and analyze millions of rows of customer data for ad hoc business questions, including analyzing changes to policies over time and estimating the volume of missing driver suspensions from vendor data • Queried and joined data from multiple tables to acquire the number of electric vehicles GEICO insured in each U.S. zip code for targeted advertising at charging stations• Participated in Agile process by checking teammates’ work, discussing blockers on projects, and providing feedback in retrospectives • Compared internal data to prospective vendor data to determine the magnitude of additional traffic violations from implementing the vendor’s product• Formatted Excel sheets with R to produce similar outputs without recurring point and click manipulation • Attended and took notes at a webinar series provided by the Highway Loss Data Institute and reported on emerging industry trends and technologies to my team • Updated the underlying data and made stylistic revisions to internal reports and dashboards created with R Shiny for upper management and C-suite• Drafted email shared with upper management (AVP and VP) in a report style highlighting trends in the automobile industry and GEICO’s insured fleet to accompany the publishing of one of my team’s dashboards to R Server

• Wrote, organized, and annotated Stata code to clean and analyze large data sets that included panel data on all historical production by individual mineral leases in the Gulf of Mexico• Analyzed macroeconomic trends and aided in generating the Louisiana unemployment forecast based upon multiple considerations, including the state’s diminished dependence on the energy sector or the growing gig economy• Conducted literature review relating to projects and communicated findings to superiors on a variety of topics, including an entirely independent review of early education literature• Conveyed sophisticated results of analyses to clients by constructing creative visualizations showing the impact on state revenues if tax legislation had passed earlier• Forecast all or part of each source of Louisiana revenues—bidding, rental payments, and royalties—from offshore oil and gas activity in the Gulf of Mexico • Mapped leasing activity in the Gulf of Mexico using ArcMap GIS software to visualize and understand ramifications of oil and gas extraction off the gulf coast and to convey the information to clients• Analyzed oil production data in Excel and presented results to project head, informing him of the major causal driver of tax revenue growth from leasing activity in the Gulf of Mexico