Data Analyst

CAROLINE A. ORR

*** * *** ** *** * New York, NY 843-***-**** adlp5b@r.postjobfree.com

EXPERIENCE

BATES WHITE ECONOMIC CONSULTING Washington, DC

Consultant II Aug 2019 – Present

● Managed team of 3 consultants in the analysis of over 200M records of highly confidential pharmaceutical claims and company transaction data using SQL, STATA, and R, improving client position by $65M

● Delivered key data analyses results to clients involved in high-profile litigation; regularly presented data-driven stories to non-technical audiences using Microsoft PowerPoint and Tableau

● Processed and analyzed over 150M records of complex data using SQL to improve client position by $25M

● Contributed to more than 10 time-sensitive life sciences cases involving breach of contract, drug pricing, and patent litigation for clients including corporations (e.g., Pfizer, AbbVie), law firms (e.g., Skadden, Dentons), and the DOJ

● Appointed as Bates White Community Connection Chair; worked closely with team of 5 and firm management (COO, CHRO, and equity partners) to oversee over 50 workplace charity events per year, increased donation amount by 18% for a total of $223,000 in 2020; personally organized 10 community initiatives, raising over $30,000

● Served as University of Virginia Campus Recruiting Lead; led team of 8 in recruiting efforts, organized 4 on-campus events servicing over 250 people, reviewed 200 candidate applications, conducted 30+ interviews per year

● Selected for promotion at the earliest date of eligibility Consultant I Aug 2018 – Jul 2019

● Processed and validated 15+ data sources of over 300M records using STATA and SQL to enable econometric analysis

● Led proactive data analysis using Google Analytics and Bloomberg Symphony data, creatively solving long-term team issue of insufficient data and improving client position by $15M

● Presented complex data analysis findings to manager; summarized key findings and data assumptions in expert report

● Mentored Summer Consultants by serving as Summer Consultant Program Peer Coach (1 of 20 Peer Coaches at firm); provided career development coaching and feedback to help each individually succeed in the Summer Consultant role Summer Consultant May 2017 – Aug 2017

● Analyzed over 100M records of hospital data to identify trends and determine correct assumptions for modeling damages

● Processed complex pharmaceutical data from 5+ sources with over 150M records; produced clean and easily-accessible data set to be used by larger team in model calculating $75M in damages

● Identified and corrected coding error in damages model in STATA, improving client position by $10M NATIONAL DEFENSE UNIVERSITY, THE EISENHOWER SCHOOL Washington, DC Research Assistant Apr 2016 – Aug 2016

● Assisted professor in developing graduate-level Economics of National Security coursework for 150+ students

● Constructed analytical narrative of economics, national security, and globalization serving as a coursework example; presented findings to school leadership, including top-ranking military leaders and government officials; professor described the presentation as “most compelling”

EDUCATION

UNIVERSITY OF VIRGINIA Charlottesville, VA

Bachelor of Arts in Economics; Bachelor of Arts in Public Policy and Leadership with Distinction Aug 2014 – May 2018

● 3.50/4.00 Cumulative GPA; 3.66/4.00 Major GPA

● University of Virginia Class of 2018 Fourth Year Trustees, Lighting of the Lawn 2017 Programs Director, University of Virginia Student Class Council (2015-2017), Frank Batten School of Public Policy Undergraduate Council (2016-2018), The Virginia Sil’hooettes A Cappella (2014-2018; President, Publicity Manager), Relay for Life Volunteer (2014-2017) UNIVERSITY OF EDINBURGH Edinburgh, Scotland

Economics (Semester Abroad) Jan 2017 – May 2017

ADDITIONAL

● Technical skills: Advanced (4+ years and LinkedIn Certified) SQL, STATA, and Microsoft suite (including Excel); Intermediate (3+ years) Tableau, R, Bloomberg, and Google Analytics; Beginner (1+ year) Python and Looker

● Research: Advanced (5+ years) EBSCOHost, ProQuest, and Google Scholar

● Security Clearance: Interim SECRET security clearance obtained Apr 2016 through Aug 2016

● Volunteered 5+ hours per week as a Mentor with Higher Achievement; mentored 3 students every week for 2 years

● Avid traveler and hiker; intermediate skier; keen reader (averaging 1 book per week in 2020)

Contact this candidate